Net Revenue Retention Calculator

Behind the number

Net revenue retention measures what happens to revenue from an existing cohort, including expansion: NRR = (starting revenue + expansion − contraction − churn) ÷ starting revenue × 100.

It excludes new customers entirely, which is what makes it a measure of the existing base rather than of growth.

Above 100% means the existing base grows without any new customers, which is the property that makes a subscription business compound.

A real example

A cohort starting at $100,000 of annual revenue: $22,000 of expansion from upgrades and larger orders, $6,000 of contraction from downgrades, and $18,000 lost to churn.

NRR = (100,000 + 22,000 − 6,000 − 18,000) ÷ 100,000 = 98%.

The base is shrinking slightly. Raising expansion to $30,000 would give 106%, at which point the business grows 6% a year from existing customers alone before any acquisition.

That difference, 98% against 106%, compounds enormously over five years, and it is the single most watched number in subscription businesses for exactly that reason.

The usual mistakes

NRR can exceed 100% while customer counts fall, if the remaining customers expand faster than others leave. That is a real result and it concentrates the business into fewer, larger relationships, which is a risk the metric does not show.

It is also cohort-specific, and quoting a blended figure across cohorts of different ages mixes populations behaving differently.

Using the result

Report it alongside gross revenue retention, which excludes expansion. The gap between the two is the expansion contribution, and knowing whether NRR is held up by expansion or by low churn changes what to work on.

Then watch customer count alongside it. NRR above 100% with a falling customer count is concentration rather than growth, and it is more fragile than the number suggests.

Why it matters less outside subscriptions

NRR is built for businesses with contractual recurring revenue, where expansion and contraction are observable events. In transactional retail, a customer buying more this year than last is not an upgrade and there is no contraction to record.

The transactional equivalent is cohort revenue over time; what a cohort spends in year two against year one, which answers the same question without the subscription framing.

That figure is worth calculating for any repeat-purchase business, because it distinguishes a business whose customers deepen from one whose customers fade. The first can grow while acquiring less; the second has to keep acquiring to stand still, which is a materially harder business to run.

Expansion revenue should be traced to its source, since expansion from price rises is a different thing from expansion through genuine account growth and the two have very different durability.

Reporting the split makes a headline figure interpretable, because a business holding NRR above 100% purely through annual price increases is in a weaker position than the number suggests.

Segmenting it by customer size usually reveals that expansion concentrates among larger accounts while churn concentrates among smaller ones, which are two separate problems.

The measure hides its own composition, which is where the interesting information sits. Net retention of 105% could be low churn with modest expansion, or heavy churn offset by a handful of accounts upgrading substantially. Those describe very different businesses with the same headline number, and reporting gross retention alongside it is what separates them.