What to enter
Opening cohort MRR is the MRR from customers paying just before the month's first day. Every other field covers only those customers. Anyone who first paid during the month stays out.
Count each loss once. A customer who pays less but stays is contraction. A customer who cancels everything is churn.
Reactivation here is narrow. It's for someone in the opening group who cancelled and came back in the same month. Enter their loss as churned MRR and their return as reactivation. A former customer who had already left before the month began isn't in this group.
How to read the result
$20,000 opening MRR
Example
Expansion $1,500. Contraction $400. Churned $1,100, of which $200 came back as reactivation.
Ending cohort MRR is $20,200. NRR is 101.00%.
The breakdown table walks from opening to ending cohort MRR. In the example, NRR is above 100% even though $1,100 churned, because expansion more than made up for it.
How is net revenue retention calculated?
Take the opening group's MRR, add what they gained, subtract what they lost, and divide by where they started.
Net revenue retention
Formula
NRR = (opening MRR + expansion + reactivation - contraction - churned) ÷ opening MRR × 100
ChartMogul's NRR report uses this formula and leaves new customers out. Not every tool counts reactivation: Baremetrics' formula leaves it out, and ChartMogul has a setting to drop it. Pick one rule and keep it from month to month.
What does NRR above or below 100% mean?
At 100%, your existing customers pay exactly what they paid at the start of the month. Above 100%, their upgrades outweigh their downgrades and cancellations, so revenue grows even with no new sales. Below 100%, they pay less than before.
NRR measures revenue, not people. You can lose customers and still be above 100%, as the example shows. To count the customers who left, use the customer churn calculator.
How is NRR different from gross revenue retention?
Gross revenue retention (GRR) counts only the losses. It leaves out expansion and reactivation, so it can't go above 100%. NRR adds the gains back.
This calculator doesn't show GRR. The revenue churn calculator shows the share of starting MRR lost, and compares churn and retention measures side by side.
Why doesn't my NRR match my billing tool?
Usually the starting group or a rule differs. Check these:
- Who was in the opening group. ChartMogul counts past-due subscriptions as well as active ones.
- Whether reactivation is counted.
- Whether every figure covers the same month and currency.
For the whole company's MRR, new customers included, use the MRR waterfall calculator.