Revenue Churn Rate Formula and How to Track It
Customer churn tells you how many logos you lost. The revenue churn rate formula tells you how much money walked out the door, which is often the number that actually matters. Losing ten $20/month hobby accounts stings far less than losing a single $3,000/month enterprise customer, yet customer churn treats them the same. Revenue churn fixes that by weighting every cancellation by its dollar value.
This guide breaks down the revenue churn rate formula, works a full example, distinguishes gross from net revenue churn, and shows how to track it without drowning in spreadsheet errors.
The Revenue Churn Rate Formula
Here is the core calculation, measured in MRR over a period:
Revenue churn rate = MRR lost from existing customers ÷ MRR at start of period × 100
"MRR lost" includes both full cancellations and downgrades (contraction). The denominator is the recurring revenue you started the period with, from customers who existed at the start. New MRR added during the period does not belong here, the same way new signups stay out of the customer churn rate formula. If you want the conceptual background first, see what revenue churn is.
A Worked Example of the Revenue Churn Rate Formula
Take a company entering the month with $80,000 in MRR.
- Starting MRR: $80,000
- MRR lost to cancellations: $2,400
- MRR lost to downgrades (contraction): $1,600
- New MRR from fresh signups: $6,000 (excluded)
Total MRR lost from existing customers is $4,000. Apply the formula:
$4,000 ÷ $80,000 × 100 = 5% revenue churn
The $6,000 in new MRR does not reduce your churn figure. Netting new sales against churn would hide the real leak. This 5% is your gross revenue churn, which we will contrast with net churn next.
Try StripeReport Free
Get your Stripe revenue every morning
Yesterday’s revenue, MRR, churn, and today’s renewals, delivered to your inbox and Slack daily. Plus a full revenue dashboard. 3-day free trial.
Start Your Free Trial →Gross vs Net Revenue Churn Rate Formula
There are two versions of the revenue churn rate formula, and confusing them is a common reporting mistake.
Gross revenue churn
Counts only losses (cancellations plus contraction) against starting MRR. It ignores expansion entirely, so it can never be negative and never exceeds 100%. Gross churn is the honest measure of how much revenue you are bleeding.
Net revenue churn
Subtracts expansion MRR (upgrades and seat additions) from the losses before dividing:
Net revenue churn = (MRR lost − Expansion MRR) ÷ Starting MRR × 100
If expansion outweighs losses, net revenue churn goes negative, which is the coveted state of negative churn. That is the same idea as net revenue retention above 100%. Just be clear which one you are reporting, because net churn can mask a real gross problem hiding under strong upsell.
Why Revenue Churn Beats Logo Churn
Comparing customer churn to revenue churn reveals where your risk sits. The gap between them is diagnostic.
- Revenue churn higher than customer churn: your larger accounts are leaving. This is the dangerous pattern, since a few big losses can sink you.
- Revenue churn lower than customer churn: you are mostly losing small accounts. Painful for logo counts, but far less threatening to the bottom line.
Tracking both side by side, as covered in churn rate vs retention rate, gives you a fuller picture than either number alone.
Common Revenue Churn Rate Formula Mistakes
- Netting new sales into churn: new customer MRR belongs in growth metrics, never in the churn denominator or numerator.
- Forgetting contraction: downgrades are revenue churn too, even though the customer stays. Leaving them out understates the leak.
- Ignoring involuntary churn: failed payments often count as churned revenue that a card update would have saved. See our guide to involuntary churn and recovering failed Stripe payments.
A good habit is to report gross and net revenue churn side by side every month. Gross keeps you honest about how much you are losing, while net shows whether expansion is winning the tug-of-war. When the two diverge sharply, that gap is itself a signal: a low net churn sitting on top of a high gross churn means your growth depends heavily on a handful of expanding accounts, which is a riskier position than it looks.
Monthly vs Annual Revenue Churn
Like customer churn, revenue churn is measured over a period, and you cannot annualize it by multiplying the monthly figure by 12. Revenue compounds on a shrinking base, so the naive multiplication overstates the loss. Convert through retention instead.
Annual gross revenue retention = (1 − monthly gross revenue churn) raised to the power of 12
At 5% monthly gross revenue churn, monthly retention is 0.95, and 0.95 to the twelfth power is about 0.54. That implies roughly 46% annual revenue churn, a very different message than the 60% you would get from multiplying. Enterprise businesses on annual contracts often measure revenue churn annually from the start, since renewals cluster once a year.
Segmenting the Revenue Churn Rate Formula
A blended revenue churn number can hide exactly where the money is leaking. Running the formula across segments turns it from a scoreboard into a map.
- By plan tier: your entry tier may churn far faster in dollar terms than your top tier, which changes where you invest in retention.
- By cohort: comparing the revenue churn of recent cohorts against older ones shows whether pricing and onboarding changes are actually improving retention.
- By loss type: splitting cancellations from contraction tells you whether customers are leaving entirely or just spending less.
The segment with the worst revenue churn is usually where a small fix returns the most money, which is why this breakdown is worth more than the headline rate.
How to Track the Revenue Churn Rate Formula Automatically
Computing revenue churn by hand means reconciling cancellations, downgrades, upgrades, proration, and coupons across every billing interval, every month. It is exactly the kind of task that quietly accumulates errors in a spreadsheet.
StripeReport connects to Stripe with a read-only key and calculates both gross and net revenue churn automatically, separating cancellations from contraction and expansion, then delivers the numbers by daily email or Slack. You always know how much recurring revenue you are keeping without rebuilding the model each period.
Try StripeReport Free
Get your Stripe revenue every morning
Yesterday’s revenue, MRR, churn, and today’s renewals, delivered to your inbox and Slack daily. Plus a full revenue dashboard. 3-day free trial.
Start Your Free Trial →Key Takeaways
- The revenue churn rate formula is MRR lost from existing customers divided by starting MRR, times 100.
- Gross revenue churn counts only losses; net revenue churn subtracts expansion and can go negative.
- Compare revenue churn to customer churn to see whether your big or small accounts are the ones leaving.
- Always include contraction, exclude new sales, and account for involuntary churn from failed payments.