Human Resources KPI Scorecard

Human Resources KPI Scorecard Template using typical HR KPIs and excel gauge charts. In this tutorial, we will use four essential groups of performance indicators in the area of HR: Employee turnover, Recruiting, Retention finally, and Training & Development.

What is the key role of HR in a company?

Medium and large enterprises today are inconceivable without a Human Resources department. HR is responsible for recruitment, handling employees’ records, and payroll.

Follow up the performance and ensure that employees receive the necessary training for their development.

The dashboard shows the differences between targets and goals to track the company’s activities and the employees.

HR Template – A Closer Look

Let’s take a closer look at the figure below. We will use people graphs to build a dashboard template and manage your HR-related decisions! We created a gauger section to display eye-catching visualization for the main KPIs.

human resource KPI dashboard in Excel

Check the formulas to see how they work! How to calculate the sub-KPIs? Choose your KPI so you will know the value of sub-KPIs.

You can fill the column ‘Weight‘ with values between 1 and 10 according to the displayed value’s importance. If the value is equal to 1, it represents the least important value in the company.

10 is the most important in the given field.

We have summed up weights; the “Employee Turnover” summarizing field on the figure is the sum of the column’s subcategories; Cost per Hire, Turnover Cast, Turnover Rate, and Time to Fill.

kpi calculation for hr metrics

We have made a short description of a key performance indicator in the column Description, so those unfamiliar with this field can also use the hr analytics template.

In column Performance, you will see the sub-KPI’s value that we track in a percentage format.

The question arises: How to calculate the 54% rate in the Total Performance line (Employee turnover group)? We mentioned at the article’s beginning that this is a group performance indicator.

The calculation is as follows:

=(3*30% + 2*70% + 3*80% + 3*4%) / 7 = 54%

And with this, we are done with the calculation part of the human resource KPI scorecard. And now we only have to do is to create the design. So, finally, let’s summarize the phrases used in making the dashboard.

Human Resources KPI Scorecard – Indicators

Employee Turnover

Cost per Hire: The sum of advertising and marketing fees, employee referrals, relocation expenses, recruiter salary, and other expenses incurred until hiring, divided by the total number of hires.

Turnover Cost: It refers to the cost of replacing an employee who leaves the company. The costs of recruiting a new employee include hidden expenses like the time it takes to train the newcomer to the same productivity level.

Turnover Rate: The primary formula for turnover rate percentage is the number of separations divided by the average number of employees in the given month. Partitions include employees who quit, are dismissed, move to another business, or retire.

Time to Fill: One crucial element in measuring the recruiting function’s efficiency and effectiveness is measuring the time it takes to fill a vacancy. In order words, it means the number of days between publishing a job post and receiving a signed employment contract.

Recruiting

Vacant Period: Number of overall days the positions were vacant
New Hires Performance Appraisal: Average performance appraisal of new hires, in comparison to the previous period

New Hires Performance Appraisal: Evaluation of new employees’ average performance. Newcomers are usually evaluated before the probation period so that the employer can decide whether they want to extend the contract with the employee or terminate the employment.

Turnover Rates of New Hires is the ratio of total turnovers among employees hired in the last 12 months to the total number of employees engaged in the previous 12 months.

Financial Impact of Bad Hire: A bad hire can negatively impact a company from many aspects. On the one hand, the company pays an employee’s salary, benefits, and hiring costs that do not meet expectations. But, on the other hand, when this employee leaves the company, they most likely need to hire a new one, which costs additional hiring.

Retention

Preventable Turnover: This indicator refers to the rate of those turnovers that could have been evaded with better management, expressing expectations more clearly during the hiring process, or creating an appealing workplace atmosphere. (When the reasons why the employee leaves are out of the company’s control, we talk about Non-Preventable Turnover.)

Diversity Turnover: This metric describes the turnover rate in a given group of employees (based on gender, race, or age distinction) compared to the number of all turnovers in the company.

Financial Impact of Employee Turnover

Learning and Growth Opportunities: This metric shows the percentage of employees satisfied with the learning and training opportunities and the career prospects provided by the company.

Job Satisfaction: This indicator shows the average satisfaction of the employees of the company. So, there are many different approaches to measure employee satisfaction with varying questions and weights. The most common aspects are communication with managers, cooperation with colleagues, working conditions, salary, and benefits.

Conclusion

As you can see, using our Human Resources KPI Scorecard, one can easily present a fancy, appealing insight into the most important and generally used HR measurements. Finally, You are free to change the weight and the percentage of any indicators. Likewise, the gauges and the people bar charts will adjust accordingly.

Our template is free as always.

Download the Human Resources KPI Scorecard in Excel!