MRR Calculator Worksheet: The Full MRR Bridge

Most subscription reports show two MRR numbers — last month and this month — and a gap nobody can explain. The MRR bridge fixes that. It breaks the change into five movements: new, expansion, contraction, churned, and reactivated revenue. Work the bridge by hand once and you will never trust a bare MRR total again, because the bridge forces the uncomfortable line — churned MRR — out into the open where you can act on it. This worksheet gives you the formulas, a fully worked month, and blank tables to run your own numbers. Keep it next to our subscription metrics formula sheet for the definitions behind each term.

The five movements, defined tightly

• Starting MRR. Monthly recurring revenue at the start of the month, counting only active paid subscriptions at their current monthly value. Annual plans count at one-twelfth of their yearly price. Trials and free plans count as zero.
• New MRR. Revenue from subscribers who paid for the first time this month, including trial conversions. Count the full monthly value, not the days remaining in the month.
• Expansion MRR. Extra revenue from existing subscribers: upgrades, added seats, added usage, or a move to a higher tier. Only the increase counts, not the new total.
• Contraction MRR. Revenue lost from existing subscribers who stayed but pay less: downgrades, removed seats, or discounts applied. Only the decrease counts.
• Churned MRR. The full monthly value of every subscription that ended this month, voluntary or involuntary. A subscriber who cancelled mid-month still counts their whole monthly value here.
• Reactivated MRR. Revenue from former subscribers who returned and paid again this month. Keep it separate from new MRR — a returning subscriber behaves differently from a stranger, and mixing them hides whether your winback work is paying.

The bridge must balance: starting MRR + new + expansion + reactivated − contraction − churned = ending MRR. If it does not balance, a movement is missing or double-counted, and the error is in your data, not in the arithmetic.

A worked month, end to end

The following month is invented for illustration only. The numbers are round on purpose so you can check every step by hand.

Bridge line	How it was counted	Amount
Starting MRR	Active paid subscriptions on the 1st	$48,000
New MRR	60 new subscribers at $50 average	+$3,000
Expansion MRR	Upgrades and added seats across existing accounts	+$900
Reactivated MRR	10 returning subscribers at $50	+$500
Contraction MRR	Downgrades and discounts applied	−$400
Churned MRR	44 subscriptions ended, at $50 average	−$2,200
Ending MRR	$48,000 + $3,000 + $900 + $500 − $400 − $2,200	$49,800

Read the worked month the way an operator should. Growth looks healthy — MRR rose $1,800. But the bridge shows $2,200 walking out the back while $3,000 came in the front. Acquisition is carrying the business; retention is leaking. Net new MRR is $1,800, gross churn against the starting base is $2,200 ÷ $48,000, and the expansion-plus-reactivation lines ($1,400 combined) are doing quiet, cheap work that deserves more attention than another acquisition push. None of that is visible from the two headline numbers alone.

Your blank worksheet

Copy this table into your spreadsheet or notebook and fill it monthly, on the same day each month, from the same report. Consistency of definitions matters more than precision of any single month.

Bridge line	Count of subscribers	MRR amount	Notes (what drove it)
Starting MRR
New MRR
Expansion MRR
Reactivated MRR
Contraction MRR
Churned MRR — voluntary
Churned MRR — involuntary (payment failure)
Ending MRR (must balance)

Note the split inside churned MRR. Voluntary churn means someone chose to leave. Involuntary churn means a payment failed and the subscription ended, often without the subscriber deciding anything. They have different owners, different fixes, and different costs — track them as separate lines from day one. If you want the churn-rate side of the same picture, pair this with our churn rate calculator worksheet.

Common counting errors that break the bridge

• Counting annual plans at full price in one month. Spread them monthly or your new and churned lines will swing wildly whenever an annual subscriber joins or leaves.
• Putting reactivations in new MRR. It flatters acquisition and hides winback performance. Keep the line separate even when it is small.
• Netting contraction against expansion. A single “net expansion” line hides both the wins and the warning signs. Report both gross.
• Forgetting failed-payment endings. Subscriptions that end because a card failed are churned MRR in the month they end, even if you recover some of them later — the recovery then shows up honestly as reactivated MRR.
• Changing definitions mid-year. If you must change a definition, restate the earlier months. A bridge that changes rules is worse than no bridge.

The churned-MRR deep dive

Once the bridge balances, spend your analysis time on one line: churned MRR. Break it three ways. First, voluntary versus involuntary, as in the worksheet. Second, by subscriber age — endings in the first ninety days point at onboarding and trial quality; endings after a year point at value, price, or life changes. Third, by plan — if one tier supplies most of the churned revenue, the problem is that tier's price-to-value fit, not your whole product.

The involuntary slice deserves its own next step, because it is the only churn you can recover without persuading anyone. A subscriber lost to a failed payment did not reject you. Run that slice through our recovery calculator to put a value on recovering part of it, and hold your current recovery results up against the failed payment recovery benchmarks to see how much room is realistically on the table. Recurly research estimates that 20–40% of subscriber churn is involuntary, so for many businesses this slice is not a rounding error — it is a major share of the whole churned line.

What to do with the bridge each month

1. Balance it. No commentary until the arithmetic closes.
2. Name the biggest movement. One line drove the month. Say which, in one sentence.
3. Assign one owner per negative line. Contraction, voluntary churn, and involuntary churn each get a name and a next action, not a shared shrug.
4. Compare against the trailing three months, not just last month. One odd month is weather; three is climate.
5. File it where the team can see it. A bridge in a private spreadsheet changes nothing.

The bottom line

The MRR bridge turns a vague “we grew a bit” into five named movements you can manage. New and expansion tell you acquisition and upsell are working. Contraction warns you quietly. Reactivated proves winback pays. And churned MRR — split honestly into voluntary and involuntary — shows you exactly what leaving costs, and which part of it was never really a decision to leave. Work the involuntary part and the bridge improves without a single new customer. If you want that line worked automatically, Swipe Again recovers failed payments across Stripe, Recharge, Seal Subscriptions, Skio, Loop Subscriptions, Chargebee, Recurly, Braintree, and Paddle for $179/mo flat — see what the trial includes on our pricing page.

Frequently asked questions

What is the difference between MRR and revenue?

MRR counts only recurring subscription value, normalised to a month, and excludes one-time charges, setup fees, and usage spikes you do not expect to repeat. Actual revenue in a month will differ. MRR is a health measure for the subscription base; revenue is what landed in the bank. Track both, and do not use one in place of the other.

How do annual subscriptions count in the MRR bridge?

At one-twelfth of the annual price each month. When an annual subscriber joins, only that monthly slice enters new MRR, and when one leaves, only the slice enters churned MRR. Counting the full annual amount in a single month makes the bridge swing in ways that hide the real movements.

Where do failed-payment cancellations go in the bridge?

In churned MRR, in the month the subscription ends, labelled as involuntary churn so it is never mixed with subscribers who chose to leave. If you later recover that subscriber, the returning revenue is recorded as reactivated MRR in the month they pay again, which keeps both the loss and the recovery honest.

Why keep reactivated MRR separate from new MRR?

Because they come from different work and behave differently afterwards. New MRR measures acquisition. Reactivated MRR measures whether your save, winback, and payment recovery efforts are bringing people back. Combining them makes acquisition look stronger than it is and can hide a winback program that is quietly paying for itself.

How often should you build the MRR bridge?

Monthly, on a fixed day, using the same definitions and the same source report every time. Review it against the trailing three months rather than a single previous month, and always check that the bridge balances before drawing conclusions from any individual line.