Net Revenue Retention Calculator

Net revenue retention is the share of recurring revenue you keep from the customers you already had, counting what they added as well as what they cut or cancelled. The formula is simple, and most calculators stop at it. The hard parts are deciding which revenue belongs in it, converting a monthly figure to an annual one, and seeing which customers or segments moved the number. This calculator handles all three.

Pages as fetched on 3 November 2026.

Take the recurring revenue of the customers you had at the start of a period. Add what those customers expanded by, and subtract what they contracted and what churned. Divide by the starting figure. 120,000 at the start, plus 14,500 of expansion, minus 3,800 of contraction and 7,200 of churn, is 123,500, so NRR is 123,500 / 120,000 = 102.9%.

Revenue from new customers never goes in, which is why an NRR worked out from MRR at the end of the period only works if the end figure leaves new customers out. The customer list mode avoids the problem: list each customer with what they paid then and now, and anyone who paid nothing then is treated as new and excluded.

Gross revenue retention uses the same starting revenue but ignores expansion: it counts only what was lost. It can never be above 100%, so it shows how leaky the base is on its own. NRR adds expansion and can go well above 100%. A business with high NRR and low GRR is growing its best accounts while losing many others; the two together say more than either alone. The list mode adds logo retention, the share of customers who stayed, which shows whether the losses are small or large accounts.

NRR is usually quoted over 12 months. A monthly NRR of 101% does not become 112% a year; it compounds to about 112.7%, because each month’s expansion is earned on a larger base. A monthly NRR of 99% compounds to about 88.6% a year. The calculator converts a monthly or quarterly figure by compounding and shows the simpler scaled figure next to it, so the difference is visible. For a true 12-month figure, the customer list mode with revenue 12 months apart is the most reliable.

A blended NRR is each segment’s NRR weighted by its share of starting revenue. That means it can rise because the mix shifted toward a segment that retains better, with no segment improving. The segment mode shows each segment’s NRR and GRR and how far it pulls the blended figure up or down, so a change in the blend can be traced to its cause. For churn over time and month by month, use the churn rate calculator; for the whole MRR picture, including new customers, the MRR and ARR calculator.

1. Choose how to calculateFrom totals, from a customer list, or by segment.
2. Enter starting revenueMRR or ARR of the customers you had at the start.
3. Enter the movementsExpansion, contraction and churn from those customers.
4. Or paste customersName, MRR then and MRR now; new customers are left out.
5. Read NRR and GRRWith annual figures, movers or segment effects.
6. ExportCSV, a Markdown summary or a share link.