Gross Revenue Retention Calculator

Calculate gross revenue retention from starting MRR, downgrades, churn, and optional credits to understand how durable your existing cohort is.

Recurring revenue at the opening of the period
Revenue lost to plan downgrades within the cohort
Revenue lost from cancellations in the cohort
Optional recoveries such as reactivations or invoice credits

For FP&A guidance only. Reconcile results with audited revenue schedules before publishing KPIs.

Examples

  • $120,000 starting MRR, $8,000 downgrades, $6,000 churn ⇒ Gross revenue retention: 88.33%. Retained MRR: $106,000.00.
  • $90,000 starting MRR, $3,500 downgrades, $2,000 churn, $1,200 credits ⇒ Gross revenue retention: 95.22%. Retained MRR: $85,700.00.

FAQ

What does gross revenue retention measure?

It shows the percentage of recurring revenue from an existing cohort that remains after downgrades and churn, excluding any expansion from upsells.

How should I treat partial-period cancellations?

Allocate only the portion of MRR lost within the measurement window. Annual contracts that churn mid-term should contribute the prorated amount.

When should I include credited adjustments?

Use the optional field for invoice credits, reactivations, or make-good revenue that offsets churn. Leaving it blank assumes no such recoveries occurred.

Can gross revenue retention exceed 100%?

Not under the standard definition, because expansions are excluded. If your calculation is above 100%, verify that expansion revenue has not been mixed in.

Additional Information

  • Report inputs in the same currency and monthly cadence to stay comparable across cohorts.
  • Gross revenue retention excludes expansion revenue; use the Net Dollar Retention calculator for the complementary metric.
  • Credits default to zero, so leaving the optional field blank assumes no recoveries or invoice adjustments.
  • Result unit: % of starting MRR