past-due-dunning

Past Due & Dunning

Stripe MCP Setup

Requires Stripe MCP connected via OAuth or restricted key. Docs: https://docs.stripe.com/mcp

1. GetMcpTools with server: "user-Stripe" (or plugin-stripe-stripe) before any call
2. Prefer stripe_api_search → stripe_api_details → stripe_api_read for list/retrieve
3. Always paginate — limit: 100, follow has_more with starting_after
4. Amounts are in cents unless noted
5. Never expose secret keys in output

Workflow

1. GetSubscriptions with status: past_due and status: unpaid — paginate all
2. Expand default_payment_method and latest_invoice
3. Per sub record:
   • Plan(s) + MRR
   • latest_invoice.attempt_count, amount_due, status
   • Card: brand, last4, funding, country, wallet type
4. Sum MRR at risk

Dunning Checklist (Dashboard)

• Smart Retries enabled (Billing → Revenue recovery)
• Customer emails: failed payment, card expiring
• Customer Portal: payment method update enabled
• Webhook: invoice.payment_failed handled in app

Output Template

Past Due Report ([date])

| # | Sub | Plan | MRR | Attempts | Card | Country |
|---|-----|------|-----|----------|------|---------|

Total: [N] subs | $[MRR]/mo at risk
Funding mix: credit [n] | debit [n] | prepaid [n]

Priority actions:
1. [highest $ sub with most attempts]

Route email gaps to email-dunning-setup; card patterns to card-funding-risk.