Skip to content
Free · by GainTrace

Net Revenue Retention (NRR) Calculator

Two numbers per account · what they paid then and pay now · and every retention metric, the board bridge, and the accounts that moved it fall out.

Your existing customers' revenue is
Waiting for your book

Paste your accounts with just two numbers each · what they paid a year ago and what they pay today · and every retention number computes itself.

Account · ARR a year ago · ARR today. Cancelled customers just have 0 today. Nothing you paste leaves this tab.

Three columns: account, what they paid a year ago, what they pay today. Cancelled = 0 today.

Who reads which number
  • Board: the headline above · finance calls it NRR.
  • Finance: the without-upsells number · they call it GRR.
  • Your team: the account list · it says who to call, a ratio doesn't.

Your numbers never leave this tab · calculations run entirely in your browser.

What it does

Paste your book · GainTrace computes every retention metric at once

The formula was never the hard part. GainTrace's free NRR calculator takes you from an account export to a board-ready answer without the afternoon of spreadsheet work.

Straight from your spreadsheet

Three columns · account, ARR a year ago, ARR today · pasted as TSV or CSV, header row optional. Dollar signs, commas, and 120k or 1.2m shorthand all parse. A cancelled customer simply has 0 today.

Nothing to label

Upsells, downgrades, and churn derive from each account's change, so NRR, GRR, logo retention, and churned ARR compute together from one paste. No tagging rows, no formulas to babysit.

Totals-only mode

No account export handy? Switch modes and enter four totals · starting ARR, upsells, downgrades, cancellations · and every metric computes from those instead.

Free · no signup
GainTraceFree tool
The whole formula, in plain sight
NRR = (Start + UpsellsDowngrades Churn) ÷ Start
  • Above 100%the base grows on its own
  • Below 100%growth spend refills a leak

New-logo revenue never counts · every input comes from your own paste.

What it does

Built for the board meeting, the GainTrace way

The ARR bridge draws itself

The waterfall your board expects · starting ARR through expansion, contraction, and churn to ending ARR · renders live as you type and downloads in one click.

See who moved the number

Every account that pulled the number down or pushed it up, ranked by dollar impact with cancellations flagged. The ratio is for the board; this list is for Monday morning.

Benchmarks on the same scale

Your NRR lands on a scale with published medians · 97% SMB, 105% mid-market, 110% enterprise · so the number arrives with its context already attached.

Free · no signup
GainTraceFree tool
NRR benchmarkspublished medians
  • SMB-heavy books~97%
  • Mid-market~105%
  • Enterprise110%+
  • Top quartile110 to 120%+

Published medians by segment · sources cited under Methodology below.

How it works

Three steps, no signup.

  1. Step 1

    Paste your accounts with two numbers each: what they paid a year ago and what they pay today.

  2. Step 2

    Upsells, downgrades, and cancellations derive from the change · every retention metric and the bridge compute at once.

  3. Step 3

    See exactly which accounts moved the number, then download the board-ready bridge chart.

Everything included

Everything in GainTrace's free NRR Calculator.

  • NRR, GRR, and logo retention together

    One paste computes all three, plus churned ARR and net change · no separate calculators.

  • ARR bridge waterfall

    The standard board chart, drawn from your own accounts and always in sync with the inputs.

  • Contributors and detractors

    Accounts ranked by dollar impact in both directions, worst first, cancellations flagged.

  • Loose-format parsing

    TSV or CSV, dollar signs, commas, k and m suffixes, header row optional. Unparseable rows are counted, not silently dropped.

  • Sample book

    One click loads a realistic book so you see the full output before pasting your own.

  • Totals-only mode

    Four totals instead of an account export, same metrics and bridge.

  • Benchmark scale

    Published NRR medians by segment on a gradient scale, with your position marked.

  • Per-dollar framing

    Your NRR restated as what each dollar of last year's revenue became · the version non-finance stakeholders get instantly.

  • Board-ready export

    Download the bridge as a clean PNG, sized for the deck.

  • Runs entirely in your browser

    Account names and ARR figures are never uploaded or stored.

The guide

NRR, explained properly.

What is net revenue retention (NRR)?

Net revenue retention (NRR), also called net dollar retention (NDR), measures how much recurring revenue you keep and grow from existing customers over a period, usually a year. It starts from the ARR those customers paid at the beginning, adds expansion from upsells, subtracts contraction from downgrades and the ARR lost to cancellations, and divides by the starting ARR. New-logo revenue never counts.

An NRR above 100% means the installed base grows even with zero new sales, which is why investors read it as the quality score of a SaaS business. Below 100%, every new deal first refills a leak before it grows the company.

The net revenue retention formula

NRR = (starting ARR + expansion − contraction − churned ARR) ÷ starting ARR × 100.

Worked example with this calculator's default totals: $10.0M starting ARR, $1.4M of upsells, $0.3M of downgrades, and $0.9M cancelled gives (10.0 + 1.4 − 0.3 − 0.9) ÷ 10.0 = 102%. The same four inputs also produce GRR, (10.0 − 0.3 − 0.9) ÷ 10.0 = 88%, which is the floor under that 102%.

What is a good net revenue retention rate?

Published medians vary mostly by deal size. SaaS Capital's annual private-company survey and public-company disclosures cluster as follows, so benchmark within your segment rather than against a single number.

SegmentMedian NRRRead
SMB-heavy books~97%Below 100% is structural at low ACV · watch GRR closely
Mid-market~105%Expansion covers churn with a margin
Enterprise110%+Top quartile runs 110 to 120%+

Sources: SaaS Capital private-company survey and public filings · full citations under Methodology.

NRR vs. GRR vs. logo retention

The three retention metrics answer different questions from the same account list. NRR includes expansion, so it can hide churn behind strong upsell. GRR excludes expansion and can never exceed 100%, which is why finance plans on it. Logo retention counts customers rather than dollars, so it tells you whether you are losing many small accounts or a few large ones. This calculator computes all three from one paste.

How to improve net revenue retention

The levers rank by typical impact: catch churn before the renewal (each saved account protects both its ARR and its future expansion), expand inside healthy accounts (seat growth and tier upgrades are the entire gap between GRR and NRR), price so growth accrues to you (usage- or seat-based models outperform flat licenses on NRR), and fix onboarding (accounts that reach first value in the first month renew at materially higher rates). Watching the signals behind those levers continuously is the job GainTrace automates.

Methodology

Every number has a source.

Benchmarks in this tool come from published research, cited below with what each is used for. Model assumptions are visible and editable in the tool itself.

Questions

Frequently asked.

GainTrace

NRR without the quarterly rebuild.

GainTrace computes this from your live billing, product, and support data, so the bridge is always ready. Live in days, no admin to hire.

Free plan · 25 tracked accounts · no credit card.