Skip to content
PutlerPutler
Rain fills a garden basin as water leaks through a crack.

Net Revenue Retention (NRR): Formula and Worked Example

Calculate net revenue retention from existing customers, compare it with gross revenue retention, and see why NRR can differ from your billing dashboard.

Net revenue retention (NRR) measures how much recurring revenue you have at the end of a period from the customers who were paying at the start. It counts increases from upgrades or add-ons, decreases from downgrades, and revenue lost when customers leave. It’s also called net dollar retention (NDR).

If those customers generated $10,000 in monthly recurring revenue at the start and $10,500 at the end, your NRR is 105%. Revenue from newly acquired customers stays outside the calculation.

How to calculate net revenue retention

NRR = (Ending recurring revenue from starting customers ÷ Starting recurring revenue from those customers) × 100

You can calculate it from two billing snapshots:

  1. Choose a start date and an end date. Use the same currency and recurring revenue rules at both dates.
  2. List each customer ID with positive monthly recurring revenue (MRR) on the start date. Combine multiple subscriptions for the same customer. Divide annual subscription fees by 12 for their monthly equivalent and leave out one-time charges such as setup fees.
  3. Look up ending MRR for those same customer IDs. Use zero for a starting customer whose recurring revenue has ended by the second date.
  4. Sum the starting and ending amounts for that group, then apply the formula. If starting recurring revenue is zero, the rate is undefined.

The fixed starting group method also gives you a way to explain changes. Compare each starting customer’s two amounts. A positive difference is expansion. A decrease to a positive amount is contraction. A drop to zero is churn. Count each customer’s net change once, even if they changed plans several times during the period.

Net revenue retention worked example

Suppose the customers you start the quarter with generate $10,000 in MRR. Here’s how their MRR changes by the end of the quarter.

Two people set out picnic chairs while their dog tugs one away.
At least we have enough chairs.
MRR from starting customersAmount
Starting MRR$10,000
Expansion from upgrades and add-ons+$1,500
Contraction from downgrades−$300
Revenue lost to churn−$700
Ending MRR from the same customers$10,500

NRR = ($10,500 ÷ $10,000) × 100 = 105%

Expansion covered the $1,000 lost to downgrades and churn, leaving the starting group with $500 more MRR. That’s a gain in recurring revenue. To track how many customers stayed, use customer retention rate.

Net vs. gross revenue retention

Gross revenue retention (GRR) shows how much of the starting MRR you kept before counting expansion. For this calculation, take the lower of each starting customer’s opening and ending MRR. Add those amounts and divide the total by the group’s starting MRR. Express the result as a percentage. That caps GRR at 100%. NRR can exceed 100% because it includes expansion. Stripe’s NRR guide covers how the two metrics work together.

Using the same example:

GRR = (($10,000 − $300 − $700) ÷ $10,000) × 100 = 90%

The 105% NRR tells you the starting customers are worth more in recurring revenue at the end. The 90% GRR tells you that 10% of the starting MRR was lost to downgrades or churn. Read both numbers before deciding where to investigate. The churn rate guide explains how to track customer and revenue losses separately.

Why your billing dashboard may show a different NRR

Suppose company-wide ending MRR is $12,900. That total includes $10,500 from the starting group, $2,000 from new customers, and $400 from former customers who were inactive at the start and returned during the period.

What you’re measuringEnding MRR usedResult
NRR for customers paying at the start$10,500105%
NRR when the convention also counts the $400 in reactivation$10,900109%
Company-wide ending MRR as a percentage of starting MRR$12,900129%

All three calculations use $10,000 as the denominator. The 129% figure includes new customer revenue. It means company-wide MRR grew by 29% over the period.

A customer who was paying at the start and canceled and returned before the end stays in the fixed group. Use that customer’s ending MRR. The $400 above comes from former customers who had zero MRR at the start, so it sits outside the starting group.

Billing reports may handle reactivation differently. For example, ChartMogul’s Net MRR Retention report includes reactivation by default and offers an option to exclude it. When reconciling your figures, check which customers the report counts and whether it uses the same dates and MRR rules as your calculation. Compare completed periods because some reports, including ChartMogul’s, project retention for a period still in progress.

How to interpret your NRR

At 100% NRR, the starting group ends the period with exactly as much recurring revenue as it started with. Below 100%, the group shrinks in revenue. Above 100%, it grows. Compare figures over the same length of time and confirm that each report treats reactivation and recurring revenue the same way before using an industry benchmark.

In the 105% NRR and 90% GRR example, start with the $1,000 in losses. Break down the $700 in churn and $300 in downgrades by plan or customer segment to see where they came from. Then check how many customers contributed the $1,500 in expansion. A single large upgrade can cover a loss this quarter while leaving the underlying retention problem in place.

If the same losses keep showing up, use cohort analysis to see whether they cluster among customers who joined around the same time.

Where Putler fits

Putler’s Subscriptions dashboard shows MRR and subscriber churn. Use those metrics to see when recurring revenue shifted or subscriber churn rose. For the NRR calculation, use customer-level recurring revenue from your billing records at the start and end of the period.

FAQ

How do you calculate annual NRR from MRR?

Take MRR from the same group of customers at two dates 12 months apart. Divide their ending MRR by their starting MRR and multiply by 100. Each monthly NRR figure can start with a different group, so averaging those percentages does not give you annual NRR.

What if a customer cancels one of several subscriptions?

Combine all subscriptions for the customer at each date. If the account still has recurring revenue and its total fell, count the decrease as contraction. Count the full loss as churn when that customer’s ending MRR falls to zero.

Can net revenue retention exceed 100% even if customers cancel?

Yes. If upgrades and add-ons from the starting group bring in more recurring revenue than downgrades and cancellations take away, net revenue retention can exceed 100%. Use gross revenue retention alongside it to see the losses before expansion offsets them.