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.
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
- The starting group. Customers paying on the first day. New customers are out.
- What counts as lost. A cancellation, a non-payment after the grace period, or a downgrade to free. Pick one and keep it.
- Reactivations. A customer who returns is a new customer in a monthly count, unless your definition says otherwise.
- Trials. Trial customers who never paid are usually excluded from churn, but they belong in the acquisition funnel.
- Revenue basis. Recurring revenue only, with annual plans divided by twelve.
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.
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 →