How to use it
- Enter your MRR at the start of the period, counting only the customers you had then.
- Enter the expansion MRR (upgrades, extra seats), the contraction MRR (downgrades) and the churned MRR (customers who left) for the same period.
- Read the big number first: it is the share of your starting MRR that those same customers bring in now.
The numbers in the boxes when the page loads are examples, not a forecast. Replace them with your own.
The math, shown
Net revenue retention compares the revenue you have now from the customers you started with, to the revenue they brought in at the start. New customers are left out on purpose.
NRR = (starting MRR + expansion − contraction − churn) ÷ starting MRR
Starting MRR. Monthly recurring revenue from the customers you had at the start of the period.
Expansion. Extra MRR from those customers: upgrades, extra seats, add-ons.
Contraction. MRR lost to downgrades from those customers.
Churn. MRR lost because those customers left.
MRR from the same customers now. Starting MRR + expansion − contraction − churn.
NRR is a published formula (see Sources). The 12-month figure is Webtilly’s own calculation: it raises a monthly NRR to the power of 12, which assumes the monthly rate never changes.
Worked example
Starting MRR 10,000. Expansion 2,000. Contraction 500. Churn 1,000.
- MRR from the same customers now = 10,000 + 2,000 − 500 − 1,000 = 10,500.
- NRR = 10,500 ÷ 10,000 = 105%.
- If those figures are for one month, 12 months at the same rate is 1.05 to the power of 12 = 179.59%.
How to read your result
At 100%, the customers you started with bring in the same revenue as before. Above 100%, expansion is more than making up for downgrades and churn. Below 100%, the same customers are bringing in less. A second example: starting MRR 20,000, expansion 500, contraction 800 and churn 1,700 gives 18,000, which is 90%.
We give no figure for a good NRR, because we have no source for one. NRR also depends on the period: a monthly 105% is not an annual 105%. Compare your own figure with the same method and period over time.
What this tool leaves out
- New customers are not counted. NRR is about the customers you already had.
- Some teams count downgrades inside expansion. Use the same method every time you compare.
- The 12-month figure assumes the monthly rate never changes, which is rarely true. Treat it as an illustration, not a forecast.
Frequently asked questions
Can NRR be above 100%?
Yes. If the extra revenue from upgrades is larger than the revenue lost to downgrades and churn, the customers you started with bring in more than before, even without any new customers. In the example it is 105%.
Why are new customers left out?
NRR asks what happened to the customers you already had. Adding new customers would mix selling to new people with keeping and growing the ones you have, and you could no longer tell which was which.
Can I compare a monthly NRR with an annual one?
No. Over a month, losing 1% of revenue is small; over a year the same rate compounds into a much bigger change. Use the same period every time you compare, and say which period you used.
Sources
- Orb: How to calculate NRR (the formula; 10,000 starting MRR, 2,000 expansion, 500 contraction and 1,000 churn gives 105%; some teams fold downgrades into net expansion)
- Webtilly’s own: the 12-month figure.
W
Written by the Webtilly team
Note: This tool shows the result of the numbers you enter. It is an estimate, not a forecast, and it is not tax, legal, or financial advice.