Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementHR Analytics & DashboardsHR Metrics Dashboard

SpreadsheetHR Analytics & DashboardsFree

HR Metrics Dashboard

Headcount, joiners, leavers, turnover and absence by month, with the year’s rates worked out.

Shown with sample data

Colour

HR Metrics Dashboard

Headcount, joiners, leavers, turnover and absence by month, with the year’s rates worked out.

Headcount now
89
Annualised turnover
26%
Voluntary share of leavers
87%
Absence rate
2.9%
Headcount at end of month
JanAug

Latest: 89

How to use it

  1. 1Enter one row per month.
  2. 2Split leavers into voluntary and involuntary.
  3. 3Use working days in the month for the absence rate.
  4. 4Comment on any month that stands out.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

The people numbers leadership asks for, in one sheet. Enter headcount at the start of each month, joiners, voluntary and involuntary leavers and days lost to absence; the sheet calculates monthly and annualised turnover, absence rate and net growth.

Who it’s for

  • Monthly HR reporting
  • Board packs
  • Benchmarking turnover against your sector

What’s included

  • Monthly sheet: One row per month.
  • By quarter sheet: Joiners and Voluntary leavers and Involuntary leavers and Absence days and the number of entries for each quarter.

How to use it

  1. 1Enter one row per month.
  2. 2Split leavers into voluntary and involuntary.
  3. 3Use working days in the month for the absence rate.
  4. 4Comment on any month that stands out.
Related searcheshr dashboardhr metricsemployee turnover rateheadcount reportpeople analytics

Details

Format
Spreadsheet
Category
HR Analytics & Dashboards
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetHR Analytics & DashboardsFree

HR Metrics Dashboard

Headcount, joiners, leavers, turnover and absence by month, with the year’s rates worked out.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
HR Analytics & Dashboards
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More hr analytics & dashboards templates

View all

Employee Engagement Survey

This survey is anonymous and takes about five minutes. Please answer honestly.

Department *

EngineeringSalesMarketing

How long have you worked here? *

Less than 1 year1 to 3 yearsMore than 3 years

I understand how my work contributes to the company’s goals *

Strongly agreeAgreeNeutral
Submit survey
FormHR Analytics & Dashboards

Employee Engagement Survey

Fifteen questions on purpose, manager, growth, workload and belonging, plus the eNPS question.

10 min setupPreview
Employee Turnover and Retention Analysis5 sheets

Current headcount

226

Annual turnover

21%

Voluntary turnover

17%

ABCD
1MonthNew hiresVoluntary leaversInvoluntary leavers
2Jan 2027631
3Feb 2027420
4Mar 2027841
5Apr 2027552
Monthly
SpreadsheetHR Analytics & Dashboards

Employee Turnover and Retention Analysis

Track monthly headcount, hires and leavers, and calculate voluntary, involuntary and annualised turnover and retention.

25 min setupPreview
Diversity and Inclusion Metrics Tracker2 sheets

Total headcount

310

Women overall

48%

Women in leadership

33%

Women representation by level
25%
36%
44%
43%
51%
ExecutiveSenior leadershipManagerSenior professionalProfessional
SpreadsheetHR Analytics & Dashboards

Diversity and Inclusion Metrics Tracker

Measure representation by level, compare hiring and promotion rates, and track progress against your DEI targets.

25 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ