Net Revenue Retention Calculator

Net Revenue Retention Calculator

Measure retained recurring revenue from an existing customer cohort. Enter opening revenue, expansion, contraction, churn, and account counts to calculate NRR, GRR, expansion offset, churn drag, account retention, and target expansion needed.

🎯NRR Scenario Presets

🧼Retention Inputs

Use the same cadence for every revenue field.

The benchmark card adapts to the selected motion.

Currency changes display only; formulas are unchanged.

Many teams exclude reactivations and track them separately.

Starting revenue from customers active at period start.

Upsells, cross-sells, usage growth, and seat growth.

Revenue lost from retained accounts that spend less.

Revenue from starting customers that fully left.

Optional returning customer revenue, never brand-new logos.

Used to backsolve the expansion gap for this cohort.

Count customers in the opening cohort only.

Accounts from the opening cohort still active at period end.

Net revenue retention 107.0% ending retained revenue / opening revenue
Gross revenue retention 89.0% before expansion revenue
Expansion offset 164% expansion / churn plus contraction
Target expansion gap $130,000 additional expansion to reach target

🔱Current Cohort Snapshot

$1.07MRetained revenue
$70KNet change
18.0%Expansion rate
11.0%Revenue loss rate
93.3%Account retention
$2.73KRetained ARPA
31.0%Target expansion
StableBenchmark band

📐NRR Formula Breakdown

Retained cohort revenueOpening recurring revenue + expansion - contraction - churn. New customer revenue is excluded from standard NRR.
Net revenue retentionNRR = retained cohort revenue / opening recurring revenue x 100.
Gross revenue retentionGRR = (opening recurring revenue - contraction - churn) / opening recurring revenue x 100. Expansion is ignored.
Expansion offsetExpansion offset = expansion / (contraction + churn). Above 100% means expansion more than covers revenue loss.
Target expansionNeeded expansion = target NRR x opening revenue - opening revenue + contraction + churn - included reactivation.

📊Segment Benchmark Guide

SegmentWatch ZoneHealthy ZoneStrong ZoneBest SignalTypical Risk
Blended SaaS portfolioBelow 100% NRR100% to 110% NRR110%+ NRRExpansion covers contraction plus churnMixed segments hide weak cohorts
Enterprise accountsBelow 105% NRR110% to 125% NRR125%+ NRRSeat growth and cross-sell expansionLarge-logo churn swings results
Mid-market accountsBelow 100% NRR105% to 115% NRR115%+ NRRUpgrade path offsets downgradesBudget cuts cause contraction
SMB self-serve accountsBelow 90% NRR95% to 105% NRR105%+ NRRLow logo churn and add-onsHigh logo churn overwhelms upsell
Usage-based customersBelow 105% NRR110% to 130% NRR130%+ NRRConsumption expands after adoptionUsage drops look like contraction
Product-led subscriptionsBelow 95% NRR100% to 112% NRR112%+ NRRTeam invites and plan upgradesSmall accounts churn quickly
Managed service retainersBelow 90% NRR95% to 105% NRR105%+ NRRScope expansion within retained clientsProject scope compression

🧭Preset Scenario Reference

ScenarioOpening RevExpansionContractionChurnNRRGRRPlain Read
Enterprise expansion$8.0M$2.2M$0.25M$0.35M120.0%92.5%Expansion-led benchmark result
Mid-market baseline$3.5M$0.42M$0.18M$0.22M100.6%88.6%Barely expanding after losses
SMB churn pressure$850K$80K$55K$170K82.9%73.5%Revenue base is shrinking
Usage-based growth$1.9M$620K$120K$95K121.3%88.7%Consumption growth offsets loss
Downgrade wave$2.4M$210K$390K$180K85.0%76.3%Contraction is the main drag
Expansion recovery$1.2M$260K$85K$75K108.3%86.7%Expansion covers revenue loss
Quarterly cohort$640K$88K$22K$38K104.4%90.6%Short-period cohort is healthy
Founder-led SaaS$220K$39K$8K$18K105.9%88.2%Small base with useful expansion
Target backsolve$5.0M$450K$250K$300K98.0%89.0%Needs more expansion to hit 115%

⚖Metric Comparison Table

MetricIncludes ExpansionIncludes ChurnNew Customer RevenueMain Use
NRRYesYesExcludedMeasures growth from existing customers
GRRNoYesExcludedMeasures retained revenue before upsell
Logo retentionNoAccount churn onlyExcludedShows account count retention
Expansion rateExpansion onlyNoExcludedShows upsell pace against opening base
Revenue churn rateNoContraction plus churnExcludedShows recurring revenue lost from cohort
Total ARR growthYesYesIncludedCompany growth across all customers

🔍Retention Quality Checks

CheckUse This RuleGood SignRisk SignWhy It Matters
Cohort lockUse customers active at period startNo new logos includedNew ARR mixed into NRRNRR should isolate existing customers
Same cadenceARR with ARR, MRR with MRRAll fields share cadenceMonthly expansion against ARR baseMixed periods distort retention
Contraction splitSeparate downgrade from churnClear loss sourceAll loss dumped into churnFixes differ by loss type
Reactivation policyApply consistentlyTracked outside new ARRReactivations boost NRR one periodPolicy affects trend comparability
Segment viewSlice by motion or sizeEnterprise, SMB, PLG separatedBlended average hides weak cellsBenchmarks differ by segment
Account countPair NRR with logo retentionHigh NRR and stable accountsHigh NRR despite many churned accountsUpsell can mask customer loss

💡Practical NRR Tips

Keep new customers out: NRR is a cohort metric. Revenue from brand-new customers belongs in total ARR growth, not existing-customer retention.
Use GRR beside NRR: A high NRR with weak GRR means expansion is hiding losses. That can still be strong, but it needs operational attention.
Separate contraction from churn: Downgrades usually point to packaging, usage, or value realization. Full churn often points to fit, adoption, or renewal risk.
Backsolve the gap: Target expansion shows exactly how much additional upsell or usage growth is needed after known losses.

A lot of SaaS founders spends all their time trying to win new logos, only to realize they’ve slowly lost revenue from there base. It’s easy to fall into this trap, winning a new logo is noisy and expensive, whereas losing an old one are silent and slow.

Net revenue retention flips the story, making you consider health of your current group. Plug in your churn, contraction, expansion, and starting revenue numbers into the calculator above, and it do the math for you. It saves you from wading through formula-filled spreadsheets where you’ll inevitablly miss some subtle interaction.

Why Keeping Current Customers Is Important

It’s a simple idea. So simple it can be brutal. At the start of a period, you have a set of customer. At the close of a period, you measure how many bucks those same customers brought in, including up- and cross-sell revenue
 not including revenue from any new customer whatsoever.

People misunderstand this part. They confuse retention metrics with new sales, and cheer for growth in one without noticing decay in the other. This tool neatly splits them. Take your opening cohort revenue, add expansion, and then subtract contraction and churn. What you’re left with: did your existing business grow or shrink, all on its own?

The hero metric are expansion. When your customers consume more usage, upgrade their plans, buy more seats, etc., your net retention rise.

There is a villain lurking in plain sight. It is called contraction. It’s what occurs when your customers don’t leave entirely but do something else, like reduce usage or downgrade a plan. Churn is the straight-up loss. That’s churn.

The calculator will show you the offset ratio. This shows how much expansion you’re achieving relative to the contraction (downgrade) and churn (loss). It tells you if you has enough expansion to cover everything. If the ratio is greater than 100 percent, then you’re a self-sustaining growth engine. Less than one hundred percent means you’re paying to make up for lost ground.

Additionally, check out gross revenue retention. Gross revenue retention will tell you how sticky your product realy is after accounting for all expansion. Seeing high net retention but low gross are not good. You’re essentially buying your growth via upsell instead of retaining it via a strong product.

While the reference table on the page helps break down what is healthy by segment (because an enterprise account behaves different than a small business user), note that seat growth typically drives high expansion in enterprise teams while there’s often more churn at the logo level for small business segments.

Baksolve for your target, Being able to backsolve for a target is perhaps one of the more pragmatic capabilities. Want to reach your next valuation mark? The tool will tell you precisely how much more you have to expand to get there. No longer do you guess, now you aim.

And this is important: Expansion isn’t something that happens by chance. It takes conscious efforts from Customer Success, defined upgrade paths, and product features that reward deeper usage. And don’t forget about the account retention numbers. It’s possible to get lots of big upsells and still end up with a low revenue retention rate because so many of your customers is churning out. The calculator matches those accounts against their revenue to show the full story.

Are your account numbers falling while your revenue rises? Maybe you’re too reliant on a dwindling set of customers. That is not good.

Why does this matter? Measuring these things forces you to shift from an acquisition mindset to an optimization mindset. Instead of asking “How do I acquire more customers?” you ask, “How can I serve my existing customers better?” Retention becomes a growth strategy rather than a cost center. It allows you to create a self-sustaining business that doesn’t require continuous streams of new blood.

And the secret is
 knowing what you’re actualy measuring. Seeing the difference between new logos and retained value helps you understand the way forward. You begin creating something lasting instead of chasing empty numbers. This is the difference between owning value and renting attention.

Net Revenue Retention Calculator