Budget vs Actual Report, Explained: How to Find the Variances That Actually Matter

Saltbox Catering had a great September. Sales came in $5,000 over plan, the calendar was full, and net profit landed within $50 of budget. The owner almost closed the report there. That would have been a mistake: hidden inside an on-target bottom line was $3,300 of spending the extra sales should never have needed.

This walkthrough uses Saltbox’s month to show how a budget vs actual report works: the two variance formulas, how to read favorable and unfavorable lines, why a flexible budget changes the story, how to decide which variances deserve your time, and how to set up a budget that makes the comparison worth running.

The Budget vs Actual Report in One Paragraph

Take every line of your profit and loss statement and put two numbers next to it: what you planned and what happened. Add the difference in dollars and in percent. That is the whole report. Its value comes entirely from what you do next — it points at the lines worth questioning and leaves the explaining to you.

What is the formula for budget variance?

• Variance ($) = Actual − Budget
• Variance (%) = Variance ($) ÷ Budget

Saltbox planned $2,200 for equipment rental — chafing dishes, tents, extra tables — and spent $3,300. That is a $1,100 variance, or 50% over plan.

Is a favorable variance always good?

A variance is favorable when it helps profit relative to plan (more revenue, or less spending) and unfavorable when it hurts (less revenue, or more spending). The sign alone is ambiguous — +$5,000 is welcome on revenue and alarming on payroll — so tag each line F or U. And don’t treat F as praise: underspending on maintenance or a delayed hire can show up as favorable this month and as a much larger cost later.

Saltbox Catering’s September, Line by Line

On a first read, food costs look like the villain: $3,100 over budget. But Saltbox sold more events than planned, and more events need more food. Some of that overage was simply the cost of the extra sales. How much?

Flexible Budgets: Take Sales Volume Out of the Picture

The table compares against a static budget — figures fixed in advance for $48,000 of sales. Saltbox plans food and supplies at 35% of revenue, so a flexible budget restates that line for the $53,000 it actually sold: 35% × $53,000 = $18,550. Measured against that, the real food overspend is $1,350, not $3,100. Smaller, but still genuine: the kitchen used more ingredients per dollar of sales than it should have.

How do you separate a volume variance from a spending variance?

Each extra dollar of sales should have contributed 65 cents after food costs. So $5,000 of additional revenue ought to have added $3,250 to profit — the volume variance. Everything else is spending variance, and that is where the month went:

Saltbox should have finished September about $3,250 ahead. Instead, $3,300 of extra spending absorbed every cent of the growth. The busy month felt like success and made no money. The same contribution idea drives break-even analysis, and it is what lets you see this at all.

Hitting the profit target is not the same as running to plan. Sometimes it means two mistakes cancelled out.

Deciding Which Variances to Chase

When is a budget variance big enough to investigate?

Set the rule before you see the numbers, or you’ll find reasons to skip the uncomfortable lines. A practical default: examine anything off by more than 10% and more than $500, plus revenue and net profit every month. For Saltbox that flags sales, food and supplies, and equipment rental. Staff costs, at 4.8%, slip under the bar — a reminder to glance down the dollar column before you close the report, because percentages flatter large accounts.

What do you do with a flagged line?

1. Rule out a bookkeeping cause. Miscoded bills, a quarterly charge landing in one month and duplicated entries create variances that have nothing to do with the business. Open the transactions behind the number first.
2. Find the business reason. Saltbox’s rental overage came from three outdoor weddings it hadn’t owned enough tents for. Its food overage came from quoting menus on last year’s ingredient prices.
3. Choose a response. Buy the tents if outdoor events are now a regular line of work; reprice menus; or accept a genuine one-off and note it so it isn’t questioned again next month.

Setting Up a Budget That Makes the Comparison Useful

• Plan month by month. Catering peaks in wedding season and around the holidays; dividing an annual figure by twelve produces variances every month that mean nothing.
• Draft from last year’s actuals. Pull the prior year’s P&L by month and account, then adjust for known changes — new pricing, a new hire, a lease renewal.
• Use the same accounts as your books. A budget built on different categories from your chart of accounts needs translating every time you compare it.
• Stay on one accounting basis. An accrual budget measured against cash-basis results produces timing noise forever.

When should I run a budget vs actual report?

Monthly, as the last step of your month-end routine — once the bank is reconciled and the adjusting entries are in. Before then you are comparing the plan against unfinished books and will chase gaps that are really missing entries. Check the month for early signals and the year to date for confirmation.

Should I change my budget when things change?

Generally, no. Leave the budget as the commitment you made, so it stays a fair benchmark, and keep a separate forecast for what you now expect. When Saltbox’s wedding bookings outrun the plan, the forecast goes up; the budget stays put, and the variance tells the story. Reserve a formal re-budget for real structural change, such as losing a major client or opening a second kitchen. The cash side of that forward view is covered in our 13-week cash flow forecast guide.

Common Budget vs Actual Mistakes

1. Only looking at the bottom line. Saltbox’s profit was on plan; its operations weren’t.
2. Comparing variable costs to a static budget. Busy months look wasteful and slow months look thrifty, whatever actually happened.
3. Trusting percentages alone. A 50% miss on a small account can matter less than a 5% miss on payroll.
4. Editing the budget to match reality. Forecast instead; otherwise nothing is left to measure against.
5. Reviewing too late. A quarterly or annual look finds problems after they’ve compounded.

Budget vs Actual in Kantivo

• A built-in Budget Manager sets budgets account by account, in monthly, quarterly or annual periods, aligned to your fiscal year.
• The variance report reads your posted ledger directly, showing budget, actual, and the dollar and percentage gap for every budgeted account — no exports, no spreadsheet formulas to break.
• Status indicators on every line flag expenses as on track, approaching (within 10% of plan) or over, and show whether each revenue line has reached its target.
• Genuine double-entry accounting underneath, so the actuals match your financial statements exactly and any variance can be traced to its transactions.
• Several budgets side by side, each marked draft, active or closed, so next year’s plan can take shape while this year’s is still being measured.

Frequently Asked Questions

What does a budget vs actual report show?

For each revenue and expense account, it shows the figure you planned for the period, the figure actually recorded in your books, and the gap between them in dollars and as a percentage. Totals show how far overall profit landed from plan. It is a map of where to look rather than a verdict — each gap still needs an explanation.

What is the formula for budget variance?

Dollar variance equals actual minus budget; percentage variance equals the dollar variance divided by the budget. Equipment rental budgeted at $2,200 that cost $3,300 has a $1,100 variance — 50% over plan. Mark every line favorable or unfavorable, since a positive number is good news on revenue and bad news on an expense.

Is a favorable variance always good?

No. Favorable only means the line helped profit relative to plan, through higher revenue or lower spending. Spending less because you skipped planned maintenance or delayed a hire looks favorable now and can cost more later. And revenue above budget is favorable, but if costs rose faster than sales, you’re growing less profitably than intended.

When is a budget variance big enough to investigate?

Decide the rule before you look. A common small-business approach is to examine any line off by more than 10% and more than $500, which ignores trivial swings on small accounts and routine noise on large ones. Review revenue and net profit every time, and scan the dollar column for large gaps that stay under the percentage limit.

When should I run a budget vs actual report?

Once a month, at the end of your month-end close, after the bank reconciliation and adjusting entries. Any earlier and you’re measuring the plan against unfinished books, chasing variances that are really missing entries. Compare both the latest month and the year to date, since a single month is easily distorted by timing.

Should I change my budget when things change?

Usually not. Keep the budget as the original commitment so it stays a fair benchmark, and track changing expectations in a separate forecast updated through the year. Rewriting the budget whenever results drift makes variances disappear without explaining them. A formal mid-year re-budget is reasonable only after a major change, like losing a large customer or opening a new location.

Where This Leaves You

A budget vs actual report is only as good as the questions you ask of it. Work out each variance, tag it favorable or unfavorable, and flex the variable costs for the volume you actually achieved — then look past the bottom line, because an on-target profit can be two problems cancelling each other out.

Saltbox’s fix wasn’t to cut back on weddings. It was to reprice menus on current ingredient costs and decide whether to own the tents it keeps renting. Neither decision was visible in the profit figure. Both were obvious in the variance report.

Related Articles

• Break-Even Analysis, Explained: Find the Sales Number That Covers Every Bill
• How to Read a Profit and Loss Statement (No Accounting Degree Needed)
• The Cash Flow Forecast Every Owner Should Run (13 Weeks, 20 Minutes a Week)
• How to Close Your Books Every Month: A Small Business Month-End Routine
• Financial Ratios for Small Business: 8 Numbers to Check Before Your Banker Does
• Job Costing for Small Business: How to Find the Projects Carrying You