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
- Each Xero organisation can have two active tracking categories, with about 100 options each as Xero's suggested limit.
- Each transaction line takes one option from each category; split lines that belong to two departments.
- Tracking categories don't carry across organisations, so use identical names everywhere.
- Untagged transactions silently drop out of filtered reports; review them every month.
- For group reporting by region or department, use a spreadsheet or an app that reads every organisation.
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
| Limit | Detail | What it means in practice |
|---|---|---|
| Active categories | Two per organisation | Choose your two dimensions carefully, such as region and department |
| Options per category | About 100 is Xero's suggested limit | Reports can slow down beyond that; don't use tracking for every project |
| Per transaction line | One option from each category | A line can't be split between two departments; split the line instead |
| Across organisations | Not shared | Each organisation keeps its own list |
| Balance sheet | Mainly a P&L tool | Don'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
- Go to Accounting, then Advanced, then Tracking categories.
- Add a category, such as "Region", and its options.
- Add a second category if you need one, such as "Department".
- Tag new invoices, bills, bank transactions and journals with the right options.
- Set up bank rules that apply tracking automatically to regular transactions.
- 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
- Untagged transactions reviewed and coded
- Bank rules still applying the right options
- Shared costs treated consistently
- Option names still identical across organisations
- Departmental results reviewed by the people responsible
Tracking categories for common business types
| Business | Category 1 | Category 2 |
|---|---|---|
| Multi-site retail or hospitality | Site | Revenue stream (food, drink, events) |
| Professional services firm | Service line | Office |
| Construction or trades | Region | Work type (new build, maintenance) |
| E-commerce brand | Sales channel (own site, marketplace, wholesale) | Product range |
| Charity | Fund (restricted, unrestricted) | Programme |
| Group with shared services | Department | Cost 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.
- Export the Tracking Summary for the last 12 months to see which options are actually used.
- Agree a new, short list with the people who'll read the reports.
- Map old options to new ones in a simple table.
- Recode recent transactions where it's worth it, usually the current financial year, and leave older history alone.
- Archive the old options so they can't be used again but history is kept.
- Update bank rules so new transactions use the new options.
- 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.