Budget vs Actual Variance Analysis: Template and How to Explain It
How to run budget vs actual variance analysis: the formula, a template layout, a worked example, flexed budgets, and variance commentary an owner can act on.
What is budget vs actual variance analysis? It compares what you planned to earn and spend with what actually happened, line by line, then explains the differences that matter. Calculate each variance as actual minus budget, mark it favorable or unfavorable, flag lines above a materiality threshold, and write one sentence per flagged line giving the cause, whether it repeats, and the action.
Key takeaways
- Variance is actual minus budget; variance percentage is that difference divided by budget. Whether it is favorable depends on the line type, so label F or U explicitly.
- Set a two-part materiality threshold before you look, such as 5% and $5,000, and flag only lines that breach both.
- A good template has phased monthly budget, actual, variance, year to date, full-year forecast, a flag and one line of commentary.
- Flex volume-driven costs to actual sales, or a revenue shortfall will show up as a cost saving.
- Every flagged line gets one sentence: what moved, why, timing or permanent, and what happens next.
The arithmetic takes minutes. The explanation is the part that makes a budget-versus-actual report useful, and the part most reports leave out. This guide gives you a template layout, a worked example with every number shown, a simple formula for writing variance commentary that an owner or board can act on, and a rhythm for doing it every month. To run the calculation on your own figures, paste them into the free budget variance calculator, which sorts the largest variances to the top and flags each by severity.
How do you calculate budget vs actual variance?
Two formulas:
- Variance ($) = actual − budget
- Variance (%) = (actual − budget) ÷ budget
A marketing line budgeted at $20,000 that came in at $31,000 has a variance of +$11,000, or +55%.
The sign alone does not tell you whether the variance is good or bad. That depends on the type of line:
| Line type | Actual above budget | Actual below budget |
|---|---|---|
| Revenue, other income | Favorable (F) | Unfavorable (U) |
| Cost of goods sold, expenses | Unfavorable (U) | Favorable (F) |
| Profit lines (gross profit, operating profit) | Favorable (F) | Unfavorable (U) |
Label each line F or U explicitly rather than relying on color or sign. A report that turns every positive number red is wrong on every revenue row.
Set a materiality threshold before you look
Not every variance deserves an explanation. Decide in advance which ones do, using two tests together: a percentage and a dollar floor. A line is flagged only if it breaches both. A small business might start at 5% and $5,000; a larger one might use 5% and $10,000. The two-part test stops a $900 overrun on a small line from taking up the meeting, while still catching a large dollar miss on a big line. Write the threshold down and do not change it after you have seen the results.
What should a budget vs actual template include?
One row per P&L line at the level the owner or board actually manages, and these columns:
| Column | Purpose |
|---|---|
| Line item | Revenue, COGS, gross profit, each expense group, operating profit |
| Budget (month) | The phased budget for this month, not one-twelfth of the annual figure |
| Actual (month) | From the closed books |
| Variance $ and % | Actual minus budget, and as a share of budget |
| F / U | Favorable or unfavorable, by line type |
| Budget, actual and variance (year to date) | Shows whether a monthly swing is reversing or compounding |
| Full-year forecast | Your current best estimate for the year, updated for what you now know |
| Flag | Yes if the line breaches the materiality threshold |
| Commentary | One sentence per flagged line: cause, timing or permanent, action |
Two details make the difference between a template that informs and one that misleads. First, phase the budget. An annual budget spread evenly across twelve months will show a variance every month in any seasonal business, and people learn to ignore it. Second, always include gross profit and margin. Revenue and cost of goods sold can each look acceptable while the margin between them falls.
Worked example: one month, six lines
All figures in this example are hypothetical. Materiality threshold: 5% and $5,000, both required.
| Line | Budget | Actual | Variance $ | Variance % | F/U | Flag |
|---|---|---|---|---|---|---|
| Revenue | $400,000 | $372,000 | ($28,000) | −7.0% | U | Yes |
| Cost of goods sold | $240,000 | $229,000 | ($11,000) | −4.6% | F | No |
| Gross profit | $160,000 | $143,000 | ($17,000) | −10.6% | U | Yes |
| Payroll | $85,000 | $86,500 | $1,500 | +1.8% | U | No |
| Marketing | $20,000 | $31,000 | $11,000 | +55.0% | U | Yes |
| Software | $6,000 | $6,900 | $900 | +15.0% | U | No |
| Rent | $12,000 | $12,000 | $0 | 0.0% | No | |
| Operating profit | $37,000 | $6,600 | ($30,400) | −82.2% | U | Yes |
Three things to notice.
- Cost of goods sold is "favorable" and that is not good news. It is lower because revenue was lower. Read it alongside revenue, through gross profit, never on its own.
- Software is up 15% but not flagged. At $900 it fails the dollar test. Note it; do not spend meeting time on it.
- Gross margin fell as well as revenue. Budget margin was 40.0% ($160,000 ÷ $400,000). Actual margin was 38.4% ($143,000 ÷ $372,000). That is a separate problem from the volume shortfall, and it needs its own explanation.
The gross profit miss splits cleanly into those two causes. At the budgeted 40% margin, $372,000 of revenue would have produced $148,800 of gross profit. So:
- Volume effect: $160,000 − $148,800 = $11,200, from selling less.
- Margin rate effect: $148,800 − $143,000 = $5,800, from earning less on each dollar sold.
Together they make the $17,000. For a deeper breakdown into price, volume and mix by product, the variance analysis guide walks through rate and volume decomposition, and the P&L variance bridge draws the waterfall for you.
Compare costs to a flexed budget
For costs that should move with sales, a static budget comparison is misleading. Flex the budget to actual volume first. In the example, cost of goods sold was budgeted at 60% of revenue. At actual revenue of $372,000, the flexed budget is $223,200 (60% × $372,000). Actual cost of goods sold was $229,000, so against the flexed budget it is $5,800 unfavorable, not $11,000 favorable. That is the same $5,800 margin rate effect, seen from the cost side. A flexed column for volume-driven costs stops the report from presenting a sales shortfall as a cost saving.
How do you explain a budget variance?
Every flagged line gets one sentence with four parts: what moved and by how much, why, whether it is timing or permanent, and what happens next. If you cannot write all four, the investigation is not finished.
Weak commentary describes the number. Strong commentary explains it. Using the example above:
| Line | Weak | Strong |
|---|---|---|
| Revenue | "Revenue was below budget due to lower sales." | "Revenue was $28,000 (7.0%) under budget because two confirmed customer orders worth about $25,000 shipped on the 2nd of next month instead of the 30th. Timing: expected to reverse next month. No change to the full-year forecast." |
| Gross margin | "Gross margin was lower than expected." | "Gross margin was 38.4% against 40.0% budget. $11,200 of the $17,000 gross profit shortfall is volume; $5,800 is a supplier price increase on our main product line effective this month. Permanent until we reprice. Pricing review with the owner by the 15th." |
| Marketing | "Marketing was over budget." | "Marketing was $11,000 over because of a trade show approved in January that was not in the budget. One-off. Full-year forecast for marketing increased by $11,000." |
The timing-or-permanent label is the most useful word in the report, because the question behind every variance discussion is whether the year still looks the way the budget said it would. A timing difference reverses. A permanent change repeats every month until someone acts, and it belongs in the full-year forecast immediately.
How to present it to an owner or board
- Lead with the two or three variances that matter most by dollar impact, not by percentage.
- Put the commentary above the table, not in a footnote.
- Separate what was decided (an approved trade show) from what was discovered (a supplier price rise). The first is a budget update; the second may need a decision.
- Give every unresolved item an owner and a date.
- Put the full table in an appendix for anyone who wants it.
How often should you do budget vs actual analysis?
Monthly, as the last step of the month-end close, once the books are reconciled and adjusted. Analysing numbers before the close is finished means explaining variances that are really missing accruals. The month-end close checklist puts the budget-versus-actual report at the end of the close for that reason.
Beyond the monthly report:
- Quarterly, reforecast. Keep the original budget as the fixed comparison, and update the full-year forecast for everything you now know.
- Read month and year to date together. A monthly variance shows a new problem quickly. Year to date shows whether last month's timing difference actually reversed.
- Fix lines that miss every month. A line that shows a variance every single month is a budgeting problem, not a performance one. Rebuild that line's budget rather than explaining it again.
Comparing actual performance to plans and investigating the differences is also a standard control activity. The GAO Green Book includes top-level reviews of actual performance against plans among its examples of common control activities, and the COSO framework likewise treats management review of performance as a control. A budget-versus-actual report that is read and acted on every month is one of the cheapest controls a small organization has.
Common mistakes
- Ranking by percentage. The largest percentages are usually on the smallest lines.
- Ignoring favorable variances. Underspending on hiring can mean unfilled roles and missed work. Revenue above budget can mean the budget was set too low.
- Netting before flagging. Two large variances in opposite directions can cancel at the department total. Flag at line level first.
- Commentary with no forecast impact. If the explanation does not say whether the full year changes, the reader still has to ask.
How DataWyse helps
The calculation and the flags in this guide are mechanical, and the free calculator handles them. The commentary is not: writing "two orders shipped on the 2nd instead of the 30th" means going from the revenue line to the invoices, and writing "a supplier price increase" means going from the margin line to the purchase records. DataWyse connects read-only to your accounting and CRM data and does that drill-down when you ask why a line moved, returning the cause with the formula and the source transactions behind every figure, in Excel and SQL form, so you can check it before it goes in the board pack.
It also tracks spend against budget daily, so a line heading for a variance shows up before the month closes. The judgement about what the variance means for the business, and what to do about it, stays with you.
References and Further Reading
- U.S. Government Accountability Office. Standards for Internal Control in the Federal Government (the Green Book). https://www.gao.gov/greenbook
- Committee of Sponsoring Organizations of the Treadway Commission (COSO). (2013). Internal Control: Integrated Framework. https://www.coso.org/internal-control
- U.S. Small Business Administration. Manage your finances. https://www.sba.gov/business-guide/manage-your-business/manage-your-finances
Frequently asked questions
How do you calculate budget vs actual variance?
Subtract the budget from the actual for each line to get the dollar variance, and divide that difference by the budget to get the percentage variance. For example, a line budgeted at $20,000 with actual spend of $31,000 has a variance of $11,000, or 55%.
What is a favorable vs unfavorable variance?
A favorable variance improves profit compared with the budget: revenue above budget or costs below budget. An unfavorable variance reduces profit: revenue below budget or costs above budget. A cost that is below budget only because sales were lower is not good news, so compare volume-driven costs against a budget flexed to actual sales.
How do you explain a budget variance?
Write one sentence per material variance that states what moved and by how much, why it moved, whether it is a timing difference that will reverse or a permanent change, and what happens next, including any change to the full-year forecast and who owns the follow-up.
What is a good materiality threshold for variance analysis?
Use two tests together: a percentage and a dollar floor, and flag a line only when it breaches both. Many small businesses start around 5% and $5,000, and larger ones around 5% and $10,000. Set it before looking at the results and keep it consistent from month to month.
How often should you do budget vs actual analysis?
Monthly, after the month-end close is complete, so you are not explaining variances that are really missing accruals. Reforecast the full year quarterly while keeping the original budget as the fixed comparison, and read month and year-to-date variances together.
