Net Revenue Retention Calculator

Use the Net Revenue Retention Calculator to check your startup assumptions with a clear formula and breakdown.

How to calculate net revenue retention

  1. Net revenue retention follows only the customers present at the beginning of the measurement period. Expansion offsets recurring revenue lost through downgrades and cancellations, while new customers never enter the numerator. Gross retention excludes expansion and cannot exceed 100% in this model. Net retention can exceed 100% when the starting cohort expands enough to outweigh losses. Use a nonzero starting base and avoid counting one lost dollar twice.
  2. For Net Revenue Retention Calculator, enter starting mrr, expansion mrr, contraction mrr, churned mrr. Use source records from one clearly defined reporting scope rather than combining unrelated populations. The default values are illustrative and can be replaced immediately. Every field is required, and invalid values produce N/A rather than a partial result. Monetary amounts use US dollars, while counts represent actual whole observations when the field requires them. Keep the source worksheet available if someone else needs to reproduce the inputs.
  3. The existing-customer revenue calculation updates locally when an input changes. It preserves unrounded intermediate values and rounds only the displayed outputs, so a manually rounded component may not multiply back to exactly the same displayed total. Review the primary result together with the breakdown instead of treating a single percentage or dollar amount as a complete operational diagnosis. This arithmetic does not forecast changes in customer behavior, contract terms or future business conditions.

Formula: ending cohort MRR = starting MRR + expansion - contraction - churn NRR = ending cohort MRR / starting MRR * 100

Formula

ending cohort MRR = starting MRR + expansion - contraction - churn NRR = ending cohort MRR / starting MRR * 100

Where:

startingMrr
= Starting MRR
expansion
= Expansion MRR
contraction
= Contraction MRR
churn
= Churned MRR

Worked example

Starting MRR of $10,000, expansion of $2,000, contraction of $500 and churn of $1,000 produce ending cohort MRR of $10,500. NRR is 105%, while gross retention excluding expansion is 85%.

With $10,000 starting MRR, $500 expansion, $1,000 contraction and $1,500 churn, ending cohort MRR is $8,000. NRR is 80% and gross retention is 75%. New-customer revenue is excluded from both calculations.

Existing-customer revenue

Create a repeatable review process for existing-customer revenue before using the result to allocate money or staff time. Reconcile each input to a named report, note the reporting date and identify any manual adjustment. Net revenue retention follows only the customers present at the beginning of the measurement period. Expansion offsets recurring revenue lost through downgrades and cancellations, while new customers never enter the numerator. A lightweight audit trail is often more valuable than displaying additional decimal places, especially when several people prepare the same metric at different times.

Use Net Revenue Retention Calculator as a transparent arithmetic check rather than a complete decision model. Gross retention excludes expansion and cannot exceed 100% in this model. Net retention can exceed 100% when the starting cohort expands enough to outweigh losses. Use a nonzero starting base and avoid counting one lost dollar twice. Run a conservative case alongside the expected case and explain which assumption creates the largest movement. Revisit those assumptions when actual results arrive. Related startup calculators provide additional context, but combining several ratios does not eliminate uncertainty or replace professional review where contracts, accounting or legal rights are involved.

Frequently asked questions

Net revenue retention follows only the customers present at the beginning of the measurement period. Expansion offsets recurring revenue lost through downgrades and cancellations, while new customers never enter the numerator. Select a consistent period and write down which records belong in that scope before calculating. Changing the population between comparisons can move the result even if individual performance has not changed. The calculator cannot detect that reporting mismatch automatically.

Related calculators

Track only customers present at the start. Exclude all new-customer revenue. Enter contraction and churn as positive amounts with no overlap; their combined loss cannot exceed starting MRR.