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
Open the Functions tab in the task pane and click "Insert Function" to quickly add =XO.ORG() to a cell. Since XO.ORG has no parameters, it inserts directly. 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.