How to calculate net revenue retention (NRR)

Net revenue retention shows how much recurring revenue you keep and grow from existing customers. Take recurring revenue from customers active at the start of the period, add expansion, subtract contraction and churn, and divide by the starting figure. The hard part is agreeing who counts as an existing customer.

NRR is the ARR question one level deeper: not how much recurring revenue you have, but how much your current customers keep paying.

Why NRR matters

1. It shows whether growth comes from new customers or from existing ones.
2. Investors and boards use it to judge product value and pricing power.
3. Gross revenue retention (GRR), which ignores expansion, shows the floor.

The gray area

1. Cohort or period? Track a fixed group of customers, or recompute each period?
2. Which revenue? ARR, MRR or recognized revenue?
3. Price increases. Do contractual escalators count as expansion?
4. Merged or acquired customers. When two customers combine, is that churn plus expansion?
5. Name changes and new accounts. A customer that reappears under a new ID can look like churn and a new logo.
6. Usage revenue. Is variable usage in or out?
7. Currency. Is foreign revenue measured at constant exchange rates?

Core principles

1. Use the same revenue basis as ARR, so the two figures reconcile.
2. Define the starting cohort once and keep it fixed for the period.
3. Report GRR alongside NRR, capped at 100%.
4. Link customers across systems before calculating anything.

Calculating NRR in one system

1. Pick the start date and list customers with recurring revenue on that date.
2. Record their starting recurring revenue.
3. Measure the same customers' recurring revenue at the end date.
4. Divide ending by starting for NRR. For GRR, cap each customer at their starting amount before dividing.

Calculating NRR across systems

The CRM, billing system and ERP each have their own customer IDs, parent structures and revenue timing. Without a crosswalk, a renamed or merged customer shows up as churn in one system and a new logo in another, and NRR moves for reasons that have nothing to do with the business. Build the crosswalk first, then calculate.

How Preql helps

Preql maps how your CRM, billing system and ERP define customers and recurring revenue. Finance approves the NRR and GRR definitions, with an owner, version history and lineage back to source, so retention reflects real customer behavior.

FAQ

What's the difference between NRR and GRR?

NRR includes expansion. GRR doesn't, so it can never exceed 100%.

Should NRR use the same customers as ARR?

Yes. Use the same customer definition and revenue basis for both.

Talk to our team

Want one approved definition of NRR across your reports? Book a call with our team.

What happens next: in a 30-minute call, you'll see where your numbers stop matching and why.