Calculator Inputs
Formula Used
Net Revenue Retention = ((Starting Recurring Revenue + Expansion Revenue + Reactivation Revenue - Contraction Revenue - Churned Revenue) ÷ Starting Recurring Revenue) × 100
Gross Revenue Retention = ((Starting Recurring Revenue - Contraction Revenue - Churned Revenue) ÷ Starting Recurring Revenue) × 100
Logo Retention = (Retained Customers ÷ Starting Customers) × 100
NRR above 100% means existing accounts expanded enough to outweigh churn and downgrades. NRR below 100% means the retained base shrank during the measured period.
How to Use This Calculator
- Enter the cohort or reporting period name.
- Add starting recurring revenue from existing customers only.
- Enter expansion, reactivation, contraction, and churned revenue.
- Optionally include customer counts for logo retention analysis.
- Set a target NRR if you want a gap analysis.
- Press the submit button to view metrics above the form.
- Download the summary as CSV or PDF after results appear.
Example Data Table
| Period | Starting Revenue | Expansion | Reactivation | Contraction | Churn | NRR |
|---|---|---|---|---|---|---|
| Q1 SaaS Cohort | $120,000 | $22,000 | $3,000 | $8,000 | $10,000 | 105.83% |
| Q2 SaaS Cohort | $150,000 | $28,000 | $4,500 | $11,000 | $12,500 | 106.00% |
| Enterprise Segment | $220,000 | $48,000 | $6,000 | $13,000 | $15,000 | 111.82% |
Frequently Asked Questions
1. What does net revenue retention measure?
It measures how recurring revenue from an existing customer cohort changed over time after expansions, reactivations, downgrades, and churn are considered.
2. Is new business included in NRR?
No. NRR excludes revenue from brand-new customers. It focuses only on revenue changes inside the starting customer base.
3. Why is NRR above 100% important?
An NRR above 100% shows that expansion and reactivation revenue more than offset churn and contraction within the same cohort.
4. What is a healthy NRR benchmark?
Many recurring revenue teams view 100% as the survival line, 110% as strong, and 120% or more as elite, depending on pricing and segment.
5. What is the difference between NRR and GRR?
NRR includes positive expansion and reactivation effects. GRR ignores those gains and measures only how much starting revenue remained before any upsell benefit.
6. Can I use monthly or annual values?
Yes. Use any consistent time basis, such as MRR, ARR, or quarterly recurring revenue. Keep every input in the same unit.
7. Why track logo retention too?
Logo retention shows customer count durability. It complements NRR because strong revenue retention can still hide account losses if a few large customers expand heavily.
8. When should reactivation revenue be added?
Add it when previously churned customers return and contribute recurring revenue within the same measurement logic used by your finance team.