xero budgeting departments tracking-categories how-to

How to Create a Xero budget rollup by department

May 8, 2026 4 min read

Most growing finance teams reach the same fork in the road: the company is big enough that one combined budget no longer answers the questions managers ask. Sales wants its own budget. Operations wants its own. The CFO still wants a single number for the board.

In Xero, the answer is to budget at the department level using tracking categories — and then build a rollup to get back to a single company-wide budget. This post walks through how that's structured, how to report on it, and the gap you'll hit when you want a true rollup.

The Xero structure

Departmental budgeting in Xero rests on three pieces:

A tracking category — typically named Department (Xero allows up to two tracking categories per organisation).
A tracking option per department — e.g., Sales, Marketing, Operations, Finance.
A tracking budget per option — one budget for each department.

Once each transaction is coded with its department on entry, every line item flows naturally into the right departmental P&L.

Setting up the categories

In Settings → Tracking Categories, create a category called Department and add an option for each cost centre.

A few rules of thumb that pay off later:

Use stable names. Renaming a tracking option later doesn't break history, but it does break any saved reports filtered on the old name.
Keep the list short. Five to ten departments is plenty; once you go past 15 you're effectively building a second chart of accounts.
Don't double-up. If a transaction belongs to multiple departments, split the line at entry rather than picking one and adjusting later.

Building each department's budget

Inside Reports → Budget Manager, click New Budget and select your Department category, then the specific option (e.g., Sales). Xero gives you a familiar grid: accounts down the side, months across the top.

This is where you'll spend most of the setup time:

Decide your account granularity. A revenue-heavy department like Sales might budget at the account-code level for revenue lines and roll up expenses to the parent. An admin function might do the opposite.
Use the Apply Formula tool. The green arrow next to each cell opens a small dialogue with three options: apply a fixed amount to each month, adjust by amount each month, or adjust by percentage each month. Click the green arrow next to a month header instead of a cell to apply the same formula across every account at once — much faster than typing 12 cells per row.
Save often. Xero's budget grid does not autosave.

Repeat for each department. Save every one before you walk away.

Reporting on departmental budgets

Once budgets and actuals are coded by tracking option, two reports do most of the work:

Budget Variance — pick a tracking budget at the top of the report to see actuals vs. budget for that one department.
Profit & Loss (with tracking) — add columns by tracking option to see all departments side-by-side, including totals.

The P&L view will show you a total column of actuals across all departments. What it won't show you is a total column of budget across all departments — because Xero stores each tracking budget independently and there's no native "Sum of all tracking budgets" field.

That gap is the rollup problem.

The rollup gap

Here's the situation in plain terms: Xero will happily sum your actuals across departments, but it will not sum your budgets across departments. If your CFO asks "what's the company budget for Q3?" and you've only built departmental tracking budgets, the only Xero report that gives them a number is the one that compares actuals to whichever single budget is selected at the top — typically the Overall Budget, which you may not have populated.

There are two ways out:

Option 1: Maintain a parallel Overall Budget

Update the Overall Budget every time a tracking budget changes, keyed off the sum of all departments. This is easy in concept and brittle in practice — every department reforecast means re-summing, re-importing, and hoping no one is editing simultaneously.

Option 2: Build the rollup outside Xero

Export each tracking budget from Xero, sum them in Excel, and import the consolidated total back into the Overall Budget. This is the workflow we describe in detail in How to consolidate tracking category budgets in Xero.

Either way, the rollup ends up living in the Overall Budget, which is the only place Xero will report against on a true company-wide basis.

Practical tips

A few things we've seen save teams real time:

Lock down account codes before you build the budget. Adding a new account in month four means revisiting every department's budget.
Standardise revenue recognition. If two departments split shared revenue, agree on the split rule before budgeting — otherwise the rollup double-counts (or misses) the same dollar.
Reforecast on a cadence. Quarterly is enough for most teams.

Automating the rollup

Budget Consolidator is built for exactly this — pulling every tracking budget directly from Xero's API and producing a consolidated import file you can drop straight into the Overall Budget. If you're running monthly or quarterly reforecasts across more than a handful of departments, automating the rollup pays for itself almost immediately.