A budget vs actual analysis compares planned figures to real results each month using the formula variance = actual − budget, usually expressed as a percentage. A variance needs action when it's large, repeats across several months, or involves a controllable expense — rather than a one-time or seasonal blip that's expected to correct itself. Setting a budget without ever running this comparison wastes most of the point of having one.
Key takeaways
- Budget vs actual analysis compares what actually happened to what you planned, once a month, for every line item.
- The formula is variance = actual − budget, usually shown as both a dollar amount and a percentage.
- A favorable variance means results were better than planned; an unfavorable variance means worse.
- Not every variance needs action — a large, repeating, or controllable one usually does; a small or one-time one usually doesn't.
- Run this comparison monthly, right after closing the books, so gaps are caught while they're still recent and explainable.
- Even a favorable variance is worth a quick look — it can mean the original target was set too low.
What a budget vs actual analysis is
A budget vs actual analysis is a monthly comparison between the numbers you planned in your budget and what actually happened in your accounting records, used to spot where the business is over or under target and to decide whether that gap needs a response. It's the step that turns a budget — once you've built your first one — from a static document into an actual management tool.
Most small businesses run this comparison once a month, right after closing the books, as part of a broader monthly reporting routine — reconciling first so the "actual" side of the comparison is trustworthy, then reviewing statements before checking variance line by line.
How to calculate budget variance
Subtract the budgeted amount from the actual amount for each line item: variance = actual − budget. Expressing the result as a percentage of the budgeted amount makes it far easier to compare variances across line items of very different sizes — a $600 miss means something different on a $500 budget than on a $50,000 one.
Variance = Actual − Budget, then Variance % = Variance ÷ Budget × 100
The variance formula
For revenue, a positive variance is favorable — you brought in more than planned. For an expense line, a positive variance is unfavorable — you spent more than planned. Keeping that sign convention straight matters, because "positive" doesn't mean "good" once you're looking at costs instead of income.
A worked example
Harbor Print Shop reviews budget vs actual every month. Here's its comparison for one month:
| Line item | Budget | Actual | Variance | Variance % |
|---|---|---|---|---|
| Revenue | $15,000 | $16,200 | +$1,200 | +8.0% |
| Materials (COGS) | $4,500 | $5,100 | +$600 | +13.3% |
| Marketing | $800 | $950 | +$150 | +18.8% |
| Rent & fixed overhead | $3,200 | $3,200 | $0 | 0.0% |
| Net profit | $6,500 | $6,950 | +$450 | +6.9% |
Net profit: budgeted $15,000 − $4,500 − $800 − $3,200 = $6,500; actual $16,200 − $5,100 − $950 − $3,200 = $6,950 — a favorable $450 variance overall, even though two expense lines ran over.
That's the case where reading only the bottom line would mislead you. Overall profit beat target, but materials ran 13.3% over budget — worth checking whether a supplier raised prices — while marketing's overage traces to a one-off trade show that isn't part of the ongoing plan. Rent came in exactly on budget, as fixed costs usually do.
Favorable vs. unfavorable variance
A favorable variance means results were better than planned — more revenue or less expense than budgeted. An unfavorable variance means results were worse — less revenue or more expense than planned — and generally deserves closer attention first, since it's the type most likely to signal a real problem worth investigating.
That doesn't mean favorable variances are automatically fine to ignore. A revenue line that consistently beats budget by 20% month after month is a sign the original target was set too conservatively, not a reason to celebrate every month — it's worth resetting the target so the budget stays a useful benchmark.
A single month's expense line running 15% over budget is common and usually explainable — a supplier price bump, an unusual one-off cost, a seasonal swing. Treating every variance as an emergency wastes attention that should go toward the ones that actually repeat.
When a variance needs action
A variance needs action when it's large relative to the line item, part of a repeating pattern across several months, or tied to something controllable like discretionary spending — versus a one-time or seasonal blip that's expected to self-correct. A few practical signals:
- Size relative to the line, not just in dollars. A 20% miss on a $200 category matters less than a 5% miss on a $10,000 one.
- Repetition. One month over budget on materials is a data point. Three months running is a trend that needs a cause.
- Controllability. Marketing spend, subscriptions, and discretionary purchases are within your control to adjust. A rent increase or a tax rate change isn't — those call for updating the budget itself, not "fixing" the variance.
- Whether it's already explained. Harbor Print Shop's marketing overage from a trade show doesn't need action — it needs a note in the file explaining why, so next month's comparison isn't confused by it.
Common causes of variance worth knowing before you investigate: unexpected supplier price increases, sales running faster or slower than planned, one-off expenses like repairs, ordinary seasonal swings, and — especially in a business's first year — a budget that was simply set with too little historical data to be accurate yet.
Reyuko's Account Budget module (Backup plan and up) computes this comparison automatically: for every Level-4 account, it shows budget-vs-actual variance in both dollars and percentage, computed live against your ledger rather than recalculated by hand each month. A multi-month, quarterly, or yearly comparison view is built in, so a repeating pattern like Harbor Print Shop's materials overage is visible at a glance across several periods, not just the one month you happen to be reviewing.
If your business tracks budgets by project or department, variance can be broken down that way too, since department and project tags are supported directly on the same accounts. This sits alongside the free edition's Income Statement, which already groups revenue and expense accounts the way a variance table needs — the budget module adds the comparison, not a new chart of accounts.
A monthly variance check
Run this after reconciling and reviewing statements
- Pull actual results for the month, by line item.
- Calculate variance ($ and %) for each line against your budget.
- Sort by size of unfavorable variance first — those get looked at before favorable ones.
- For each variance above roughly 10–15%, ask: is this new, or has it repeated for two or more months?
- Note a one-line explanation for anything unusual, so next month's review isn't confused by it.
- Only adjust the budget itself if a variance is persistent and reflects a genuine change, not a one-off.
A quick glance at your financial dashboard between monthly reviews can flag a large variance forming early, before it's had a full month to compound — and if this analysis keeps turning up the same avoidable gaps, common mistakes in budgeting and reporting is worth a look.
Reyuko