Net Revenue Retention: How to Calculate NRR and GRR in Excel
Net revenue retention explained: the formula, how NRR differs from GRR, and how to calculate both in Excel from an MRR export, with a worked example.
- SaaS Metrics
- Excel
- Retention

Net revenue retention (NRR) tells you how much recurring revenue you kept from the customers you already had, after upgrades, downgrades and cancellations. Above 100%, your existing customers grow on their own. Below 100%, you need new customers to stand still. Below: the formula, how it differs from gross revenue retention, and how to compute both in Excel or Google Sheets from an MRR export, with a worked example.
What is net revenue retention?
Net revenue retention is the recurring revenue a fixed group of customers brings at the end of a period, divided by what the same customers brought at the start. Expansion pushes it up, contraction and churn pull it down, and new customers stay out of it.
Stripe gives the formula as beginning recurring revenue, minus MRR lost to churn and downgrades, plus revenue from upgrades, divided by beginning recurring revenue Stripe:
NRR = (starting MRR + expansion - contraction - churn) / starting MRRThe period is usually 12 months: the customers active a year ago, compared with their MRR today Metabase. A monthly NRR exists too, but it moves a lot from one month to the next and doesn't compare with figures from other organizations.
Some tools also count reactivations, customers who left and came back during the period. ChartMogul adds them to the numerator by default and lets you exclude them ChartMogul. Say which rule you use next to the figure.
What is the difference between NRR and GRR?
Gross revenue retention (GRR) counts only the losses: churn and contraction. Expansion is left out, so each customer counts for at most their starting MRR and GRR can never go above 100%. NRR adds expansion back and can.
Stripe gives GRR as beginning recurring revenue minus MRR lost to churn and downgrades, divided by beginning recurring revenue, and notes that it can't exceed 100% Stripe. Read the two together. A high NRR with a low GRR means a few customers grow fast while many leave. That is a fragile base, even when the NRR looks healthy.
| NRR | GRR | |
|---|---|---|
| Counts expansion | Yes | No |
| Counts contraction and churn | Yes | Yes |
| Can exceed 100% | Yes | No |
| Answers | Does the base grow on its own? | How much of the base do you keep? |
How do you calculate NRR in Excel?
Put one row per customer with two columns: MRR at the start of the period and MRR at the end. Keep only the customers whose starting MRR is above zero. NRR is the sum of their ending MRR divided by the sum of their starting MRR.
Take eight customers, with MRR in October 2025 in column B and October 2026 in column C:
| Customer | Oct 2025 | Oct 2026 | What happened |
|---|---|---|---|
| A | 500 | 650 | Expansion |
| B | 300 | 300 | No change |
| C | 200 | 0 | Churn |
| D | 1,000 | 800 | Contraction |
| E | 400 | 520 | Expansion |
| F | 250 | 0 | Churn |
| G | 0 | 600 | New customer |
| H | 350 | 350 | No change |
=SUMIFS(C2:C9, B2:B9, ">0") / SUM(B2:B9)The seven customers present in October 2025 started at 3,000 and end at 2,620: 270 of expansion, 200 of contraction and 450 of churn. 2,620 divided by 3,000 gives 87.33%. Customer G started after October 2025, so the criterion leaves G out.
107.33% is what you get if customer G's 600 slips into the numerator: a shrinking base that looks like it grows.
That is the most common NRR mistake. Total MRR grew 7.33% in the example, but all of the growth came from one new customer, while the existing base lost 12.67% of its revenue.
Google Sheets takes the same formulas. SUMIFS works with the same arguments Google Docs Editors Help.
How do you calculate GRR and the four movements?
Add a helper column with the smaller of the two MRR values for each customer. GRR is the sum of that column divided by starting MRR. Three more helper columns split the change into expansion, contraction and churn, so you can see what drives the figure.
In column D, caps each customer at their starting MRR. Then:
=SUMIFS(D2:D9, B2:B9, ">0") / SUM(B2:B9)The capped values add up to 2,350, which gives 78.33%. For the movements, one helper column each, filled down:
- Expansion: =IF(B20, MAX(C2 - B2, 0), 0) adds to 270.
- Contraction: =IF(C20, MAX(B2 - C2, 0), 0) adds to 200.
- Churn: =IF(AND(B20, C2 = 0), B2, 0) adds to 450.
Check the sum: 3,000 + 270 - 200 - 450 = 2,620, the numerator of NRR. If it doesn't match, a customer is counted twice or a new customer slipped in. The same split appears in how to calculate real MRR and churn, which covers the definitions behind each MRR figure.
Where do you get MRR per customer from Stripe?
Stripe's Billing analytics offers a prebuilt report called "MRR per subscriber per month", with each subscriber's MRR at the end of each month. Download it from Report downloads on the Billing overview page, in live mode Stripe Docs.
From there, build a pivot table with customers in rows, months in columns and MRR in values. Copy the two months you compare into columns B and C, and the formulas above work as they are. How to group a pivot table by month covers the pivot step.
Two details from Stripe's documentation matter for the totals. Prebuilt reports use UTC, while the Billing analytics charts use your account's time zone, so a monthly total in the export can differ slightly from the chart. The "Customer MRR changes" report logs each upgrade, downgrade, reactivation and churn, which helps when you need to explain a single customer's line.
Without Stripe, any billing export with a customer, a date and a monthly amount works. Annual plans need dividing by 12 first, or a yearly renewal shows as a huge expansion one month and a churn the next.
Which mistakes skew NRR?
The usual errors are counting new customers, comparing different customer lists at the start and the end, and mixing billing amounts with MRR. Each one moves the figure by several points, and none of them shows up as an error in the spreadsheet.
- New customers in the numerator, as in the example above.
- One-off charges, setup fees or usage peaks counted as MRR. Expansion then looks bigger than it is.
- Annual plans not spread over 12 months.
- Currencies mixed without conversion.
- A start list rebuilt from today's customer list, which drops the customers who churned and pushes NRR up.
NRR describes revenue. For the number of customers you keep, use the customer retention rate, as shown in how to calculate customer retention rate.
Where does Glow Reports fit?
The spreadsheet above works well for one period. It gets slow when you want NRR every month over two years, by plan or by country, with the four movements under each figure.
Glow Reports starts from the same export. You upload the MRR CSV or Excel file and ask for NRR and GRR by month in plain language, with your rules on new customers and reactivations. The AI writes the SQL, builds the charts and drafts the text. The SQL sits under each figure, so you can check which customers were counted at the start and edit the query when a rule is wrong. The free plan gives 300 credits once, and a report costs 100 credits.
Common questions
What is a good net revenue retention?
Above 100% means the existing base grows without new customers. Stripe cites a 2022 OpenView report where median net dollar retention for SaaS ranged from 100% to 111%, depending on customer size Stripe. Compare with your own history first.
Is NRR the same as net dollar retention?
Close to it. Many teams use net dollar retention (NDR) as another name for the same calculation. Stripe treats the two as related, with NRR measured over a set period Stripe.
Should NRR be monthly or annual?
Annual for reporting and comparison: the customers active 12 months ago, compared with their MRR today. Monthly NRR helps to spot a bad month, but don't multiply it by 12.
Can GRR be higher than NRR?
No. GRR leaves expansion out, so it is equal to NRR when no customer grew and lower in every other case.
I am a product engineer and the founder of Glow Reports. I spent more than 6 years building products in tech, data and cybersecurity, for large groups, startups and SMEs. In most organizations I saw data treated as a technical topic, when it drives business decisions. I built the reporting tool I was looking for, so the people who run small and mid-sized organizations can read their own numbers without a data team.
More from El Mehdi BenaneUpload your CSV or Excel export to Glow Reports and get NRR and GRR with the SQL behind each figure.


