Churn Calculator: Formulas, Sheet Setup, and Fixes

SaaS churn calculator spreadsheet template showing customer and revenue churn rate formulas

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:

ColumnContents
AMonth
BStart customers
CNew customers
DLost customers
EEnd customers
FStart MRR
GNew MRR
HExpansion MRR
IContraction MRR
JChurned MRR
KEnd MRR
LCustomer churn %
MGross MRR churn %
NNet 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

InputWhat it isWhy it matters
Start-of-month usersActive paying customers on day oneThe denominator for customer churn
Lost usersCustomers who cancelled or lapsed during the monthThe numerator for customer churn
New upgrades (expansion MRR)Extra monthly revenue from existing customersTurns gross churn into net churn
Downgrades (contraction MRR)Revenue lost from customers moving to cheaper plansHidden churn that customer counts miss
Start MRRTotal recurring revenue on day oneThe denominator for revenue churn
Churned MRRRecurring revenue lost from cancellationsThe biggest piece of revenue loss
End MRRTotal recurring revenue on the last dayYour 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 typeTypical monthly customer churnStrong performance
B2B SaaS, enterprise (annual contracts)0.5% to 1%Under 0.5%
B2B SaaS, mid-market1% to 2%Under 1%
B2B SaaS, SMB (monthly plans)3% to 5%Under 2% to 3%
B2C subscriptions5% 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.

1 thought on “Churn Calculator: Formulas, Sheet Setup, and Fixes”

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

Leave a Comment

Your email address will not be published. Required fields are marked *