Budget vs Actual Report: How to Read It and What to Do Next

Most small-business budgets die in February. They get built with real care in December, saved to a spreadsheet, and never opened again — because nobody set up the one report that makes a budget useful. A plan you never compare against is just a wish with a total at the bottom.

That report is the budget vs actual report, and it is the subject of this guide: what goes into it, how to calculate each variance, how to tell a genuine cost problem from a simple drop in sales, what deserves investigation, and how to turn the numbers into decisions. One example runs throughout — Cedar Ridge Landscaping, and an August that did not go to plan.

What Is a Budget vs Actual Report?

It is a comparison of your plan with your results for the same period, account by account. Each row is a line from your profit and loss statement; the columns are the budgeted amount, the actual amount from your books, the dollar variance and the percentage variance. Some versions add a year-to-date block alongside the month, which is where the more reliable signals live.

The report does not tell you what went wrong. It tells you where to look. That distinction matters, because the most common mistake with a budget variance analysis is treating every red number as a failure rather than as a question.

How do you calculate budget variance?

Two formulas cover it:

• Dollar variance = Actual − Budget
• Percentage variance = Dollar variance ÷ Budget

Cedar Ridge budgeted $2,400 of fuel for August and spent $3,150. The variance is $750, and $750 ÷ $2,400 = 31.3% over budget. Simple — but the sign needs interpreting, which is where the next idea comes in.

What is a favorable vs unfavorable variance?

A favorable variance helps profit compared with the plan: revenue above budget, or an expense below it. An unfavorable variance hurts profit: revenue below budget, or an expense above it. Because a positive number means opposite things on revenue and expense lines, label every variance F or U rather than relying on plus and minus signs. It saves a surprising amount of confusion in the review meeting.

A Worked Budget vs Actual Report

Cedar Ridge is a four-crew landscaping company. Its August budget expected $62,000 of revenue and $13,300 of net income. Then it rained for eleven days. Here is the report:

Read top to bottom, the story looks straightforward: sales were down, most costs were up, and profit fell by two-thirds. Materials look like the one bright spot — $1,700 under budget. That last conclusion is wrong, and seeing why is the most useful skill in budget vs actual analysis.

Static vs Flexible Budget: Separate Volume From Performance

The budget above is a static budget: it was set in advance for $62,000 of work and never adjusted. But some costs are supposed to move with sales. Cedar Ridge plans materials at 30% of revenue. Comparing a $62,000 materials plan against a $55,200 month is comparing two different businesses.

A flexible budget restates the variable lines at the volume you actually achieved. At $55,200 of revenue, 30% is $16,560 of materials. Against that figure, the actual $16,900 is $340 unfavorable, not $1,700 favorable. The crews used slightly more material per dollar of work than planned — a small problem hiding inside an apparently good line.

How do you split the profit miss into volume and spending?

Every dollar of revenue Cedar Ridge lost would have carried 70 cents of contribution after materials. So the lost $6,800 of sales explains $4,760 of the profit shortfall on its own — that is the volume variance, and it is mostly weather. The rest is spending variance: things the business did differently from plan.

Now the owner has two separate conversations. One is about the weather and whether the pipeline can recover the lost jobs in September. The other is about $4,070 of spending that the rain does not explain — wages that rose while hours of billable work fell, and a repair bill more than double the plan. The contribution margin from break-even analysis is exactly the tool that makes this split possible.

A static budget tells you that you missed. A flexible budget tells you whether it was the market or the business.

Which Variances Should You Investigate?

Not every line deserves a meeting. Set an investigation threshold in advance so the review is consistent month to month.

What budget variance percentage is acceptable?

There is no universal figure, but a two-part rule works well for most small businesses: investigate any line that misses by more than 10% and more than $500. The percentage filters out ordinary noise on large lines; the dollar floor stops a $40 overage on bank fees from eating ten minutes. Always review revenue and net income regardless.

Applied to Cedar Ridge, the rule flags revenue, fuel and equipment repairs. It does not flag crew wages, at 6.7% — yet $1,400 is the second-largest spending miss on the page. That is the weakness of any threshold, and the reason to read the dollar column with your own eyes before closing the report.

What should you do with each flagged line?

1. Check the posting first. A surprising share of variances are bookkeeping, not business: a bill coded to the wrong account, a quarterly insurance premium landing in one month, an expense recorded twice. Drill into the transactions before drawing conclusions.
2. Identify the cause. Cedar Ridge’s repair variance was a mower transmission — a one-off. Its fuel variance was crews driving between rescheduled jobs — a pattern that will recur whenever it rains.
3. Decide: act, accept or re-plan. Fix what is controllable (route planning for rain days), accept what is genuinely one-time, and note anything that means the original budget assumption was simply wrong.

How to Build a Budget Worth Comparing Against

A budget vs actual report is only as useful as the budget behind it. Four habits make the difference:

• Budget by month, not by year divided by twelve. A landscaper, a retailer or a tax practice has a seasonal year. An even split guarantees meaningless variances in every month and hides the real ones.
• Start from last year’s actuals by account. Your prior-year profit and loss, month by month, is the best first draft. Then adjust for what you know is changing: a price increase, a new hire, a lease renewal.
• Budget at the level of your chart of accounts. If the budget uses different categories from your books, every comparison needs a translation step. A clean chart of accounts is the foundation.
• Match the accounting basis. A budget built on accrual assumptions compared against cash-basis actuals will show timing variances every single month.

How often should you run a budget vs actual report?

Monthly, as a step in your month-end close — after the bank reconciliation and adjusting entries, never before. On unclosed books you are comparing the plan with incomplete numbers, and the variances evaporate a week later. Look at the single month for early warning and at year-to-date to confirm whether a trend is real.

Budget vs forecast: what is the difference?

The budget is the plan you committed to at the start of the year; leave it alone so it stays a fixed yardstick. A forecast is your current best estimate of how the year will end, updated as things change. If August’s rain makes the annual revenue target unreachable, don’t rewrite the budget — update the forecast, and keep measuring against the original plan. For the cash side of that estimate, see our guide to building a cash flow forecast.

Five Ways Budget vs Actual Reviews Go Wrong

1. Running the report once a year. By December every variance is history. The value is in catching a trend in March.
2. Judging variable costs against a static budget. It rewards teams for low sales and punishes them for high ones.
3. Reading only the percentage column. Small lines produce huge percentages; big lines hide expensive misses under modest ones.
4. Rewriting the budget to make the variances go away. Re-forecast instead, so there is still something honest to measure against.
5. Skipping the root cause. Noting that fuel was over budget, every month, without ever asking why, is a report nobody is actually reading.

How BizBooks Pro Handles Budget vs Actual

• Budget Manager lets you set a budget for each income and expense account by month, quarter or year, aligned to your fiscal year.
• A variance report built from your posted ledger shows budget, actual, dollar variance and percentage variance for every budgeted account — no exporting to a spreadsheet and no copy-paste errors.
• Traffic-light status on every line: expense lines show on track, approaching (within 10% of budget) or over; revenue lines show whether you’ve reached the target.
• A real double-entry general ledger underneath, so the actuals are the same numbers your financial statements report, and you can drill into any account to see the transactions behind a variance.
• Multiple budgets with draft, active and closed status, so this year’s plan, next year’s draft and last year’s record can sit side by side.

Frequently Asked Questions

What is a budget vs actual report?

A budget vs actual report lists each income and expense account with the amount you planned for a period, the amount your books actually recorded, and the difference in dollars and as a percentage. It shows where the business is ahead of or behind its plan, so you can investigate the lines that moved and act while there is still time in the year to respond.

How do you calculate budget variance?

Subtract the budget from the actual amount to get the dollar variance, then divide the variance by the budget for the percentage. If fuel was budgeted at $2,400 and actual fuel was $3,150, the variance is $750, and $750 ÷ $2,400 is 31.3% over budget. Label each variance favorable or unfavorable, because the sign means opposite things for revenue and expenses.

What is the difference between a favorable and an unfavorable variance?

A favorable variance improves profit compared with the plan: revenue above budget, or an expense below it. An unfavorable variance reduces profit: revenue below budget, or an expense above it. Favorable isn’t automatically good news — an expense under budget because a planned marketing campaign never ran is favorable on paper but may cost sales next quarter.

What budget variance is acceptable before I should investigate?

There’s no universal rule, but many small businesses use a two-part threshold, such as investigating any line that misses by more than 10% and more than $500. The percentage filters noise on large lines; the dollar floor keeps tiny accounts from demanding attention. Always review total revenue and net income regardless, and scan the dollar column for large misses that fall under the percentage.

How often should a small business run a budget vs actual report?

Monthly, as part of the month-end close, once bank accounts are reconciled and adjusting entries are posted. Running it on unclosed books compares the budget with incomplete numbers, producing variances that vanish a week later. Review both the single month and year to date: one month can mislead through timing, while year to date shows whether a trend is real.

What is the difference between a budget and a forecast?

A budget is the plan you commit to at the start of the year and usually leave unchanged, so it works as a fixed yardstick. A forecast is your latest estimate of how the year will actually end, updated as conditions change. Most businesses keep both: the budget to measure performance against the original plan, and a rolling forecast to manage cash and decisions.

The Bottom Line

A budget vs actual report turns a plan into a management tool. Calculate each variance, label it favorable or unfavorable, and flex the variable lines for the volume you actually achieved — because until you separate what the market did from what the business did, you can’t fix either.

Cedar Ridge couldn’t stop the rain. But it could plan rain-day routes, look hard at why wages rose while billable hours fell, and see a repair bill for what it was. That is what the report is for: not to grade last month, but to change next month.

Related Articles

• Break-Even Analysis for Small Business: The Formula, Worked Step by Step
• How to Read a Profit and Loss Statement: A Small Business Owner's Guide
• How to Build a Cash Flow Forecast for a Small Business (The 13-Week Method)
• The Month-End Close Checklist for Small Business (8 Steps, In Order)
• Financial Ratios for Small Business: The 8 Numbers That Show If You're Healthy
• Job Costing for Small Business: How to Know Which Jobs Actually Make Money