Quick Answer

Churn rate equals customers lost during a period divided by customers at the start of that period, multiplied by 100. For SaaS teams, calculate both logo churn (customer count) and revenue churn (MRR lost) separately, and report net revenue churn to capture expansion offsetting cancellations.

Introduction

Most SaaS teams calculate churn wrong, and the errors rarely surface until a board meeting exposes them. The core churn rate formula is arithmetic simple, yet teams routinely blend logo and revenue churn, ignore mid-period signups, or pull inconsistent snapshots from spreadsheets that drift week to week. The result is a metric that leadership treats as gospel while the underlying number swings by two or three percentage points depending on who ran the query. In 2026, competitive B2B SaaS churn sits well below the informal 5% monthly benchmark that circulated a decade ago, and using outdated targets can quietly justify a retention problem that is actively compounding.

Key Takeaways:

• The churn rate formula is (customers lost ÷ customers at period start) × 100, calculated separately for logos and revenue.

• Competitive 2026 B2B SaaS benchmarks sit near 5-7% annual logo churn for mid-market and under 1% monthly for enterprise.

• Manual spreadsheet tracking introduces snapshot drift that warehouse-native calculations eliminate.

The Churn Rate Formula and Its Variations

Churn is not a single number. It is a family of related calculations, and picking the wrong variant for your reporting context distorts everything downstream, from forecasting to LTV modeling.

The Core Formula and Its Components

The base churn rate formula divides the count of customers lost during a period by the count of customers active at the start of that period. That output, multiplied by 100, gives you a percentage. The formula sounds trivial, but each input has to be defined precisely before the number means anything. According to attrition rate methodology, the denominator and treatment of mid-period signups are where most teams diverge.

• Period definition: Monthly, quarterly, and annual churn are not interchangeable and cannot be linearly converted.

• Customer count basis: Active paying accounts only, excluding trials, paused subscriptions, and internal test accounts.

• Loss trigger: Cancellation date, subscription end date, or failed renewal, chosen once and applied consistently.

• Mid-period signups: Excluded from the denominator to avoid understating churn.

• Involuntary churn: Payment failures should be tracked separately from voluntary cancellations.

Logo Churn vs Revenue Churn vs Net Revenue Churn

Logo churn counts customers, revenue churn counts dollars, and net revenue churn subtracts expansion MRR from lost MRR. The distinction matters enormously for reporting. A company can lose 8% of its logos while growing net revenue if the departing customers were small and existing accounts expanded. Confusing the three is the fastest way to misrepresent retention health to investors. For teams building formal reporting layers, the revenue churn formula should be codified in the semantic layer rather than recalculated per dashboard.

The table below compares the three most common churn variants used in SaaS reporting, showing what each measures and when to use it.

The takeaway: report all three side by side. A single number hides the tension between logo loss and revenue expansion, which is precisely the signal leadership needs to act on. Understanding the churn rate formula basics across all variants prevents the mixed-metric confusion that plagues quarterly reviews.

Benchmarks, Worked Examples, and the Free Template

Numbers only mean something in context. A 4% monthly churn rate is a crisis for enterprise SaaS and unremarkable for consumer subscription apps, so benchmarking has to be segmented by business model and stage.

2026 SaaS Churn Benchmarks by Segment

Competitive churn thresholds have tightened significantly since 2020, driven by tougher fundraising environments and higher scrutiny on unit economics. According to current churn benchmarks, healthy B2B SaaS companies now target annual logo churn between 5% and 7% for mid-market accounts and below 3% for enterprise. Consumer SaaS operates on a different scale entirely, with monthly churn between 3% and 8% considered normal. For b2b saas churn benchmarking for European markets, the ranges are broadly similar to US comparables, though contract lengths and payment terms create slightly lower monthly volatility.

Here is a worked example using realistic SaaS numbers. Assume you start the month with 1,000 paying customers and $500,000 MRR. During the month, 42 customers cancel, representing $18,500 in lost MRR. Expansion from existing accounts adds $22,000 in new MRR. Logo churn is (42 ÷ 1,000) × 100 = 4.2%. Gross revenue churn is ($18,500 ÷ $500,000) × 100 = 3.7%. Net revenue churn is (($18,500 - $22,000) ÷ $500,000) × 100 = -0.7%, meaning your existing base is net expanding despite logo loss. Applying the calculating churn rate workflow consistently across periods is what makes these numbers comparable quarter over quarter.

Free Template Structure and What to Track Alongside

A usable churn template needs five columns at minimum: period, starting customers, customers lost, starting MRR, and MRR lost, with derived columns for each churn variant. TrackRaptor publishes a free template alongside its retention analytics frameworks that covers logo churn, gross revenue churn, net revenue churn, and the LTV to churn ratio formula. Track churn alongside cohort retention curves, NRR by customer segment, and CAC payback period to get a complete retention picture rather than a single lagging indicator.

Why Manual Spreadsheets Break Churn Reporting

Spreadsheet-based churn tracking works until it does not, and the failure mode is always the same: the number quietly stops matching the source of truth.

Snapshot Drift and Calculation Inconsistency

Manual spreadsheet calculation vs automated BI tools comes down to reproducibility. A spreadsheet pulled on the 3rd of the month gives a different starting customer count than one pulled on the 5th because cancellations continue to backfill. Warehouse-native pipelines snapshot the state deterministically and can be rerun for any historical period without drift. According to SaaS churn methodology guidance, the calculation method matters as much as the formula, and inconsistent snapshotting is the most common source of quarter-to-quarter noise in reported churn. TrackRaptor's coverage of warehouse-native churn tracking walks through how to build these pipelines in dbt with source-of-truth timestamps.

When to Move Off Spreadsheets

Once you cross roughly 500 paying customers or start segmenting churn by plan, cohort, or region, spreadsheets stop scaling. Cohort analysis for churn reduction becomes nearly impossible to maintain manually across dozens of cohorts, and any change to the definition requires rebuilding every historical calculation. Moving churn calculations into the warehouse means the definition lives in code, changes are versioned, and every dashboard reads from the same source.

Conclusion

Calculating churn rate correctly is less about the formula and more about the discipline around definitions, snapshots, and reporting context. Report logo churn, gross revenue churn, and net revenue churn together, benchmark against current 2026 segment-appropriate ranges rather than legacy averages, and codify the calculation in your warehouse so the number does not shift between dashboards. Teams that treat churn as a versioned metric rather than a spreadsheet output tend to catch retention problems months earlier than teams that recalculate manually each quarter. The template and formulas above give you a working starting point, but the real win comes from making the calculation reproducible.

Want a deeper breakdown of warehouse-native metric pipelines and retention analytics? Explore more analytics guides on TrackRaptor to build reporting infrastructure your leadership team can actually trust.

Frequently Asked Questions (FAQs)

What is a good churn rate for a SaaS business?

A good churn rate in 2026 is under 7% annual logo churn for mid-market B2B SaaS and under 3% for enterprise, with net revenue churn ideally negative through expansion.

How do you calculate churn rate step by step?

Take the number of customers lost during the period, divide by the number of customers active at the period start, then multiply by 100 to get the percentage.

What is the difference between logo churn and revenue churn?

Logo churn measures the percentage of customers lost, while revenue churn measures the percentage of MRR lost, which can diverge significantly when customer sizes vary.

Is it possible to calculate churn using SQL?

Yes, SQL is the preferred approach because it can snapshot customer and MRR states deterministically from the warehouse and rerun historical periods without drift.

How often should you report churn rate?

Report churn monthly for operational review and quarterly for board updates, using consistent period definitions so the numbers remain comparable over time.

What metrics should be tracked alongside churn rate?

Track NRR, cohort retention curves, CAC payback period, and the LTV to churn ratio formula to contextualize churn within broader retention and unit economics health.

Churn rate vs retention rate: which should you use?

Use both because they are mathematically inverse but frame retention health differently, with churn emphasizing loss and retention rate emphasizing stickiness for cohort analysis.

About the Author

Noah Richardson is a SaaS Metrics Advisor who writes about KPIs, retention analysis, customer lifecycle measurement, and revenue-focused analytics. His work focuses on helping product and growth teams build reporting frameworks that leadership can trust, with particular attention to churn, NRR, and cohort-level retention analytics.