Ending MRR
`Beginning + New + Expansion − Churn`—single headline **ending MRR** with net change extra for waterfall storytelling.
Example scenario
A SaaS RevOps team closes the month with $380,000 beginning MRR, adds $42,000 from new logos and $28,000 from expansion within the existing base, and records $22,000 in churned plus contraction MRR using consistent revenue recognition rules. The bridge resolves to about $428,000 ending MRR with roughly $48,000 net MRR change after gross new and expansion are netted against churn-side leakage. Leadership uses this snapshot for board bridges, quota planning, and diagnosing whether growth is acquisition-led versus expansion-led versus retention-constrained.
Ending MRR
Beginning + new + expansion − churn
Want a similar calculator on your website?
Describe your fields and formula in plain English, match your brand, and embed the widget anywhere—WordPress, Webflow, Shopify, or custom HTML. Capture leads when you're ready.
How to use the ending mrr
- Input beginning MRR ($) from your reporting period opening balance aligned to the same currency and recognition policy as downstream movements.
- Enter new logo MRR ($) from first-time customer subscriptions activated in the period, excluding expansion from existing accounts unless your taxonomy routes it there.
- Add expansion MRR ($) from upsells, cross-sells, seat adds, and usage lifts booked against existing customers.
- Subtract churned plus contraction MRR ($) for cancellations and downgrades, then review ending MRR and net MRR change against targets.
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.
Best use cases
- Forecasting and scenario planning
- Client education and pre-qualification
- Budget and performance decision support
Frequently asked questions
Should reactivation revenue go into new logo MRR or expansion MRR?
Use your internal taxonomy consistently. Many teams classify returned customers as new logo if churned long enough, while others route win-backs into a reactivation bucket modeled separately.
Why bundle churn and contraction into one input here?
This bridge collapses downside movements into a single churn-side term for speed. If you need gross churn versus downgrade detail, split contraction out in source reporting before feeding totals.
Does ending MRR equal cash collected this month?
Not necessarily. MRR is a normalized recurring revenue snapshot tied to subscription economics; cash timing can differ due to billing frequency, credits, and collections.
How should I treat FX if subscriptions are multi-currency?
Pick a reporting currency and conversion policy for the period. Mixed-currency bridges distort outcomes when rates shift unless balances are translated consistently.
Glossary
Scenario modeling
Testing multiple assumptions to estimate possible outcomes before execution.
Commercial intent
User behavior indicating readiness to buy, subscribe, or request a quote.
Related calculators
Category: SaaS subscription revenue analyticsTopics: MRR bridge, Net new ARR/MRR, RevOps reporting
Last reviewed: 2026-05-07
Reviewed by: Calclet Growth Team