Xero Budget Manager: How to Build a Budget That Actually Gets Used
Sophie Chen
Head of Content at SortBooks
In this article
Why Most Xero Budgets Fail
Budget Manager sits in Xero under Accounting, then Reports, then Budget Manager. It is not hidden and it is not hard to use. Yet in most files it holds either nothing at all or a single budget somebody built during onboarding and never touched again.
The reason is almost never the tool. It is that the budget was built as a compliance exercise rather than as a decision tool. A budget nobody compares against is just a spreadsheet with better formatting.
A budget earns its place when it does two things. It tells you before the money is spent whether the spend is inside plan, and it tells you at month end where reality diverged and why. Everything below is aimed at that outcome.
Setting Up Your Overall Budget
Xero gives you one Overall Budget plus as many additional budgets as you need. Start with the overall.
Step 1: Import Last Year Rather Than Starting Blank
In Budget Manager, choose your date range and set the period. Xero can pre populate each account line from actuals for the equivalent prior period. Do this. Starting from real numbers is faster than starting from a blank column and dramatically more accurate, because your actuals already contain the costs you would have forgotten.
Step 2: Choose a Sensible Period Length
Monthly is the default and the right answer for most businesses. Quarterly budgets hide too much, and they are useless if you want to spot a problem in week six rather than week fourteen. If your business is seasonal, monthly is not optional. An even twelfth of annual revenue is a fiction that will make eight months look like failure and four months look like triumph.
Step 3: Adjust Line by Line, Not by Percentage
The temptation is to take last year and add ten per cent across the board. Resist it. Your rent is contracted and known. Your insurance renews on a date you can look up. Your software subscriptions are visible in your own bank feed. Your wages depend on headcount decisions you have already made or are about to make.
Work through the profit and loss accounts in order and set each one deliberately. Known and contracted costs get exact figures. Variable costs get a percentage of forecast revenue. Genuinely uncertain lines get a considered estimate that you note somewhere.
Step 4: Use the Adjustment Tools
Xero lets you apply a change across a row rather than typing into every cell. Select a cell, enter your figure, then use the adjustment options to apply a fixed amount or a percentage increase across the remaining months. This is where a twelve month budget goes from an hour of typing to about fifteen minutes.
Tracking Category Budgets
This is the feature that turns Budget Manager from adequate into genuinely useful, and it is the one most businesses never touch.
If you use tracking categories in Xero for locations, departments, service lines or job types, you can build a separate budget for each tracking option. A cafe group can budget each site independently. A trades business can budget commercial work separately from residential. A professional services firm can budget by service line.
The value is that variance becomes attributable. An overall budget tells you that materials costs ran fifteen per cent over. Tracking category budgets tell you that one site or one job type caused all of it while everything else ran to plan. Those are completely different management conversations.
To set one up, create an additional budget in Budget Manager and select the tracking category and option it applies to. Build it the same way as the overall budget.
One caution: tracking category budgets do not automatically sum to your overall budget. If you build both, reconcile them deliberately or you will end up quoting two different numbers in the same meeting.
Reporting Against the Budget
A budget that is never compared to actuals is decoration. There are two reports that matter.
Budget Variance report. Found under Reports, this shows budget, actual and variance side by side for each account, in both dollars and percentage terms. Run it monthly, on the same day each month, as part of a fixed routine.
Budget Summary report. This shows the budget itself across periods without actuals. Useful for circulating the plan, less useful for management.
When you run the variance report, do not read every line. Set a threshold, for example any account varying by more than ten per cent or more than one thousand dollars, and investigate only those. Chasing a forty dollar variance on stationery is how people learn to hate month end.
Making It Survive Contact With Reality
Do not rewrite the budget every time you miss it. A budget that moves to match actuals measures nothing. Keep the original and let the variance stand as information.
Do reforecast deliberately. Once or twice a year, or when something genuinely structural changes such as losing a major client or opening a second site, build a new budget rather than editing the old one. Xero lets you hold multiple budgets, so keep the original for reference.
Accuracy in equals accuracy out. A variance report is only as good as the categorisation underneath it. If half your expenses are sitting in a general or suspense account because nobody has categorised them, the report will show apparently perfect performance on every budgeted line and a large unexplained lump elsewhere. Keeping categorisation current as transactions arrive is exactly the problem SortBooks solves on top of your Xero file, and it is a prerequisite for budgets that mean anything.
A Realistic Monthly Routine
Reconcile the bank. Confirm categorisation is complete for the month. Run the Budget Variance report. Investigate the three or four lines that breached your threshold. Write two sentences on each. Decide whether anything needs to change next month.
That is twenty to thirty minutes. It is also the difference between finding out about a cost problem in month two and finding out about it at year end.
Ready to automate your bookkeeping?
SortBooks connects to Xero and categorises your transactions automatically. Start your 14-day free trial today.
Start 14-Day Trial