How to analyze headcount costs

How to analyze headcount costs: compare payroll expense with the approved budget using average staffing and recurring cost per full-time equivalent, or FTE. Then inspect hiring dates and one-time charges to explain the difference. Ending headcount alone cannot explain a month of expense.

Start with comparable payroll and budget exports

Use one month and the same departments in both files. Keep the approved budget fixed; a revised hiring expectation belongs in the forecast alongside the budget.

Gather a payroll summary with department, service period, gross wages, employer taxes, benefits, and separately identified unusual charges. Add a staffing schedule with department, FTE allocation, start date, and departure date. Department totals are enough for the first pass; use restricted employee detail only to resolve differences.

Use gross wages rather than take-home pay. Employee withholding is already part of wages; adding it again duplicates expense. The IRS employer tax guide explains that withheld income taxes and employees' Social Security and Medicare taxes are wages paid to the Treasury instead of employees. Employer taxes are a separate employer cost.

State whether contractors, commissions, equity compensation, and recruiting fees are included. Apply that scope to actuals and budget. Keep cash payments separate from expense: payroll earned in the month can be paid later.

Measure staffing over the whole period

Count each position according to the portion of the month employed and its contractual FTE allocation. Use the same calendar-day or workday convention in budget and actuals; do not switch between them.

For a simple half-month example, Engineering has 19 full-time employees throughout the month and one new full-time employee for half the month. Its average staffing is 19 + 0.5 = 19.5 FTE, even though ending headcount is 20. The timing explains why a fully staffed month will cost more next month without another hire.

Retain the actual payroll calendar alongside this schedule. The SBA's payroll setup guidance includes scheduling pay periods, setting compensation for leave, and maintaining records. Those records help explain differences that a department total conceals.

Build the departmental bridge

This illustrative US business separates recurring compensation from a signing bonus. All amounts are USD; FTE values are exact and dollar results below are unrounded.

Set up columns A:E with these headers in row 1 and inputs in rows 2:4. Budget recurring cost per FTE includes the same wages, employer taxes, and benefits as actual recurring cost.

Add columns F:K: actual recurring cost per FTE, budget recurring cost, staffing effect, rate-and-mix effect, total recurring variance, and reconciliation check. Enter these formulas in row 2 and fill down through row 4:

F2 =IF(D2=0,NA(),E2/D2)
G2 =B2*C2
H2 =(D2-B2)*C2
I2 =E2-D2*C2
J2 =E2-G2
K2 =J2-H2-I2

Positive cost variances are unfavorable; negative ones are favorable on expense alone. Staffing is valued at budget rates. The residual measures actual recurring cost above or below actual staffing at budget rates. It includes compensation rates and workforce mix, not necessarily raises.

For totals in row 5, sum E and G:K; do not sum or average departmental cost-per-FTE rates. Zero actual FTE makes F undefined and needs investigation if expense remains. The bridge still exposes that expense through column I.

Prove the total, then identify the decision

The recurring bridge is exact:

Actual recurring cost = Budget recurring cost + Staffing effect + Rate-and-mix effect

395,150 = 384,000 + 0 + 11,150

Suppose a separately identified signing bonus is $12,000 actual against zero budget. Total expense becomes $407,150, and total variance is $23,150: $11,150 recurring plus $12,000 one-time. Tie those amounts to the included ledger accounts before explaining them.

Equal total FTE does not mean departments followed their staffing plans. Sales added capacity while Engineering and Operations carried vacancies. Review approved positions and start dates with each department owner. Then check the rate-and-mix residual against pay changes, grades, overtime, and benefits. The wider variance analysis method uses the same requirement: the parts add back to the total.

FP&A owns the reconciliation; HR validates staffing dates and compensation assumptions; managers explain staffing decisions. The FP&A role connects those findings to the next forecast. A vacancy saving may need a delivery-risk explanation before anyone calls it good performance.

Where headcount cost analysis goes wrong

• Ending headcount as the expense denominator. It assigns a full month's staffing to late hires.
• Net pay plus withholding. Use gross wages once, then add employer costs within scope.
• One-time costs inside recurring rates. A signing bonus can look like a permanent compensation increase.
• Department transfers treated as hires. Align effective dates so one person is not counted twice.
• An unexplained residual labeled raises. Rates, seniority mix, taxes, and benefits need separate evidence.

Analyze your own payroll summary in Covirage

Upload your departmental payroll summary and budget to Covirage. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for finance teams for the supporting industry context.