XO.ORG
Get a list of all connected Xero organizations with their IDs and names. This is typically the first function you'll use to get the Org ID needed by other functions.
Syntax
Parameters
No parameters required.
Returns
A spilling table with the following columns:
| Column | Description |
|---|---|
| OrgID | Organization identifier (e.g., "!abc123") |
| OrgName | Organization full name |
How to Use
- Type
=XO.ORG()in a cell (e.g., A1) - The function will spill into a table showing all connected organizations
- Reference specific cells in other formulas (e.g., use
A2for the first org's Org ID)
Examples
Get organization list:
=XO.ORG()Returns a table of all connected Xero organizations.
Use Org ID in another function:
=XO.BALANCE(A2, "4000", C1, D1)Lock to first organization:
=XO.BALANCE($A$2, "6200", C1, D1)Tip
Click the "Insert into Active Cell" button in the task pane to quickly add =XO.ORG() to a cell. The function will automatically create a spilling table.
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.