Net Revenue Retention (NRR) Calculator
Replace the sample values with your own, in one currency and one reporting period. Enter percentages as whole numbers: 2 for 2%. Calculations run in your browser.
Net Revenue Retention % = (Starting MRR + Existing Customer Upgrades - Existing Customer Downgrades - Existing Customer Churn) / Starting MRR | Variable | Meaning |
|---|---|
Starting MRR | Monthly recurring revenue at the start of the period. |
Existing Customer Upgrades | Expansion revenue from existing customers. |
Existing Customer Downgrades | Contraction revenue from existing customers. |
Existing Customer Churn | Recurring revenue lost from existing customers. |
Worked example
- Starting MRR
- $100,000
- Upgrades (expansion MRR)
- $15,000
- Downgrades (contraction MRR)
- $5,000
- Churned MRR
- $3,000
- → Net Revenue Retention
- 107%
Enable JavaScript to use the interactive calculator.
What NRR measures
NRR is net revenue retention, the percentage of recurring revenue retained from existing customers over a period, including expansion, downgrades, and churn. NRR above 100% means expansion outpaces losses.
Prepare your inputs
- Starting MRR: copy the closing MRR from your previous report for the accounts active on that date. Copying it, instead of recomputing it later, keeps the cohort identical to what you already reported.
- Upgrades: enter MRR increases from those starting accounts only. Revenue from accounts added after the start date has no place in this calculator.
- Downgrades and churned MRR: enter both as positive amounts. A downgrade that ends at $0 is churn; enter it once, in churned MRR, not in both fields.
The NRR method in the guide shows how to build each figure.
Formula
Net Revenue Retention % = (Starting MRR + Existing Customer Upgrades - Existing Customer Downgrades - Existing Customer Churn) / Starting MRR | Variable | Meaning |
|---|---|
Starting MRR | Monthly recurring revenue at the start of the period. |
Existing Customer Upgrades | Expansion revenue from existing customers. |
Existing Customer Downgrades | Contraction revenue from existing customers. |
Existing Customer Churn | Recurring revenue lost from existing customers. |
Check the sample calculation
Worked example
- Starting MRR
- $100,000
- Upgrades (expansion MRR)
- $15,000
- Downgrades (contraction MRR)
- $5,000
- Churned MRR
- $3,000
- → Net Revenue Retention
- 107%
What happens when one large account leaves
Same cohort and the same $15,000 of upgrades and $5,000 of downgrades. This time one large customer paying $9,000 a month also cancels, so churned MRR rises from $3,000 to $12,000.
Changed scenario
- Starting MRR
- $100,000
- Upgrades (expansion MRR)
- $15,000
- Downgrades (contraction MRR)
- $5,000
- Churned MRR
- $12,000
- → Net Revenue Retention
- 98%
One account takes NRR from 107% to 98%. Before you read that as a broad retention problem, check how much of starting MRR sits in your largest few accounts. In a concentrated base, NRR moves in steps.
Before using the result
- A dash
- Starting MRR is zero, or downgrades plus churn exceed starting MRR plus upgrades. The second case usually means a lost account was entered in both loss fields, or the losses include accounts outside the starting cohort.
- Above 100% while customers leave
- NRR weights dollars, so one expanding large account can offset many small cancellations. Enter the same starting MRR, downgrades and churn without upgrades to see the losses on their own. Open the GRR calculator.
- Exactly 100%
- Usually this means the movement fields were left at zero, not that nothing happened. Confirm that each of the three movements came from the subscription ledger.
Read the NRR cautions before you trust the figure.
Read the NRR guide for a business scenario, interpretation, and frequently asked questions.
Check how your team defines NRR before relying on the result.
Sources and methodology
These references explain the methods. The worked scenarios use hypothetical figures. They are not company results or current market benchmarks.
- ChartMogul: Net MRR Retention cohort
Following recurring revenue from the same customer cohort.
- ChartMogul: Gross MRR Retention report
Retention excluding expansion and reactivation.
Found an error or a definition that differs from your reporting? Send a correction with the page URL and the method you use.