Net revenue retention calculation, with a cohort audit
Calculate NRR from the same starting customers, exclude new logos, and test what expansion may be hiding.
By Wei-Lin Zhao · AI Correspondent
· 5 min read
A net revenue retention calculation measures how recurring revenue from the customers you already had at the start of a period changed by the end. Start with that cohort’s recurring revenue, add its expansion, subtract its downgrades and cancellations, then divide by starting revenue. Revenue from customers acquired during the period does not belong in NRR.
The result is revenue-weighted, not a customer-retention count and not total company growth. A business can add substantial new-logo revenue while its NRR falls, because NRR isolates the performance of the opening customer base.
Net revenue retention calculation formula
NRR = (Starting recurring revenue + Expansion revenue − Contraction revenue − Churned revenue) ÷ Starting recurring revenue × 100
- Starting recurring revenue: recurring revenue from the customer cohort in place on day one.
- Expansion revenue: added recurring revenue from those customers, such as upsells, cross-sells, added seats, higher committed usage, or upgrades.
- Contraction revenue: recurring revenue lost when an existing account downgrades, removes seats, or reduces committed usage.
- Churned revenue: recurring revenue that falls to zero because a customer cancels or does not renew.
Use one revenue basis and one time interval throughout. A monthly NRR calculation uses MRR and the month’s movements; an annual calculation uses annual recurring-revenue inputs for the annual period. Mixing monthly losses with annual starting revenue produces a ratio that does not describe either period. If using ARR, apply a consistent recurring-revenue policy; ARR is an annualized subscription measure, rather than total revenue or profit.
Worked example: from $100,000 to 101% NRR
Inputs for one month
- Starting MRR from the January 1 customer cohort: $100,000
- MRR lost to cancellations: $5,000
- MRR lost to downgrades: $2,000
- MRR added through upgrades from that same cohort: $8,000
- MRR from customers signed during January: excluded from this calculation
Step 1: Reconcile the ending MRR of the starting cohort.
$100,000 − $5,000 − $2,000 + $8,000 = $101,000
Step 2: Divide by the opening cohort revenue.
$101,000 ÷ $100,000 × 100 = 101% NRR
Check: the cohort finished with $1,000 more recurring revenue than it started with, so NRR is 1 percentage point above 100%. The company may have acquired other customers during the month, but their revenue affects total MRR or ARR, not this result.
Build the calculation so it can be checked
- Freeze the cohort. List every paying customer with recurring revenue at the start date. Do not add customers that first paid later in the period.
- Set the unit and window. Decide whether the measure is monthly, quarterly, or annual, and retain that convention for every input and comparison.
- Classify each change from the cohort. An account’s added seats are expansion; a lower plan is contraction; a cancellation or nonrenewal is churn. For usage-based pricing, use consistent snapshots and classify the net usage movement.
- Reconcile to the cohort’s end balance. Starting revenue plus expansion, less contraction and churn, should equal end-of-period recurring revenue from the original cohort. A mismatch can mean new-customer revenue has entered the numerator or an account movement was misclassified.
- Keep the components beside the headline percentage. The result is more useful when readers can see expansion, contraction, and churn separately, and when it is split by segment where the data permits.
How to read the percentage
- Above 100%: expansion from the starting cohort exceeded its contraction and churn. The cohort’s recurring revenue grew without crediting any new customers.
- At 100%: expansion exactly offset contraction and churn, leaving recurring revenue from the cohort unchanged.
- Below 100%: contraction and churn exceeded expansion, so recurring revenue from the cohort declined.
There is no universal target that travels cleanly across SaaS businesses. Customer segment, contract value, pricing structure, product scope, stage, and the precise measurement rules all affect the figure. The first analytical question is usually composition: whether a reported NRR comes from broad account expansion, a small number of large expansions, low churn, or some combination.
NRR and GRR answer different questions
Gross revenue retention, or GRR, uses the same starting cohort but excludes expansion: (starting recurring revenue − contraction − churn) ÷ starting recurring revenue × 100. It shows the revenue preserved before upsells and cross-sells, and cannot exceed 100%.
- NRR: includes expansion; shows the net revenue change in the existing base.
- GRR: excludes expansion; makes downgrade and cancellation losses visible.
Read the pair together. A strong NRR can coexist with weak GRR if expansions from a few accounts compensate for losses elsewhere. Conversely, the same ending total company MRR can mask sharply different retention results if one company got there through new acquisition while another grew its opening cohort. NRR should therefore be reported with its period, cohort definition, recurring-revenue policy, and component movements, rather than as a standalone percentage.
Frequently asked questions
Does NRR include revenue from new customers?
No. NRR measures recurring-revenue change within the customer cohort that existed at the beginning of the chosen period. Revenue from customers acquired during that period belongs in total MRR or ARR growth, not NRR.
What does NRR above 100% mean?
It means expansion revenue from the starting customer cohort exceeded the recurring revenue lost through downgrades and churn. The cohort generated more recurring revenue at period end than it did at period start, without counting new customers.
How do you calculate NRR from customer-level data?
Identify the customers paying at the start date, then compare recurring revenue from only that group at the end date with its starting recurring revenue. Classifying changes as expansion, contraction, and churn creates an auditable reconciliation; the end-of-period cohort amount divided by the starting cohort amount produces the same NRR.
Why track both NRR and GRR?
NRR includes expansion, while GRR excludes it and captures revenue retained after downgrades and churn. Comparing them can show whether account expansion is offsetting losses that a single NRR figure could conceal.
Sources
- Net revenue retention (NRR) for SaaS businesses — stripe.com
- Net Revenue Retention: How to Calculate NRR with ... — www.gainsight.com
- What Is Net Revenue Retention & Why It Matters - Amplitude — amplitude.com
- What is Net Revenue Retention & How To Calculate It — churnzero.com
- Net Revenue Retention (NRR): Tutorial + Excel Examples — breakingintowallstreet.com
