Home / Blog / Churn Rate Formula
How-to · 2026

Churn Rate Formula: Customer Churn vs Revenue Churn, With Examples

Customer churn and revenue churn can point in opposite directions in the same month. Both formulas are simple. Which one you quote, over which period, and which customers you count, is where two reports from the same data disagree.

By · Published November 17, 2026 · 7 min read

Customer churn rate = customers lost during the period ÷ customers at the start of the period, × 100. Revenue churn uses the same structure with recurring revenue in place of customers. The two can move in opposite directions, because the customers who leave are not always typical of the base. Below is a worked example where they disagree, then the conversion to annual, then the definition to write down before you quote a figure.

The formulas

Customer churn rate  = customers lost in period / customers at start × 100
Revenue churn rate   = MRR lost from those customers / starting MRR × 100
Annual churn         = 1 - (1 - monthly churn) ^ 12

A worked example where the two disagree

The figures are illustrative: a subscription business with 5,000 customers and $150,000 of starting MRR, so an average of $30 per customer.

Customers at start                  5,000
Customers lost                        300
Customer churn                        300 / 5,000 = 6.0%

Average MRR of lost customers          $12 each
MRR lost                              300 x 12 = 3,600
Revenue churn                        3,600 / 150,000 = 2.4%

Six percent of customers left, but only 2.4% of revenue. The customers who cancelled were on the cheapest plan. Both numbers are correct, and both are useful. A board that hears only "6% churn" will worry about the wrong thing, and a team that hears only "2.4%" may ignore a retention problem in the small-customer segment, which is where the cancellations are concentrated.

Monthly churn and annual churn

Monthly churn does not add up to annual churn. Each month, the base you lose from is smaller, and the customers who join are not in the first month's base. A 5% monthly rate gives about 46% annual churn, not 60%. Say which you are quoting: a monthly figure of 5% and an annual figure of 46% describe the same behavior, and a reader comparing them against a 60% annual figure will be misled.

What to write down

Asking for churn with one definition

The churn figure is easy to calculate and easy to report differently in each place it appears. Quiriz keeps the churn definition in Company Context, so the board deck, the monthly report and the ad hoc question all use the same rule. Connect Stripe for subscription data, or upload an export, and in Excel with the Excel add-in:

=QUIRIZ.ASK("customer churn and revenue churn by month this year, with the definition from Company Context", "table")

In Google Sheets, use the Sheets add-in with the function written without the dot. The answer shows the starting count and the lost count, so you can check the rate yourself.

What it does not decide. Whether a downgrade counts as churn is a policy choice, and so is the grace period for failed payments. Quiriz applies the rule you set. For the revenue side of the same question, see the NRR formula post, and for the Stripe details that change the inputs, Stripe reporting.

📚 Connector reference: every dataset and metric definition behind this, and how each is calculated, is in the Stripe connector. All connectors.

One churn number everyone can check

Try the questions on sample company data with no signup, then connect Stripe and ask for churn by month with your definition.

Try Quiriz free →

Frequently asked questions

What is the basic churn rate formula?
Customers lost during a period divided by customers at the start of the period, times 100. For example, 300 lost out of 5,000 is 6%.
What is the difference between customer churn and revenue churn?
Customer churn counts customers. Revenue churn weights each customer by what they paid. If the customers who leave are small, revenue churn is lower than customer churn. If large customers leave, it is higher.
How do I convert monthly churn to annual?
Use annual churn = 1 - (1 - monthly churn) to the power of 12. A 5% monthly rate is about 46% a year, not 60%, because the customers you lose each month are not replaced by the same base.
Is churn the same as net revenue churn?
No. Net revenue churn subtracts expansion from the revenue lost, so it can be negative. Gross churn does not. Say which one you mean, because they are different numbers.
Why does ChatGPT give a different churn rate each time?
Usually because the question does not fix the definition: which customers count, which period, and whether downgrades are lost revenue. Define churn once in Company Context and every answer uses the same rule.