NRR & GRR calculator
Net and gross revenue retention side by side — because the gap between them is the number that actually tells you something. Add periods to see whether it is widening. Runs entirely in your browser.
Your cohort
Take every customer who was a customer at the start of the period and track only what happened to their revenue. New logos won during the period are excluded — that is the whole point of retention. Add a period to see whether the trend is improving.
| Period | Starting ARR | Expansion | Contraction | Churn | New business | Remove |
|---|
New business is optional — it is excluded from NRR and GRR by definition, and used only for the quick ratio.
—
—
—
How many points of NRR are expansion rather than retention.
—
Revenue gained for every dollar lost.
Where the revenue went
The movement from starting cohort ARR to ending cohort ARR.
What this is telling you
The formulas
NRR = (Starting ARR + Expansion − Contraction − Churn) ÷ Starting ARR
Includes expansion, so it can exceed 100%. Above 100% means the existing base grows with zero new sales.
GRR = (Starting ARR − Contraction − Churn) ÷ Starting ARR
Expansion removed, so it is capped at 100%. This is the leak, with nothing covering it up.
Pick a definition and hold it constant
NRR is easy to move accidentally. The number changes materially depending on whether you measure over twelve months or annualise a quarter, whether you include customers who were mid-implementation at the start, whether a downgrade-then-upgrade inside the period nets to zero or counts as both movements, and whether usage overage is expansion or base revenue. None of those choices is wrong — but if the definition moves between periods, the trend line means nothing.
The terms behind the numbers
Definitions for everything this calculator touches.
Where did these numbers come from?
If assembling expansion, contraction and churn took a week of spreadsheet work, that is the real problem. Bunny computes retention from live billing data, because quoting, subscriptions, usage and invoicing share one system of record.