Budget Variance Chart Template
A budget variance waterfall shows how actual spending differed from plan — category by category, building to the total over or underspend. FP&A teams use it in monthly business reviews and board reporting to explain why results landed where they did.
Sample data
Copy this into the editor to get started. Replace the labels and values with your own numbers.
| Category | Variance ($K) |
|---|---|
| Budget | 2400 |
| Marketing | 120 |
| Headcount | -180 |
| Software & Tools | -45 |
| Travel & Events | 60 |
| Facilities | -30 |
| Actuals | 2325 |
How to read it
The budget and actuals bars sit on the baseline. Each bar in between shows one category's variance — positive means you spent more than planned, negative means you came in under. The chart makes it immediately clear which categories drove the overall variance without needing to read a table.
When to use it
Monthly finance reviews
Show the CFO and department heads exactly where spending landed vs plan and why. Turns a variance table into a story that's readable in seconds.
Board reporting
Boards want to know if the company is spending to plan. A variance waterfall answers that in one chart — they can see the total variance and its drivers without reconciling line items.
Department budget conversations
When a department head needs to explain their cost performance, this chart lets them show exactly which decisions drove the variance rather than defending a single number.