tracker template · Free download
HR Metrics Dashboard Template
An HR metrics dashboard template tracking headcount, turnover, time-to-hire, cost-per-hire, and engagement so you can report on people performance with real numbers.
Enter your details below to unlock the free PDF and CSV download.
Get your free download
Enter your details — the PDF downloads instantly.
What you get
- Core HR KPIs organised by theme with formulas
- A monthly tracking table for trend reporting
- Headcount, turnover, hiring, and engagement metrics
- Target and status columns to flag what needs attention
Template preview
A preview of the structure. Download the PDF or CSV for the complete, ready-to-use version.
Dashboard details
- Reporting period
- Prepared by
- Audience— leadership / board / team
- Last updated
Headcount & composition
Headcount metrics
| Metric | Formula | Current | Target | Status |
|---|---|---|---|---|
| Total headcount | Active employees at period end | |||
| Net change | Joiners − leavers | |||
| Manager-to-IC ratio | Managers ÷ individual contributors | |||
| Diversity mix | % by category (aggregate) |
Turnover & retention
Retention metrics
| Metric | Formula | Current | Target | Status |
|---|---|---|---|---|
| Turnover rate | Leavers ÷ avg headcount × 100 | |||
| Voluntary turnover | Voluntary leavers ÷ avg headcount × 100 | |||
| Regrettable turnover | Regretted leavers ÷ avg headcount × 100 | |||
| Average tenure | Sum of tenure ÷ headcount |
This is a preview — the full template continues in the download.
Enter your details above to download the full template.
How to use this template
- 1
Pick your core metrics
Start with headcount, turnover, time-to-hire, and one engagement measure rather than tracking everything.
- 2
Set targets
Add a target for each metric so the dashboard shows performance, not just raw numbers.
- 3
Update on a cadence
Refresh the monthly table on the same date each month so trends stay comparable.
- 4
Report the story
Use the status column to highlight what moved and why, not just the figures.
Frequently asked questions
Which HR metrics matter most?
Start with headcount, turnover (especially regrettable turnover), time-to-hire, and one engagement measure like eNPS. These four cover growth, retention, hiring, and sentiment without overwhelming the dashboard.
How do I calculate turnover rate?
Divide the number of leavers in the period by the average headcount, then multiply by 100. Track voluntary and regrettable turnover separately — losing high performers signals very different problems than backfilling planned exits.
How often should I update the dashboard?
Monthly is standard for most HR KPIs, refreshed on the same date each month so trends stay comparable. Engagement scores may update quarterly in line with your survey cadence.