Accounting Churn Rate Formula
Learn how to calculate customer churn, retention, recurring revenue churn, and ending customers for an accounting period.
Accounting churn measures losses from the customer and recurring-revenue base that existed at the start of a reporting period. Separating losses from new business makes retention trends easier to compare across months, quarters, or years.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Customer Churn Rate
Where:
Divide customers lost during the period by the opening customer count, then multiply by 100.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| customersLost - Customers lost | Customers from the opening base who cancelled, did not renew, or became inactive during the period. | customers |
| startingCustomers - Customers at start of period | Active customers at the beginning of the reporting period. | customers |
| newCustomers - New customers acquired | Customers added during the period; used for ending customers but not to reduce gross churn. | customers |
| startingRecurringRevenue - Starting recurring revenue | Recurring revenue from the opening customer base for the selected period. | currency |
| recurringRevenueLost - Recurring revenue lost | Recurring revenue lost through cancellations, non-renewals, or included downgrades. | currency |
Step-by-Step Calculation
Set the opening customer base
Use active customers at the beginning of the month, quarter, or year.
startingCustomers
Calculate customer churn
This shows the percentage of the opening customer base that was lost.
(customersLost / startingCustomers) * 100
Calculate customer retention
Retention is the portion of opening customers still retained before new acquisitions are considered.
100 - customerChurnRate
Estimate ending customers
Subtract customer losses and add customers acquired during the period.
startingCustomers - customersLost + newCustomers
Calculate recurring revenue churn
This shows the share of opening recurring revenue that was lost.
(recurringRevenueLost / startingRecurringRevenue) * 100
Calculate recurring revenue retained
This is recurring revenue remaining from the opening base, before new or expansion revenue.
startingRecurringRevenue - recurringRevenueLost
Monthly accounting churn example
Customer churn rate
(25 / 500) * 100
5.00%
Customer retention rate
100 - 5.00
95.00%
Estimated ending customers
500 - 25 + 40
515 customers
Recurring revenue churn rate
(3000 / 50000) * 100
6.00%
Recurring revenue retained
50000 - 3000
$47,000
Final Result
Customer churn is 5.00%, customer retention is 95.00%, estimated ending customers are 515, and recurring revenue churn is 6.00%.
Assumptions
- ✓Customer churn uses the customer base at the start of the selected period as its denominator.
- ✓New customers affect the ending customer estimate but do not offset gross customer churn.
- ✓Starting and lost recurring revenue cover the same reporting period and recurring-revenue definition.
- ✓Revenue churn includes only the loss categories your reporting policy consistently includes.
Limitations
- !The calculation does not identify why customers left or whether losses were avoidable.
- !Different customer segments, contract terms, and pricing tiers can have materially different churn patterns.
- !Revenue recognition timing may differ from billing or subscription movement timing.
- !The ending customer estimate does not show reactivations, mergers, or account-level changes unless they are classified consistently.
Common Mistakes to Avoid
Using ending customers instead of starting customers as the churn denominator.
Subtracting new customers from customers lost when calculating gross churn.
Comparing a monthly churn rate directly with an annual churn rate without noting the different periods.
Mixing one-time revenue with recurring revenue in the revenue-churn calculation.
Counting a downgrade twice as both a lost customer and lost recurring revenue without clear reporting definitions.
Related Formulas
Frequently Asked Questions
What is the customer churn rate formula?
Customer churn rate equals customers lost divided by customers at the start of the period, multiplied by 100.
How is customer retention calculated from churn?
For this gross measure, customer retention rate is 100% minus customer churn rate.
Do new customers lower the churn rate?
No. New customers affect ending customer count and net growth, but gross churn measures losses from the opening base.
What is the recurring revenue churn formula?
Divide recurring revenue lost during the period by recurring revenue at the start of the period, then multiply by 100.
Should downgrades count as recurring revenue churn?
They may be included when your reporting definition treats a reduction in recurring spend as lost recurring revenue. Apply the same approach each period.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.