Net Revenue Retention (NRR) Calculator

Replace the sample values with your own, in one currency and one reporting period. Enter percentages as whole numbers: 2 for 2%. Calculations run in your browser.

Try it with your numbers

Illustrative calculation; verify inputs and assumptions before relying on it.

Net Revenue Retention—

Tick the box above to see your result.

Net Revenue Retention % = (Starting MRR + Existing Customer Upgrades - Existing Customer Downgrades - Existing Customer Churn) / Starting MRR
Variable Meaning
Starting MRR Monthly recurring revenue at the start of the period.
Existing Customer Upgrades Expansion revenue from existing customers.
Existing Customer Downgrades Contraction revenue from existing customers.
Existing Customer Churn Recurring revenue lost from existing customers.

Worked example

Starting MRR
$100,000
Upgrades (expansion MRR)
$15,000
Downgrades (contraction MRR)
$5,000
Churned MRR
$3,000
→ Net Revenue Retention
107%

Enable JavaScript to use the interactive calculator.

What NRR measures

Published by 4NLab · Updated · Our methods

NRR is net revenue retention, the percentage of recurring revenue retained from existing customers over a period, including expansion, downgrades, and churn. NRR above 100% means expansion outpaces losses.

Prepare your inputs

  1. Starting MRR: copy the closing MRR from your previous report for the accounts active on that date. Copying it, instead of recomputing it later, keeps the cohort identical to what you already reported.
  2. Upgrades: enter MRR increases from those starting accounts only. Revenue from accounts added after the start date has no place in this calculator.
  3. Downgrades and churned MRR: enter both as positive amounts. A downgrade that ends at $0 is churn; enter it once, in churned MRR, not in both fields.

The NRR method in the guide shows how to build each figure.

Formula

Net Revenue Retention % = (Starting MRR + Existing Customer Upgrades - Existing Customer Downgrades - Existing Customer Churn) / Starting MRR
Variable Meaning
Starting MRR Monthly recurring revenue at the start of the period.
Existing Customer Upgrades Expansion revenue from existing customers.
Existing Customer Downgrades Contraction revenue from existing customers.
Existing Customer Churn Recurring revenue lost from existing customers.

Check the sample calculation

Worked example

Starting MRR
$100,000
Upgrades (expansion MRR)
$15,000
Downgrades (contraction MRR)
$5,000
Churned MRR
$3,000
→ Net Revenue Retention
107%

What happens when one large account leaves

Same cohort and the same $15,000 of upgrades and $5,000 of downgrades. This time one large customer paying $9,000 a month also cancels, so churned MRR rises from $3,000 to $12,000.

Changed scenario

Starting MRR
$100,000
Upgrades (expansion MRR)
$15,000
Downgrades (contraction MRR)
$5,000
Churned MRR
$12,000
→ Net Revenue Retention
98%

One account takes NRR from 107% to 98%. Before you read that as a broad retention problem, check how much of starting MRR sits in your largest few accounts. In a concentrated base, NRR moves in steps.

Before using the result

A dash
Starting MRR is zero, or downgrades plus churn exceed starting MRR plus upgrades. The second case usually means a lost account was entered in both loss fields, or the losses include accounts outside the starting cohort.
Above 100% while customers leave
NRR weights dollars, so one expanding large account can offset many small cancellations. Enter the same starting MRR, downgrades and churn without upgrades to see the losses on their own. Open the GRR calculator.
Exactly 100%
Usually this means the movement fields were left at zero, not that nothing happened. Confirm that each of the three movements came from the subscription ledger.

Read the NRR cautions before you trust the figure.

Read the NRR guide for a business scenario, interpretation, and frequently asked questions.

Check how your team defines NRR before relying on the result.

Sources and methodology

These references explain the methods. The worked scenarios use hypothetical figures. They are not company results or current market benchmarks.

Found an error or a definition that differs from your reporting? Send a correction with the page URL and the method you use.