Tracking categories: divisional reporting without the mess

Jamee White, CPA5 min read

Picture two divisions in the same Xero file, one clearly turning a profit, one quietly bleeding, and a profit and loss that can't tell you which is which because everything sits in one undivided column. Tracking categories exist to fix exactly that: they tag a transaction with a dimension such as location, division or income stream, so you can run a report for each slice of the business without cloning your entire chart of accounts. Xero gives you two active categories per organisation. Used with discipline they change what you can see. Used loosely, they produce data nobody trusts.

What the categories are actually for

Every transaction already answers one question in Xero, through the account it's coded to: what was the money for. Tracking categories answer a different question entirely: which part of the business does it belong to. One rent account tagged by location gives you rent per site. One sales account tagged by division gives you revenue per division. The chart of accounts stays small, and the report gains a whole extra dimension for free.

Because you only get two active categories, choosing them is a genuine design decision, not an afterthought. Pick the two dimensions that actually drive decisions in your business, not the two that merely seem interesting. For most businesses that lands on some combination of location, division, service line or salesperson.

Setting them up well

  • Keep each option list short: five to ten options stays manageable, thirty options more or less guarantees miscoding
  • Name the options so the right one is obvious even to a staff member with none of today's context
  • Add a deliberate overheads or shared option, so costs that genuinely belong to no single division have a proper home rather than a random one
  • Decide upfront which account types get tagged: revenue and direct costs at minimum, overheads only if you plan to allocate them honestly
  • Build the category into bank rules and repeating invoices so routine transactions arrive already tagged, with nobody having to remember

The human problem, not the technical one

Tracking categories rarely fail on setup. They fail on discipline. A divisional profit and loss where a fifth of expenses sit untagged is worse than no divisional report at all, because it looks authoritative while quietly lying. Untagged transactions fall out of every column, which flatters whichever division someone happens to be worried about that month.

The fix is a small monthly habit: run the profit and loss with the category as columns, and look straight at the unassigned column. Chase it to zero, or to a small deliberate overheads figure, before anyone reads the report as fact. Five minutes keeps the whole thing honest.

Tracking categories versus projects and apps

Tracking categories suit stable, ongoing dimensions: sites, divisions, income streams that stick around. They suit short lived jobs poorly, because every finished job leaves a dead option cluttering the list. For per job margins, quoting against actuals or time tracking, a purpose built project tool inside the Xero ecosystem does the job properly and keeps your categories clean for the bigger structural view.

Getting the structure right

We treat tracking categories as part of the file's architecture: chosen once, chosen well, then enforced by automation plus a human checking the unassigned column every month. If your divisional numbers never quite add up, or you suspect a whole part of the business is invisible in Xero, our Strategic Finance Review is a sensible place to start.

Quick answers

Two active categories per organisation, each holding as many options as you need, though additional categories can be archived and swapped in if your needs change.

This article is general information for Australian businesses, current at the published date. It is not financial, tax or legal advice. Speak to a registered agent or adviser about your circumstances before acting.

Jamee White, CPA, founder of NextEra Bookkeeping

Jamee White, CPA

Founder of NextEra Bookkeeping. Jamee leads a team supporting established Australian businesses with strategic bookkeeping, reporting, payroll and Xero, and is a multiple national awards finalist across bookkeeping and finance.

Book a Strategic Finance Review