ConsoHQ

Xero tracking categories across multiple organisations

How they work, where they stop, and how to report on them across a group.

Quick answer

Xero tracking categories let you tag transactions by department, location, project or any other dimension, then filter reports by them. Each organisation can have two active tracking categories, and Xero suggests about 100 options per category. Each transaction line can carry one option from each category. Tracking categories don't carry across organisations, so a group that tracks the same regions or departments in several companies needs a spreadsheet or an app such as Joiin to report on them together.

Key takeaways

What tracking categories are for

Your chart of accounts answers "what kind of income or cost is this?" Tracking categories answer a second question: "which part of the business does it belong to?" A restaurant group might track by site. A consultancy might track by service line. A charity might track by fund. Add the right tracking option to each invoice, bill or journal line, and Xero can show a profit and loss for each part of the business without separate accounts for every combination.

Used well, they're one of Xero's most valuable features. Used badly, they produce reports nobody trusts.

The limits you need to know

Xero tracking category limits
LimitDetailWhat it means in practice
Active categoriesTwo per organisationChoose your two dimensions carefully, such as region and department
Options per categoryAbout 100 is Xero's suggested limitReports can slow down beyond that; don't use tracking for every project
Per transaction lineOne option from each categoryA line can't be split between two departments; split the line instead
Across organisationsNot sharedEach organisation keeps its own list
Balance sheetMainly a P&L toolDon't expect a balance sheet by department

Designing tracking categories that work

Pick dimensions you'll report on every month. Two categories goes quickly. Region and department are the most common pair. Projects with a defined end usually fit better in Xero Projects (on the Ultimate plan in the UK) or a separate tool than in tracking.

Keep options few and stable. Ten clear options beat 80 overlapping ones. Use "Online", "North" and "South", not "Online 2024", "Online new" and "Online - old".

Use identical names across organisations. If you'll ever want group reporting by region, "North" must be spelled the same in every organisation. This one habit makes cross-organisation reporting easy later.

Decide who tags what. Write a one-page rule: which transactions are tracked, by whom, and what happens to shared costs such as rent or software.

Archive, don't delete. When an option is finished, archive it to keep historic reports intact.

Setting up tracking categories in Xero

  1. Go to Accounting, then Advanced, then Tracking categories.
  2. Add a category, such as "Region", and its options.
  3. Add a second category if you need one, such as "Department".
  4. Tag new invoices, bills, bank transactions and journals with the right options.
  5. Set up bank rules that apply tracking automatically to regular transactions.
  6. For past transactions you want tracked, recode them in bulk where Xero allows, or accept that tracking starts from now.

Reporting on tracking categories

Inside one organisation, you have two main tools. Run the Profit and Loss and filter or group by a tracking category to see each department's or region's result side by side. Or run the Tracking Summary for a quick overview of one category. Both are useful for spotting miscoded transactions: if a cost appears in a department that couldn't have incurred it, recode it.

Watch for untagged transactions. Untagged lines don't cause errors, but they fall outside filtered reports. If £12,000 of payroll isn't tagged, every department looks £12,000 more profitable in total than it really is. Add an "Unassigned" view to your monthly checks and keep it close to zero.

Report on tracking categories across organisations in Joiin

The multi-organisation problem

Here's where groups get stuck. Suppose you run three companies, each with regions North, South and Online. Xero can show North for company A. It can't show North across all three. To get a group view by region, you either export each organisation's tracking reports and combine them in Excel, matching option names by hand, or use an app that reads tracking categories from every organisation and groups matching options automatically.

Joiin does the second: it reads tracking categories from each Xero organisation and lets you report on them across the group, alongside the consolidated totals. If your options are named consistently, it's straightforward. If they aren't, tidy the names in Xero first.

Shared costs: allocate or not?

Rent, software, insurance and head-office salaries rarely belong to one department. You have three choices. Leave them in a "Central" or "Head office" option and report departmental results before central costs. Allocate them with a monthly journal using a fixed basis such as headcount or floor area. Or split invoice lines between departments when they're entered. The first is simplest and often the most honest; allocations can create arguments about the basis rather than the business. Whichever you choose, apply it consistently.

Tracking categories and budgets

Xero lets you create budgets by tracking option on plans that include budgets, so you can compare each department against its own target. The catch is that tracking budgets aren't linked to each other or to the overall budget, and there's no quick way to update many at once. Our Xero budgets guide covers the workarounds, and Calxa is a specialist option for detailed budgeting by tracking category.

Tracking categories versus separate organisations

A common question: should a new business line be a tracking option or a separate Xero organisation? The answer depends on the legal structure. If it's the same legal company, use tracking. If it's a separate company, it needs its own organisation, and you'll consolidate for group reporting. Don't use tracking to avoid setting up a company that legally exists.

Monthly tracking checklist

Tracking categories for common business types

Typical pairs of tracking categories
BusinessCategory 1Category 2
Multi-site retail or hospitalitySiteRevenue stream (food, drink, events)
Professional services firmService lineOffice
Construction or tradesRegionWork type (new build, maintenance)
E-commerce brandSales channel (own site, marketplace, wholesale)Product range
CharityFund (restricted, unrestricted)Programme
Group with shared servicesDepartmentCost centre or region

These are starting points, not rules. The best pair is the one your managers already use when they talk about performance.

Cleaning up messy tracking categories

Inherited a Xero organisation with 140 tracking options, half of them duplicates? Here's a practical clean-up.

  1. Export the Tracking Summary for the last 12 months to see which options are actually used.
  2. Agree a new, short list with the people who'll read the reports.
  3. Map old options to new ones in a simple table.
  4. Recode recent transactions where it's worth it, usually the current financial year, and leave older history alone.
  5. Archive the old options so they can't be used again but history is kept.
  6. Update bank rules so new transactions use the new options.
  7. Write the rules down and share them with everyone who codes transactions.

If you run several organisations, do the clean-up in all of them at once with identical option names. That's what makes group reporting by department possible later.

Mixed groups: Xero tracking and QuickBooks classes

Groups formed by acquisition sometimes have one company on Xero and another on QuickBooks Online. Xero has tracking categories; QuickBooks has classes and locations. They do similar jobs. If you want group reporting by department across both, use the same names in each system and a reporting tool that reads both. Joiin, for example, reads tracking categories from Xero and classes from QuickBooks and can report on them alongside consolidated totals.

Reporting tracking categories to managers

Tracking categories pay off when the people who run each part of the business see their own numbers. A simple monthly routine works well: each site or department manager gets a one-page P&L for their area, against budget and last year, with the direct costs they control separated from central costs they don't. Ask them for two or three sentences of explanation in return. Over a few months, managers start spotting miscoded transactions themselves, which improves the data for everyone.

Tracking payroll correctly

Payroll is often the biggest cost and the most commonly mistracked. If staff work in one department, tag their payroll journal lines to that department each month. If they split their time, split the journal lines by a fixed percentage and review it each quarter. If your payroll software posts a single summary journal to Xero, check whether it can post by department; if not, a monthly reallocation journal does the job. Untracked payroll is the single biggest reason departmental P&Ls look wrong.

A worked setup for a three-company group

Harbour Group runs three Xero organisations and wants group profit by region and by department. In each organisation it creates the same two categories. "Region" has the options North, South and Online. "Department" has Sales, Operations and Central. Bank rules tag recurring costs automatically: the Manchester office rent always goes to North and Central. Payroll journals are split by department every month. Shared head-office costs stay in Central rather than being allocated. In the group reporting tool, regions and departments line up across all three organisations because the names match exactly. The board sees one table: profit by region for the group, with each company's contribution underneath.

Frequently asked questions

How many tracking categories can you have in Xero?

Two active tracking categories per organisation, with about 100 options per category as Xero's suggested limit.

Can tracking categories be shared between Xero organisations?

No. Each organisation has its own. Use identical option names so a reporting app or spreadsheet can group them.

Can a transaction line have two options from the same category?

No. Each line can carry one option from each category. Split the line if a cost belongs to two departments.

Can I see a balance sheet by tracking category?

Tracking categories are mainly useful for profit and loss reporting. Balance sheet reporting by department isn't their strength.

Should I use tracking categories for projects?

For a few long-running projects, possibly. For many short projects, Xero Projects or a dedicated tool is usually better, because tracking options are limited.

How do I fix transactions with the wrong tracking option?

Edit the transaction and change the option, or use Xero's tools to find and recode transactions in bulk where available. Fix recent periods and leave closed years alone unless there's a good reason.

Can I rename a tracking option?

Yes. Renaming updates past transactions too, so it's a quick way to standardise names across organisations.

Can I report on tracking categories across Xero and QuickBooks companies?

Yes, with a reporting tool that reads both. Use identical names for tracking options and classes so they group together.

How should I treat head-office costs in tracking reports?

Either keep them in a central option and report departmental results before central costs, or allocate them with a consistent monthly journal. The first is simpler and avoids arguments about the allocation basis.