spyc.ai

Free tool

NRR and GRR Calculator

Get net and gross revenue retention from starting MRR, expansion, contraction and churned revenue.

How it works

What is the NRR and GRR Calculator?

The NRR and GRR Calculator is a free tool that measures how much recurring revenue you keep from existing customers. Enter starting MRR, expansion, contraction and churned MRR. It returns net revenue retention, gross revenue retention, ending MRR from that group of customers and the net change.

How to use the NRR and GRR Calculator

  1. Enter the MRR you had at the start of the period from existing customers.
  2. Enter expansion MRR from those same customers: upgrades, extra seats, cross-sells.
  3. Enter contraction MRR from downgrades and churned MRR from cancellations.
  4. Read NRR, GRR and ending MRR, then copy the results.

What is net revenue retention?

Net revenue retention, NRR, is the share of recurring revenue you keep from a fixed group of customers over a period, after adding their upgrades and subtracting their downgrades and cancellations. Revenue from customers won during the period is excluded.

It is also called net dollar retention, NDR. An NRR above 100% means the existing customer base grew on its own.

How do I calculate NRR and GRR?

NRR = (starting MRR + expansion - contraction - churned) / starting MRR. GRR = (starting MRR - contraction - churned) / starting MRR.

With 100,000 starting MRR, 12,000 expansion, 3,000 contraction and 5,000 churned, NRR is 104% and GRR is 92%. The calculator shows both, plus ending MRR and the expansion and loss rates separately.

What is the difference between NRR and GRR?

GRR ignores expansion. It only measures how much of the starting revenue survived, so it can never be above 100% and never above NRR. NRR adds expansion back.

Read them as a pair. A high NRR with a weak GRR means upsells to some customers are covering for others leaving, which holds only while there is still room to upsell.

What is a good net revenue retention rate?

The one fixed line is 100%. Above it, revenue from existing customers grows without any new sales; below it, new sales first have to refill what was lost. Beyond that, good depends on the market: businesses selling seat-based or usage-based products to large companies have far more room to expand than those selling a flat plan to small ones.

Compare with your own past periods before comparing with anyone else's published figure, since companies define the inputs differently.

Should I measure NRR monthly or annually?

Most published NRR figures are annual: take the customers you had twelve months ago and compare what they pay now with what they paid then. The formula is identical with ARR in place of MRR, and this calculator works for either.

A monthly NRR looks deceptively close to 100%, because small monthly changes compound over a year. For the account-level view, use the Churn Rate Calculator. For how growth and profit combine, see the Rule of 40 Calculator.

Questions

Does NRR include new customers?
No. Only customers who were paying at the start of the period count. New-customer revenue is growth, not retention.
Can GRR be higher than NRR?
No. GRR leaves out expansion, so it equals NRR when expansion is zero and is lower otherwise.
Can NRR be above 100%?
Yes. It is above 100% whenever expansion is larger than contraction plus churned revenue.
Do price increases count as expansion?
Usually yes, since the customer pays more. Whatever you decide, apply it the same way every period and say so when you report the number.
Is the NRR and GRR Calculator free?
Yes, with a free spyc.ai account. It runs in your browser, so nothing you type is sent to a server.

Marketing Calculators

More in Marketing Calculators

ROAS Calculator

Work out return on ad spend from revenue and spend, plus break-even ROAS and profit from your gross margin.

Calculate ROAS

CAC and LTV Calculator

Get CAC, lifetime value, the LTV:CAC ratio and payback from spend, new customers, ARPU, margin and churn.

Calculate LTV:CAC

Churn Rate Calculator

Measure customer and revenue churn for a month, quarter or year, with compounded monthly and annual rates.

Calculate churn

Ready when you are

Before your next buyer asks AI about you, ask AI about yourself

One check, four engines, about twenty seconds. We show you the answers before we ask for anything.