Churn is the quiet leak in a subscription business. Signups look great on the dashboard, traffic is climbing, the sales pipeline is full. Meanwhile customers are slipping out the back door at a rate that makes all that effort pointless.
Here’s the uncomfortable math. If you lose 5% of your customers every month, you replace roughly half your base in a year. You’re not growing a business at that point. You’re refilling a bucket with a hole in it.
The problem is that top-of-funnel numbers hide this. A good month of new signups can mask a bad month of cancellations, and you walk away feeling fine. A churn calculator fixes that by forcing the two numbers into the same picture. This guide covers what to calculate, how to build your own, what “good” looks like, and what to do when the number is worse than you hoped.
What a churn calculator actually does
At its simplest, a churn calculator answers one question: of what I had at the start of the period, how much did I lose by the end?
The catch is that “how much” can mean two different things.
Customer churn counts heads. How many paying customers left?
Revenue churn counts dollars. How much recurring revenue left, and how much did the survivors shrink or grow?
These can tell very different stories. Lose ten tiny accounts and one enterprise account, and your customer churn looks mild while your revenue churn looks ugly. Run a business with a few big accounts and many small ones, and you need both views.
Revenue churn also splits in two:
- Gross MRR churn counts only the losses: cancellations plus downgrades. It ignores any growth from existing customers.
- Net MRR churn subtracts expansion revenue (upgrades, add-ons, seat growth) from those losses. If expansion beats losses, net churn goes negative. People call that “negative churn,” and it’s the best place a SaaS company can be.
Track gross so you can see how leaky the bucket is. Track net so you can see whether existing customers are making up for it.
The core math, with simple numbers
Customer churn rate formula
Customer churn rate = Customers lost during the period ÷ Customers at the start of the period
Say you start the month with 1,000 customers and lose 30.
30 ÷ 1,000 = 3% monthly customer churn
Two traps to avoid:
- Use the starting count in the denominator, not the ending count.
- Don’t include customers who signed up during the month and also left that month in your starting base. They weren’t there at the start.
Annualizing it
Three percent a month sounds small. It isn’t. Churn compounds:
Annual churn = 1 − (1 − monthly churn)^12
1 − (0.97)^12 = 1 − 0.694 = about 30.6% annual churn
You lose nearly a third of your customers in a year. That’s why a “small” monthly number deserves attention.
Gross MRR churn
Gross MRR churn = (Churned MRR + Contraction MRR) ÷ Starting MRR
Say you start the month with $50,000 in MRR. Cancellations take away $1,500. Downgrades take away another $750.
(1,500 + 750) ÷ 50,000 = 4.5% gross MRR churn
Notice this is higher than the 3% customer churn above. That happens when the customers leaving or downgrading skew toward higher-paying accounts. It’s a signal worth chasing.
Net MRR churn
Net MRR churn = (Churned MRR + Contraction MRR − Expansion MRR) ÷ Starting MRR
Same month, but existing customers also upgraded for $1,250 in additional MRR.
(1,500 + 750 − 1,250) ÷ 50,000 = 1,000 ÷ 50,000 = 2% net MRR churn
If expansion had been $3,000 instead, you’d get (2,250 − 3,000) ÷ 50,000 = −1.5%. Negative churn. Your existing base grew without a single new signup.
Build your own churn calculator in Google Sheets or Excel
You don’t need software to start. Calculating churn in Excel or Sheets takes about twenty minutes, and you’ll understand your numbers far better than if you pasted them into a black-box tool.
Step 1. Set up one row per month. Months run down column A.
Step 2. Add the customer columns. Start-of-month customers, new customers, lost customers, and end-of-month customers.
Step 3. Add the revenue columns. Start MRR, new MRR, expansion MRR, contraction MRR, churned MRR, and end MRR.
Step 4. Add the formulas. Using this layout:
| Column | Contents |
|---|---|
| A | Month |
| B | Start customers |
| C | New customers |
| D | Lost customers |
| E | End customers |
| F | Start MRR |
| G | New MRR |
| H | Expansion MRR |
| I | Contraction MRR |
| J | Churned MRR |
| K | End MRR |
| L | Customer churn % |
| M | Gross MRR churn % |
| N | Net MRR churn % |
The formulas for row 2:
- End customers (E2):
=B2+C2-D2 - End MRR (K2):
=F2+G2+H2-I2-J2 - Customer churn (L2):
=D2/B2 - Gross MRR churn (M2):
=(I2+J2)/F2 - Net MRR churn (N2):
=(I2+J2-H2)/F2
Step 5. Link months together. Make next month’s start customers and start MRR equal this month’s end values. That way your sheet reconciles automatically, and any mismatch with your billing system tells you something’s off.
Step 6. Format the percentage columns and add conditional formatting to highlight any month above your target.
Step 7. Chart it. A simple line chart of the three churn rates over time will tell you more than any table.
Key inputs every churn calculator needs
| Input | What it is | Why it matters |
|---|---|---|
| Start-of-month users | Active paying customers on day one | The denominator for customer churn |
| Lost users | Customers who cancelled or lapsed during the month | The numerator for customer churn |
| New upgrades (expansion MRR) | Extra monthly revenue from existing customers | Turns gross churn into net churn |
| Downgrades (contraction MRR) | Revenue lost from customers moving to cheaper plans | Hidden churn that customer counts miss |
| Start MRR | Total recurring revenue on day one | The denominator for revenue churn |
| Churned MRR | Recurring revenue lost from cancellations | The biggest piece of revenue loss |
| End MRR | Total recurring revenue on the last day | Your reconciliation check |
Tip: decide up front how you’ll treat failed payments. Many teams count a customer as churned only after a grace period. Pick a rule and stay consistent, or your trend line will lie to you.
Why acquisition quality shows up in your churn number
Here’s something a revenue churn calculator can’t tell you directly, but your cohort data will: a lot of churn is decided before the customer ever signs up.
If your marketing pulls in people who were never a good fit, they’ll sign up, poke around, and leave. Your top-of-funnel looks healthy. Your churn climbs. Nothing in the product is broken.
That’s why the way you acquire matters as much as how much you acquire. Channels built on relevance and intent, like the digital PR and link-building work run by agencies such as linksbuilderhub.com, tend to bring people who found you while actively looking for a solution. A visitor who lands on your site after reading a relevant article about the exact problem you solve is a very different customer from someone who clicked a broad discount offer.
The practical move: tag every new customer with their acquisition source in your sheet, then compare churn by source after three or four months. You’ll probably find one or two channels that bring in customers who stick, and one or two that bring in customers who vanish. Shift budget accordingly.
What’s a good churn rate?
Benchmarks vary a lot by price point, contract length, and customer size, so treat these as rough ranges and not targets carved in stone.
| Business type | Typical monthly customer churn | Strong performance |
|---|---|---|
| B2B SaaS, enterprise (annual contracts) | 0.5% to 1% | Under 0.5% |
| B2B SaaS, mid-market | 1% to 2% | Under 1% |
| B2B SaaS, SMB (monthly plans) | 3% to 5% | Under 2% to 3% |
| B2C subscriptions | 5% to 8% | Under 4% |
A few things that shift these numbers:
- Annual contracts hide monthly churn until renewal. Look at renewal rates separately.
- Cheaper products churn faster, because switching costs less than the hassle of keeping them.
- Young companies usually run higher churn while they figure out who their best customers are.
The benchmark that matters most is your own trend. If your net churn is falling quarter over quarter, you’re heading the right way regardless of what the industry average says.
Practical fixes once you see the number
The calculation tells you where you are. These steps move the number.
1. Find where customers leave. Check how long customers stay before cancelling. If most leave in the first 30 to 60 days, it’s an onboarding or fit problem. If they leave after a year, it’s value or pricing.
2. Fix onboarding first. Early churn is the cheapest to fix. Get new users to their first meaningful result fast, with a clear first task, a short email sequence, and a human check-in for higher-value accounts.
3. Talk to people who left. A short exit survey or a few calls will teach you more than any dashboard. Ask what they were trying to do and what got in the way.
4. Recover failed payments. A meaningful share of churn is involuntary: expired cards, declined payments. Retry logic and friendly payment reminder emails recover revenue with almost no effort.
5. Offer plan changes instead of cancellation. A pause option or a cheaper tier keeps some revenue and keeps the relationship alive.
6. Watch usage, not just billing. Customers who stop logging in usually cancel soon after. Flag accounts with falling activity and reach out before they decide.
7. Build expansion into the product. Seats, usage tiers, and add-ons let happy customers grow their spend, which pushes net churn down even when some customers leave.
8. Tighten who you target. Go back to your acquisition sources. If a channel brings high-churn customers, cut it or change the message.
How often should you measure churn?
Monthly for the headline numbers: customer churn, gross MRR churn, net MRR churn. It’s frequent enough to catch problems and spot trends.
Quarterly for cohort analysis. Group customers by signup month and track how many are still active after one, three, and six months. This shows whether your fixes are working, because new cohorts should retain better than old ones.
Review immediately after any big change: a pricing update, a major product release, a new acquisition channel. Don’t wait for the quarter to end.
Keep the spreadsheet simple, update it on the same day each month, and look at the trend rather than a single data point. Churn rarely improves overnight, but it does improve steadily when you measure it consistently and act on what you find.
If you want, I can also put this in a Word doc or build a downloadable Excel churn calculator template to go with it.

Pingback: Headscale GUI: Best Web UIs + Docker Setup (2026)