XO.TRACKING
Get all tracking categories and options for an organization. By default returns only Active categories/options. Returns a table with 6 columns.
Syntax
Parameters
| Parameter | Required | Description |
|---|---|---|
| org_id | Yes | Organization ID from XO.ORG() |
| include_archived | No | 0 = Active only (default), 1 = All including archived |
Returns
A table with 6 columns. Each row represents one option within a category:
Examples
Active tracking only:
=XO.TRACKING(A2)Returns a spilling table of all active tracking categories and options.
Include archived:
=XO.TRACKING(A2, 1)Tip
Use Excel's Filter feature to see all options for a specific category (e.g., filter "Category Name" = "Region").
Multi-Organization Data
Using the Function Builder
When connected to multiple Xero organizations, use the Function Builder in the task pane to select which organizations to include. The builder will create the formula for you — you don't need to write the VSTACK formula manually.
Advanced: Manual VSTACK Formula
To manually combine tracking categories from multiple orgs, use Excel's VSTACK function:
=VSTACK(XO.TRACKING(A2), DROP(XO.TRACKING(A3), 1))The DROP(,1) removes the duplicate header row from the second result.
Troubleshooting
If you see an error, check the troubleshooting guide. XO Report shows readable guidance messages for connection issues (not caught by IFERROR) and standard Excel errors (#VALUE!, #N/A) for data problems — hover over the cell to see the specific message.