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.
Download the files
Sign in with Google and both the PDF and the CSV unlock immediately. We email you the links too.
Get your free download
Sign in with Google to unlock the PDF and CSV instantly. No form to fill in.
Free. By continuing you agree to our terms and privacy policy. We record your email and this download; marketing emails only if you tick the box.
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
The structure, not the finished file. The PDF and CSV carry the complete 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 |
The preview stops here; the template continues in the download.
How to use this template
- Pick your core metrics. Start with headcount, turnover, time-to-hire, and one engagement measure rather than tracking everything.
- Set targets. Add a target for each metric so the dashboard shows performance, not just raw numbers.
- Update on a cadence. Refresh the monthly table on the same date each month so trends stay comparable.
- 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.