Tool 45 · Treasury, Strategy & Revenue

Subscription Dunning & Recovery Simulator

Simulate subscription payment failure cohorts and dunning recovery sequences. Model retry logic (fixed, exponential, payday-aware), email/in-app/SMS cadence, and billing cycle LTV optimisation. Seed-controlled for reproducible results. Export AP2 JSON or board memo.

v1.0 Retry Engine LTV Optimiser AP2 JSON Export

Cohort Parameters

Cohort Size (subscribers) Average MRR per Subscriber ($) Billing Cycle Random Seed

Scope & reliance — 🔒 All inputs are processed locally in your browser. No data is transmitted. Do not enter real personal data — use synthetic or anonymised inputs only. Embedded rates, thresholds, and regulatory citations are static reference values that may age — verify against current primary sources and your own data before relying on any output for commercial, legal, or compliance decisions. Deterministic logic · no inference · zero PII · CC BY 4.0.

Failure Mix

NSF / Insufficient Funds (%) Card Expired (%) Do Not Honour (%) Processor Error (%) Soft Decline / Timeout (%) Hard Decline (%)

Retry Logic

Retry Strategy Max Retry Attempts Initial Retry Delay (days)

Recovery Funnel

Retry Timeline

Dunning Channel Effectiveness

Failure Mode Breakdown

Failure Mode	Count	Recovery Rate	Recovered	Churned	Revenue Lost

Billing Cycle LTV Comparison

Cycle	Churn Exposure	Avg Failed Payments/Year	12-Mo LTV	Recovery Cost	Net LTV