HR Dashboard Template | Impactful Identity
Free Template Excel & Google Sheets + Advanced Paid Version

Most HR dashboards
show numbers.
This one shows
what to do next.

Paste your HR data once and instantly see RAG status, decision triggers, industry benchmarks and 10 live KPIs — no analyst, no formulas to write.

Free or Paid · one-time · yours forever
10Live KPIs
296+Auto-formulas
1Data paste
30 minSetup time
Free foreverNo email req.
HR Dashboard — 10 live KPIs with RAG status, decision triggers and industry benchmarks
🎁 Free Starter Template

Not ready to commit?
Start here for free.

The free template gives you the full KPI dashboard and decision-trigger system so you can see exactly how it works — before trying the advanced version.

What’s included free

  • KPI Dashboard with RAG status (Red / Amber / Green) per metric
  • 10 core HR metrics — all auto-calculated
  • Decision trigger for every metric — what to do, not just what happened
  • 12-month Trend Tracker with data bars
  • Industry Benchmarks reference sheet
  • 296 working auto-formulas
  • Excel + Google Sheets compatible
  • Same single-paste setup as the full version
Download Free Template →

No email required · Instant download · Google Sheets & Excel

The free template shows you the dashboard and decision triggers. The full paid system adds Department Scorecards, Manager Scorecards, 12-Month Forecasting, Cost Calculator, and an auto-generated Executive Summary — all from one paste.

Free HR Dashboard — 5 sheets including Instructions, Data Input, Dashboard, Trend Tracker and Benchmarks
The Problem

You have the data.
But the room still goes quiet.

Most HR teams are drowning in metrics. Dashboards exist. Reports get sent. Decisions are still guesswork.

✗ Without this system
  • Turnover at 14% — but no idea which team or what to do about it
  • eNPS declining — no action attached, no owner assigned
  • Metrics everywhere with zero benchmarks for context
  • Hours building reports from scratch every month
  • Executive asks a question — you need a week to answer
✓ With this system
  • Every metric auto-flagged Red / Amber / Green against industry benchmark
  • Specific “what to do” action auto-detected for every flagged metric
  • 12-month trend shows patterns before they become crises
  • Monthly HR review done in under 5 minutes
  • Board-ready executive summary auto-generated from your data
Decision Triggers

Not just what happened.
Exactly what to do next.

Every metric comes with a pre-built decision trigger. Red fires an action. Amber sets a review date. Green confirms to hold the course — automatically.

🔴 Red — Act Now 🟡 Amber — Monitor 🟢 Green — On Track
HR Dashboard decision triggers — High Turnover Alert, Engagement Declining, Hiring Moving Well with specific next actions
What’s Inside

5 sheets free. 10 sheets paid.
One paste to run them all.

Each module answers a specific HR question your leadership needs answered — automatically, the moment you enter your data.

Included Free
📊
KPI Dashboard

10 core HR metrics with RAG status, industry benchmarks, decision triggers, and snapshot KPI cards — all auto-calculated from your input.

📥
Data Input Sheet

Enter monthly HR numbers in yellow cells only. 12 months of entry. Blue cells auto-calculate — no manual formulas needed.

📈
Trend Tracker

12-month view for all 10 metrics with data bars. Spot patterns early — before they become board-level problems.

🎯
Industry Benchmarks

Red / Amber / Green thresholds for every metric. No more guessing whether a 14% turnover rate is something to worry about.

📖
Setup Instructions

5-step walkthrough with colour-code guide. Up and running in 30 minutes. Same paste-and-go setup as the full version.

Paid — Full Decision System
🏢
Department Scorecard NEW

Every metric broken down by team. Composite dept score across 5 metrics. See which department needs action — not just the company average.

👤
Manager Scorecard NEW

Individual manager impact on team turnover, eNPS and goal achievement. Identifies high performers and flight-risk zones before they escalate.

🔮
12-Month Forecast NEW

Predictive trends with breach alerts before problems hit. Act before the crisis — not after the performance review.

💰
Cost Calculator NEW

Turnover and absence cost in dollars. Build the business case for HR investment instantly — with numbers leadership responds to.

📋
Executive Summary NEW

One-page board-ready report auto-generated from your data. Top 3 priorities, RAG snapshot, action plan. Walk into any meeting prepared.

How It Works

No APIs. No plugins.
No analyst required.

Open in Excel or Google Sheets. Enter your HR numbers into the yellow input cells. Every dashboard, trigger, and trend updates instantly.

01 Enter your data

Type your monthly HR numbers into the yellow Data Input sheet. 10 core metrics — turnover, eNPS, time to hire, cost per hire, absence, and more.

02 Everything updates instantly

All sheets recalculate the moment you enter data. RAG status, benchmarks, decision triggers and trend charts auto-populate — zero formulas to write.

03 Know exactly what to fix

Each Red metric shows a specific action. Amber sets a review task. Green confirms you’re on track. Walk into any meeting with clarity — not a wall of numbers.

Paid Feature · Executive Summary

Board-ready report.
Auto-generated from your data.

The paid version auto-generates a one-page People Performance Report — RAG snapshot, top 3 priorities, and action plan — the moment you paste your numbers.

Auto-generated People Performance Report — executive summary with RAG metrics, top 3 priorities and action items
Auto-generated

Pulls directly from your data. No copy-pasting. No formatting. Just paste and present.

🎯Top 3 priorities

Auto-identifies the three most urgent actions based on your RAG status this period.

📊Board-ready layout

Clean, professional one-pager. Print, share, or screenshot for your leadership deck.

🔄Updates monthly

Enter new data each month and the report regenerates automatically. Zero rework.

Free vs Full System

Free starter or
full decision system?

Both work with the same data input. The full system goes further — and costs less than one hour of HR consulting.

Free Version No email · Instant download
  • KPI Dashboard with RAG status
  • 10 core HR metrics — auto-calculated
  • Decision triggers for every metric
  • 12-month Trend Tracker
  • Industry Benchmarks reference
  • 296 working formulas
  • Department Scorecard
  • Manager Scorecard
  • 12-Month Forecast with breach alerts
  • Cost Impact Calculator
  • Executive Summary (board report)
Free Instant download · No strings Download Free →
Full System
  • Everything in the free version
  • Department Scorecard NEW
  • Manager Scorecard — team impact scores NEW
  • 12-Month Forecast with breach alerts NEW
  • Cost Calculator — turnover & absence in $ NEW
  • Executive Summary — board-ready report NEW
  • Composite dept score (5 metrics weighted)
  • 462 working formulas
  • One-time purchase · Lifetime updates
  • Excel + Google Sheets
One-time Anchored from higher price · Lifetime updates Get the Full System →
Free vs paid HR Dashboard — full feature comparison
Get the Full System

Stop guessing what to fix.
Start knowing.

One payment. Instant download. Works in Excel and Google Sheets.
No subscriptions, no setup calls, no analyst required.

Instant download Excel + Google Sheets One-time payment No setup required Lifetime updates 30-day guarantee
FAQ

Common questions

The free version includes the KPI Dashboard with RAG status, 10 core HR metrics, decision triggers, 12-month Trend Tracker, Industry Benchmarks, and 296 formulas. The paid full system adds Department Scorecard, Manager Scorecard, 12-Month Forecast with breach alerts, Cost Impact Calculator, and an auto-generated Executive Summary — plus 462 total formulas.
No. Enter your monthly HR numbers into the yellow input cells and everything updates automatically. If you can use Excel or Google Sheets, you can use this. Setup takes under 30 minutes the first time — then under 5 minutes each month.
Yes. Both the free and paid versions work in Microsoft Excel and Google Sheets. All formulas are compatible with both platforms.
The dashboard tracks 10 core HR metrics: Turnover Rate, Headcount, Absence Rate, eNPS Score, Goal Achievement Rate, Time to Hire, Cost per Hire, Satisfaction Score, Training Completion Rate, and Internal Promotion Rate. Each comes with an industry benchmark and decision trigger.
No. One payment, yours forever. No recurring fees, no account required, no lock-in. Lifetime updates included — whenever the template is improved, you get the new version free.
Yes. 30-day money-back guarantee. If you set it up and it doesn’t work for your HR setup, email for a full refund — no questions asked.

Scroll to Top