Skip to content
PutlerPutler

Churn Rate: Meaning, Formula, and How to Calculate It

Calculate churn rate with customer and revenue formulas. Follow a worked example, reconcile your records, and find subscription losses to investigate.

Churn rate is the percentage of customers or recurring revenue a business loses during a defined period. To calculate customer churn rate, divide customers lost from the starting group by customers in that group, then multiply by 100.

New sales can hide those losses. A store can grow from 100 to 115 paying customers while losing 5% of the people it started with. The ending total tells you about growth; churn tells you about the customers who left.

This guide follows one illustrative subscription store through the calculation, the checks, and the next decision. The figures are examples, not customer results or industry benchmarks.

What is churn rate?

Churn rate measures the share of an existing customer base or its recurring revenue lost over a set period. Losing 5 of 100 opening customers gives 5% customer churn, also called customer attrition or user churn. Revenue churn measures lost recurring revenue, including cancellations and downgrades.

For subscriptions, define when a paying relationship ends. A cancellation requested today may take effect next month. For one-time purchases, you need a separate inactivity rule because a buyer doesn’t formally cancel.

Start with a complete month and unique paying customers. Count each customer once, even if they hold several subscriptions. For the 100-customer example, that means tracing five specific departures rather than comparing two totals.

Which churn rate formula should you use?

Use customer churn to measure lost accounts, gross revenue churn to measure recurring-revenue losses, and net revenue churn to see whether existing-customer expansion offsets those losses. The denominator must use the same starting group and revenue basis as the numerator.

How do you calculate customer churn rate?

Customer churn rate = (customers lost from the starting group ÷ paying customers at the start) × 100.

If 100 paying customers start the month and five are no longer paying at month-end, customer churn is 5%. New customers acquired during the month don’t belong in either side of this opening-group calculation.

Stripe’s subscription churn guide explains the starting-customer approach. Record your own loss and reactivation rules alongside the figure so someone else can reproduce it.

How do you calculate gross revenue churn rate?

Gross revenue churn rate = ((cancellation MRR + downgrade MRR) ÷ starting MRR) × 100.

Monthly recurring revenue, or MRR, is the monthly value of recurring subscriptions. A $1,200 annual plan contributes $100 of MRR; its full invoice isn’t one month’s recurring revenue. Keep one-time purchases out of this calculation.

Suppose the same 100 customers each start on a $100 monthly plan. Starting MRR is $10,000. Five cancel, removing $500, and five different customers downgrade to $80, removing another $100.

Gross revenue churn is ($600 ÷ $10,000) × 100 = 6%. It exceeds customer churn because downgrades remove revenue without losing a customer.

How do you calculate net revenue churn rate?

Net revenue churn rate = ((cancellation MRR + downgrade MRR − expansion MRR) ÷ starting MRR) × 100.

Now suppose eight other existing customers each upgrade from $100 to $200. Their extra $800 offsets the $600 loss. Net revenue churn is (($600 − $800) ÷ $10,000) × 100 = −2%.

That is net negative churn: existing customers generate more recurring revenue despite cancellations and downgrades. New-customer revenue is excluded. Stripe’s revenue churn guide explains the gross/net distinction.

MetricCalculation in this exampleResult
Customer churn5 ÷ 100 × 1005%
Gross revenue churn$600 ÷ $10000 × 1006%
Net revenue churn($600 − $800) ÷ $10000 × 100−2%

All three numbers describe the same month. Keep the gross figure visible: expansion doesn’t remove the need to understand why five customers left.

How do you calculate churn rate from your own records?

Calculate churn from a fixed opening customer list, match losses to that list, and check the result against closing balances. You’ll need customer IDs, paid subscription status, effective start/end dates, and recurring plan amounts. A total customer count alone cannot show who left.

Step 1: choose the period and write the rules

Use a complete calendar month in one reporting timezone. Record the opening and closing timestamps so late-night renewals aren’t assigned to different months across exports.

For this worksheet, a customer is lost if they were paying at the start and have no active paid subscription at the end. A customer who leaves and returns before month-end is retained under this end-state rule. A churn-event report may count that departure differently.

Step 2: build the opening customer list

Export the customers with active paid subscriptions at the opening timestamp. Remove free trials and duplicate records, then count unique customer IDs. The example starts with 100.

Across systems, check whether two IDs represent the same person or account before combining them. Don’t merge people solely because their names match. An incorrect merge changes both the customer count and the loss rate.

Step 3: match the customers who were lost

Check each opening customer against the closing paid-subscription status. In the example, five no longer have paid access. Keep their IDs and effective end dates with the report so you can trace the numerator.

Someone who joined and left within the month is outside this opening group. Track that early loss separately; excluding it from this formula doesn’t make it unimportant.

Step 4: separate the recurring-revenue movements

Record starting MRR, cancellation losses, downgrade losses, and expansion for the opening customers. Normalize annual plans to monthly amounts and use one currency basis throughout. List new-customer MRR separately so it doesn’t offset churn.

The example has no reactivations or currency changes. If your report does, add separate movement lines and state which customer group they belong to. Don’t silently count returning former customers as expansion from customers who were paying at the start.

Step 5: check the closing totals

The store also gains 20 new customers at $100 per month. Its customer count rises to 115 and its MRR rises to $12,200, even though five opening customers left.

MovementPaying customer countMRR
Opening balance100$10000
Five cancellations−5−$500
Five downgrades0−$100
Eight upgrades0+$800
Twenty new customers+20+$2000
Closing balance115$12200

Customer check: 100 − 5 + 20 = 115. MRR check: $10,000 − $500 − $100 + $800 + $2,000 = $12,200.

If you used (starting customers − ending customers) ÷ starting customers, you’d get −15%. That’s net customer change expressed as a loss, not the 5% customer churn experienced by the opening group.

When a reconciliation fails, look for missing plan changes, duplicate customers, mismatched dates, or unlisted reactivations. Don’t change the formula just to make the totals agree.

Which reporting mistakes change the result?

Customer identity, effective dates, and billing rules can change a churn figure even when the underlying business hasn’t changed. Set these policies before comparing periods or dashboards. Use the same rules next month so a reporting change isn’t mistaken for better retention.

SituationRule for the opening-group worksheet
One customer cancels one of two subscriptionsCount revenue loss but no customer loss if another paid subscription remains active
Cancellation requested before paid access endsCount customer loss when paid access ends
Free trial never convertsExclude from paying-customer churn and track trial conversion separately
Refund issued while subscription remains activeTrack refund separately rather than automatically treating it as lost MRR
Annual plan paid upfrontNormalize recurring value monthly and distinguish notice from effective end date
Opening customer leaves and returns before month-endTreat as retained under this end-state policy and record the event separately
No paying customers at the startReport customer churn as not applicable because the denominator is zero

Small bases also need care. One loss among 20 customers is 5%; one loss among 200 is 0.5%. Show the count beside the percentage before reacting to a one-month spike.

How do monthly and annual churn rates compare?

Monthly churn measures losses from a month’s starting group; annual churn measures losses from a year’s starting group. A projected annual rate compounds monthly losses. It isn’t the monthly percentage multiplied by 12, and it isn’t a substitute for tracking the actual annual group.

For a constant monthly customer churn rate with no reactivations:

Annualized customer churn (%) = [1 − (1 − monthly churn as a decimal)^12] × 100.

At 5% monthly churn, projected annual churn is 46.0%. At 2%, it’s 21.5%. Those are projections under fixed assumptions; changing customer mix, seasonal renewals, and different monthly rates will change the outcome.

For a measured annual example, losing 3,000 of 52,000 opening customers gives 5.77% annual customer churn. Losing $44,408 from $501,000 of opening MRR over that year gives 8.86% gross revenue churn, with both revenue amounts on the same monthly recurring basis.

How does churn relate to retention and customer value?

For the same starting customer group and end-state rules, retention equals 100% minus customer churn. The example’s 5% churn means 95% of its opening customers remain. Use the customer retention guide for the wider retention calculation.

A simple revenue lifetime-value estimate divides average recurring revenue per customer by customer churn as a decimal. At $100 monthly revenue and 5% monthly churn, that gives $2,000 and an estimated 20-month lifetime.

This shortcut assumes stable churn and revenue per customer, with no discounting. It fails at zero churn and can mislead when behavior changes sharply. Applying gross margin estimates contribution before overhead, not net profit; the customer lifetime value guide explains the broader metric.

What is a good churn rate for your business?

A useful churn target matches the business model, customer segment, billing period, and metric being measured. A monthly customer-loss rate cannot be compared directly with annual revenue churn. Start with your own consistently measured trend, then use comparable external data for context.

Before adopting a benchmark, check the source’s period, sample, price points, and treatment of cancellations or reactivations. Separate monthly subscriptions from annual contracts where renewal opportunities differ. A low rate across all customers can still hide a poorly performing plan.

Which benchmarks need extra care?

The current Recurly churn benchmarks show conflicting SaaS summary and detail values. Check the underlying definition and table before choosing a target. This guide doesn’t select one disputed figure as the correct rate for your store.

The UserMotion company-size survey also needs caution: its size-based figures don’t clearly establish a common period and size boundaries. A precise-looking percentage isn’t useful when you can’t match the population.

The historical ChartMogul SaaS Benchmarks Report found negative churn in 40% of its $15M-$30M ARR group. Its aggregates generally cover the 12 months ending March 2023. That is dated context for a specific business group, not a current target for a smaller subscription store.

How should ecommerce stores measure churn?

Subscription stores can measure effective cancellations and recurring-revenue losses. One-time ecommerce stores need an inactivity definition based on how often customers are expected to buy again. A customer who skips one month hasn’t necessarily left a business with a long repurchase cycle.

Keep refill subscriptions, annual memberships, and one-time orders separate. Coffee buyers and furniture buyers shouldn’t share an arbitrary 30-day deadline.

For non-subscription purchases, inspect the time between repeat orders and choose a documented point at which a buyer becomes inactive. Adobe’s repeat-purchase analysis guide describes using the changing probability of another purchase to choose a business-specific threshold.

Label that measure clearly, such as “customers crossing our 90-day inactivity threshold.” The 90 days would be your chosen rule, not an industry standard. Keep the threshold stable when comparing periods, and review it if the product mix or buying cycle changes.

What should you do after calculating churn?

Investigate the lost customers before choosing a retention offer. In the example, review the $500 of canceled MRR separately from the $100 of downgrade losses. A percentage shows the scale of loss; it doesn’t establish the cause.

For the five cancellations and five downgrades in the example, use this table to choose a first investigation:

Evidence to checkPossible responseFollow-up measure
Failed renewals followed by ended subscriptionsReview retries and payment-update messages in the billing providerSuccessful recoveries and later paid renewals
Early cancellations with repeated setup complaintsImprove the specific setup step and help affected customersSame-age customer retention after the change
Downgrades with lower usage or budget feedbackInvestigate plan fit before offering a discountContraction MRR and retained contribution
Repeated product or support complaintsFix the recurring issue and contact affected customersCancellations with that reason in a later complete period

Voluntary churn means the customer chose to leave. Involuntary churn includes loss after payment failure without an intended cancellation. Confirm the sequence in billing records; a single failed charge isn’t automatically a lost customer.

Start with one action and keep the reporting rules fixed. A later improvement may also reflect seasonality or a different customer mix, so don’t assign all of it to the change. The deeper churn analysis guide covers investigation beyond the headline rate.

How can you check subscription losses in a reporting dashboard?

A subscription dashboard can bring recurring-revenue and customer-loss signals together, but its definitions must match your comparison. Use a hand calculation to check the reporting period, customer eligibility, and loss policy before treating a difference as an error.

Putler’s Subscriptions documentation describes MRR, churn, active subscriptions, and churned subscriptions in one reporting area. It lists Stripe, WooCommerce, EDD, Braintree, Authorize.Net, and Inbound for subscription reporting. Confirm your source; general integration support isn’t the same as subscription-metric support.

Historical Putler Subscriptions dashboard showing MRR, churn, active subscriptions, and churned subscriptions

Existing Putler Subscriptions screenshot from July-August 2023. It illustrates the reporting layout; these are historical figures, not results from this article or a current interface test.

What should your first reporting check cover?

  1. Match the window. Putler documents user churn as canceled customers in the last 30 days divided by active paying customers 30 days ago. Compare that with a matching period, rather than assuming it equals your calendar-month worksheet.

  2. Check the units. Review MRR, churn, and subscription counts together. A canceled subscription need not mean a lost customer.

  3. Trace a loss. Check payment and cancellation records for the reason. Run retries or recovery messages in your billing provider.

  4. Compare another complete period. Keep the definition fixed and record what changed. The wider subscription metrics guide explains the surrounding measures.

Keep refunds separate from MRR, as the documentation specifies. That prevents cash refunds from being mistaken for recurring-revenue losses.

What could retaining two subscribers be worth?

Suppose your investigation leads to an action that retains two $100 monthly subscribers for their next paid month. That’s $200 of MRR retained. At an assumed 70% gross margin, those payments contribute $140 before software, recovery work, and overhead.

This is a conditional first-month illustration, not a customer result or a guaranteed Putler return. Reporting helps you find a loss to investigate; the billing, support, or product action determines whether someone stays.

Start with one reconciled month

Choose the last complete month, save the opening customer list, and trace each loss to an effective end date. Calculate customer and gross revenue churn before adding the net figure. The example’s 5%, 6%, and −2% answer different questions.

For a reporting trial, aim to reconcile one period and identify one loss worth investigating. Use that task to judge whether the reporting saves enough work or supports a useful decision to justify its cost.

FAQs

How do you calculate churn rate?

Divide customers lost from the starting group by paying customers at the start, then multiply by 100. Losing five of 100 opening customers gives 5% customer churn. Specify the period, effective loss date, and reactivation rule. New customers acquired during the period are excluded from this opening-group calculation.

What is revenue churn rate?

Revenue churn measures lost recurring revenue from an existing customer group. Gross revenue churn includes cancellations and downgrades. Net revenue churn subtracts expansion from those losses. Use starting recurring revenue as the denominator, keep amounts on the same time basis, and exclude revenue from new customers.

What is negative churn?

Net negative revenue churn occurs when expansion from existing customers exceeds recurring revenue lost through cancellations and downgrades. In the example, $800 of expansion exceeds $600 of loss, giving −2% net churn against $10,000 of starting MRR. It doesn’t mean no customers left or that new sales count as retention.

What is a good churn rate?

A useful target depends on business model, customer segment, billing period, and metric. Compare like-for-like rates and read the benchmark’s sample and definitions before adopting it. Show customer counts alongside percentages for a small base, and check your own trend using the same rules across complete periods.

What does a high churn rate mean?

A high rate means a large share of the starting customer base or its recurring revenue was lost. It doesn’t automatically mean the business shrank, because new customers and expansion can exceed those losses. Check billing failures, deliberate cancellations, and downgrades separately before choosing a response.