Net Revenue Retention Calculator
Calculate net revenue retention, gross revenue retention and logo retention from expansion, contraction and churn figures, plus a 12-month cohort projection.
At or above 100% expansion fully replaces what you lose, so revenue grows without any new logos.
12-month cohort projection at the computed NRR
| Month | Cohort revenue | Change vs start | % of start |
|---|---|---|---|
| 0 | $500,000 | $0 | 100.0% |
| 1 | $515,000 | $15,000 | 103.0% |
| 2 | $530,450 | $30,450 | 106.1% |
| 3 | $546,364 | $46,364 | 109.3% |
| 4 | $562,754 | $62,754 | 112.6% |
| 5 | $579,637 | $79,637 | 115.9% |
| 6 | $597,026 | $97,026 | 119.4% |
| 7 | $614,937 | $114,937 | 123.0% |
| 8 | $633,385 | $133,385 | 126.7% |
| 9 | $652,387 | $152,387 | 130.5% |
| 10 | $671,958 | $171,958 | 134.4% |
| 11 | $692,117 | $192,117 | 138.4% |
| 12 | $712,880 | $212,880 | 142.6% |
The projection holds this period's retention rate constant and adds no new customers, so it shows what the existing base alone would be worth in a year.
NRR = (start + expansion − contraction − churn) ÷ start · GRR = (start − contraction − churn) ÷ start · logo retention = retained ÷ starting customers
Worked example: $500,000 starting revenue with $45,000 expansion, $12,000 contraction and $18,000 churn gives NRR = (500,000 + 45,000 − 12,000 − 18,000) ÷ 500,000 = 103.0% and GRR = (500,000 − 30,000) ÷ 500,000 = 94.0%.
Revenue from brand-new customers is deliberately kept out of both retention numbers — that is the standard definition, and mixing it in is the most common way NRR gets overstated. GRR excludes expansion by design so it can never exceed 100%, while NRR often does. The SaaS quick ratio shown alongside is (new + expansion) ÷ (contraction + churn). All maths runs locally in your browser; nothing is sent anywhere.
What is the Net Revenue Retention Calculator?
Net revenue retention is the single metric that separates a subscription business that compounds from one that treads water.
- NRR, GRR and logo retention calculated together from one set of inputs
- 12-month cohort projection compounding the computed retention rate
- Monthly, quarterly and annual periods normalised to a common monthly rate
- SaaS quick ratio — (new + expansion) ÷ (contraction + churn)
- Interpretation bands from best-in-class 120% down to a leaky bucket
- Fully client-side — no signup, no upload, works offline
How to use the Net Revenue Retention Calculator
- 1
Choose your currency and whether the figures below cover a month, a quarter or a year.
- 2
Enter recurring revenue at the start of the period.
- 3
Add expansion, contraction and churned revenue for the same period.
- 4
Optionally add new-customer revenue and customer counts for the quick ratio and logo retention.
- 5
Read NRR and GRR in the stat row, then scroll to the 12-month cohort projection table.
About the Net Revenue Retention Calculator
Net revenue retention is the single metric that separates a subscription business that compounds from one that treads water. This calculator takes your starting recurring revenue plus expansion, contraction and churn for the period and returns NRR, gross revenue retention and logo retention together, so you can see whether upsells are genuinely covering what you lose.
It also projects the same cohort forward twelve months at the retention rate you just computed, holding new sales at zero. That projection is the honest picture of what your existing customer base alone is worth in a year — the number that tells you whether growth is compounding or being manufactured by the sales team every month.
Quarterly and annual inputs are converted to a monthly rate so the projection is comparable however you report. All the arithmetic runs in your browser: revenue figures, customer counts and everything derived from them stay on your device and are never uploaded.
Frequently asked questions
What is a good net revenue retention rate?
Above 100% means your existing customers grow on their own, which is the level most investors treat as the pass mark for a serious SaaS business. Top public companies report 110% to 130%. Below 100% the installed base shrinks every period and new sales spend most of its effort refilling the bucket.
What is the difference between NRR and GRR?
Gross revenue retention deliberately excludes expansion, so it can never exceed 100% and shows how much of your base you keep before any upsell. Net revenue retention adds expansion back in and often exceeds 100%. Quoting NRR without GRR can hide serious churn behind a handful of big upgrades.
Should new customers be included in net revenue retention?
No. Revenue from brand-new customers is excluded from both NRR and GRR by definition — they were not in the starting cohort. Mixing new business in is the most common way retention figures get overstated, and it makes the number meaningless for comparison.
How do I convert monthly NRR to annual NRR?
Compound it rather than multiplying: an NRR of 102% a month is 1.02 to the twelfth power, or about 127% a year, not 124%. This calculator does the reverse conversion too, turning quarterly or annual inputs into a monthly rate for the projection.
What counts as contraction versus churn?
Contraction is revenue lost from customers who stayed — downgrades, dropped seats, moving to a cheaper plan. Churn is revenue from accounts that left entirely. Both reduce gross retention, but they usually have completely different causes and fixes, which is why they are separate inputs here.
Related tools
Churn Rate Calculator
Calculate customer churn, revenue churn, retention rate, net revenue retention and average customer lifetime from your start-of-period figures.
MRR & ARR Calculator
Normalise monthly, quarterly and annual plans into a single MRR and ARR, and break month-over-month movement into new, expansion, contraction and churn.
ARPU Calculator
Calculate ARPU and ARPPU from revenue and user counts, with free-to-paid conversion and automatic monthly, quarterly and annual normalisation. Free and private.
Customer Lifetime Value Calculator
Calculate LTV from ARPU, gross margin and churn, then check it against your CAC for the LTV:CAC ratio, payback period and a health band.
CAC Calculator
Calculate blended and paid customer acquisition cost, the LTV:CAC ratio and CAC payback in months from your sales and marketing spend. Free and offline.