Gross Revenue Retention Calculator

How it is calculated

Gross revenue retention shows how much of last period's recurring revenue you kept from the same customers, ignoring any growth from them. The tool adds the two losses, lost = contraction + churn, subtracts them from the starting MRR, retained = starting MRR − lost, and then gives GRR = retained ÷ starting MRR × 100. Contraction is the MRR lost when customers downgrade but stay; churn is the MRR of customers who cancelled completely. There is no field for expansion, because upsell is deliberately left out of GRR. Start with the MRR at the beginning of the period, and take contraction and churn from that same group of customers. The starting MRR must be above zero, the losses cannot be negative, and together they cannot exceed the starting MRR; otherwise there is no result. That caps GRR between 0% and 100%.

Common mistakes

• Counting new customers. GRR only follows the revenue that existed at the start; MRR from customers who joined during the period belongs in neither the starting figure nor the losses.
• Netting expansion against the losses. Subtracting upgrades from churn gives net revenue retention, not GRR, and can make a leaky base look healthy.
• Entering annual and monthly figures together. If starting MRR is monthly, contraction and churn must be monthly MRR too, not annual contract value.
• Entering losses as negative numbers. The fields take the lost amounts as positive values; a negative value gives no result.
• Entering losses larger than the starting MRR. That cannot happen to a fixed starting base, so the tool shows no result; it usually means new-customer losses were mixed into the figure.