Accounting Churn Rate (Per-Unit) Calculator
Calculate unit churn from opening units, additions, closing units, and the length of the reporting period.
Overview
Use this accounting churn rate calculator to reconcile active units from the start and end of a reporting period. Enter opening units, units added, closing units, and the period length to estimate lost units, gross churn, retention, and a monthly equivalent rate.
How it works
The calculator first reconciles unit movement: churned units equal opening units plus new units added minus closing units. Gross unit churn is then churned units divided by opening units. Retention shows the share of the opening base that remained, while the monthly equivalent rate converts the period churn into a compounded monthly figure. New units are excluded from the opening-base churn denominator so that growth does not hide losses from the starting population.
How to use this calculator
- 1Enter the active unit count at the beginning of the period.
- 2Add units acquired or activated during the period.
- 3Enter the active unit count at the end of the period.
- 4Set the number of months in the reporting period.
- 5Review the reconciled churned units and gross churn rate.
Example Calculation
Opening units
1000
New units added
180
Closing units
1050
Reporting period
3
Gross unit churn rate
13.00%
With 1,000 opening units, 180 additions, and 1,050 closing units, estimated churn is 130 units. That is a 13.00% gross churn rate for the period, or about 4.54% per month on a compounded equivalent basis.
Frequently asked questions
What is per-unit churn rate?
Per-unit churn rate measures the proportion of units in the opening base that were lost during a reporting period. A unit may be an account, subscriber, customer, seat, location, or another consistently defined active item.
How are churned units calculated?
Churned units are calculated as opening units plus new units added minus closing units. For example, 1,000 opening units plus 180 additions and 1,050 closing units implies 130 churned units.
Why are new units excluded from the churn rate denominator?
Using opening units as the denominator focuses the rate on attrition from the starting population. New additions are used to reconcile the closing count but do not reduce the calculated churn rate.
What is the difference between gross churn and net unit change?
Gross churn measures units lost from the opening base. Net unit change compares total closing units with opening units, so it includes both additions and churn and can be positive even when churn is high.
Why does the calculator show a monthly equivalent churn rate?
The monthly equivalent rate makes churn periods of different lengths easier to compare. It expresses the period's churn as a compounded monthly rate rather than simply dividing the rate by the number of months.
What should I do if closing units exceed opening units plus additions?
This may indicate reactivations, data timing differences, classification changes, or incomplete input data. The calculator reports zero churn in this case, but the underlying reconciliation should be reviewed.
Explore Related Calculators
Assumptions and warnings
Assumptions
- Opening and closing counts use the same definition of an active unit.
- New units added during the period are recorded separately from the opening unit base.
- Churned units are calculated as opening units plus additions minus closing units.
- The monthly equivalent rate assumes churn compounds evenly across the reporting period.
- Results are operational estimates and depend on accurate unit reconciliation.
Warnings
- This calculator provides an estimate for management reporting and should be checked against your organisation's accounting policies and source records.
- A negative reconciliation result is treated as zero churn; review the input data if closing units exceed opening units plus additions.