Employee Attrition Rate Calculator
From beginning and ending headcount and separations, compute the employee attrition rate.
Input Data
Results
At a glance:Attrition rate = separations / average headcount x 100%, where average headcount = (beginning + ending) / 2. Using the average smooths within-period changes. Example: beginning 200, ending 180, 30 left gives average 190 and 15.79%. WARNING: Distinguish voluntary vs involuntary and regrettable vs healthy attrition; compare with industry benchmarks; any decision must comply with Hong Kong's Employment Ordinance.
Formula
Average headcount = (beginning headcount + ending headcount) / 2.
Attrition rate = separations / average headcount x 100%.
$$\overline{N} = \dfrac{N_{\text{begin}} + N_{\text{end}}}{2}$$$$\text{Attrition Rate} = \dfrac{\text{Separations}}{\overline{N}} \times 100\%$$How to Use
- Enter the beginning and ending headcount.
- Enter the number of separations in the period.
- View the average headcount and the attrition rate.
FAQ
Why use average headcount as the denominator?
Headcount changes within the period, so either endpoint alone can distort the rate. Averaging (beginning + ending) / 2 fairly reflects the typical size over the period. For very volatile headcount, use the average of month-end counts, but keep the basis consistent.
What attrition rate is high?
No universal standard — it varies by industry, role and region (retail/F&B higher; professional services lower). Compare with your own history and peers, and break down by department and level. Build a baseline (e.g. your 3-year average) and see if the current figure is flat, improving or worsening.
Do all departures count?
For the total rate, yes. But for management, split voluntary vs involuntary (layoffs, dismissal) and regrettable (high performers) vs healthy. Total turnover reflects filing load; voluntary rate signals pay/management issues; regrettable loss is the real warning.
Is attrition rate the same as turnover rate?
Both translate to 'employee attrition/turnover rate' and share the same formula (separations / average headcount). Usage sometimes differs (turnover = all exits; attrition = natural exits not backfilled), but not universally. What matters is defining the numerator and denominator clearly and keeping them consistent. Our turnover-rate calculator takes average headcount directly; this one derives it from beginning/ending counts.
What Hong Kong compliance points apply?
The rate itself is just a metric, but decisions from it are governed by law. Redundancies/terminations must follow the Employment Ordinance (notice or pay in lieu, earned leave pay, and severance payment or long-service payment where eligible, not both). Handling employee data must comply with the Personal Data (Privacy) Ordinance. Avoid discrimination under Hong Kong's anti-discrimination ordinances when analysing groups. This tool is for calculation only, not legal advice — consult Labour Department guidance and professionals.
Related Tools
References
Content review: Calculatorism Finance Team. Results are for reference only; please refer to the relevant authorities for the official figures.