Accounting Churn Rate (Per-Unit) Formula
Learn how to reconcile lost units and calculate gross per-unit churn, retention, and a monthly equivalent churn rate.
This calculator estimates how many active units were lost between the opening and closing counts after accounting for new units added during the reporting period. It then expresses those losses as a percentage of the opening unit base, which helps separate attrition from overall growth or decline.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Gross Unit Churn Rate
Where:
First, reconcile the units lost by adding opening units and new units, then subtracting closing units. Divide the reconciled losses by opening units to find the percentage of the starting base that churned.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| openingUnits - Opening units | The number of active accounts, subscriptions, seats, customers, or other consistently defined units at the beginning of the reporting period. | number |
| unitsAdded - New units added | Units acquired or activated during the reporting period that are recorded separately from the opening base. | number |
| closingUnits - Closing units | The number of active units at the end of the reporting period. | number |
| periodMonths - Reporting period | The number of whole months between the opening and closing unit counts. | months |
Step-by-Step Calculation
Reconcile churned units
Reconciled churn is the shortfall between the units expected after additions and the actual closing count. The maximum function prevents a negative churn result.
churnedUnits = max(0, openingUnits + unitsAdded - closingUnits)
Calculate gross unit churn
Gross churn measures lost units as a share of the opening unit base, rather than as a share of closing units or average units.
grossChurnRate = (churnedUnits / openingUnits) * 100
Estimate retained opening units
This estimates how many units from the opening base remained active after the reconciled losses.
retainedUnits = max(0, openingUnits - churnedUnits)
Calculate opening unit retention
Retention is the portion of opening units that remained. Where churn is within the opening base, retention plus gross churn equals 100%.
retentionRate = (retainedUnits / openingUnits) * 100
Convert period churn to a monthly equivalent
This expresses the total period churn as an evenly compounded monthly equivalent, making periods of different lengths easier to compare.
monthlyChurnRate = (1 - pow(1 - grossChurnRate / 100, 1 / periodMonths)) * 100
Calculate net unit change
Net change compares only the opening and closing counts. It includes both additions and churn, so it is not a substitute for gross churn.
netUnitChange = closingUnits - openingUnits
Three-Month Subscription Unit Churn Example
Expected units before churn
1,000 + 180
1,180 units
Churned units
max(0, 1,180 - 1,050)
130 units
Gross unit churn rate
130 / 1,000 × 100
13.00%
Opening unit retention
(1,000 - 130) / 1,000 × 100
87.00%
Monthly equivalent churn
(1 - pow(1 - 0.13, 1 / 3)) × 100
4.54% per month
Net unit change
1,050 - 1,000
+50 units
Final Result
Estimated gross churn is 13.00%, representing 130 lost units. Opening unit retention is 87.00%, monthly equivalent churn is 4.54%, and net unit change is +50 units.
Assumptions
- ✓Opening and closing counts use the same definition of an active unit.
- ✓New units are separately identified and are not included in the opening base.
- ✓Units added during the period are available to reconcile the closing count.
- ✓The monthly equivalent calculation assumes churn compounds evenly over the stated number of months.
- ✓A negative reconciliation is treated as zero churn.
Limitations
- !The calculation cannot identify the exact timing of losses within the reporting period.
- !Reactivations, migrations, mergers, and classification changes can affect the reconciliation unless handled consistently.
- !A count-based churn rate does not measure revenue lost, contract value, or profitability.
- !The retained opening unit estimate assumes churned units can be attributed to the opening base.
- !Results depend on complete and accurate source records and should be treated as management-reporting estimates.
Common Mistakes to Avoid
Using closing units as the churn denominator instead of opening units.
Counting reactivated units as new additions in one period but not another without a consistent reporting policy.
Comparing a quarterly period churn rate directly with a monthly rate without converting the period length.
Interpreting positive net unit growth as evidence that no churn occurred.
Mixing active-unit definitions between the opening and closing dates.
Leaving out additions that occurred during the reporting period.
Related Formulas
Frequently Asked Questions
What is the formula for per-unit churn rate?
Per-unit gross churn rate equals reconciled churned units divided by opening units, multiplied by 100. Reconciled churned units equal opening units plus additions minus closing units, with negative results capped at zero.
Why is churn based on opening units?
The opening base shows the population exposed to attrition at the start of the period. Using it as the denominator keeps new acquisitions from reducing the reported loss rate.
How do I calculate churned units from opening and closing counts?
Add new units to opening units, then subtract closing units. For example, 500 opening units plus 40 additions minus 490 closing units equals 50 churned units.
What is the relationship between churn and retention?
When losses are attributed to the opening base, opening unit retention equals 100% minus gross unit churn. A 12% churn rate corresponds to 88% opening-unit retention.
How is monthly equivalent churn calculated?
The calculator uses a compounded conversion: 1 minus the period retention raised to the power of one divided by the number of months. It is not simply the period churn rate divided by months.
What does zero churn mean when closing units exceed opening units plus additions?
The formula caps churn at zero because it cannot infer negative losses. The excess may reflect reactivations, data timing, omitted additions, or changes in how units are classified.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.