You will not be allowed to compare more than 4 products at a time
View compare
Interactive Tool
Variance Analysis Tool
Compare budget to actual across any set of line items, identify what drove the difference, and understand what the numbers are telling you.
For educational and illustrative purposes only. All inputs, calculations, and outputs are your responsibility. This tool does not validate your accounting classifications or check figures against source systems. Consult your Finance team before presenting variance analysis to stakeholders. Benchmarks or interpretations shown are illustrative only.
The tool is pre-loaded with an illustrative Marketing Department budget example to show how it works. Clear the example using the "Clear all" button and enter your own line items, or edit the existing ones directly. You can rename any line item, change whether it is a revenue or cost item, add rows, and remove rows — the analysis updates instantly.
Variance Analysis
Enter budget and actual figures for each line item — favorable / unfavorable is calculated automatically
| Line Item | Type | Budget ($) | Actual ($) | Variance ($) | Variance (%) | F / U | |
|---|---|---|---|---|---|---|---|
| Total | |||||||
Total Budget
—
all line items
Total Actual
—
all line items
Net Variance $
—
vs budget
Net Variance %
—
vs budget
Variance Waterfall — What drove the difference?
Each bar shows one line item's contribution to the total variance. Green = favorable, terracotta = unfavorable.
Enter budget and actual figures above to see the waterfall chart
Detailed Variance Breakdown
Volume variance (did we do more or less?) vs. rate/price variance (did each unit cost more or less?) — enter volume inputs below to split the variance
Line Item
Budget
Actual
Total Variance
F / U
The volume/rate variance split requires volume data (e.g. units produced, headcount, campaign impressions) which varies by business context. The table above shows the total variance for each line item. To decompose further, work with your Finance team who will have the underlying volume and rate assumptions from the original budget.
What the numbers are saying
Enter your figures above to generate an interpretation of the variance pattern.