Kpiloom

Google Sheets HR Dashboard Templates

A hR dashboard tracks your people: hiring, attrition, attendance, training and pay in one place. Pick your industry below to see a live preview of the Google Sheets version.

Choose your industry

KPIs in every hR dashboard

KPIWhat it tells youFormula
HeadcountNumber of active employees at period end.COUNT of employees with status = Active
Attrition rateShare of employees who left in the period.Leavers ÷ Average headcount
Time to hireAverage days from job opening to offer accepted.AVERAGE of (Offer accepted − Opening date)
Open positionsRoles approved but not yet filled.COUNT of open requisitions
AbsenteeismShare of scheduled work time lost to unplanned absence.Days absent ÷ Scheduled working days
Training hoursTotal hours of learning completed.SUM of training hours logged
eNPSHow likely employees are to recommend you as a workplace.% Promoters − % Detractors
Avg salaryAverage monthly pay per employee.Total payroll ÷ Headcount