How to Track Employee Turnover
How to track employee turnover accurately requires separating voluntary resignations from involuntary exits and measuring each against the right headcount denominator. An overall turnover rate that lumps both types together obscures whether you have a retention problem or a performance management one.
Upload your termination data and ask "What is our voluntary turnover rate by department for the past 12 months?" or "Which tenure band has the highest early-exit rate?"
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountWhat this export contains
| Employee ID |
| Department |
| Hire Date |
| Termination Date |
| Termination Type |
| Termination Reason |
| Job Level |
| Manager |
| Salary at Exit |
| Tenure Months |
What usually goes wrong with it
Voluntary and involuntary exits aren't separated in the report
The termination export lists all exits in one column, and managers calculate turnover rate on total exits — including layoffs from a restructuring that inflated the rate artificially.
DataMimi Datamimi filters terminations by Termination Type and calculates voluntary and involuntary turnover rates separately for the same period.
Early-tenure exits aren't flagged separately
An employee who leaves in month 2 and one who leaves after 5 years both count as one termination, but the first is an onboarding failure and the second is a retention failure — they need different interventions.
DataMimi It buckets exits by Tenure Months (0-90 days, 91 days-1 year, 1-3 years, 3+ years) so early-tenure and late-tenure exits are tracked independently.
Turnover cost isn't calculated
HR reports the turnover rate but not the dollar impact — replacing an employee costs 50-200% of their salary, so a 15% turnover rate at a 200-person company has a very different cost depending on average salary.
DataMimi It multiplies each exit's Salary at Exit by a configurable replacement cost multiplier (e.g., 1.5x) and sums the estimated cost of turnover by department.
Manager-level turnover isn't isolated
Exit data is aggregated by department, not by direct manager, so high turnover caused by a specific manager is invisible until the problem has already escalated.
DataMimi It groups exits by Manager and calculates per-manager voluntary turnover rate so high-attrition managers are visible in the data.
Common questions
How to track employee turnover: what formula should I use?
Voluntary Turnover Rate = (Voluntary Exits in Period ÷ Average Headcount in Period) × 100. Use average headcount (beginning + ending divided by 2) rather than ending headcount alone for more accurate results.
How much does it cost to replace an employee?
Estimates range from 50% of salary for entry-level roles to 200%+ for senior or specialized positions, when you include recruiting, onboarding, lost productivity, and training time. A 15% voluntary turnover rate at a company with $70K average salary can represent $1M+ in annual replacement cost.
What is a regrettable turnover rate?
Regrettable turnover counts only exits of employees you wanted to keep — high performers, critical role holders, tenured institutional knowledge. It's a better signal than total turnover because it filters out exits that were inevitable or intentional.
How do I track turnover by manager without embarrassing anyone?
Calculate manager-level turnover for internal HR use first, share it with department heads as part of a private talent review, and never publish raw manager rankings publicly. Use it to identify coaching needs, not to shame managers in all-hands meetings.
How much does Datamimi cost?
Free plan: $0/month, 40 credits, no credit card required. Lite: $9/month, 400 credits. Starter: $24/month, 1,500 credits, up to 3 simultaneous files. Pro: $59/month, 5,000 credits with rollover. Team: $199/month, 20,000 credits for 5 users.
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file