Why Net Revenue Retention matters
NRR above 100% means expansion more than offsets lost revenue under the chosen definition. Below 100% means the opening base contracted overall.
- Business question
- After expansion and churn, how much recurring revenue remains from the customers we started with?
- Teams that use it
- Finance, customer success, revenue operations, sales, and leadership teams.
- Decisions it supports
- Renewal and expansion priorities, forecasts, account health programmes, packaging, and customer-segment strategy.
Net Revenue Retention formula
(Revenue Retained + Expansion Revenue − Churned Revenue) ÷ Starting Revenue × 100
Formula components
- Starting revenue
- Recurring revenue from the fixed opening customer cohort.
- Revenue retained
- Recurring revenue carried by that opening cohort before the separately recorded churn deduction, excluding expansion and new customers.
- Expansion revenue
- Additional recurring revenue from upgrades, add-ons, or increased usage by the opening cohort.
- Churned revenue
- Recurring revenue lost from customers in the opening cohort.
How to calculate Net Revenue Retention
- Freeze the customer cohort and recurring revenue at the start of the period.
- Measure retained, expansion, and churned revenue for only that cohort using mutually exclusive categories.
- Add retained and expansion revenue, then subtract churned revenue as specified by the workbook formula.
- Divide by starting revenue and multiply by 100; exclude all new-customer revenue.
Net Revenue Retention example
An opening customer cohort has £500,000 in recurring revenue. During the quarter, £480,000 is retained before the separate churn adjustment, £55,000 comes from expansion, and £30,000 is classified as churned revenue.
- Adjusted ending revenue = £480,000 + £55,000 − £30,000 = £505,000.
- NRR = £505,000 ÷ £500,000 × 100.
- NRR = 101%.
Net Revenue Retention is 101%.
Revenue from the opening customer base grew by 1% after the defined expansion and churn movements, without counting new customers.
How to interpret the result
Read NRR with gross retention and an account-level bridge. Strong expansion from a few accounts can mask broad customer losses, while a stable rate can hide offsetting movements.
Definitions differ in how they treat contraction, usage revenue, currency changes, reactivation, and churn. Compare only when the bridge categories are aligned.
Common mistakes and limitations
- Including new customers
- NRR isolates the opening cohort; new-logo revenue belongs elsewhere.
- Double-counting churn
- If retained revenue is already net of churn, subtracting churn again understates NRR. Bridge categories must be mutually exclusive.
- Mixing customer and revenue retention
- NRR weights accounts by recurring revenue, not by account count.
- Inconsistent currency or period
- Exchange rates and mismatched monthly or annual values can create false movement.
