Module 05 · Reporting, Budgeting, and Security

How to Run a Budget vs Actual Analysis

A budget only earns its keep once you compare it to what actually happened — here's how to do that comparison, and how to tell a real problem from noise.

6 min readLesson 5 of 13 in this moduleUpdated 2026-08-25

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.

Not every variance is a crisis

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.

Doing this in Reyuko

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
  1. Pull actual results for the month, by line item.
  2. Calculate variance ($ and %) for each line against your budget.
  3. Sort by size of unfavorable variance first — those get looked at before favorable ones.
  4. For each variance above roughly 10–15%, ask: is this new, or has it repeated for two or more months?
  5. Note a one-line explanation for anything unusual, so next month's review isn't confused by it.
  6. 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.

Frequently asked questions

What is a budget vs actual analysis?

It's 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.

How do you 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 easier to compare variances across line items of different sizes.

What is a 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.

How often should you compare budget to actual?

Most small businesses compare budget to actual once a month, right after closing the books, so variances are caught while they're recent enough to still explain and, if needed, act on before the next month compounds the problem.

When does a budget variance require 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.

What causes budget variances in a small business?

Common causes include unexpected price increases from suppliers, slower or faster sales than planned, one-off expenses like repairs, seasonal swings, and simply an unrealistic budget target that was set with too little historical data, especially in a business's first year.

Should I change my budget after seeing a variance?

Not usually, and not immediately. Adjust the budget itself only once a variance has persisted for several months and reflects a genuine, lasting change — a rent increase, a new recurring cost — rather than reacting to a single month's result.

Let variance calculate itself, every month

Reyuko's Account Budget module computes budget-vs-actual variance in dollars and percent, live from your ledger, with multi-month comparison built in.

Download Reyuko freeSee what's included