Net Revenue Retention (NRR) Calculator
Plug your starting ARR, expansion, contraction and churn into this calculator to get your exact Net Revenue Retention rate — then see instantly how it stacks up against SaaS and B2B benchmarks by stage and segment.
What's inside
- The exact NRR formula, broken into its four inputs
- A fill-in calculation table you can complete by hand
- A copy-paste Excel/Google Sheets formula
- A fully worked example with real numbers
- Benchmark bands by company stage (early, growth, mature)
- Benchmark bands by customer segment (SMB, mid-market, enterprise)
- The Gross Revenue Retention (GRR) companion formula
- A diagnostic guide for what your score actually means
- Five common calculation mistakes that distort your number
Net Revenue Retention (NRR) measures how much revenue your existing customer base generates this period compared to the same base last period — including upgrades, downgrades, and cancellations. It's the single best number for answering "would this business still grow if we never closed another new logo?"
The Formula
NRR (%) = (Starting ARR + Expansion ARR − Contraction ARR − Churned ARR) ÷ Starting ARR × 100
Measured over a fixed period (usually trailing 12 months, sometimes quarterly):
| Input | Definition |
|---|---|
| Starting ARR | Annual recurring revenue from the cohort of customers you had at the start of the period |
| Expansion ARR | Additional ARR from that same cohort — upsells, cross-sells, seat/usage increases |
| Contraction ARR | ARR lost from that same cohort via downgrades, seat reductions, discounting at renewal |
| Churned ARR | ARR lost from that same cohort via full cancellation/non-renewal |
Note what's deliberately excluded: new logo revenue. NRR only ever looks at customers you already had — that's what makes it a retention metric, not a growth metric.
Step 1 — Gather Your Four Numbers
Pull these from your billing system or CRM for your chosen period. Keep the cohort fixed — only customers active at the start of the period count.
Step 2 — Fill In the Calculator
| Line | Input | Your Number |
|---|---|---|
| A | Starting ARR | $__________ |
| B | Expansion ARR | $__________ |
| C | Contraction ARR | $__________ |
| D | Churned ARR | $__________ |
| — | NRR = (A + B − C − D) ÷ A × 100 | ______% |
Copy-Paste Spreadsheet Formula
Put A, B, C, D in cells A2:D2 of Excel or Google Sheets, then in E2:
`` =(A2+B2-C2-D2)/A2*100 ``
Worked Example
- Starting ARR: $1,000,000
- Expansion ARR: $150,000
- Contraction ARR: $40,000
- Churned ARR: $60,000
NRR = (1,000,000 + 150,000 − 40,000 − 60,000) ÷ 1,000,000 × 100 = 105%
Read this as: even with zero new logos this year, this cohort of customers would grow revenue by 5%.
Benchmarks — How Does Your Number Compare?
By company stage
| Stage | Median NRR | Top-quartile NRR |
|---|---|---|
| Early-stage (<$5M ARR) | 95–100% | 110%+ |
| Growth-stage ($5M–$50M ARR) | 100–110% | 120%+ |
| Mature ($50M+ ARR) | 105–115% | 125%+ |
By customer segment (ACV)
| Segment | Typical NRR range |
|---|---|
| SMB (<$10K ACV) | 85–100% (higher logo churn drags it down) |
| Mid-market ($10K–$100K ACV) | 100–115% |
| Enterprise ($100K+ ACV) | 110–130% (fewer logos, bigger expansion) |
These bands are directional, not a pass/fail line — a 92% NRR in a heavily SMB, low-ACV book can be healthy; a 98% NRR in an enterprise book with $150K average deals is usually a warning sign.
The Companion Number: Gross Revenue Retention (GRR)
NRR can hide a real problem: high expansion from a handful of accounts can mask serious churn everywhere else. Always calculate GRR alongside it.
GRR (%) = (Starting ARR − Contraction ARR − Churned ARR) ÷ Starting ARR × 100
GRR is capped at 100% by definition — it never includes expansion, so it isolates pure retention health. A common pattern to watch for: NRR of 110% sitting on top of GRR of 82%. That combination means you're losing customers and revenue everywhere, and a small number of big expansions are covering for it in the headline number.
What Your Number Means
| NRR | Read |
|---|---|
| 120%+ | Best-in-class, expansion-led growth engine |
| 110–120% | Strong and healthy — retention is a growth lever |
| 100–110% | Stable, retention-led, but expansion isn't carrying much weight |
| Below 100% | Net contraction — you're losing more revenue from existing customers than you're gaining |
Five Mistakes That Distort Your Number
- Letting the cohort drift. If you add new customers into the "starting" base partway through the period, you're quietly inflating the denominator's growth potential and understating true retention.
- Netting churn against expansion at the account level instead of the cohort level. Calculate contraction and churn separately — don't let one big save mask a real cancellation elsewhere.
- Using MRR and ARR inconsistently. Pick one and annualize everything the same way.
- Excluding one-time or usage-based revenue inconsistently period to period. If it's recurring enough to count as ARR in month one, count it the same way every month.
- Measuring NRR on a rolling window that doesn't match your renewal cycle. If most contracts are annual, a monthly NRR snapshot is noisy — use trailing 12 months.
If You're Below Benchmark
- Calculate GRR separately — confirm whether the problem is churn, contraction, or weak expansion.
- Segment NRR by tier, by CSM, and by cohort start-quarter — a blended number hides where the leak actually is.
- Cross-reference against the Churn Risk Calculator and Customer Health Score Scorecard in this library to find which accounts are dragging the number down before the next renewal cycle.
How to use it
Pull four numbers from your billing/CRM system for a trailing 12-month period, drop them into the table, run the formula (or paste it straight into Excel/Sheets), then check your result against the benchmark bands to see whether you're retention-led, expansion-led, or leaking revenue.