Variance analysis
Reviewed by Jakob Schubert · Co-Founder, Basqo · 2026-11-03
Definition
Variance analysis compares actual results with planned values, measures the gap and identifies its causes. HR controlling and FP&A teams use it to explain why costs differ from the budget and what to do about it. For workforce costs, the gap is usually split into headcount, timing and pay effects, so that the cause is clear, not only the amount.
Formula
Variance = actual − plan (for costs, a positive result means spending above plan)
Key takeaways
- Variance analysis compares actual results with the plan, measures the gap and identifies its causes.
- Workforce cost variances can be split into headcount (volume), timing and pay effects.
- Example: a plan of 50,000 and actual costs of 56,000 give a variance of 6,000, or 12 % above plan.
- A budget vs actual comparison finds the gap; variance analysis explains why it happened.
How do you calculate a variance?
Subtract the planned value from the actual value, then express the difference as a share of the plan.
Example with illustrative numbers: a team plans 10 FTE (full-time equivalents) at 5,000 per month, so 50,000 in monthly workforce costs. The month closes at 56,000.
Item | Amount |
|---|---|
Plan | 50,000 |
Actual | 56,000 |
Variance | 6,000 (12 % above plan) |
The number alone does not say what to do. The next step is the cause.
What causes variances in workforce costs?
Headcount (volume): more or fewer FTE than planned, for example 11 FTE instead of 10. In the example, one extra FTE at 5,000 explains 5,000 of the variance.
Timing: hires or exits happening earlier or later than planned, which shifts costs between months.
Pay: salary changes, bonuses or other pay elements that differ from the plan. In the example, this explains the remaining 1,000.
Separating these causes matters because they call for different actions: a hiring decision, a correction of the plan or a pay review.
What is the difference between variance analysis and a budget vs actual comparison?
A budget vs actual comparison shows where actual values differ from the plan. Variance analysis goes one step further and explains why. In practice, the terms are often used together: the comparison finds the gap, the analysis finds the cause.
Why does variance analysis matter for HR controlling?
Workforce costs are usually one of the largest cost blocks, and they change through many small decisions: hires, exits, working hours and pay. Without a variance analysis, Finance sees a total that is off plan and has to ask HR for the reasons. With it, the review starts from the causes. Many Finance teams run the analysis each month, after the payroll actuals are in.
Common mistakes
- Looking only at the total and not at the split by cause.
- Comparing against an outdated plan instead of the approved version.
- Mixing planned and actual FTE definitions, so the headcount effect is wrong.
In Basqo
How to run variance analysis on workforce costs
In a spreadsheet, plan and actuals sit in different files, and every reconciliation starts with copying data. Basqo syncs the HRIS on an ongoing basis, brings in the payroll actuals each month for reconciliation and shows the variance analysis down to the single position, including the cost drivers. Monthly development by cost type and FTE shows whether a variance comes from people or from pay.
Parloa’s monthly reporting runs more than 75 % faster with Basqo (customer story). More on the process: why people teams need a month-end close.
Forecast & controlling in BasqoFrequently asked questions
Variance equals actual minus plan. For costs, a positive result means actual spending is above plan. Dividing the variance by the plan gives the deviation in percent.
The usual split is headcount, timing and pay. Headcount means more or fewer FTE than planned, timing means hires and exits on different dates than planned, and pay means salary or bonus changes.
Many Finance teams do it monthly, once the payroll actuals are available. The right rhythm depends on how often the plan is updated.
Related resources
Go deeper
News on workforce planning by email
Customer stories, benchmarks and articles straight to your inbox.