Report on Xero tracking categories

xero tracking categories

authorEdgar de Wit


We often receive this question: "How can we report on Xero tracking categories with multiple Xero administrations?"

Many Xero customers have the same problem, they are entering transactions on tracking categories but reporting possibilities in Xero are limited. You can select one or more tracking categories when you run a report, but it is dificult reporting on them as a "dimension" of your business. Even more so if you have multiple Xero companies.

As a result, most Xero customers resort to running multiple reports in Xero, exporting to Excel, and doing their consolidating and reporting in spreadsheets. It is a very manual process, time-consuming and not ideal.

Examples of tracking categories in Xero are:

  • Business units
  • Departments
  • Cost centers
  • Sales channels
  • Customer types
  • Product groups
  • Geographic locations

How to report automatically with multiple Xero administrations

Category tracking in Xero is great. But reporting in Xero is limited. Before you know it you'll be doing it all in spreadsheets. As your business grows, doing your consolidating and reporting manually in spreadsheets is time-consuming without a good solution.

There are many online solutions that can connect with Xero. XLReporting is an one of these solutions, and ideally suited to report on your tracking categories.

XLReporting to the rescue

XLReporting integrates with Xero. Once you authorize XLReporting to access your data, you can then import the data for each Xero administration into XLReporting's online database. That includes your Chart of Accounts, account balances, general ledger details, and tracking categories.

xero integration categories

The beauty of this method is that you no longer have to do any manual work. All reports are immediately updated, and you can view your numbers any way you want.

For example, if you have a tracking category "Business Units", you can define a report with all business units next to each other, consolidated across all Xero administrations. Or show your companies side-by-side:

xero report tracking categories

What's stopping you?

When you can automate your consolidation and reporting, you have more time to analyze your numbers. Which tracking category performed best and which worst?

Thanks to automation, you keep better overview, and your numbers are instant and reliable. That gives you confidence in your numbers and in your decisions.

Contact us for a free demo or Proof of Concept.

Do you want to know more about tracking categories in Xero, then click here.

Back to the list


Recent blogs:

What your Budget says about your Organization
Bottom-Up Budgeting Beats Top-Down
Period Selection in Reporting
Financial Forecasting Is Not Fortune-Telling
How to Navigate a Business

Popular blogs:

A Guide to Consolidation with QuickBooks
A step-by-step Guide to Financial Consolidation
Build the Right Budget Structure for your Business
Report on Xero Tracking Categories
Build effective Budget Models

More about Setup:

Key Pain Points in Accounting and How to Solve Them
Why Good Financial Data Quality is Crucial for Your Business
Define extra dimensions
Improve Reporting, Budgeting and Analysis in 5 steps
Free up Time from Monthly Financial Reporting

More from Edgar de Wit:

Period Selection in Reporting
The One-Stop Solution for Finance Professional
Why Revenue Forecasting Matters
Involving your team in budget planning
XLReporting: a trusted European alternative in uncertain times

Back to the list

Start Your Solution Today

Schedule a Meeting with one of our Planning and Reporting Experts.

Let's Talk

We value your privacy

We use cookies to enhance your browsing experience and analyze our traffic.
By accepting, you consent to our use of cookies.

Accept Reject Cookie Policy