Ending MRR

What is an MRR movement bridge?

An MRR movement bridge, also called an MRR waterfall or MRR roll-forward, explains how monthly recurring revenue changed from the start to the end of a period. It starts with beginning MRR, adds new customer MRR and expansion MRR, and subtracts churned and contraction MRR to reach ending MRR. SaaS founders, finance teams, and RevOps leaders use it for board reporting, investor updates, and to see whether growth comes from acquisition, expansion, or better retention.

Ending MRR

Beginning + new + expansion − churn

Embed this free calculator on your website—copy the snippet after signup and keep the Built with Calclet link for attribution (or upgrade to remove branding).

Ending MRR — formula: Ending MRR = Beginning MRR + New MRR + Expansion MRR - Churned and contraction MRR
Ending MRR — formula: Ending MRR = Beginning MRR + New MRR + Expansion MRR - Churned and contraction MRR
1200×630

MRR bridge formula

Ending MRR is the opening balance plus every upward movement minus every downward movement in the period. Net MRR change is the movement total on its own.

Ending MRR = Beginning MRR + New MRR + Expansion MRR - Churned and contraction MRR
  • Net new MRR = New MRR + Expansion MRR - Churned and contraction MRR.
  • Net revenue retention (monthly) = (Beginning MRR + Expansion MRR - Churned and contraction MRR) / Beginning MRR x 100.
  • SaaS quick ratio = (New MRR + Expansion MRR) / Churned and contraction MRR.

Inputs explained

Use consistent definitions every month so the bridge ties to your billing system and trends stay comparable.

Beginning MRR ($)
Recurring revenue at the start of the period, which should equal last period's ending MRR. Exclude one-time setup fees, services, and non-recurring charges.
New logo MRR ($)
MRR from customers who started paying during the period. Annual contracts count as annual value / 12; free trials count only once they convert to paid.
Expansion MRR ($)
Additional MRR from existing customers through upgrades, added seats, add-ons, usage increases, or price increases. Track price increases separately if you want to see underlying expansion.
Churned + contraction MRR ($)
MRR lost from cancellations (churn) plus downgrades and seat reductions (contraction). Splitting the two in your source data helps diagnose whether you are losing customers or losing revenue per customer.

Example MRR bridge calculation

A SaaS company starts the month with $380,000 MRR, adds $42,000 from new customers and $28,000 from expansion, and loses $22,000 to churn and contraction. Ending MRR is $380,000 + $42,000 + $28,000 - $22,000 = $428,000, a net MRR change of $48,000, or 12.63% growth. Monthly net revenue retention is about 101.58%, gross churn is about 5.79% of beginning MRR, and the quick ratio is about 3.18.

Put this calculator on your site

We'll copy this tool into your Calclet account—tweak branding and fields, then paste the embed on WordPress, Webflow, Shopify, or any HTML page. Every embed can link back to Calclet for discovery.

Platform embed guides · Pricing

How to use the ending mrr

  1. Input beginning MRR ($) from your reporting period opening balance aligned to the same currency and recognition policy as downstream movements.
  2. Enter new logo MRR ($) from first-time customer subscriptions activated in the period, excluding expansion from existing accounts unless your taxonomy routes it there.
  3. Add expansion MRR ($) from upsells, cross-sells, seat adds, and usage lifts booked against existing customers.
  4. Subtract churned plus contraction MRR ($) for cancellations and downgrades, then review ending MRR and net MRR change against targets.

Common MRR bridge mistakes

  • Counting the full value of an annual contract as MRR instead of dividing it by 12.
  • Including one-time setup, onboarding, or services fees in MRR.
  • Letting this month's beginning MRR differ from last month's ending MRR without a reconciling line.
  • Treating price increases as customer expansion and overstating product-led growth.
  • Combining churn and contraction permanently so you cannot tell lost customers from downgrades.
  • Changing definitions for reactivations, trials, or discounts from month to month.

MRR bridge reporting context

Bridge reconciliation practice
Finance and RevOps teams typically reconcile movement components to billing system cohort exports so waterfall totals tie to recognized subscription revenue.
Expansion versus new logo attribution
Strong SaaS reporting separates new logo acquisition from seat, tier, and usage expansion so net retention diagnostics remain interpretable.
Churn-side composition clarity
Churn and contraction are often tracked separately in advanced models; combining them requires stable definitions month over month.

FAQs

My MRR bridge does not tie to my billing system—how do I find the gap?

Check that beginning MRR equals last month's ending MRR, then look for movements outside the four categories: reactivations, currency changes, billing corrections, mid-month proration, and one-time fees counted as recurring. If the bridge says $428,000 but billing shows $431,000, add a reconciling line for the $3,000 and identify its source rather than forcing it into new or expansion MRR.

MRR is growing, but is our churn too high?

Look at churn as a share of beginning MRR. Losing $22,000 of $380,000 is about 5.79% a month; at that rate, about 51% of starting MRR would be lost over a year without expansion. Strong new sales can hide this. Split churn from contraction to see whether customers are leaving or downgrading, and compare gross churn with SaaS benchmarks for your customer segment.

How do I calculate net revenue retention (NRR) from my MRR bridge?

Use beginning MRR plus expansion minus churn and contraction, divided by beginning MRR, leaving out new customers. In the example, ($380,000 + $28,000 - $22,000) / $380,000 = about 101.58% for the month. Compounded over 12 months that is roughly 120.7%, but true annual NRR is usually measured on a 12-month customer cohort, so treat the compounded figure as an estimate.

How do I calculate the SaaS quick ratio from an MRR bridge, and what does it tell me?

Divide new plus expansion MRR by churned plus contraction MRR. Here, ($42,000 + $28,000) / $22,000 = about 3.18, meaning the company adds about $3.18 of MRR for every $1 lost. Many investors view a quick ratio around 4 or higher as efficient growth; a low ratio means growth is fragile and depends on constantly replacing lost revenue.

How much new MRR do we need next month to hit an MRR target?

Work backward from the target. Starting at $428,000 and aiming for $450,000, you need a $22,000 net increase. If churn stays at about 5.79% of beginning MRR (about $24,800) and expansion at about 7.37% (about $31,500), new customer MRR must be about $15,200. Rerun the bridge with your forecast to check the plan.

How much would reducing churn change our ending MRR?

Model the bridge at a lower churn rate. Cutting churn and contraction from 5.79% to 3% of the $380,000 beginning MRR lowers losses from $22,000 to $11,400, raising ending MRR from $428,000 to $438,600, about $10,600 more every month. Because the gain carries forward, retention improvements often beat equivalent new-sales gains over a year.

How should annual contracts, discounts, and setup fees be counted in MRR?

Divide annual or multi-year contract value by the number of months: a $60,000 annual contract adds $5,000 MRR, not $60,000. Record MRR net of recurring discounts, and exclude one-time setup, implementation, and services fees. Free trials should not count until they convert to paid.

A price increase drove most of our expansion—how should that show in the bridge?

Track pricing as its own line or tag it inside expansion so you can see underlying retention. If $19,000 of the $28,000 expansion came from a 5% price increase, monthly NRR excluding pricing drops from about 101.58% to about 96.58%, showing the existing customer base would shrink without the price change.

Should a returning customer count as new MRR, expansion, or reactivation?

Pick a rule and apply it every month. Many teams use a separate reactivation line, or count a customer as new if they were gone longer than a set period such as 90 days. Putting $4,000 of reactivations into new MRR overstates acquisition, while putting it into expansion inflates NRR, so a separate line keeps both metrics clean.

How do I handle usage-based or seasonal revenue in an MRR bridge?

Separate committed subscription MRR from variable usage revenue, or use a trailing average for usage. Otherwise a slow month shows up as large contraction and a busy month as large expansion, even though customer health did not change. Report both views so leadership can see true retention trends.

Related calculators

Category: SaaS subscription revenue analyticsTopics: MRR bridge, Net new ARR/MRR, RevOps reporting

Last reviewed: 2026-05-07

Reviewed by: Souhayb Kama Ldine