Example
MRR dashboard example
This is Honest MRR's Overview with illustrative figures. Below it, each figure is explained: what it measures, the formula, and how the example's numbers fit together. The full rule set is on how we calculate MRR.
Illustrative data — your own numbers appear after the first sync.
See it with your own data
Pick your billing provider to see how Honest MRR reads it:
Connect your billing providerWhat each panel shows
- Current MRR$24,830
Monthly recurring revenue: every paying subscription — active or past due — amortized to a monthly amount, so an annual plan counts a twelfth of its price. Trials are left out until they convert — except on Patreon, whose data doesn't mark a trial — and metered usage is tracked separately (what counts). The chart under it is the same figure, day by day.
- Growth+8.2%
Current MRR compared with exactly 30 days ago.
- New MRR and churned MRR+$1,240 / −$310
The last 30 days of new subscriptions and cancellations, summed from the ledger's movements. Upgrades, downgrades and returning customers are movements too, each with its own category (MRR movements).
- Active customers314
Customers with at least one active paid subscription. A customer can hold more than one, so the example's 314 customers have 341 subscriptions between them.
- Logo churn1.8%
Customers who had MRR 30 days ago and have lost all of it since, divided by the customers active 30 days ago. It counts customers, not subscriptions: cancelling one of two plans is a contraction, not a lost customer (how churn is calculated).
- ARPA$79.08
Average revenue per account: current MRR divided by paying customers — here $24,830 ÷ 314 ≈ $79.08.
- Predicted LTV$4,393
What a customer is worth if current churn holds: ARPA divided by monthly logo churn, averaged over the last three complete months — here $79.08 ÷ 1.8% ≈ $4,393 (how LTV is calculated).
- Realized LTV per customer$612
Money actually collected — paid minus refunded — divided by every customer who has ever had a paying subscription. Predicted LTV is the forecast; realized is the history.
Behind every MRR figure: a ledger of movements
MRR, churn and cohorts are computed from a ledger with one row per change in a subscription's MRR; realized revenue and realized LTV come from the cash collected. Open a movement to see its ledger entry, the webhook event that recorded it when there is one, and the subscription's current record as the billing provider sent it. A movement found by a backfill or the daily resync has no event — the drill-down says so.
Every version of a billing record Honest MRR receives is fingerprinted in a tamper-evident hash chain (how the hash chain works).
An example drill-down — illustrative data.
Build one yourself, or connect
You can build an MRR dashboard in a spreadsheet or a BI tool from your billing exports. The charts are the easy part; the work is in the rules:
- Turn every plan into a monthly amount: annual plans divided by 12, weekly and daily plans scaled up.
- Leave trials out until they convert, and keep past-due subscriptions in, flagged as at-risk.
- Sort every change into new, expansion, contraction, churn or reactivation, and keep that history when a subscription changes again.
- Convert each amount at the exchange rate of its own date, so last month doesn't move when rates do.
- Count app-store revenue after Apple's or Google's cut, and merchant-of-record sales without the tax the merchant of record collects.
- Keep one-time and metered charges out of MRR — they belong in realized revenue and usage.
For a handful of plans, the MRR calculator does the arithmetic. Honest MRR applies the same rules to every subscription your billing provider holds, each dated from when it started, and keeps the dashboard current as subscriptions change.
See your own dashboard
Free up to $2k MRR (a soft limit), with a 14-day Pro trial and no credit card.