Budget vs Actual: How to Run the Report

By Jake McKenna, FounderPublished 2026-10-17Last reviewed 2026-10-19

Budget vs actual or actual vs budget: is there a difference?

No. The two phrases describe the same report. People tend to say "budget vs actual" when they are thinking of the plan first, and "actual vs budget" when they are thinking of the results first. The columns can sit in either order.

What does matter is that the report always has the same three ingredients:

• Budget: the plan for the period, set before it started.
• Actual: what the books show for the same period, taken from your profit and loss statement.
• Variance: actual minus budget (or budget minus actual, as long as you pick one rule and keep it).

If you are new to the profit and loss statement the actuals come from, read how to read a profit and loss statement first. The budget vs actual report is only as good as the books behind it.

How do you run a budget vs actual report?

Here is the process in plain steps. It works in a spreadsheet. Many accounting packages offer a budget comparison report; check what your plan includes.

1. Set the budget by line. Use the same account names as your profit and loss statement, or the comparison will not line up. Break the year into months.
2. Close the month first. Do not run the report on books that are still being tidied. Bank accounts should be reconciled, bills and invoices entered, and obvious miscodings fixed. A report on unfinished books is a guess.
3. Pull the actuals for the same month and the year to date.
4. Calculate the variance for each line, in money and as a share of the budget.
5. Mark the variances that matter. Pick a rule, for example "anything over a set share of budget and over a set amount of money", and apply it every month. Small lines with large percentage swings are usually noise.
6. Write a one-line reason for each flagged variance. "Higher materials cost because the supplier raised prices" is useful. "Over budget" is not.
7. Decide what changes. A variance with no decision attached is trivia.

Budget vs actual: a worked example

Here is an invented small business to show how to read the output. The numbers are illustrative only.

Example (illustrative numbers only): one month for a small landscaping company.

Reading it top down: revenue is the main story. The shortfall explains most of the profit gap, and labor came down with it, which softened the blow. Materials and fuel are small overruns worth a note but not a panic. The marketing line is exactly on plan and needs no discussion.

Notice the sign convention. On revenue, a negative variance is bad. On costs, a negative variance is good. That trips people up. Many reports add a "favorable" or "unfavorable" column so nobody has to work it out.

What is the difference between budget, forecast and actual?

This is the question behind "budget vs forecast vs actual", and it is worth getting straight.

The budget is the yardstick. The forecast is the current expectation. The actual is the result. Keeping the original budget unchanged is what lets you see how far reality has drifted from the plan. If you rewrite the budget every time results miss it, the report will always look fine and tell you nothing.

A common healthy routine is three columns side by side: budget, latest forecast, and actual. It shows both "how far from the plan" and "where are we heading now". For a plain introduction to the forecasting side, see forecasting and cash flow planning.

How do you read a variance?

Ask four questions about each flagged line.

• Is it timing or permanent? A bill that landed a month early will reverse. A price rise will not.
• Is it volume or rate? Spending more because you did more work is different from paying more for the same work.
• Is it one-off or recurring? A one-off repair is not a trend.
• Does it connect to another line? Revenue and labor, sales and commissions, and stock and cost of goods usually move together.

Then tie the variance to cash. A profit shortfall and a cash shortfall are not always the same problem. See profit vs cash flow for why.

What is "budget vs actual cost"?

In project-based and construction work, the phrase means the budgeted cost of a job against the cost actually incurred so far. The idea is identical: planned against real, line by line, with a reason for each gap. For a business with jobs, run the report per job as well as for the company as a whole, so a loss-making job does not hide inside a healthy total.

Mistakes that make the report useless

• Budget set once and never looked at. The report has to be run monthly to be of any use.
• Accounts that do not match. If the budget has ten lines and the books have forty, the comparison will not work. Align the chart of accounts.
• Running it before the books are closed. Variances will be mostly errors.
• Too many lines. Focus on the lines that move profit.
• No owner for each line. Someone should be answerable for explaining a variance.
• Changing the budget to match results. Use a forecast column instead.
• Ignoring favorable variances. A big favorable swing can mean income booked early or a cost missed.

Who should build and review it?

If you have a bookkeeper who keeps the books current and you are comfortable setting a simple budget, you can run this yourself. If you want help running it each month and turning the variances into decisions, that is budget vs actual and management reporting work within a fractional controller engagement. Budget development and forecasting sit with the fractional CFO service. Both run on a monthly reporting cycle. The books underneath come from a steady bookkeeping routine, and we can work in QuickBooks or Xero.

It is not worth paying for a monthly budget review if your business is very small and stable, with a handful of costs that barely change. A quarterly look at the profit and loss statement may be enough. It starts to pay off when costs are varied, you have people or stock, or you are making decisions on pricing and hiring.

English Oak's controller service starts at $1,500 a month, as one fixed monthly fee, custom to the business. The pricing page explains how that works. This is general information, not tax or investment advice, and English Oak does not prepare tax returns, audit or give investment advice. For related measures, see KPIs for small business and what is management reporting.

New to a term used here? Our small business finance glossary defines it in plain English.

Related pages

• How to Read a Profit and Loss Statement
• KPIs for Small Business Owners
• Are Cash Flow and Profit the Same?
• What Is Management Reporting?