I operate a phpbb forum, where users can elect not to see ads by voluntarily paying at least $[url removed, login to view] per year, mostly via Paypal. Currently I manually operate an Excel spreadsheet, whereby their payment is manually recorded on the date it is made, and I perform a mail merge with Microsoft Word from the Excel spreadsheet to pull one or two months' worth of contact information out of those who have expired 'subscriptions', to encourage them to donate again. I then have to manually enter each one back into the spreadsheet, and mark those who do renew. Within PHPBB, I have to remove them from the 'Donors' group, which is what activates the ads being seen.
I would like a system that automatically sends out the reminder emails when their expiration takes place (nearly all pay via PayPal, so I can handle manually those who do not), and updates their status accordingly. I would like an online database, perhaps, that allows me to quickly view those who have paid and those who have not, so I can just manually alter the groups in phpbb. If phpbb customization is allowed, to have it integrated with the phpbb software would be even better, so that the entire system is automated.