Skip to main content

Guide · 8 min read · November 19, 2026

Budget vs actual analysis: how to run a monthly variance review

A budget only earns its keep if you compare it to what happened. Budget vs actual analysis is that comparison, line by line, every month, and it is how founders catch overspending, slipping revenue and bad assumptions while there is still time to act. This guide covers how to prepare the numbers, read the variances, decide which ones matter and run a review that ends in decisions.

What's inside

  • · What a budget vs actual review is and why it should be monthly
  • · Getting the inputs right before you compare anything
  • · How to read favorable and unfavorable variances, with a worked example
  • · Setting thresholds and finding the cause of each variance
  • · A one-hour monthly review and how to turn it into a forecast

What a budget vs actual review is

A budget vs actual report puts three columns next to each account on your profit and loss: what you planned to earn or spend, what you actually earned or spent, and the difference. The difference is the variance. Expressed as a formula, variance equals actual minus budget, and variance percent equals that difference divided by the budget.

Most businesses build an annual budget and then look at it twice: once when it is approved and once at year-end. That is too late to change anything. A monthly review turns the budget into an early-warning system. If contractor costs run 20% over plan in October, you want to know in the first week of November, not in January when the year is already gone.

The review is not about hitting the budget exactly. Every variance is information. Some point to a real problem, some to timing, and some to a budget assumption that was wrong. The job is to tell which is which.

Get the inputs right before you compare

A variance report is only as good as the two sets of numbers behind it. If the books for the month aren't closed, or the budget is shaped differently from the books, the report produces noise and the meeting turns into an argument about data. Fix these four things first.

Close the month first

Reconcile bank and card accounts, record bills and accruals, and finish the close before you run the report. Our month-end close checklist covers the steps. Comparing a budget to half-finished books creates variances that disappear a week later.

Use the same chart of accounts

Build the budget on the accounts in your general ledger, not on a separate list of categories. If the budget has one line for software and the books split it across three accounts, every month starts with a mapping exercise.

Phase the budget by month

Don't divide the annual number by 12 for lines that move with the calendar. If a trade show happens in March and annual insurance renews in July, put those costs in those months. Otherwise every month shows a variance that is really just bad phasing.

Match the accounting basis

If you budget on an accrual basis, compare against accrual books. A cash-basis P&L puts expenses in the month you paid them, so a quarterly bill paid early or late shows up as a variance that has nothing to do with performance.

How to read the report: a worked example

A variance is favorable when it helps profit: revenue above budget or an expense below it. It is unfavorable when it hurts profit: revenue below budget or an expense above it. Favorable doesn't always mean good, and unfavorable doesn't always mean bad, which is why each one needs a cause.

Say a 12-person agency budgeted October like this, and the closed books came back with the actuals below.

AccountBudgetActualVarianceVariance %
Revenue$120,000$108,000-$12,000-10.0% (unfavorable)
Contractor costs$30,000$36,500+$6,500+21.7% (unfavorable)
Payroll$55,000$52,000-$3,000-5.5% (favorable)
Software$4,000$4,300+$300+7.5% (unfavorable)
Marketing$8,000$3,500-$4,500-56.3% (favorable)
Net income$23,000$11,700-$11,300-49.1% (unfavorable)

Net income came in at about half of plan. Read line by line, the story is more specific. Revenue fell short by $12,000 while contractor costs rose by $6,500, which suggests the agency paid outside help on work it didn't bill in October. The $4,500 marketing saving looks favorable, but if it is a campaign that slipped into November, it is a timing difference that will reverse next month.

Set thresholds and find the cause

You can't explain every line every month, and you shouldn't try. Set a rule for which variances get a written explanation and apply it every month. A common approach combines a percentage and a dollar floor, so small accounts with big percentage swings don't eat the meeting. For example, the agency above might investigate any line that is off by 10% or more and $2,000 or more.

Under that rule, revenue, contractor costs and marketing get explained. Payroll is under 10% and software is under $2,000, so they get a glance, not an investigation. Pick thresholds that fit your size; a business with $50,000 of monthly expenses needs a lower dollar floor than one with $500,000.

For each flagged line, put the variance into one of five buckets. The bucket tells you what to do next.

  • Timing: the cost or revenue is real but landed in a different month than planned. Note when it will reverse and move on.
  • Volume: you sold more or fewer units, hours or seats than planned. This usually points to the sales pipeline or capacity.
  • Price or rate: the volume was on plan but the price per unit changed, such as a vendor rate increase or a discount you gave.
  • One-time: an event that won't repeat, like a legal bill or an equipment repair. Explain it once and exclude it from trend analysis.
  • Booking error or budget error: a transaction coded to the wrong account, or a budget assumption that was wrong. Fix the books, or note that the budget line needs revisiting.

A one-hour monthly variance review

  1. 01

    Close the books (business days 1 to 5)

    Finish reconciliations, accruals and reclassifications so the actuals are final before anyone looks at them.

  2. 02

    Run the report and flag lines (day 6)

    Run budget vs actual for the month and year to date. Apply your thresholds and highlight the lines that need an explanation.

  3. 03

    Get explanations from budget owners (days 6 to 7)

    Send each flagged line to the person who owns that spend or revenue. Ask for one or two sentences and a bucket: timing, volume, price, one-time or error.

  4. 04

    Hold the review (day 8, about an hour)

    Walk through year-to-date first, then the month. Spend the time on the flagged lines and on anything that has been unfavorable for two or three months running.

  5. 05

    Record decisions and owners

    End with a short list: what changes, who owns it and by when. A variance review without decisions is just a reading of the report.

Turn variances into a better forecast

Keep the original budget fixed for the year so you have a stable baseline, and maintain a separate forecast that you update as you learn. When a variance turns out to be permanent, such as a vendor that raised rates for good or a client that churned, carry it into the forecast for the remaining months. Then add a third comparison to your review: actual vs forecast tells you whether your latest expectations are holding.

Your accounting software can do much of the mechanical work. Intuit says budgeting is available in QuickBooks Online Plus and Advanced, where you can create a profit and loss budget, subdivide it by class or location, and run a Budgets vs. Actuals report from the Budgets page (Intuit's guide to creating budgets). Xero offers a Budget Variance report. The harder part is everything around the report: closed books, a budget built on the right accounts and someone who writes up the story each month.

That work is part of good financial reporting. If you want help building the budget itself, setting thresholds or running the monthly review with your team, controller and CFO support covers it.

Frequently asked questions

What is a good variance threshold?
There is no universal number. Many businesses combine a percentage and a dollar amount, such as 10% and $2,000, and adjust both to their size so small accounts with large percentage swings don't dominate the review.
Should I compare month or year-to-date numbers?
Both. The month shows what changed recently, while year-to-date smooths out timing differences and shows whether you are on track for the year. Start with year-to-date and use the month to explain it.
How often should I update the budget?
Keep the approved budget fixed for the year as your baseline, and update a separate forecast monthly or quarterly as permanent changes appear. Rewriting the budget every month removes the baseline you are measuring against.
Is a favorable variance always good news?
No. Spending less than planned on marketing or hiring can mean a campaign slipped or a role is still open, which may cost you revenue later. Treat favorable variances with the same questions as unfavorable ones.

Want a budget vs actual review you can act on every month?

We'll look at how your books and budget line up and show you what a monthly variance review could look like for your business, on one short call.