Churn rate calculator: how to calculate churn rate
What it works out
This calculator works out customer churn rate by dividing the customers lost during a period by the customers you had at the start of it. It shows the result as a percentage, with the retention rate, which is 100 less the churn rate, on the line below.
A churn rate calculator answers a simple question: of the customers you had at the start of a period, what share had gone by the end? Churn is the one subscription number that works against you quietly, so it pays to measure it the same way every time.
How the churn rate calculator works
The calculator divides one count by another and turns the answer into a percentage.
Churn rate = customers lost / customers at the start x 100
Retention rate = 100 - churn rate
Both are shown to one decimal place. The number of customers at the start must be more than zero. The period is whatever you choose, a month, a quarter or a year, and the calculator does not convert between them. Lose 14 customers in a month and the result is a monthly rate.
What to enter
- Customers at the start. Paying customers on the first day of the period. Free users and people on trial do not count.
- Customers lost. Of those starting customers, how many were no longer paying at the end of the period. Count cancellations and failed payments that were never recovered.
Two things are left out on purpose.
Customers who joined during the period are not in either box. If someone signed up on the 3rd and cancelled on the 20th, they were not there at the start, so strictly they are not part of this sum. Add them to the lost count and you can end up with a rate above 100%.
Downgrades are not lost customers. Someone who moved to a cheaper plan is still a customer. That shows up in revenue churn, which counts money and not people.
A worked example
Take a hypothetical product with 400 paying customers on the first of the month. By the last day, 14 of those 400 have cancelled or lapsed.
Churn rate = 14 / 400 x 100 = 3.5%
Retention rate = 100 - 3.5 = 96.5%
During the same month the product signed up 22 new customers, so it ended on 408. Those 22 do not enter the calculation. The customer count went up while 3.5% of the starting base left, and both statements are true. This is why a rising customer count cannot be read as proof of low churn.
What the result does not tell you
A single rate hides who is leaving. Losing fourteen customers on the cheapest plan in their first month is a different problem from losing fourteen who had paid the top price for two years. The calculator counts heads and treats them all alike.
A single period can also mislead. One month can be thrown off by a price change, a batch of expired cards or a seasonal dip. Look at several months in a row before drawing a conclusion.
Finally, do not turn a monthly rate into a yearly one by multiplying by twelve. Each month's losses come out of a smaller remaining base, so the yearly figure is lower than twelve times the monthly one. If you need a yearly rate, enter the customers at the start of the year and how many of them were gone by the end.
What churn means when a subscription business is for sale
For a buyer, churn says how fast the revenue being paid for would wear away if nothing new came in. That is why it gets asked about early in most SaaS conversations.
If you are acquiring. Ask for the customer count at the start of each of the last twelve months and the number lost in each, then run the figures yourself. Check the method: some sellers divide by the customer count at the end of the month, which makes churn look lower in a growing business. Ask also how failed payments are treated, since a customer whose card bounced three months ago and was never chased may still be counted as active. Then set the customer figure beside net revenue retention to see whether the customers who stay are paying more or less over time.
If you are selling. Publish the monthly series, not your best month. A buyer who finds the weaker months in diligence will wonder what else was selected. If one month is out of line, say why. A known cause, such as a price rise, is much easier for a buyer to accept than a gap in the record.
Churn also sets how long the average customer stays, which is one of the three inputs to the LTV calculator. A small change in the rate moves lifetime value a long way, so use the rate you can defend.
Related: churn, revenue-churn, net-revenue-retention, tools/ltv-calculator
When you are ready to read real listings.
Everything on sale, on the same fields, from $1,000 to $500,000.