Next cohorts · Spreadsheet Fundamentals: Part 1 · Jan 11
Back to blog
GuidesApr 1, 2023Katie Fifer

Easily Track Headcount Changes

You will quickly be able to view how you are tracking by team for new hires, exits, and overall headcount, and how those changes compare to plan.

for HR professionals

To help you track headcount changes throughout the year, we have created an easy to update headcount tracking template. All you need to do is insert your census data and annual plan numbers, and a summary tab will automatically update with entries and exits by team, including table and chart views. You will quickly be able to view how you are tracking by team for new hires, exits, and overall headcount, and how those changes compare to plan.

Headcount Tracking Template (YouTube)

An easy, simple to use headcount tracking template

Our easy-to-use and update headcount tracking template includes two tabs -- an input tab and a summary tab. The input tab is where you insert your employee roster data. The summary tab includes:

  • YTD summary by team: actuals and vs. plan
  • Monthly summary of entries, exists, and total headcount by team: Actuals and vs. plan
  • Chart illustrating monthly changes by team

Quickly update the template in 5 steps:

StepsDetailed explanation
Upload census dataInput tab: Insert census data in yellow highlighted columns
Update start and end dates for analysisSummary tab: Enter desired starting month and ending month in cells D12 and D13
Insert YTD plan numbersSummary tab: Enter YTD Plan for entries and total headcount in Z22 - Z41 & Z72 - Z91 respectively
Regroup columns to reflect relevant date rangeSummary tab: Regroup columns M - X to reflect relevant date range
Refresh filter to only show relevant rowsSummary tab: Refresh filter in cell A19 by re-selecting "1" in the drop-down

Browse more articles.

Explore more tips, guides, and insights to sharpen your skills.