Image 1 of 1
Image 1 of 1
Image 1 of 1
Image 1 of 1
Understanding why people leave is as important as knowing that they left. This template gives HR teams the data structure and analysis formulas to turn raw exit data into actionable insight.
Leaver log captures: employee ID, department, level, tenure, exit date, exit type, exit reason category, exit reason detail, whether the departure was regrettable, replacement need, and days to backfill. Analysis sheet automatically calculates: total leavers, overall/ voluntary/ involuntary/ regrettable turnover rates against headcount inputs, average tenure at exit, and exit reason breakdown with counts and percentages. Includes a horizontal bar chart of exit reasons.
FAQS
Q What data does the leaver log capture?
Employee ID, department, level, tenure in months, exit date, exit type (voluntary/involuntary/retirement/end of contract), exit reason category, exit reason detail, whether the departure was regrettable, whether replacement is needed, whether the replacement has been hired, days to backfill, and notes. The exit reason categories are predefined and map directly to the analysis sheet.
Q What does the analysis sheet calculate automatically?
Total leavers, overall turnover rate, voluntary turnover rate, involuntary turnover rate, regrettable turnover rate, and average tenure at exit — all calculated as formulas against the headcount inputs you enter. Exit reason breakdown by category with counts and percentages. All metrics update automatically when new leaver data is entered in the log.
Q What turnover rates are considered normal?
Benchmarks vary by industry and role type. The analysis sheet includes benchmark references: overall annual turnover of 10–15% is broadly normal across industries; above 20% is typically a signal of structural issues. Regrettable turnover above 8% is a common intervention trigger. The dashboard flags whether each metric is within, below, or above benchmark based on the inputs.
Q Can this template track trends over time?
Yes. The leaver log captures all leavers in a rolling format — you add new rows as people leave and the analysis sheet recalculates. For year-over-year trend analysis, the recommended approach is to archive the annual log and start a fresh one at the beginning of each year, comparing annual summary metrics across files.
Understanding why people leave is as important as knowing that they left. This template gives HR teams the data structure and analysis formulas to turn raw exit data into actionable insight.
Leaver log captures: employee ID, department, level, tenure, exit date, exit type, exit reason category, exit reason detail, whether the departure was regrettable, replacement need, and days to backfill. Analysis sheet automatically calculates: total leavers, overall/ voluntary/ involuntary/ regrettable turnover rates against headcount inputs, average tenure at exit, and exit reason breakdown with counts and percentages. Includes a horizontal bar chart of exit reasons.
FAQS
Q What data does the leaver log capture?
Employee ID, department, level, tenure in months, exit date, exit type (voluntary/involuntary/retirement/end of contract), exit reason category, exit reason detail, whether the departure was regrettable, whether replacement is needed, whether the replacement has been hired, days to backfill, and notes. The exit reason categories are predefined and map directly to the analysis sheet.
Q What does the analysis sheet calculate automatically?
Total leavers, overall turnover rate, voluntary turnover rate, involuntary turnover rate, regrettable turnover rate, and average tenure at exit — all calculated as formulas against the headcount inputs you enter. Exit reason breakdown by category with counts and percentages. All metrics update automatically when new leaver data is entered in the log.
Q What turnover rates are considered normal?
Benchmarks vary by industry and role type. The analysis sheet includes benchmark references: overall annual turnover of 10–15% is broadly normal across industries; above 20% is typically a signal of structural issues. Regrettable turnover above 8% is a common intervention trigger. The dashboard flags whether each metric is within, below, or above benchmark based on the inputs.
Q Can this template track trends over time?
Yes. The leaver log captures all leavers in a rolling format — you add new rows as people leave and the analysis sheet recalculates. For year-over-year trend analysis, the recommended approach is to archive the annual log and start a fresh one at the beginning of each year, comparing annual summary metrics across files.
