| Scenario | Start | End | New | Lost (implied) | Churn (Start base) | Retention |
|---|---|---|---|---|---|---|
| Sample A (12 months) | 1,200 | 1,350 | 450 | 300 | 25.00% | 75.00% |
- Implied lost customers = Start Customers + New Customers − End Customers.
- Customer churn rate (period) = Customers Lost ÷ Denominator.
- Denominator = Start Customers (or Average Customers = (Start + End) ÷ 2).
- Retention rate = 1 − Churn rate.
- Annualized churn = 1 − (1 − Periodic Churn)^(12 ÷ Period Months).
- Net growth rate = (End − Start) ÷ Start.
- GRR = 1 − (Churned ARR + Contraction ARR) ÷ Starting ARR.
- NRR = (Starting ARR + Expansion − Contraction − Churned) ÷ Starting ARR.
- Enter your period length in months (use 12 for a year).
- Choose a denominator method that matches your reporting standard.
- Fill Start, End, and New customers; enable auto-lost for consistency.
- Optionally enable revenue metrics and enter recurring revenue movements.
- Click Calculate to view churn, retention, and growth above the form.
- Export your results using the CSV or PDF download buttons.
Customer churn frames your retention story
Annual churn shows how much of your customer base you lose over a year, independent of how much you acquire. For example, Start 1,200, New 450, End 1,350 implies Lost 300. Using a start-base denominator, periodic churn is 300 ÷ 1,200 = 25.00%, and retention is 75.00%. These two numbers are often easier to explain than raw counts. If implied loss turns negative, set it to zero and review reactivations.
Denominator choice changes the narrative
Teams typically report churn using beginning customers, yet some prefer an average base when the customer count changes materially during the period. With the same example, the average base is (1,200 + 1,350) ÷ 2 = 1,275, so churn becomes 300 ÷ 1,275 = 23.53%. Keep the method consistent across quarters to avoid false trend shifts. Show the denominator in reports so comparisons stay honest.
Annualization makes shorter periods comparable
If you measure churn over fewer than 12 months, the calculator compounds it to an annual rate: Annualized Churn = 1 − (1 − Period Churn)^(12 ÷ Months). A 3‑month churn of 6% annualizes to 1 − (0.94^4) = 21.93%. This prevents simple multiplication from overstating or understating the true effect. When Months = 12, annualized churn equals periodic churn.
Revenue churn adds depth beyond logo loss
When enabled, revenue metrics separate cancellations from downgrades and expansions. Suppose Starting ARR is 240,000, Expansion 60,000, Contraction 15,000, and Churned 45,000. Estimated Ending ARR is 240,000. GRR = 1 − (45,000 + 15,000) ÷ 240,000 = 75%. NRR = (240,000 + 60,000 − 15,000 − 45,000) ÷ 240,000 = 100%. If NRR rises above 100%, net revenue churn becomes negative, signaling expansion outweighs losses.
Turn the output into action-ready segments
Use the results to drill into cohorts: acquisition channel, first-year vs. tenured customers, plan tier, and region. Pair churn with net growth to see whether acquisition is masking retention issues. If churn rises while growth stays flat, focus on onboarding, product activation, pricing fit, and win-back workflows. Track churn triggers like low usage, repeat support tickets, or delayed renewals to target proactive campaigns. Export CSV/PDF to share assumptions and decisions externally.
FAQs
1) What does annual churn rate represent?
It is the share of customers lost over a year relative to your chosen customer base. It complements growth by isolating retention performance from acquisition volume.
2) What is the difference between annual churn and annualized churn?
Annual churn uses a full 12-month measurement. Annualized churn converts a shorter period into an annual equivalent using compounding, so a 3-month churn can be compared fairly to yearly results.
3) Should I use beginning customers or average customers?
Beginning customers is common and simple. Average customers can reduce distortion when the base changes quickly. Pick one method, document it, and keep it consistent across reporting periods.
4) Why might implied lost customers differ from my manual lost count?
Implied loss assumes Start + New − End with no reactivations, migrations, or pauses. Manual counts may include reinstatements, plan conversions, or data timing differences across systems.
5) Can NRR be above 100%?
Yes. If expansion outweighs churn and contraction, NRR exceeds 100%. That indicates existing customers, on average, grew their recurring revenue during the period.
6) How should I use this for quarterly tracking?
Set Period Months to 3, calculate quarterly churn, then rely on the annualized churn output for an annual view. Segment by cohort each quarter to spot early changes in retention.