active-subscriptions-audit

Active Subscriptions Audit

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

For each status, paginate GetSubscriptions:

Status	Meaning
active	Paying, current
trialing	In trial
past_due	Payment failed, not canceled yet
canceled	Ended (use date filter if needed)
paused	Collection paused
unpaid	Retries exhausted

stripe_api_read GetSubscriptions { status: "active", limit: 100 }

Repeat for trialing, past_due, unpaid, paused.

Metrics

Metric	Formula
Paid subs	active + past_due (optional)
Trial pipeline	trialing count
At-risk subs	past_due + unpaid
Line items per sub	items.data.length (multi-product subs)

Output Template

Subscription Status ([date])

| Status | Count | % of total |
|--------|-------|------------|
| Active | | |
| Trialing | | |
| Past due | | |
| Unpaid | | |

Multi-product subs: [N] subs with 2+ line items

Flag if past_due > 5% of active — investigate with past-due-dunning.