How many customers and how much revenue do you lose?
Enter customers and recurring revenue at the start and what you lost. See customer churn, revenue churn and the annualised rate.
Your numbers
Example numbers are filled in. Replace them with yours.
From customers who left or cancelled.
Optional. Used for net revenue churn.
12 if you measure monthly, 4 quarterly, 1 yearly.
Customer churn rate
5%
Customers lost ÷ customers at the start
Small per-period churn compounds: the annualised figures show what a year of the same rate means.
- Customer retention
- 95%
- Revenue churn rateRevenue lost ÷ revenue at the start
- 5%
- Net revenue churn(Revenue lost − expansion) ÷ revenue at the start; negative means expansion is bigger than losses.
- 3%
- Customer churn, annualised1 − (1 − rate) to the power of periods per year.
- 46%
- Revenue churn, annualised
- 46%
Open gives finance teams a clear view of cash movements, so the revenue side of this picture is easy to verify.
A calculation for planning, not accounting, tax or investment advice. It uses only the numbers you enter, and everything is calculated in your browser: nothing you type leaves it.
Questions about this tool
How is churn calculated?
Customer churn = customers lost ÷ customers at the start of the period. Revenue churn = recurring revenue lost ÷ recurring revenue at the start.
What is net revenue churn?
(Revenue lost − expansion from remaining customers) ÷ starting revenue. A negative number means expansion is bigger than losses.
How is the annualised rate worked out?
Annualised churn = 1 − (1 − rate) to the power of the number of periods in a year. A 5% monthly churn compounds to about 46% over twelve months.
Should new customers count?
No. Customers added during the period are left out of the start count, so churn only describes customers you already had.
Bring your banks together. Get more done.
Connect your current accounts and start using Open through your dashboard, ERP or internal systems.