SaaS Churn & Revenue Retention Calculator | MRR Churn, NRR, GRR & Expansion
Analyze SaaS churn comprehensively: separate logo churn from MRR churn, calculate Net Revenue Retention (NRR) and Gross Revenue Retention (GRR), model expansion MRR, and project revenue at risk. Includes monthly cohort retention waterfall and benchmark comparison.
12-Month MRR Waterfall
| Month | Starting MRR | New MRR | Expansion | Churn | Net MRR | MoM Change |
|---|---|---|---|---|---|---|
| Mo 1 | $125,000 | +$18,000 | +$4,000 | -$4,125 | $142,875 | — |
| Mo 2 | $142,875 | +$18,000 | +$4,572 | -$4,715 | $160,732 | +12.50% |
| Mo 3 | $160,732 | +$18,000 | +$5,143 | -$5,304 | $178,571 | +11.10% |
| Mo 4 | $178,571 | +$18,000 | +$5,714 | -$5,893 | $196,393 | +9.98% |
| Mo 5 | $196,393 | +$18,000 | +$6,285 | -$6,481 | $214,196 | +9.07% |
| Mo 6 | $214,196 | +$18,000 | +$6,854 | -$7,068 | $231,982 | +8.30% |
| Mo 7 | $231,982 | +$18,000 | +$7,423 | -$7,655 | $249,750 | +7.66% |
| Mo 8 | $249,750 | +$18,000 | +$7,992 | -$8,242 | $267,500 | +7.11% |
| Mo 9 | $267,500 | +$18,000 | +$8,560 | -$8,828 | $285,233 | +6.63% |
| Mo 10 | $285,233 | +$18,000 | +$9,127 | -$9,413 | $302,948 | +6.21% |
| Mo 11 | $302,948 | +$18,000 | +$9,694 | -$9,997 | $320,645 | +5.84% |
| Mo 12 | $320,645 | +$18,000 | +$10,261 | -$10,581 | $338,324 | +5.51% |
What Is the SaaS Churn & Revenue Retention Calculator | MRR Churn, NRR, GRR & Expansion?
Gross Revenue Retention (GRR) and Net Revenue Retention (NRR) are the two most important SaaS health metrics. GRR measures how much revenue you retain from existing customers after churn and downgrades — it can never exceed 100%. NRR measures the net revenue impact of your existing customer base including expansion (upsells, cross-sells) — it can exceed 100%, which means your existing customers alone are growing your revenue even before new customer acquisition. NRR above 120% is considered "world-class" and is the defining metric of efficient SaaS growth.
Formula
How to Use
- 1
Pull MRR from your billing system (Stripe, Chargebee, Recurly). Use MRR at start of period, not end, for the denominator in churn calculations.
- 2
Calculate logo churn rate: customers who canceled in the month ÷ customers at start of month. Track this as a 90-day rolling average to smooth one-time fluctuations.
- 3
Calculate MRR contraction: total revenue lost from downgrades (not cancellations) ÷ starting MRR. In most billing systems you can filter for plan downgrades specifically.
- 4
Calculate expansion MRR: total revenue gained from upgrades, additional seats, or new modules purchased by existing customers ÷ starting MRR.
- 5
Set new MRR to your average monthly new business closed. This is typically Net New ARR ÷ 12 or New Customer MRR from your CRM.
- 6
If GRR is below 80%, churn is your highest-priority problem. Investigate the most common cancellation reasons in customer exit interviews.
- 7
If NRR is below 100%, your existing base is shrinking in revenue — even growing your customer count will not compensate unless you fix the revenue leak.
- 8
Use the months-to-zero metric as a stress test: if you stopped all new acquisition today, how long before MRR reaches zero? Under 24 months is a red flag.
- Enter your current MRR and number of active customers from your billing system.
- Enter monthly logo churn rate — the percentage of customer accounts canceling each month. Track this separately from revenue churn.
- Enter MRR contraction rate — the revenue lost to downgrades or seat reductions, expressed as a percentage of MRR.
- Enter expansion MRR rate — the revenue gained from upsells, cross-sells, and plan upgrades from existing customers.
- Enter new MRR added per month from new customer acquisition (this is separate from expansion).
- Review the 6 metric cards: GRR and NRR are your headline retention metrics. Compare them to the benchmarks shown.
- Examine the 12-month waterfall table to project MRR trajectory under current growth and churn assumptions.
Example Calculation
A mid-market SaaS company: $125,000 MRR, 250 customers, 2.5% monthly logo churn, 0.8% contraction, 3.2% expansion, $18,000 new MRR/month. Monthly gross churn = $125,000 × 3.3% = $4,125. Expansion = $125,000 × 3.2% = $4,000. Net MRR change = $18,000 + $4,000 − $4,125 = $17,875 MRR growth. Annual GRR = (1 − 0.033)^12 = 67.1% — below the 80% SMB target, indicating a retention problem. Annual NRR = ((125,000 − 4,125 + 4,000)/125,000)^12 = (0.999)^12 = 98.8% — below 100%, confirming the base is net-shrinking without new customers.
Understanding SaaS Churn & Revenue Retention | MRR Churn, NRR, GRR & Expansion
SaaS Retention Benchmarks by Segment
| Segment | Annual GRR | Annual NRR | Monthly Logo Churn | Key Driver |
|---|---|---|---|---|
| Enterprise (ACV > $50K) | 92–97% | 115–140% | 0.3–0.7% | Expansion from contract growth, added seats |
| Mid-Market (ACV $10–50K) | 85–92% | 105–120% | 0.7–1.3% | Module expansion, user seat growth |
| SMB (ACV $1–10K) | 78–87% | 98–108% | 1.3–2.0% | Plan upgrades, multi-seat purchasing |
| Consumer / PLG | 65–80% | 90–102% | 2.0–4.0% | Upgrade to paid, power features |
| Usage-Based / Pay-per-use | 88–95% | 120–160% | 0.5–1.2% | Natural expansion with usage growth |
| Vertical SaaS | 90–95% | 110–130% | 0.4–0.9% | Sticky workflows, limited alternatives |
Revenue Expansion Strategies
| Strategy | Impact on NRR | Implementation | Typical NRR Lift |
|---|---|---|---|
| Seat-based expansion | High | Usage limits that prompt team invites, viral within org | +10–25% |
| Feature-tier upsells | Medium-High | Usage triggers for premium features, in-app upgrade prompts | +8–18% |
| Usage-based pricing | High | Price scales with value delivered (API calls, data volume) | +15–30% |
| Cross-sell adjacent products | Medium | Product-qualified leads (PQL) from usage data | +5–15% |
| Professional services | Low-Medium | Implementation, training, custom integrations | +3–8% |
| Customer success QBRs | Medium | Proactive reviews showing ROI → renewal + expansion | +5–12% |
The Rule of 40 and Retention
The Rule of 40 states that a healthy SaaS company's revenue growth rate plus profit margin should equal or exceed 40%. Retention metrics directly determine how achievable this is: a company with 85% annual GRR must grow new ARR faster to offset the 15% annual revenue decay from its existing base. A company with 110% NRR has a 10% annual tailwind from expansion — it can grow total revenue even if new ARR acquisition is zero. At scale, the math becomes dramatic: a $100M ARR business with 85% GRR loses $15M annually from existing customers. With 110% NRR, the same base contributes +$10M net. The $25M swing in annual revenue explains why investors pay 2–3x revenue multiples for SaaS companies with NRR above 120% vs 80–100%.
Frequently Asked Questions
What is the difference between logo churn and revenue churn?
Logo churn (customer churn) is the number of customer accounts lost as a percentage of total customers. Revenue churn (MRR churn) is the MRR lost from those customers as a percentage of total MRR. A company can have high logo churn but low revenue churn if only small customers are leaving. Conversely, losing one large enterprise customer can cause high revenue churn with low logo churn. Track both: logo churn tells you about product-market fit for a customer segment; revenue churn tells you the financial impact.
How is NRR calculated and why can it exceed 100%?
NRR = (Starting MRR − Churned MRR − Contracted MRR + Expansion MRR) ÷ Starting MRR, annualized. It exceeds 100% when expansion revenue from existing customers outpaces churn and contraction losses. Snowflake, Datadog, and HubSpot have historically reported NRR of 120–160%, meaning their existing customer base grows 20–60% per year on its own. This is the holy grail of SaaS because it means you can sustain growth even if new customer acquisition slows.
What GRR and NRR should I target for my business?
Benchmarks vary by market segment. Enterprise SaaS: GRR > 90%, NRR > 115%. Mid-Market SaaS: GRR > 85%, NRR > 105%. SMB SaaS: GRR > 80%, NRR > 100%. Consumer SaaS: GRR > 70%, NRR > 95%. The segment matters because Enterprise customers have longer contracts, procurement processes that reduce impulsive cancellations, and more expansion opportunity (more seats, more modules). SMB customers are more price-sensitive and have higher inherent volatility.
What is net MRR churn vs gross MRR churn?
Gross MRR churn is the total MRR lost from cancellations and downgrades. Net MRR churn subtracts expansion MRR: if you lose $5,000 to churn but gain $6,000 from upsells, your net MRR churn is negative $1,000 — meaning you have negative churn, and your existing customer base is growing in revenue. Negative net MRR churn is the most powerful growth dynamic in SaaS because it means you grow revenue without any new customers. Companies with negative net MRR churn can slow new customer acquisition significantly without immediate revenue impact.
How do I reduce churn in a SaaS business?
The most evidence-backed churn reduction tactics: (1) Improve onboarding — customers who reach the "aha moment" within 7 days retain 3–4x better than those who do not. (2) Usage-based early warning — users who log in less than once per week in month 2 are 70% more likely to churn in month 3. (3) Quarterly business reviews (QBRs) for accounts above a revenue threshold — proactive engagement catches at-risk accounts. (4) Annual contracts — customers on annual plans churn at 30–50% lower rates than monthly because the cancellation decision is annual not monthly. (5) Identify your "power users" and ensure all customers experience the same workflow patterns.
You Might Also Like
Explore 360+ Free Calculators
From math and science to finance and everyday life — all free, no account needed.