Net Revenue Retention Calculator

Measure retained revenue after churn and expansion. Spot account health with clean SaaS movement logic. Export clear reports for finance reviews and board meetings.

Calculator Inputs

Formula Used

Net Revenue Retention:

NRR = ((Opening Recurring Revenue + Expansion Revenue + Upsell Revenue + Cross-sell Revenue + Reactivation Revenue - Contraction Revenue - Churned Revenue - Credits) / Opening Recurring Revenue) × 100

Gross Revenue Retention:

GRR = ((Opening Recurring Revenue - Contraction Revenue - Churned Revenue - Credits) / Opening Recurring Revenue) × 100

Expansion Rate:

Expansion Rate = Total Expansion Revenue / Opening Recurring Revenue × 100

Loss Rate:

Loss Rate = Total Revenue Loss / Opening Recurring Revenue × 100

How to Use This Calculator

  1. Enter the recurring revenue at the start of the period.
  2. Add expansion, upsell, cross-sell, and reactivation revenue.
  3. Enter contraction, churned revenue, credits, and refunds.
  4. Add optional closing revenue to compare expected and actual values.
  5. Enter customer counts if you also want customer churn rate.
  6. Set a target NRR and forecast period count.
  7. Press the calculate button.
  8. Download the result as CSV or PDF for reporting.

Example Data Table

Input Example Value Meaning
Opening recurring revenue 250,000 Revenue from the starting customer cohort.
Total expansion 45,000 New recurring revenue from existing customers.
Total loss 30,000 Revenue lost from churn, downgrades, and credits.
Net retained revenue 265,000 Opening revenue plus expansion minus losses.
NRR 106% The cohort expanded by 6%.

Why Net Revenue Retention Matters

Net revenue retention shows how much recurring revenue remains from an existing customer group after expansion, downgrades, credits, and churn. It is a core SaaS health measure because it focuses on customers already won. A business can grow even before adding new customers when expansion revenue is larger than lost revenue. That makes NRR useful for founders, finance teams, sales leaders, and investors.

What the Number Tells You

An NRR above 100 percent means the starting cohort expanded overall. Customers upgraded, bought more seats, added modules, or returned enough revenue to offset losses. A result below 100 percent means contraction and churn were larger than expansion. The metric helps teams see whether account management, product adoption, pricing, and support are creating durable growth.

How to Read the Output

This calculator separates expansion, contraction, churn, and credits. It also estimates gross revenue retention, expansion rate, loss rate, and target gap. Gross revenue retention excludes expansion. It shows the portion kept before upgrades. NRR includes expansion. That difference helps explain whether growth comes from strong retention, heavy upsell, or both.

Best Practices

Use the same customer cohort for every input. Do not mix new sales into the opening group. Enter recurring revenue only, such as monthly or annual contract value. Keep one period basis across all fields. If you use monthly revenue, keep every input monthly. If you use annual revenue, keep every input annual. Review large customers separately because one major churn event can distort the rate.

Common Business Uses

Finance teams use NRR for board reporting and forecasting. Customer success teams use it to find renewal risk. Product teams study it to understand whether features drive upgrades. Sales teams compare segments, plans, and industries. A stable high NRR can support efficient growth because existing customers fund more of the future revenue base.

Tracking Cadence

Measure NRR monthly for operating reviews and quarterly for strategic reports. Compare the same segments over time. Break results by plan, region, channel, and customer size. Trends matter more than one isolated month. Clean inputs make the metric easier to trust and explain. Document rules so every department reports the metric consistently. Save each result for audits, planning, and renewal meetings.

FAQs

What is net revenue retention?

Net revenue retention measures recurring revenue kept from existing customers after expansion, downgrades, churn, and credits. It shows whether the same customer group grows or shrinks over time.

Is NRR different from GRR?

Yes. GRR excludes expansion revenue. NRR includes expansion revenue. GRR shows how much revenue was retained before upgrades, while NRR shows the complete net movement.

What is a good NRR?

An NRR above 100% means existing customers expanded overall. Many SaaS teams view 110% or higher as strong, but benchmarks vary by market, pricing, and customer size.

Should new customer revenue be included?

No. NRR should only use the starting customer cohort. New customer revenue belongs in new sales metrics, not retained revenue calculations.

Can NRR be above 100%?

Yes. NRR rises above 100% when expansion, upsells, cross-sells, and reactivations exceed revenue lost from downgrades, churn, credits, and refunds.

Why enter actual closing revenue?

Actual closing revenue helps compare calculated cohort movement with reported closing revenue. The gap can reveal timing issues, data errors, or mixed revenue sources.

What revenue basis should I use?

Use one basis consistently. If opening revenue is monthly, all other fields should be monthly. If opening revenue is annual, all other fields should be annual.

How often should I calculate NRR?

Most teams calculate it monthly or quarterly. Monthly tracking helps operations, while quarterly tracking often works better for board reporting and strategic reviews.

Related Calculators

Paver Sand Bedding Calculator (depth-based)Paver Edge Restraint Length & Cost CalculatorPaver Sealer Quantity & Cost CalculatorExcavation Hauling Loads Calculator (truck loads)Soil Disposal Fee CalculatorSite Leveling Cost CalculatorCompaction Passes Time & Cost CalculatorPlate Compactor Rental Cost CalculatorGravel Volume Calculator (yards/tons)Gravel Weight Calculator (by material type)

Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.