770-410-1219
Every month you send leadership a spreadsheet with forty numbers on it, and every month nobody asks a question. That is the usual sign that an HR report is measuring HR's activity instead of something the business is trying to decide. A well-built HR dashboard and a short HR scorecard fix this by doing two different jobs: one tells you what is happening in the workforce right now, the other tells leadership whether HR's strategy is working.
This guide explains the difference, gives the formulas for core metrics with worked examples, shows a sample scorecard, and walks through building both.
HR Dashboard vs. HR Scorecard
The terms are often used interchangeably. They are not the same tool.
| Dimension | HR dashboard | HR scorecard |
|---|---|---|
| Purpose | Monitor operations | Track progress against strategic goals |
| Question answered | What is happening? | Are we achieving what we said we would? |
| Content | Current values and trends for operational metrics | A small set of measures, each with a target and an owner, tied to a strategic objective |
| Refresh | Weekly or monthly, often live from the HRIS | Quarterly, with an annual reset |
| Audience | HR team and line managers | Executive team, sometimes the board |
| Typical length | One or two screens, 10 to 15 metrics | One page, 8 to 12 measures |
The scorecard idea comes from the balanced scorecard, introduced by Robert Kaplan and David Norton. It groups measures into financial, customer, internal process, and learning and growth perspectives so that no single view dominates. Brian Becker, Mark Huselid, and Dave Ulrich later adapted the approach for the HR function in The HR Scorecard. You do not need to adopt either framework wholesale. The useful principle is that every measure on a scorecard should trace back to a business objective.
Most HR departments need both. Build the dashboard first, because the scorecard draws on the same data.
The Core Metrics and Their Formulas
Definitions vary between organizations and vendors, so write yours down and keep them constant. All numbers in the examples below are invented for illustration.
Turnover rate
Formula: separations during the period ÷ average number of employees during the period × 100
This matches how the U.S. Bureau of Labor Statistics computes rates in its Job Openings and Labor Turnover Survey (JOLTS): the separations rate is the number of separations divided by employment, multiplied by 100. BLS counts total separations as quits, layoffs and discharges, and other separations such as retirements, transfers to other locations, deaths, and separations due to disability.
Example: A company has 400 employees on January 1 and 420 on December 31, so average headcount is (400 + 420) ÷ 2 = 410. During the year, 62 employees leave.
Annual turnover rate = 62 ÷ 410 × 100 = 15.1%
A more accurate average uses the headcount at the end of each of the 12 months. Whichever method you choose, use it every period.
Voluntary turnover rate
Formula: voluntary separations ÷ average number of employees × 100
BLS defines quits as employees who left voluntarily, with retirements and transfers counted separately under other separations. Decide whether your own figure includes retirements, and label it.
Example: Of the 62 separations, 45 were resignations. 45 ÷ 410 × 100 = 11.0%.
Report this separately from involuntary turnover. A single blended number hides whether people are choosing to leave or being managed out.
First-year retention rate
Formula: new hires still employed 12 months after their start date ÷ new hires in the cohort × 100
Example: 40 people were hired in the first quarter of last year; 33 are still employed at their one-year mark. 33 ÷ 40 × 100 = 82.5%.
Time to fill
Formula: total days from requisition approval to offer acceptance, across all filled positions ÷ number of positions filled
Example: Five positions took 30, 42, 28, 55, and 45 days. Total 200 ÷ 5 = 40 days.
Some organizations start the clock at job posting and stop it at the start date. Time to hire, a related metric, usually runs from the candidate's application to acceptance. Pick start and end points, document them, and do not compare against outside figures that use different ones.
Cost per hire
Formula: (external recruiting costs + internal recruiting costs) ÷ total number of hires in the period
This is the formula set out in the ANSI/SHRM Cost-per-Hire standard (ANSI/SHRM 06001.2012). Check the current standard and its status before relying on it.
Example: $78,000 external + $122,000 internal = $200,000. With 50 hires, cost per hire = $4,000.
The cost categories, and the difference between the standard's internal and comparable versions of the metric, are covered in our article on finance for HR.
Offer acceptance rate
Formula: offers accepted ÷ offers extended × 100
Example: 27 accepted of 36 extended = 75%.
Internal fill rate
Formula: positions filled by internal candidates ÷ total positions filled × 100
Example: 12 of 30 = 40%.
Unplanned absence rate
Formula: unplanned absence days ÷ total scheduled workdays × 100
Example: 150 employees × 21 scheduled workdays = 3,150 available days. With 95 unplanned absence days, the rate is 95 ÷ 3,150 × 100 = 3.0%.
Be careful with this metric. Report it only in aggregate, and never use protected leave such as FMLA absences as a negative mark against an individual or a manager's team.
Training completion and hours
Formulas: employees who completed required training ÷ employees required to complete it × 100; total training hours ÷ average number of employees
These are activity measures. Keep them on the dashboard for compliance tracking, and leave them off the scorecard unless they are paired with an outcome.
Working through calculations like these on real cases is part of the data, metrics, and analytics module in the Strategic HR Leadership Certificate Program, which includes an exercise on determining total recruiting expense.
For a wider list, see 15 HR Metrics and KPIs Every HR Department Should Track, and for definitions, the Glossary of Terms for HR Metrics.
A Sample HR Scorecard
The scorecard below is an example for a fictional company whose business goals are to grow revenue, protect margin, and open a second site. Targets and results are illustrative.
| Perspective | Strategic objective | Measure | Baseline | Target | Current | Status | Owner |
|---|---|---|---|---|---|---|---|
| Financial | Control the cost of staffing growth | Cost per hire | $4,600 | $4,000 | $4,000 | On target | Talent acquisition lead |
| Financial | Reduce avoidable turnover cost | Voluntary turnover rate, customer service | 24% | 18% | 21% | Behind | HR business partner |
| Customer (internal) | Staff the new site on schedule | Share of site roles filled by opening date | n/a | 95% | 80% | At risk | HR director |
| Internal process | Hire faster for critical roles | Time to fill, critical roles | 58 days | 45 days | 40 days | Ahead | Talent acquisition lead |
| Internal process | Keep new hires through year one | First-year retention | 76% | 85% | 82.5% | Behind, improving | HR manager |
| Learning and growth | Build leadership bench | Critical roles with a ready-now successor | 30% | 50% | 45% | Behind, improving | HR director |
| Learning and growth | Grow from within | Internal fill rate, supervisor roles | 25% | 40% | 40% | On target | HR manager |
Seven measures, each with a business reason to exist, a target, and a named owner. An executive can read it in two minutes and knows which two rows to ask about.
How to Build an HR Dashboard and Scorecard
- Start from the business plan, not the HRIS. List the organization's three to five goals and the workforce question each one raises. This is the same first step as writing the HR strategic plan template, and the scorecard should be that plan's measurement page. See also Aligning HR Strategy With Business Goals.
- Choose a small number of measures. For each objective, pick the one or two measures that would tell you whether it is being met. If a measure would not change a decision, drop it.
- Write a definition sheet. For every metric, record the formula, what is included and excluded, the data source, the refresh frequency, and the owner. This single page prevents most arguments about the numbers.
- Check the data. Reconcile headcount with payroll and finance before you publish anything. One mismatch with the CFO's number will cost you the room.
- Set a baseline, then a target. Use at least several periods of your own history. External benchmarks are useful for context only when they use the same definition, industry, and size band. BLS publishes separations and quits rates by industry through JOLTS, and our page on HR Metrics, Benchmarking and Goal Setting covers how to use benchmarks sensibly.
- Design for the reader. Put the most important measure top left. Show trend lines rather than single values. Use color only for status. Add one line of commentary per measure: what changed, why, and what you are doing about it.
- Segment, carefully. Company-wide averages hide problems. Break key measures out by department, location, tenure band, and manager. Protect privacy by suppressing small groups, and if you segment by demographic categories, restrict access and involve counsel in how the analysis is used.
Most HRIS platforms include dashboard tools, and a spreadsheet is adequate for a scorecard. The Role of HR Technology in Operations discusses system options. The tool matters far less than the choice of measures.
Leading and Lagging Indicators
Turnover is a lagging indicator: by the time it moves, the people are gone. A useful dashboard pairs each lagging measure with a leading one that moves earlier.
| Lagging measure | Possible leading measures |
|---|---|
| Voluntary turnover | Engagement or stay-interview themes, internal transfer requests, time since last pay or role change |
| First-year retention | 30-, 60-, and 90-day check-in completion, onboarding survey results |
| Time to fill | Qualified applicants per opening, days at each hiring stage |
| Bench strength | Development plan completion for identified successors |
Common Mistakes
- Too many metrics. Forty numbers is a data dump.
- Activity in place of outcome. "Trainings delivered" tells leadership nothing about capability.
- No targets. A number without a target cannot be good or bad.
- Changing definitions. If the formula changes, restate the history or mark the break.
- Averages only. A 15% company turnover rate can conceal 40% in one department.
- No narrative. Data without interpretation invites the reader to supply their own.
- Benchmark chasing. A benchmark built on a different definition is noise.
For more on turning numbers into decisions, read Using HR Metrics and Analytics Effectively.
Frequently Asked Questions
What is an HR dashboard?
An HR dashboard is a visual summary of current workforce metrics, such as headcount, turnover, time to fill, and absence, usually refreshed weekly or monthly. It is an operational monitoring tool for HR and line managers.
What is an HR scorecard?
An HR scorecard is a short set of measures, each linked to a strategic objective and given a target and an owner. It shows whether HR's strategy is delivering what the business needs and is typically reviewed quarterly with executives.
What is the difference between an HR dashboard and an HR scorecard?
A dashboard reports what is happening. A scorecard reports progress against goals. The dashboard is broader and more frequent; the scorecard is narrower and tied to strategy.
What metrics should be on an HR dashboard?
Start with headcount, turnover (total and voluntary), first-year retention, time to fill, cost per hire, offer acceptance rate, internal fill rate, and absence rate. Add measures specific to your business goals, and remove any that nobody acts on.
How do you calculate turnover rate?
Divide the number of separations in the period by the average number of employees in the period and multiply by 100. For example, 62 separations with an average headcount of 410 is a 15.1% turnover rate.
How many metrics should an HR scorecard have?
Enough to cover each strategic objective and few enough to read on one page. Eight to twelve is a practical range for most organizations.
The Bottom Line
A dashboard keeps HR informed. A scorecard keeps HR accountable to the business plan, and it is the document that changes how executives see the function. Build both from a short list of clearly defined measures, reconcile the data with finance, attach targets and owners, and add a sentence of interpretation to every number. When a measure shows a problem worth funding, the next step is presenting an HR business case to executives.
The Strategic HR Leadership Guide links to the related articles on planning and finance. If you would rather learn this with an instructor, the Strategic HR Leadership Certificate Program devotes a module to data, metrics, and analytics, covering the distinction between measures, metrics, and analytics and an exercise on choosing key metrics to demonstrate HR impact. The two-day program is offered in person and by video conference and carries 12 SHRM and HRCI recertification credits.
