Excel guide · 4 min read
How to calculate net revenue retention (NRR) in Excel
=SUMIFS(C2:C12,B2:B12,">0")/SUM(B2:B12): what last year's customers pay now, over what they paid then. Here 10,100 of starting MRR became 10,350, an NRR of 102.5%.Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Customer | MRR Oct 2025 | MRR Oct 2026 | Movement | Change | Starting MRR | 10100 | |
| 2 | Acme Dental | 1200 | 1500 | Expansion | 300 | Expansion | 1500 | |
| 3 | Birch Interiors | 800 | 800 | Flat | 0 | Contraction | 950 | |
| 4 | Cobalt Labs | 2500 | 3400 | Expansion | 900 | Churned | 300 | |
| 5 | Dune Coffee | 300 | 0 | Churned | -300 | New (excluded) | 1300 | |
| 6 | Elm Street Gym | 450 | 350 | Contraction | -100 | NRR | 1.0247524752 | |
| 7 | Fable Studio | 1800 | 1100 | Contraction | -700 | GRR | 0.87623762376 | |
| 8 | Granite Build | 950 | 1250 | Expansion | 300 | |||
| 9 | Harbor Clinic | 600 | 450 | Contraction | -150 | Monthly NRR (example) | 1.005 | |
| 10 | Iris Florals | 0 | 400 | New | 400 | |||
| 11 | Juniper Media | 0 | 900 | New | 900 | |||
| 12 | Kite Logistics | 1500 | 1500 | Flat | 0 |
Download this sheet as an Excel practice file (.xlsx)
The data: one row per customer, MRR at both ends
Net revenue retention (NRR, also called net dollar retention) asks: of the recurring revenue we had a year ago, how much do those same customers pay us now? Upgrades push it up; downgrades and cancellations pull it down. Above 100% means growth from existing customers alone outran what you lost.
You need one row per customer with their monthly recurring revenue (MRR) at the start and end of the period: October 2025 in B and October 2026 in C. A customer who left has 0 at the end; a customer who joined during the year has 0 at the start. If your billing export is one row per invoice, build these two columns first with SUMIFS on the customer and the month; see MRR in Excel.
Classify each customer's movement with IFS
Label every row so you can total each kind of movement. Order matters in IFS, because it returns the first test that's true. New has to come first, or a new customer (0 to 400) would be called Expansion. Churned comes next, then up, down, and TRUE as the catch-all for no change.
E2 holds the change, =C2-B2. Acme Dental moved from 1,200 to 1,500, an expansion of 300. In Excel 2016 and earlier, which have no IFS, nest IF functions in the same order.
Result: Expansion
Expansion: Acme Dental went from 1,200 to 1,500 a month.
Total each movement with SUMIFS
Starting MRR is the sum of column B, 10,100. New customers have 0 there, so they add nothing. Expansion is the sum of the changes labelled Expansion: 300 + 900 + 300 = 1,500. Contraction and churn are negative changes, so put a minus in front of SUMIFS to show them as positive amounts: 950 of contraction and 300 of churn.
The two new customers bring 1,300 of MRR, and it's shown in H5 only so nobody wonders where it went. It doesn't belong in NRR, which measures the customers you started with. Including it would turn NRR into plain revenue growth.
Result: 1500
1,500 of expansion MRR from Acme Dental, Cobalt Labs and Granite Build.
The NRR formula
Add expansion to the starting MRR, take away contraction and churn, and divide by the starting MRR: (10,100 + 1,500 - 950 - 300) / 10,100 = 102.5%. The customers you had a year ago now pay 2.5% more in total, even after Dune Coffee left and three customers cut back.
As a check, the shortcut in the answer gives the same result: end MRR of customers who had MRR at the start, over their starting MRR. If the two ever disagree, a customer is probably mislabelled.
Result: 1.0247524752 shows as 102.5% with Percent format
1.025, shown as 102.5%: net revenue retention for the year.
Why not just divide total MRR now by total MRR then?
Because that includes new customers. SUM(C2:C12)/SUM(B2:B12) gives 115.3%, which is revenue growth, not retention.
Result: 1.1534653465 shows as 115.3% with Percent format
1.153, or 115.3%: total MRR growth including the two new customers.
Gross revenue retention alongside
Gross revenue retention (GRR) is NRR without the expansion: starting MRR minus contraction and churn, over starting MRR. It can never be above 100%, and it shows how much revenue leaks out before upgrades cover the hole. Here it's 87.6%.
Report the two together. An NRR of 102.5% looks healthy, but the GRR says 12.4% of last year's revenue walked away or shrank, and three accounts did all the expanding. If Cobalt Labs hadn't upgraded, NRR would fall below 100%.
Result: 0.87623762376 shows as 87.6% with Percent format
0.876, shown as 87.6%: gross revenue retention, before any expansion.
Monthly vs annual NRR
NRR is usually quoted for 12 months: this year's MRR from customers who were paying 12 months ago. Some teams also track it monthly, comparing each month with the one before. The two aren't interchangeable. A monthly NRR of 100.5% held for a year compounds to about 106.2%, not 106%, and a monthly figure from one good month says little about the year.
If you report a monthly figure, say so, and don't annualise it by multiplying by 12. Measure the annual number directly from the customers who were paying at the start of the 12 months, as in this sheet.
Result: 1.0616778119 shows as 106.2% with Percent format
1.062, shown as 106.2%: what a steady 100.5% monthly NRR compounds to over 12 months.
Common mistakes
Including new customers
NRR covers only customers who were paying at the start. Their MRR at the end over their MRR at the start.
Putting the New test after the Expansion test in IFS
IFS stops at the first true test, so a 0 to 400 customer would count as expansion. Test for New first.
Reporting NRR without GRR
Expansion can hide heavy churn. Show gross revenue retention next to it.
Annualising a monthly figure by multiplying
Retention compounds. Measure the 12-month figure directly, or raise the monthly one to the power 12 as a rough guide only.
FAQ
What is the formula for net revenue retention?
(Starting MRR + expansion - contraction - churned MRR) / starting MRR, for customers who were paying at the start of the period. Use ARR instead of MRR if that's how you track revenue; the ratio is the same.
What is the difference between NRR and GRR?
GRR leaves out expansion, so it shows only what you kept of the starting revenue and can't go above 100%. NRR adds expansion back. In the example they're 87.6% and 102.5%.
Does a price increase count as expansion?
Yes. Any increase in what an existing customer pays, from an upgrade, more seats or a price rise, is expansion MRR.
How is NRR different from churn rate?
Churn rate usually counts customers lost. NRR measures money, and it nets losses against upgrades, so you can lose customers and still have NRR above 100%. See churn rate in Excel.
Functions used
Related guides
- How to calculate MRR (monthly recurring revenue) in Excel
- How to calculate churn rate in Excel
- How to calculate customer lifetime value in Excel
- How to build a deferred revenue schedule in Excel
- How to calculate customer concentration in Excel
- ABC inventory analysis in Excel
Updated