Enter monthly workforce data
Example data table
| Month | Opening Headcount | Closing Headcount | Voluntary Exits | Involuntary Exits | Separations | Average Headcount | Turnover Rate |
|---|---|---|---|---|---|---|---|
| January | 120 | 122 | 6 | 3 | 9 | 121.0 | 7.44% |
| February | 122 | 125 | 4 | 2 | 6 | 123.5 | 4.86% |
| March | 125 | 123 | 5 | 2 | 7 | 124.0 | 5.65% |
| April | 123 | 126 | 3 | 1 | 4 | 124.5 | 3.21% |
Formula used
Average Headcount = (Opening Headcount + Closing Headcount) / 2
Monthly Turnover Rate = (Separations Used / Average Headcount) × 100
Voluntary Turnover Rate = (Voluntary Exits / Average Headcount) × 100
Involuntary Turnover Rate = (Involuntary Exits / Average Headcount) × 100
Annualized Turnover = Monthly Turnover Rate × 12
Stability Rate = ((Opening Headcount − Separations Used) / Opening Headcount) × 100
Replacement Cost = Separations Used × Replacement Cost per Exit
Movement-Based Closing Headcount = Opening + Hires + Transfers In − Voluntary Exits − Involuntary Exits − Transfers Out
How to use this calculator
- Enter the reporting month label for easier exports and records.
- Add opening headcount, hires, exits, and transfer counts.
- Provide the closing headcount, or leave it blank for auto-calculation.
- Choose whether transfers out should count as turnover in your policy.
- Enter a benchmark turnover rate and an estimated replacement cost.
- Submit the form to view rates, staffing movement, cost, and risk signals.
- Use the CSV or PDF buttons to save a report for meetings or audit trails.
Frequently asked questions
1. What is monthly turnover rate?
Monthly turnover rate measures how many employees left during one month relative to average headcount. It helps HR teams monitor retention pressure, compare departments, and spot sudden workforce instability.
2. Why use average headcount instead of opening headcount?
Average headcount smooths staffing changes across the month. It reduces distortion when hiring or exits happen mid-month and makes period-to-period comparison more consistent.
3. Should transfers out be counted as turnover?
That depends on your reporting rule. Company-wide turnover usually excludes internal transfers, while departmental turnover often includes them because the team still lost capacity.
4. What counts as a healthy monthly turnover rate?
Healthy turnover varies by industry, labor market, role type, and seasonality. Use this calculator with your own benchmark and compare several months before drawing conclusions.
5. Does this calculator estimate cost too?
Yes. It multiplies the number of separations used in the turnover formula by your estimated replacement cost per exit, creating a quick attrition-cost view.
6. Can I compare voluntary and involuntary turnover separately?
Yes. The output shows separate voluntary and involuntary turnover rates, which helps distinguish retention problems from performance management or restructuring effects.
7. Why does the closing headcount warning appear?
The warning appears when the closing headcount you entered does not match the value implied by hires, exits, and transfers. It flags possible data-entry or reconciliation issues.
8. How often should HR review turnover?
Review turnover monthly at minimum. High-volume teams or fast-changing organizations may also track weekly trends, then summarize findings monthly for leadership decisions.