Revenue churn calculator: what share of opening MRR was lost?

Version 1.0.0

This calculator shows gross revenue churn: the share of a month's starting monthly recurring revenue (MRR) lost to cancellations and downgrades.

Have the MRR from customers who were paying when the month began, and how much of it they had cancelled or cut by month end. Upgrades and new customers don't count here.

Currency Required
Formats results only; it does not convert amounts.
From customers with an active, billable subscription at the start of the month.

Losses from opening MRR

All amounts in USD
Opening MRR for those customers with no active, billable subscription at month end.
Opening minus closing MRR for customers still billable at month end, including a zero-MRR billable subscription.

Count each opening dollar once at month end. Don't use raw event totals. Enter 0 when none.

What to enter

Opening MRR comes from customers paying when the month began. Leave out anyone who first paid during the month.

Compare each of those customers at the start and end of the month. If they pay nothing at month end, their whole opening MRR is canceled. If they still pay, but less, only the drop counts as reduced. If they cancelled and came back within the month, use where they ended.

Count each starting dollar once. A customer who drops from $100 to $80, goes back to $100, and ends at $80 lost $20, not $40. A billing report that adds up every downgrade can show more, sometimes more than your whole opening MRR.

How to read the result

$8,000 opening MRR

Example

Canceled opening MRR is $360. Reduced opening MRR is $120.

Gross revenue churn is 6.00%. Opening MRR still present is $7,520.00.

Divide Opening MRR still present by opening MRR and you get gross revenue retention, 94% here.

How is revenue churn calculated?

Add the MRR lost to cancellations and downgrades, then divide by MRR at the start of the month.

Gross revenue churn

Formula

Gross revenue churn = (canceled MRR + reduced MRR) ÷ opening MRR × 100

ChartMogul and Stripe use the same formula.

What's the difference between gross and net revenue churn?

Gross revenue churn counts only what you lost. Net revenue churn subtracts expansion and reactivation from those losses, so it can drop below zero. That's called negative churn: existing customers add more than they take away.

This calculator shows gross churn. Net revenue churn is 100% minus net revenue retention, which the net revenue retention calculator works out.

How do churn and retention measures compare?

All of them follow the customers you had at the start of the month. They differ in what they count and whether gains offset losses.

MeasureWhat it asksCounts upgrades?
Customer churnWhat share of paying customers left?No
Gross revenue churnWhat share of starting MRR was lost?No
Gross revenue retentionWhat share of starting MRR is still paid?No
Net revenue churnWhat share was lost, after upgrades?Yes
Net revenue retentionWhat share is still paid, after upgrades?Yes

The ones that count upgrades can pass the usual limits: net revenue churn can go below 0%, and net revenue retention above 100%. Gross revenue retention is 100% minus gross revenue churn. Net revenue retention is 100% minus net revenue churn.

Why is revenue churn different from customer churn?

Customer churn counts accounts. Revenue churn counts dollars. The two split whenever the customers who leave pay more or less than average.

Say you have 10 customers and $1,000 of MRR. One customer paying $50 leaves. Customer churn is 10%, but revenue churn is 5%. If the one who left paid $300, revenue churn would be 30%.

To count accounts, use the customer churn calculator. To see the whole month's MRR, new customers included, use the MRR waterfall calculator.