Skip to content

Blog

Budget against actual, every month, without rebuilding the spreadsheet

On this page
  1. Why budget against actual breaks
  2. Build the workbook once
  3. Map each line once
  4. Show the board two lines, not forty
  5. When the plan changes
  6. How Stratavor does it
  7. Frequently asked questions

The short answer. Build the budget workbook once, in a shape that maps cleanly: one row per line, one column per month, totals clearly labelled. Map each line to your chart of accounts once, deciding only the doubtful lines by hand. Then show the board operating profit against plan and the two lines that explain the gap, usually gross profit and overheads. Stratavor's Budgets do the mapping for you: they take the workbook as it is, with no template, and ask only about the lines they cannot place with confidence.

The budget took weeks to build. Then it went back into a spreadsheet, and every month someone copies the actuals across to find out how the month did. The work is the same every month, it is easy to get wrong, and by the time it is finished the month is half over.

Why budget against actual breaks

Three things go wrong, month after month.

  • The budget and the books are in different shapes. The budget follows the lines the team planned in; the books follow the chart of accounts.
  • Lines are mapped from memory. "Consultancy (misc.)" could be 6200 Professional fees or 6210 Consultancy fees, and the answer changes with whoever does the copying.
  • Totals get counted twice. A workbook full of subtotals is easy to read and easy to add up wrongly.

Build the workbook once

A budget maps cleanly when the workbook follows a few habits. None of them needs a template.

  1. One row per line and one column per month.
  2. The same name for the same line on every sheet.
  3. Totals and subtotals left in place and clearly labelled, so they can be recognised and left out.
  4. No merged cells in the rows and columns that hold figures.
  5. One live version for the year, replaced when you reforecast rather than kept beside it.

Map each line once

Map every budget line to an account once, when the budget is loaded, and record the decision. Most lines map themselves: "Sales: components" is 4000 Sales, components. A few need a person to decide, and those are the only ones worth a person's time. Once a line is mapped, every month after uses the same mapping.

Show the board two lines, not forty

A board does not need forty variances. It needs to know whether profit is on plan and, if not, which lines explain the gap. For most businesses those are gross profit and overheads.

Company A, a fictional company, made €139,000 of operating profit in October against €149,000 in its budget.

LineBudgetActualAgainst plan
Gross profit€739,300€707,400−€31,900
Overheads€590,300€568,400€21,900 under
Operating profit€149,000€139,000−€10,000

Gross profit was €31,900 short because revenue came in €78,000 under budget and margin 0.1 points under. Overheads were €21,900 under budget, which won back most of it. That is the month in two lines, and every figure in it can be traced to the budget and the ledger.

When the plan changes

Reforecasts are part of the year. Replace the live budget in one step, keep the old one live until the new one is ready, and keep a record of who changed what and when, so a comparison made in March can still be explained in October.

How Stratavor does it

Stratavor's Budgets take the workbook you already keep, as it is: Excel or CSV, up to 25 MB, with no template. Stratavor finds the months, leaves totals and subtotals out and maps each line to your chart of accounts. It asks only about the lines it cannot place with confidence, with the most likely accounts first.

Within about a minute of the last line being mapped, your Financial Snapshot sets every month against plan, and Ask Stratavor answers questions against it. A reforecast replaces the live budget in one step, and every change is recorded in an audit trail.

Budgets come with Growth and Enterprise. Compare the plans, or start a 7-day free trial of Essentials with no card needed.

Frequently asked questions

Can I use the budget spreadsheet I already have?

Yes. Stratavor reads common layouts directly, including months in columns, accounts in rows, summary sheets and formula-driven cells. No template is needed.

What if my budget lines do not match my chart of accounts?

Stratavor maps each line to an account and asks only about the lines it cannot place with confidence, offering the most likely accounts first. A line that should not count can be skipped.

How do I handle a reforecast?

Upload the new workbook and replace the live budget in one step. The old budget stays live until the new one is ready, and the change is recorded.

Which plans include Budgets?

Growth and Enterprise. The 7-day free trial is of Essentials, so it does not include Budgets.

The Stratavor digest

One email a month. Worth opening.

Decoded films on real companies' results, short films on how businesses make and lose money, and guides on customers, competitors, risk, cash and the board pack. No sales emails.

By subscribing you agree to receive the monthly Stratavor digest. Unsubscribe at any time from any email. Privacy policy.

Then read your own numbers.

Talk to us about what Stratavor would tell you about your own business.

7-day free trial. No credit card required.