Net and Gross Revenue Retention Calculator
How much starting-cohort recurring revenue remained with and without expansion? Check the formula, a worked example and the stated measurement limits.
Result for the values shown.
Calculations run in your browser.
What to enter
| Input | Meaning and units |
|---|---|
| Starting-cohort MRR (currency/month) | Enter starting-cohort mrr in currency/month. Use the measurement basis described below. |
| Expansion from that cohort (currency/month) | Enter expansion from that cohort in currency/month. Use the measurement basis described below. |
| Contraction from that cohort (currency/month) | Enter contraction from that cohort in currency/month. Use the measurement basis described below. |
| Churn from that cohort (currency/month) | Enter churn from that cohort in currency/month. Use the measurement basis described below. |
Understanding your result
Read NRR and GRR together: expansion can mask gross revenue loss. A net value above 100% is mathematically possible, while gross retention here cannot exceed 100%.
Common mistakes
- Adding new-customer MRR inflates retention.
- Revenue retention is not customer-count retention.
Check your calculation
- Use the worked example as a known reference case, then change one input at a time and check the direction and units of the response.
Choose a consistent measurement basis
Track the customers present at the beginning of the window. Exclude new customers acquired during the window; record losses and expansion under the same recurring-revenue policy.
A second independently worked case
No losses give GRR 100%; 200 expansion over 1,000 gives NRR 120%. Inputs: Starting-cohort MRR: 1000 currency/month; Expansion from that cohort: 200 currency/month; Contraction from that cohort: 0 currency/month; Churn from that cohort: 0 currency/month. Results: Net revenue retention: 120 %; Gross revenue retention: 100 %; Retained MRR before expansion: 1000 currency/month.
Precision and output units
Displayed results: Net revenue retention in %, rounded to 2 decimal places; Gross revenue retention in %, rounded to 2 decimal places; Retained MRR before expansion in currency/month, rounded to 2 decimal places. Display rounding does not establish the precision of the original measurements or estimates. A small positive rate can round to 0.00%; inspect the underlying counts before treating displayed zero as an absence of events.
Calculation checks, sources and review limits
How much starting-cohort recurring revenue remained with and without expansion?
How much starting-cohort recurring revenue remained with and without expansion? Check the formula, a worked example and the stated measurement limits.
Common uses
- How much starting-cohort recurring revenue remained with and without expansion
- Compare Net and Gross Revenue Retention across scenarios under matching definitions.
How it works
Subtract contraction and churn from starting-cohort MRR for gross retention. Add expansion from those same starting customers for net retention. Divide each retained amount by positive starting MRR.
Worked example
8,500 remains before expansion; 1,500 expansion brings NRR to 100%, while GRR is 85%. Enter starting-cohort mrr 10000 currency/month, expansion from that cohort 1500 currency/month, contraction from that cohort 500 currency/month, churn from that cohort 1000 currency/month. The independently worked result is net revenue retention 100 %; gross revenue retention 85 %; retained mrr before expansion 8500 currency/month. Compare this example with your reporting definitions before substituting your own figures.
FAQ
Can net retention exceed 100% while gross retention is lower?
Yes. Starting MRR of 10,000, losses of 1,500 and expansion of 3,500 imply GRR 85% and NRR 120%. Expansion can offset or exceed losses while gross retention continues to show those losses.
Why are newly acquired customers excluded?
Retention follows the starting cohort. Adding revenue from later acquisitions mixes acquisition with retention and can conceal losses among the original customers.