ClosePack logo
ClosePack
ClosePack blog

How to build a budget vs actual report your small business clients will use

By Praveen Doddamani · 2026-11-02

A profit and loss statement tells a client what happened. A budget vs actual report tells them whether that was what they expected. For many small business owners, that second question is the one they actually care about, and it is one of the simplest ways to make a monthly report feel useful rather than routine.

This post walks through how to set up a budget vs actual report for small business clients: getting a workable budget in place, picking the right level of detail, explaining variances in plain language, and presenting it so the client reads it.

Why budget vs actual is worth adding to a monthly pack

Most owners do not think in terms of gross margin or operating expenses. They think "I expected a good month and it felt slow" or "we spent more on the van than I planned". A budget vs actual report puts their own expectations next to the real numbers, so the conversation starts from something they already have in their head.

It also changes what your commentary can say. Without a budget, you can only compare this month to last month or to the same month last year. Those comparisons are useful, but they do not account for plans the owner made: a new hire, a price rise, a slow season they knew was coming. A budget captures those plans, so a variance means something.

Start with a budget the client will recognise

The most common reason budget vs actual reports fail is that the budget was never realistic in the first place. A spreadsheet built once in January and never revisited quickly becomes noise. A few habits help:

Both QuickBooks Online and Xero let you enter a budget and run a budget vs actuals style report, so you do not necessarily need a separate tool. Many bookkeepers still keep the working budget in a spreadsheet and load it in once agreed. Either way, the important part is that the client has seen and agreed to the numbers.

Choose the right level of detail

A budget vs actual report for a small business client should fit on one page. A practical layout is:

  1. Summary lines: total revenue, gross profit, total operating expenses and net profit, each with budget, actual and the difference.
  2. Month and year to date: one column set for the month and one for the year so far. A single bad month matters less if the year is on track.
  3. Grouped expenses: a few meaningful categories, such as staff, premises, vehicles, marketing and software, rather than thirty individual accounts.

Show the variance both as an amount and, where it helps, as a percentage. Percentages are misleading on small lines; a 200% overspend on a line budgeted at a small amount may not deserve attention, while a 5% shortfall in revenue might. Use your judgement about which to highlight.

If you are deciding which other figures belong alongside it, we covered that in which KPIs to include in a monthly client report.

Explain variances, do not just list them

The table shows what is different. Your commentary should explain why, and whether it matters. A useful way to sort variances is into three groups:

Keep the explanation in plain language and tied to things the owner knows: "Revenue was below budget because the Henderson project slipped into next month" is more useful than a percentage. If you do not know the cause, ask rather than guessing. That commentary is where your knowledge of the client shows, and it should stay in your own words; we wrote more about that in keeping your voice in management accounts commentary.

Presentation tips that make it readable

Revisit the budget during the year

A budget is a plan, not a promise. When something significant changes, such as a new location, a lost contract or a big price change, it is reasonable to agree a revised forecast with the client. Some bookkeepers keep the original budget and add a reforecast column so the owner can see both. That is a scoping decision: re-forecasting takes time, and it is fair to price it as part of an advisory or management accounts engagement rather than absorb it into the monthly fee.

A simple starting point

If you have never offered budget vs actual reporting, try it with one or two clients who already ask "how are we doing?" every month. Agree a simple budget, add one page to their monthly pack, and write two or three sentences on the variances that matter. You will quickly learn whether it helps the conversation, and the clients who value it are often the ones most open to a broader management accounts service.

Where ClosePack fits

ClosePack is in its founding pilot: it turns a QuickBooks Online or Xero export into a branded monthly client PDF with KPIs, trends and draft commentary you edit and own. It is early and deliberately narrow. If that sounds useful, have a look at the sample pack or request a founding spot.

Request a founding spotSee the Harbor Bike Co sample

Related reading