Budget Variance Calculator
Paste budget and actual figures by line item to get dollar variance, percentage deviation, and a severity flag on every row. Sorts the biggest drivers to the top so you know what to investigate first.
How do I calculate budget variance?
Subtract budget from actual to get the dollar variance, then divide that variance by the budget to get the percentage. A line budgeted at $50,000 that came in at $58,000 has a variance of $8,000, or 16% over. For expense lines, actual above budget is unfavourable; for revenue lines the direction reverses, which is the single most common error in hand-built variance reports: a favourable revenue variance and an unfavourable cost variance have the same arithmetic sign.
How to use this tool
- 1
Paste your lines
One line item per row with its budget and actual figures: straight from your P&L export.
- 2
Set your materiality threshold
Choose the percentage above which a variance is worth investigating, so small noise stops competing for attention.
- 3
Work the ranked list
Variances are sorted by dollar impact and flagged by severity, so the biggest drivers surface first.
A variance is not a root cause
The calculation tells you a number moved. It does not tell you why, and the gap between those two things is where most of the month-end time goes.
Volume vs rate
A cost overrun because you bought more units is a different business problem from the same overrun because the price per unit rose. Decomposing variance into volume and rate components is what turns a number into a decision.
Timing vs structural
An invoice that landed in March instead of February creates a variance in both months and means nothing. A vendor that raised prices creates a variance that repeats forever. Treating the first like the second wastes a meeting; treating the second like the first costs money every month.
Mix effects
Total revenue can hit budget exactly while the underlying mix shifts from high-margin to low-margin products. The revenue variance reads as zero and gross margin quietly deteriorates. Mix is invisible at the summary line by construction.
Offsetting variances
Two large variances in opposite directions net to a small one at the department level, and the summary report shows nothing worth investigating. Rolling up before flagging is how real problems get hidden by arithmetic.
Budget quality
A variance measures the distance from a forecast, and forecasts are not equally good. A line that was estimated casually will show variance every month without indicating anything about operational performance.
The follow-up question this cannot answer
This tool ranks your variances. The next question (why did this one happen, is it going to repeat, and what do we do about it) needs the transactions underneath the line, joined to vendors, headcount changes, contract terms, and what happened in the same month last year. That investigation is where the days go, and it starts again from scratch every month because the answer is never quite the same question twice.
See how DataWyse answers thisQuestions finance teams ask about this tool
What is a material budget variance?
Most finance teams set a dual threshold (for example, anything over 5% and over $10,000) so that a large percentage swing on a tiny line does not generate noise while a small percentage on a very large line still gets attention. The right numbers depend on your scale; the important thing is that the threshold is set before you look at the results.
Is a favourable variance always good?
No. Underspending on hiring means roles are unfilled. Underspending on marketing may explain next quarter's pipeline gap. Revenue above budget can indicate a sandbagged forecast rather than outperformance. Favourable variances deserve the same investigation as unfavourable ones, and get it far less often.
How do I decompose a variance into volume and rate?
Rate variance is the change in price multiplied by actual volume. Volume variance is the change in volume multiplied by budgeted price. The two components sum to the total variance, and separating them tells you whether to talk to procurement or to operations.
Should I calculate variance monthly or year to date?
Both, and read them together. Monthly variance catches new problems quickly. Year-to-date variance shows whether a monthly swing was a genuine timing difference that has since reversed or a structural change that keeps compounding.
How do I present variances to a board?
Lead with the three largest drivers by dollar impact, state the cause of each in one sentence, and say whether it repeats next quarter. Boards do not want the full variance table; they want to know which of these numbers changes the forecast.
Is this tool really free?
Yes. No signup, no email required, no usage limit. It runs entirely in your browser: nothing you type is uploaded to a server or stored anywhere. We build these because the people who find them useful are the people who eventually need a financial analyst that works the same way.
DataWyse answers the next thirty
Variance deep-dives, cash re-forecasts, scenario plans, board prep: asked in plain English, answered in minutes, with every number traceable to its formula and source data.