The short answer
In your Stripe Dashboard, filter your payments by Failed, and your invoices and subscriptions by Past due. The past-due invoices are the money still at stake right now. Add them up each month, and track how much of it you get back, so you know whether your reminders are working.
Where to look in Stripe
- Payments, filtered by Failed: every declined charge, with the decline reason. A single invoice can show several failed attempts, so don't add these up directly.
- Invoices, filtered by Past due: subscription invoices that haven't been paid yet. This is the money still at stake.
- Subscriptions, filtered by Past due: the customers behind those invoices.
Turning it into a number
- Each month, add up the amounts of invoices that failed at least once. That's your money at risk.
- Add up how much of it was paid in the end. That's what you recovered.
- The rest, from subscriptions that ended unpaid, is what you lost to failed payments.
- Compare month to month. If the lost amount is growing, look at the decline reasons: lots of expired cards points to expiring card warnings.
Why this is worth doing
Customers lost to failed payments didn't decide to leave. Many would have kept paying if someone had asked. That makes this churn the easiest kind to win back, and it's worth knowing how big it is. Read more on involuntary churn.
Related questions
What's the difference between failed and past due?
A failed payment is one declined attempt. Past due means the invoice is still unpaid after a failure, and Stripe may keep retrying.
Do failed payments count as churn?
Only if the subscription ends. If the customer pays after a reminder, nothing was lost.
Can I export failed payments from Stripe?
Yes. Most Stripe Dashboard lists can be exported to CSV after you filter them.