A budget vs actual report has the emotional energy of stepping on a bathroom scale after a long weekend. You already suspect the number. You'd rather not have it confirmed in a spreadsheet with red cells.
So a lot of owners build a budget in January, feel organized for about three weeks, and then stop looking at it. The budget lives in a folder. The business lives in the real world. They never speak again.
That's a shame, because the report is one of the most useful tools an owner has once you stop reading it as a grade. Here's how to read it, what to do with the differences, and how to keep it from turning into a monthly guilt trip.
What a budget vs actual report shows
The layout is simple. Each line of your P&L (revenue, cost of goods sold, each expense category) gets four columns:
- Budget: what you planned for the month
- Actual: what happened, from your closed books
- Variance in dollars: actual minus budget
- Variance in percent: that difference divided by the budget
QuickBooks Online Plus and Advanced let you enter a budget and run a Budget vs. Actuals report. Many owners keep it in a spreadsheet instead, which works fine as long as the actuals come from reconciled books. Comparing a careful budget to messy actuals is like weighing yourself while holding a bag of groceries.
Favorable, unfavorable and why neither is a moral judgment
A favorable budget variance means results were better than planned: more revenue, or lower cost. An unfavorable one means the opposite.
Those words describe direction, not character. Spending $3,000 more than planned on materials because you sold more jobs is unfavorable on that line and great for the business. Spending $3,000 less on marketing because the campaign slipped a month looks favorable and may just be delayed. The report starts the conversation. It doesn't finish it.
Variance analysis for a small business in five steps
Variance analysis is the habit of explaining the big differences. You don't explain every line. Here's a routine that takes about twenty minutes:
- Set a threshold. For example, look only at lines off by more than 10% and more than $1,000. Small businesses have enough real problems without chasing $84.
- For each flagged line, ask which of four causes it is: timing (it happened in a different month than planned), volume (you did more or less work), price (costs or rates changed), or error (something posted to the wrong place).
- Fix errors right away. They aren't variances; they're bookkeeping.
- For timing differences, note when they'll reverse and move on.
- For volume and price differences, decide: change something in the business, or update the plan.
A worked example: a plumbing contractor's April
Say you run a 15-person plumbing company. April's report shows:
- Revenue: budget $210,000, actual $194,000. Variance: $16,000 unfavorable, about 7.6%.
- Materials: budget $63,000, actual $66,500. Variance: $3,500 unfavorable, about 5.6%.
- Marketing: budget $4,000, actual $9,200. Variance: $5,200 unfavorable, 130%.
- Software: budget $2,100, actual $2,050. Nothing to see here.
Work through it. Revenue is under by $16,000. Volume problem: two large jobs moved into May because of permit delays. That's partly timing, too, so check May before panicking.
Materials are over budget even though revenue is under. That's the important one. Materials were planned at 30% of revenue and came in at about 34%. That points to price: supplier costs went up and your job pricing didn't. This is a real decision about quotes and pricing.
Marketing is way over, but the $5,200 is the deposit for a home show booth you'd budgeted in June. Pure timing. It'll even out.
Out of four lines, one deserves a meeting. That's what a good report does: it narrows your attention to the line that matters.
When the budget is the problem
Sometimes the variances aren't telling you about the business. They're telling you the budget was a guess made in December with a hopeful heart. If a line is wrong every month by roughly the same amount, the plan needs updating, not the business.
That's where a forecast comes in. A budget is the plan you set; a forecast is your current best estimate of what will happen. If those two ideas are getting blurry, read budgeting and forecasting: what's the difference, and do you need both? This is also the kind of planning a fractional CFO helps owners build and maintain, which is what our CFO services cover.
Where this report fits in your monthly package
The budget vs actual report works best alongside your core reports, not instead of them. It belongs in the set described in monthly financial reporting: the 5 reports every owner should get. And if you'd rather track a short list of numbers than every budget line, our guide to financial KPIs for small business can help you pick them.
Questions owners ask
How often should I review a budget vs actual report?
Monthly, once the books are closed and reconciled. Reviewing it weekly from unreconciled numbers tends to create false alarms. A quarterly review on top of that is a good time to update the forecast.
What is an acceptable budget variance?
There's no universal number. Many owners set a threshold based on both percent and dollars, such as 10% and $1,000, so they only investigate differences big enough to matter for their size.
Should I change my budget during the year?
Most businesses keep the original budget for comparison and update a separate forecast instead. That way you can see both what you planned and what you now expect.
More reports, fewer guilt trips
If you'd like more notes like this one, The ABFI Accounting Brief covers books, closes, reporting and controls in plain English, with no market-news filler. Subscribe to The ABFI Accounting Brief and we'll keep them coming. If you want help building a budget worth comparing against, you can request a consultation whenever you're ready.