You can report on Xero tracking codes or QuickBooks classes in any of the ways below; the easiest is the New report option, which shows every code in a category or class, one per column.
Option 1: Use the new report button to create a report on the reports tab with a column for each code in a category or class
The easiest way to create a new report for tracking codes or classes is to use the New report option. This will enable you to instantly select a code group for which to view all the tracking codes at once, one per column.
- In the Reports sidebar, click New and select New report.
- Click P&L.
- Click Tracking Codes (Classes, Locations for QuickBooks).
- Select the class or location and the time frame.

This option will create a new Tracking Codes report which you can further edit as per the Edit columns option below.
Important: New reports will not show the tracking code option for companies without any Xero tracking codes or QuickBooks classes. For a consolidated parent company, the option shows each subsidiary's tracking codes as separate columns. See below for further options in these cases.
Option 2: Use the columns configuration on the reports tab
When viewing a report, you can build a column layout with any combination of tracking codes or classes, one or more per column. See How to edit a report and create your own custom rows and columns for more on editing columns.
- Open the report in Reports, click Edit (top right) and select Edit columns.
- In the editor header, click the New column layout button next to the Columns dropdown.
- In the New column config window, select By tracking code (By class, location for QuickBooks), enter a name under Give this config a name and click Add columns.
- Choose the Value basis (for example Actual), the category under Tracking code (Class, location for QuickBooks) and the periods to show under Months, Quarters and Years, then click Add columns.


ScaleXP adds a column for each code in the category, including Unassigned for amounts with no code, followed by a highlighted total column, for each period you chose.

To change what a column includes, use the Tracking Category list on that column (Classes Category for QuickBooks):
- Select one or more individual codes. A column with several codes shows their combined amount, and you can label it with Column name Postfix (optional).
- Select Unassigned for amounts with no code.
- Tick the box next to the category name to select every code in that category at once.
- Leave the list empty to show all amounts, regardless of tracking code.

- To add more columns, click Add New Column.
- When you are done, click Save & Exit to save the new column layout to the report, or Save as New Column Config to keep it as a separate layout, or Discard to leave without saving.
- Rename your report to reflect the new tracking codes you have selected.
A report showing a month's P&L with all tracking codes plus all unassigned costs, adding to the total at the far right, can be created using either New > New report, P&L, and choosing the Tracking Codes tab (Classes, Locations for QuickBooks), or by using Edit > Edit columns in an existing tracking code report and adding columns for each of the desired tracking codes.
Important: Each Xero tracking category or QuickBooks class can have up to 90 active options. If a category has more than 90, ScaleXP stops importing figures for it, so reports keep showing the figures from the last import before it went over the limit. When a report uses a category that is over the limit (in its columns or in a row), a warning above the report names each one with its number of options, for example: "You have reached the limit of 90 tracking category options: Department has 95 options. Please archive any that are not in use to ensure accurate data is displayed going forwards." For QuickBooks the warning says "class & location" options, and for Zoho Books "reporting tag" options. Archived options are not counted, so the warning disappears once the category has 90 or fewer active options.
Option 3: Use rows editing on the reports tab
In Reports, use rows and formulas with GL accounts to select tracking categories.
See How to add tracking codes, classes, or categories as rows in your reports and details below.
When adding a row to a report from the P&L like a financial category, a group or a GL Account, you'll have a secondary option to choose a tracking category for that row. The same can be done in formulas.
- In any P&L Report, click Edit > Edit rows.
- Select Click to Start at the bottom of the rows to add a new row or create a formula.
- Choose an item from the Accounting section like a financial category, P&L group or account.
- Click Done.
- Now, with that row selected, click the cog wheel for additional configuration options.
- Finally, choose one or many tracking categories.



The same steps can be done within a formula. Now this row or formula with tracking codes built in can be referenced by other rows and formulas in the report.
Formulas and Metrics are available in reports, dashboards and the Metric Library to select tracking codes as well. Edit any dashboard chart series or metric in the library and follow the same steps as the report above.
Option 4: Use dashboards to create charts and graphs by tracking code or class
In Dashboards, use any series or formula with GL accounts to select tracking categories.
You can use the Tracking Codes option (Classes, Locations for QuickBooks) to select which categories to include in a chart or graph.

To show a total by tracking code or class:
- Create a line for the total.
- Create a stacked bar for each tracking code option, including Unassigned (this will pick up any amounts not assigned a Class or Tracking Code).
For example:

Option 5: Create customer page reports by tracking category or class
See How to report on tracking codes for Customer data and Add Metrics from Multiple Customers Pages to one Report or Dashboard.
Option 6: Create custom metrics
In the Metric Library, use formulas with GL accounts to select tracking categories or classes. These can be used in Reports and Dashboards.
See How do I create a new metric in the metric library?.
See the transactions behind a tracked figure
To see the transactions behind a tracked figure, use Download Transaction Detail on the report: each line shows its tracking categories. See How to download a report to Excel.