Net revenue retention: three mistakes that inflate the number

Net revenue retention tells you how much recurring revenue you keep and grow from an existing group of customers over twelve months. Above 100 percent means expansion outweighs churn. Above 120 percent puts you in the top quartile of B2B SaaS. It is the number that most shapes how investors value a company, which is exactly why it gets quietly inflated.

The formula is simple: take the MRR from customers who were active twelve months ago, then measure what those same customers pay today, including expansion and net of contraction and churn. Divide today by then. The trouble lives in the details.

Mistake one: letting new customers leak in

NRR is a cohort metric. If a customer signed up in month eight, they do not belong in a twelve-month calculation that starts in month zero. Including them, even accidentally through a CRM filter, adds revenue that was never at risk of churn. We regularly see this add four to eight points to a reported figure.

Mistake two: counting reactivations as expansion

A customer who churned in March and came back in July should not register as growth. If they were in the starting cohort, their return simply reduces the churn you recorded. If they were not, they are new revenue. Classify them consistently, and write the rule down.

The other two common leaks are smaller but add up across a portfolio of accounts:

• Price increases applied across the base inflate NRR without any real adoption. Report them separately so the board can see organic expansion.
• Annual prepayments booked as one month of MRR create spikes. Always normalise contracts to a monthly value.
• Currency swings can move NRR by several points for multi-currency businesses. Use constant-currency rates for the comparison.
• One-off services fees, onboarding packages and overages do not belong in recurring revenue at all.

Mistake three: picking the flattering cohort

Some teams report NRR for their best segment, often enterprise, without saying so. Others choose the trailing twelve months that happens to include a big upsell. Report a blended figure plus segment breakdowns, and show the trend over at least four quarters so a single expansion deal cannot carry the story.

An NRR figure nobody can reproduce from raw invoices will not survive due diligence, so build it to be audited from day one.

The fix is less about formulas and more about traceability. Every account in the starting cohort should be listed, every movement should link to an invoice, and the rules for edge cases should live somewhere other than one analyst's head. Do that, and your NRR becomes a number you can defend in a board meeting rather than one you hope nobody asks about.