Net revenue retention (NRR) calculator

Find how much recurring revenue the customers you started with bring in now. Enter starting MRR, expansion, contraction and churn. Formulas and sources shown.

$
$
$
$
MRR from the same customers now ÷ MRR at the start—
Net revenue retention
—
NRR = (starting MRR + expansion − contraction − churn) ÷ starting MRR. New customers are left out on purpose. Use the same period and currency for every figure: NRR depends on the period you choose, so a monthly 105% is not an annual 105%. Some teams count downgrades inside expansion, so use the same method each time. The 12-month figure is Webtilly’s own calculation: it raises a monthly result to the power of 12, which assumes the monthly rate never changes.

How to use it

  1. Enter your MRR at the start of the period, counting only the customers you had then.
  2. Enter the expansion MRR (upgrades, extra seats), the contraction MRR (downgrades) and the churned MRR (customers who left) for the same period.
  3. 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

  1. Orb: How to calculate NRR (opens in a new tab) (the formula; 10,000 starting MRR, 2,000 expansion, 500 contraction and 1,000 churn gives 105%; some teams fold downgrades into net expansion)
  2. Webtilly’s own: the 12-month figure.

W

Written by the Webtilly team

Formula and sources last checked: 26th Oct 2026 · How we check our work

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.