SaaS metrics guide
Churn Rate Formula
Churn is the one SaaS metric that compounds against you, and most of the disagreement about it comes from the denominator. Start-of-period is the standard; anything else quietly changes the number and makes it incomparable with published benchmarks.
Last updated 2026-10-20
The formula
customer churn % = customers lost / customers at start × 100
revenue churn % = MRR lost / MRR at start × 100
average lifetime = 100 / customer churn %Revenue churn counts downgrades as lost dollars as well as cancellations. That is deliberate: a customer who drops from a $500 plan to a $200 plan removes $300 of recurring revenue exactly like a cancellation of $300 would.
Why the denominator is the start of the period
Churn is a rate applied to the population that was actually at risk. Those are the customers present at the start. Three denominators are in common use:
- Start of period — the standard, and what published benchmark tables mean. Use this.
- End of period — the base is smaller after the losses, so the rate is overstated. It flatters nothing, but it is not comparable.
- Average of start and end — understates churn in a fast-growing business, because the average is pulled up by customers acquired during the period who were never at risk.
If you report churn to investors or compare it with a benchmark, state the denominator. A one-point difference is easily explained by this choice alone.
A worked example
You start the month with 500 customers and 15 cancel:
churn = 15 / 500 × 100 = 3%
lifetime = 100 / 3 ≈ 33 monthsIf those 500 customers represent $50,000 of MRR and you lose $2,000 to cancellations plus $500 to downgrades, revenue churn is $2,500 / $50,000 = 5%. The business is losing fewer logos than dollars — the reverse of the healthy pattern — which usually means larger accounts are leaving.
Monthly and annual churn do not convert linearly
Multiplying a monthly rate by twelve overstates annual churn badly. At 5% monthly:
annual retention = (1 − 0.05)^12 = 0.54
annual churn = 46%Not 60%. Churn removes a slice of whatever remains, not a slice of the original base. Going the other way, an annual churn of 46% is about 5% monthly, not 3.8%.
The same calculation in Excel
Put opening customers in B2, customers lost in C2, opening MRR in D2 and MRR lost in E2:
customer churn % = C2 / B2 * 100
revenue churn % = E2 / D2 * 100
average lifetime = 100 / (C2 / B2 * 100)
12-month retention = (1 - C2 / B2) ^ 12The last line is the one people get wrong: exponentiate, do not multiply by twelve.
Logo churn versus revenue churn
Report both, every month. Their relationship is the signal:
- Revenue churn below logo churn — you keep the customers who pay most. Healthy, and if expansion exceeds the losses you have negative net revenue churn.
- Revenue churn above logo churn — you are losing fewer accounts but more money, which almost always means the largest accounts are leaving. Materially worse than the logo count suggests.
Expansion revenue should be reported alongside churn, not netted into it silently. Negative net revenue churn means the existing base would grow even with zero new customers.
Benchmarks by segment
| Segment | Typical monthly churn | Best-in-class |
|---|---|---|
| SMB self-serve (< $50/mo) | 3% – 7% | < 3% |
| SMB sales-assisted ($50 – $500/mo) | 2% – 4% | < 2% |
| Mid-market ($500 – $2k/mo) | 1% – 2% | < 1% |
| Enterprise (> $2k/mo) | 0.5% – 1.5% | < 0.5% |
| Annual contracts (any size) | 0.5% – 1% | < 0.5% |
These bands come from ranges published by OpenView, ChartMogul and ProfitWell. Segment by plan and channel before comparing: a blended rate averages a 1% enterprise cohort with a 9% self-serve cohort and describes neither.
How to reduce churn
Retention is usually cheaper to fix than acquisition is to buy. The highest-leverage levers in most early-stage businesses are:
- Involuntary churn. Failed payments are often 20%–40% of total churn in self-serve products and are almost entirely fixable with dunning emails and card-updater services.
- Onboarding. Churn is highest in the first 90 days; if cohort curves never flatten, the problem is activation, not the product.
- Annual plans. They convert a monthly decision to leave into a yearly one, and they improve cash collection at the same time.
- Segmentation. A single blended rate hides which plan, channel or cohort is leaking.
Run the numbers on the churn calculator, which includes a twelve-month compounding projection, or see how churn flows into lifetime value in the LTV:CAC guide.
Run the numbers yourself
Churn Rate Calculator — free, no signup, results computed in your browser.
Open the Churn calculator →Frequently asked questions
What is the churn rate formula?
Customers lost during the period divided by customers at the start of the period, multiplied by 100. Revenue churn replaces customer counts with MRR: MRR lost divided by starting MRR, multiplied by 100.
What is a good monthly churn rate for SaaS?
Under 2% monthly is strong for early-stage B2B SaaS. Self-serve SMB products commonly run 3%–7%, sales-assisted SMB 2%–4%, mid-market 1%–2% and enterprise under 1.5%. Compare within your segment.
How do I calculate churn rate in Excel?
With opening customers in B2 and customers lost in C2: =C2/B2*100. For revenue churn, divide MRR lost by opening MRR. For twelve-month retention use =(1-C2/B2)^12 — exponentiation, not multiplication by twelve.
Is monthly churn multiplied by 12 the annual churn rate?
No. At 5% monthly, annual churn is 1 − 0.95^12 ≈ 46%, not 60%. Churn compounds, so the correct conversion is exponential.
Should churn include downgrades?
Include them in revenue churn as contraction, but not in logo churn. A downgrade is lost recurring revenue just as a cancellation is; leaving it out overstates retention.
Related guides
- MRR vs ARR: How to Calculate BothMRR is recurring revenue normalised to one month; ARR is MRR × 12. Learn the normalisation rules, what to exclude, and the mistakes that inflate both.
- What Is a Good LTV:CAC Ratio?A good LTV:CAC ratio is about 3x for most B2B SaaS. See benchmarks by segment, why the ratio must use gross profit, and the mistakes that inflate it.
- SaaS Metrics Cheat SheetSix core SaaS metrics with their formulas, healthy benchmarks and links to free calculators: MRR, churn, LTV:CAC, CAC payback, quick ratio and runway.
Maintained by The SaaS Metrics Calculators Editorial Team
Maintained by the site’s editors, with every formula unit-tested and every benchmark traced to a published source
Formulas and benchmarks last reviewed October 2026.
This page is educational. Every figure is computed in your browser from the inputs you supply, and nothing is checked against your own accounts — treat results as a planning aid, not as financial advice.