Budget vs Actual: How to Review Monthly Variances

A budget you never look at again is just a wish list. The real value comes from comparing it with what actually happened, month after month. A budget vs actual review shows where your plan was right, where it was wrong and what you should change, and it takes far less time than most owners expect.

Person calculating finances at a desk covered with printed documents, working through figures with a calculator and pen — A monthly variance review turns your budget from a one-time exercise into a working tool.

Key takeaways

A variance is the difference between what you budgeted and what actually happened, for income or for costs.
Not every variance matters. Set a simple threshold so you only investigate the ones big enough to act on.
Every important variance needs a reason and a decision: ignore, adjust the plan or take action.
A 30 to 60 minute review each month, using one consistent template, keeps your budget useful all year.

Most small business owners build a budget at the start of the year, feel good about it, and then file it away. By March, sales have come in differently than expected, a supplier has raised prices and an unplanned repair has eaten into the cash. The budget still says one thing while the bank account says another.

That is not a failure. Plans are always wrong in some way. The skill is noticing how they are wrong early enough to respond. With the first quarter almost finished, now is a great time to start a monthly budget vs actual habit, using January and February as your first practice runs.

What budget vs actual means

A budget vs actual report sets your planned numbers side by side with your real results for the same period. For each line, such as sales, rent, wages or marketing, you see three things: what you expected, what happened and the difference between them.

That difference is called a variance. You can express it as an amount (actual minus budget) and as a percentage (the variance divided by the budget). Both are useful. The amount tells you how much money is involved; the percentage tells you how far off the plan was.

Favorable and unfavorable variances

Accountants describe variances as favorable or unfavorable, which is clearer than positive or negative because the meaning flips between income and costs.

Income above budget is favorable. You earned more than planned.
Income below budget is unfavorable.
Costs below budget are favorable. You spent less than planned.
Costs above budget are unfavorable.

A favorable variance is not automatically good news, though. Lower marketing spend might mean you saved money, or it might mean a campaign never launched and next month's sales will suffer. Always ask why.

Common mistake

Comparing a monthly actual with one twelfth of the annual budget when your business is seasonal. If most of your sales happen in summer, splitting the year evenly will make every spring month look like a disaster. Phase your budget by month to match your normal pattern.

Before you start: get your numbers ready

A variance review is only as reliable as the data going into it. Before you compare anything, make sure the month is properly closed.

Reconcile your bank and card accounts so every transaction is recorded.
Enter all invoices and bills for the month, including any that arrived late.
Check categories. A software subscription coded to "office supplies" will create a false variance on two lines at once.
Note timing issues. An annual insurance premium paid in one month can distort that month badly. Some owners spread such costs across the year in their reports so the monthly view stays fair.

If you use accounting software, many packages can produce a budget vs actual report automatically once you enter your budget. A spreadsheet works just as well if you prefer to keep things simple.

How to review monthly variances step by step

Here is a routine you can repeat every month. Once it becomes familiar, it often takes well under an hour.

Pull the report. Put budget, actual, variance amount and variance percentage side by side for the month and for the year to date.
Apply your threshold. Highlight only the lines that cross your materiality rule, for example a variance bigger than a set amount or a set percentage, whichever matters more for your size.
Start with the big picture. Look at total income, gross profit, total costs and net profit before diving into individual lines.
Explain each highlighted variance. Write one short sentence on the cause. Was it volume, price, timing, a one-off event or a coding error?
Decide what to do. For each one, choose: no action needed, update the forecast, or take a specific action with an owner and a date.
Check cash. Profit variances do not always match cash. Confirm the bank balance and upcoming payments still make sense.
Record and share. Save your notes with the report. If you have a business partner, a bookkeeper or a small team, share the main points.

Rule of thumb

Investigate the top 3 to 5

A practical rule of thumb: in a small business, focus each monthly review on the three to five largest variances. Smaller ones can wait unless they keep repeating.

BizTips rule of thumb

Finding the real reason behind a variance

The explanation is the most valuable part of the review. A variance with no reason attached teaches you nothing. Most causes fall into a handful of groups.

Volume

You sold more or fewer units, hours or projects than expected. Sales volume variances usually ripple into cost lines too: more sales mean more materials, shipping or contractor hours.

Price or rate

You sold at a different price than planned, perhaps because of discounts, or a supplier changed what they charge you. Separating volume from price is useful. If revenue is down, did fewer customers buy, or did the same number buy at lower prices?

Timing

The money arrived or left in a different month than planned. A client paid in April instead of March, or a quarterly bill landed earlier than expected. Timing variances often reverse on their own, so note them and check that they do.

One-off events

A broken machine, a legal bill or a surprise opportunity. These do not mean the budget was wrong, but ask whether something similar could happen again and whether you need a contingency line.

Errors

Miscoded transactions or missing entries. These are surprisingly common, and fixing them often makes a scary variance disappear.

Calculator placed beside an open laptop on a desk, ready for reviewing monthly budget numbers and spreadsheets — A laptop, a calculator and an hour of focus are all a monthly review really needs.

A copyable variance review template

Use this layout in any spreadsheet. The amounts are made-up examples for a small café, purely for illustration.

Line	Budget	Actual	Variance	Variance %	F / U	Reason	Action
Sales	$22,000	$19,800	-$2,200	-10%	U	Two rainy weekends cut foot traffic	No change; watch April
Food and drink costs	$6,600	$6,900	$300	5%	U	Dairy supplier raised prices	Get two new quotes by 15 April
Repairs	$300	$1,150	$850	283%	U	Espresso machine repair, one-off	Add maintenance line to forecast

The "F / U" column marks each line as favorable or unfavorable. The "Action" column is the one that makes the review worthwhile. If every row there says "none," either your plan was excellent or you are not asking enough questions.

Pro tip

Add a year-to-date block next to the monthly figures. A small variance every month can add up to a large one over a quarter, and a bad month followed by a good one may cancel out completely. Seeing both views stops you from overreacting or underreacting.

Example

Hannah runs a small online plant shop. Her February review showed shipping costs well above budget even though sales were on target. Digging in, she found two causes: more customers were ordering large pots, which cost more to send, and a courier had added a surcharge she had not noticed. She updated her shipping prices for heavy items and set a reminder to check courier terms each quarter. March shipping came in close to plan. (Hannah and her shop are made up for illustration.)

Turning variances into decisions

Once you know why a number moved, you have three broad choices.

Accept it. Some variances are noise or timing. Note them and move on.
Reforecast. If the cause will continue, such as a permanent price rise from a supplier, update your forecast for the rest of the year. Keep the original budget for comparison, but plan with the new reality.
Act. Change a price, renegotiate a contract, cut a cost, push harder on sales or delay a purchase. Give each action an owner and a date.

Many small businesses keep the original annual budget fixed and maintain a separate rolling forecast that changes each month. That way you can still see how far you have drifted from the plan, while making decisions based on the latest view.

Common mistake

Changing the budget every time actual results differ. If you keep rewriting the plan to match reality, variances vanish and so does the learning. Leave the budget alone and use a forecast for updates.

A quick note: this guide is general information about budgeting and financial review, not accounting or tax advice. If variances point to bigger questions about pricing, borrowing or cash, a qualified accountant or bookkeeper can help you interpret them.

Your monthly variance review checklist

Phase your annual budget by month to match your seasonal pattern
Close the month: reconcile accounts and enter every invoice and bill
Set a materiality threshold for which variances to investigate
Run the budget vs actual report for the month and the year to date
Explain the top three to five variances in one sentence each
Choose accept, reforecast or act for each one
Assign owners and dates to every action
Book next month's review in your calendar

Frequently asked questions

What counts as a significant variance?

It depends on your size. Many small businesses use a combined rule, such as investigating anything over a fixed amount or a fixed percentage. Choose a threshold that keeps the list short enough to handle in one sitting, and adjust it if you find yourself chasing tiny differences.

Should I review variances weekly instead of monthly?

For most small businesses, monthly is the right rhythm because it lines up with your bookkeeping close. You can still glance at sales and cash weekly, but a full variance review on unreconciled data often wastes time on errors.

What if I do not have a budget yet?

Start with a simple one for the rest of this year. Use last year's actual figures as a base, adjust for known changes and phase it by month. Even a rough budget makes your monthly review far more useful than having none.

How is a variance review different from a forecast?

A variance review looks back and compares results with the plan. A forecast looks forward and predicts what will happen next. The two work together: what you learn in the review should feed directly into your updated forecast.

The bottom line

A budget only earns its keep when you compare it with reality. Each month, close your books, line up budget and actual side by side, pick the few variances that matter, find the real reason and decide what to do. Keep your original budget fixed and let a rolling forecast carry the updates.

Try it this week with your February numbers, then again in early April with March. After two or three rounds the review will feel routine, and you will start catching problems while they are still small and cheap to fix.