Headcount Tracker Update
Updated headcount tracker. 1-page leadership summary with green/yellow/red flags per team. Distributed to CEO, CFO, CHRO, hiring managers. Risk meetings scheduled where applicable.
Before you start
- Approved hiring plan with budget per role
- ATS, HRIS, and finance systems integrated or accessible
- Headcount review cadence with leadership
- Hiring plan (approved roles per quarter)
- Open requisitions (in flight)
- Recent hires and departures
- Budget actuals
The steps
- Pull approved plan and current state — Gather: approved roles per team per quarter, current headcount per team, open reqs, in-progress offers, expected start dates, recent departures. Reconcile any mismatches between systems.
- Calculate headcount gap per team — For each team: planned headcount at end of quarter - current headcount + departures + offers in flight = gap. Positive gap = behind plan. Negative gap = ahead of plan or offers exceeding plan (flag).
- Calculate budget run-rate vs. plan — Pull actual compensation costs vs. budget. Factor in offers in flight and expected start dates. Identify any team running >10% over or under budget. Surface to finance for reconciliation.
- Update the headcount tracker — Update the central tracker (spreadsheet or BI dashboard): planned vs actual per team, time-to-fill per role, offers extended vs accepted, departures by reason. Maintain a single source of truth — multiple trackers = misalignment.
- Flag risks to leadership — Surface: roles open >60 days (delivery risk), teams under-hiring vs. plan (capacity risk), budget over-run, regrettable attrition spikes. Don't bury these in the tracker — call them out in a 1-page summary.
- Distribute to leadership and recruiter team — Send the tracker plus 1-page summary to: CEO, CFO, CHRO, hiring managers. Include the trend chart (last 4 quarters of plan vs actual). Schedule a 30-minute review if any flag is red.
If it goes wrong
Tracker drifts out of sync because multiple people update separately
Designate one source of truth and one owner. Other systems feed in via integration or scheduled pull. Manual edits in side spreadsheets are killed.
Leadership ignores the tracker because it's all green
Tracker should highlight changes and risks, not status quo. If everything is green every week, surface trend changes (deltas) instead.
Hiring managers dispute the planned headcount
Plan is approved by exec team — disputes go to exec, not recruiter. Recruiter holds the source of truth.
All OpenLabor playbooks