Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementHR Analytics & DashboardsEmployee Turnover and Retention Analysis

SpreadsheetHR Analytics & DashboardsFree

Employee Turnover and Retention Analysis

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

Shown with sample data

Colour

Employee Turnover and Retention Analysis

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

Current headcount
226
Annual turnover
21%
Leavers ÷ average headcount, annualised
Voluntary turnover
17%
Involuntary turnover
4.1%
Retention rate
78%
Approx. share of opening headcount retained
Leavers logged
11
Regretted losses
6
Early leavers (under 1 year)
27%
Annualised turnover year to date
Jan 2027Dec 2027

Latest: 20.9%

Leavers each month
  • Jan 20274
  • Feb 20272
  • Mar 20275
  • Apr 20277
  • May 20272
  • Jun 20277
  • Jul 20274
  • Aug 20274
  • Sep 20274
  • Oct 20273
  • Nov 20272
  • Dec 20272
Leavers by reason
  • Better pay elsewhere2
  • Career progression2
  • Workload or stress2
  • Manager relationship1
  • Relocation1
  • Performance1
  • Redundancy1
  • Retirement1

How to use it

  1. 1Enter your opening headcount on the Settings sheet.
  2. 2Each month, type new hires and voluntary and involuntary leavers on the Monthly sheet; headcount and turnover rates calculate.
  3. 3Log every leaver on the Leavers sheet with department, reason, tenure and whether the loss was regretted.
  4. 4Enter current headcount by department on the By department sheet to compare turnover rates across teams.

In this workbook

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

About this template

See how many people are leaving, why, and where. Enter monthly hires and voluntary and involuntary leavers; the analysis rolls headcount forward, calculates monthly and annualised turnover, splits voluntary from involuntary, and computes retention. A leavers log breaks turnover down by department, reason, tenure and regretted loss, so you know where to act.

Who it’s for

  • Monthly and quarterly HR reporting to leadership
  • Spotting departments or tenure bands with high attrition
  • Building the case for retention investment

What’s included

  • Monthly sheet: Hires and leavers each month, with headcount and turnover calculated.
  • Leavers sheet: One row per leaver.
  • By department sheet: Leavers and turnover rate by department for the period logged.
  • By reason sheet: The number of entries for each reason.
  • Settings sheet: Headcount at the start of the year.

How to use it

  1. 1Enter your opening headcount on the Settings sheet.
  2. 2Each month, type new hires and voluntary and involuntary leavers on the Monthly sheet; headcount and turnover rates calculate.
  3. 3Log every leaver on the Leavers sheet with department, reason, tenure and whether the loss was regretted.
  4. 4Enter current headcount by department on the By department sheet to compare turnover rates across teams.

Tips

  • Report voluntary turnover separately: it is the part you can most influence.
  • Watch early turnover (leavers in their first year); it usually points to hiring or onboarding problems.
  • Compare annualised figures, not single months, because small teams swing wildly month to month.

Questions

How do you calculate employee turnover rate?

Leavers in the period ÷ average headcount in the period × 100. Average headcount is usually (start + end) ÷ 2.

How do you annualise turnover?

Divide total leavers so far this year by the average headcount so far, then multiply by 12 ÷ the number of months elapsed.

What is a good turnover rate?

It depends heavily on industry: many professional services firms see 10–15% a year, while retail and hospitality can exceed 50%. Compare yourself with your own history and sector benchmarks.

What is the difference between turnover and retention?

Turnover measures the share of people who left; retention measures the share who stayed. They are related but not exact opposites when you hire during the year.

Related searchesemployee turnover calculatorturnover rate spreadsheetattrition analysisemployee retention rateannualized turnover ratevoluntary turnover

Details

Format
Spreadsheet
Category
HR Analytics & Dashboards
Sheets
5
Setup
25 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetHR Analytics & DashboardsFree

Employee Turnover and Retention Analysis

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

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
5
Setup
25 min
Level
Intermediate
Price
Free

Your copy is private to you.

More hr analytics & dashboards templates

View all
HR Metrics Dashboard2 sheets

Headcount now

89

Annualised turnover

26%

Voluntary share of leavers

87%

Headcount at end of month
SpreadsheetHR Analytics & Dashboards

HR Metrics Dashboard

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

10 min setupPreview

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
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