Reporting For Declined or Invalid Credit Card Subscriptions

Hi Folks,

The problem that we are having, is that we must sift through many expired accounts to find accounts who have had their credit cards either decline of become invalid due to expiration dates. Right now, we must go through all the expired accounts, of which most are simply a renewal, to find these.  But this is eating up a lot of time each day and is one of the tasks that my entire staff loathe.  

We need to be able to try to contact these folks from our end to be able to keep their subscription from just expiring or to get them restarted.  If we had a report that would generate any of these customers, we could contact them up to three days in advance of expire when their first renewal payment is attempted and comes through as Declined or Invalid.  This information is already getting listed in the account’s history, so it would seem that it could be something that could be reported. 

Thanks,

Mike