Free Budget vs Actual Variance Analysis — Instant Financial Comparison
Paste or upload a budget and actual spend side by side. Instantly see variance ($), variance (%), and a color-coded bar chart.
Last updated: January 2026
Budget vs Actual Variance Analyzer
Upload CSV or Excel file
or paste budget data below
What is budget variance analysis?
Budget variance analysis compares the amounts you planned to spend (budget) against what you actually spent. A positive variance on a revenue line means you outperformed — you brought in more than expected. A positive variance on an expense line means you overspent. Finance teams run this analysis monthly, quarterly, and annually to track performance against plan. It is one of the most common FP&A tasks and is the foundation of management reporting.
The tool calculates both the absolute dollar variance and the variance percentage, so you can see not just how much you were over or under but also the relative magnitude. A $5,000 variance on a $100,000 line item (5%) is very different from a $5,000 variance on a $10,000 line item (50%).
How to read the variance chart
The grouped bar chart shows each category side by side — the blue bar is your budget, the red bar is your actual. The table beneath the chart gives you the exact dollar and percentage variance for every row. Categories are colour-coded: green for under budget (favourable), red for over budget (unfavourable), and grey for on target. Sort the table by Variance % descending to find the items that deviated most from plan.
What input format does the tool accept?
The tool expects three columns: Category, Budget, and Actual. You can paste this data directly from Excel or Google Sheets — the tab-separated values copy across automatically. Alternatively, upload a .csv or .xlsx file. Dollar signs and commas are stripped during parsing, so formatted accounting values work without modification.
Exporting variance reports for management review
The Excel export includes the full variance table with conditional formatting — over-budget items are highlighted in red, under-budget items in green. The PDF export includes the chart and the table on a single page, with a totals row at the bottom showing the net variance across all categories. Both exports are generated in your browser and ready to attach to a management report.
Frequently asked questions
Can I analyse revenue variance as well as expense variance?
Yes. The tool works for any numeric comparison — revenue, headcount, units, or any other metric. Label your rows appropriately and the variance calculation applies the same way.
How do I handle categories that were not budgeted?
Enter 0 as the Budget value. The tool will show a 100% unfavourable variance, which accurately reflects unplanned spend.
What counts as On target?
Lines within +/-5% of budget are labelled On target. Lines more than 5% over are labelled Over budget and lines more than 5% under are labelled Under budget.
Can I compare more than two periods?
This tool compares one budget column against one actual column. For multi-period comparisons, use the Chart Builder tool and select multiple value columns.
Is there a limit on the number of line items?
No hard limit. The chart becomes harder to read beyond about 20 categories — for large budgets, consider grouping sub-categories before pasting.