Two different questions
Budgeted headcount is what's been approved — the positions that exist in the org structure, each with an approved FTE and cost, whether or not anyone currently fills them. Actual headcount is who's actually on payroll right now, at what FTE, doing which job. These are two different questions, and most organizations can only answer one of them quickly.
The variance is the gap between the two — and it's where vacancies, overfilled positions, and unauthorized hires all show up. A department that's "on headcount" by simple employee count can still be over budget once every position's actual FTE is compared against what was approved.
Why the gap opens up
- Vacancies. A budgeted position with nobody in it — actual is lower than budgeted, but the cost is still allocated.
- Overfilled positions. More FTE assigned to a role than was approved for it — actual exceeds budgeted, often without anyone deciding that should happen.
- Positions filled outside the approved structure. A hire made against a role that either doesn't exist in the approved structure yet, or exists at a different FTE than what's actually being paid.
- Stale budget data. The budgeted side hasn't been updated to reflect a reorg, a role elimination, or a reclassification that happened months ago — so even the "budgeted" number in the spreadsheet isn't current.
Why this is hard to see in a spreadsheet
Budgeted headcount usually lives in a budget-planning workbook, built once a year during the budget cycle. Actual headcount lives in payroll or an HRIS export, updated whenever someone remembers to pull it. Reconciling the two means opening both, matching rows by position or department, and manually spotting the differences — a process that takes real time, so it happens rarely, usually only when Finance specifically asks for it.
By the time that reconciliation happens, the variance has often existed for months. The cost was real the whole time; it just wasn't visible until someone went looking for it.
If you want to do this reconciliation in a spreadsheet, we built a free headcount & salary budget template that matches budgeted positions to actual incumbents and calculates the variance for you — a much better starting point than two disconnected workbooks.
What continuous reconciliation looks like
The alternative is treating budgeted and actual as two live numbers on the same position, always visible side by side, rather than two separate documents reconciled periodically. That means:
- Every position shows its budgeted FTE/cost and its actual FTE/cost in one place, not two systems
- The variance is a calculated number, not a manual subtraction someone has to remember to do
- Positions with a variance — over or under — are flagged automatically, not discovered during a review
PowerPCS tracks budgeted and actual FTE/cost on every position continuously, so the variance is always current — not a project someone has to run before a budget meeting.