Skip to main content

Custom Functions

XO Report provides custom Excel functions that start with XO. to pull data directly from Xero into your spreadsheets.

How to Use Custom Functions

  1. Click on any cell in your spreadsheet
  2. Type =XO. to see all available functions
  3. Select a function and provide the required parameters
  4. Press Enter - the data will appear in the cell

Example:

=XO.BALANCE(A2, "4000", C1, D1)

Available Functions

XO.ORG

List all connected Xero organizations with their IDs.

=XO.ORG()

XO.BALANCE

Get the balance for a specific account code within a date range.

=XO.BALANCE(orgId, account, startDate, endDate)

XO.PROFIT

Get Net Income (Profit/Loss) from the P&L report.

=XO.PROFIT(orgId, startDate, endDate)

XO.BUDGET

Get budget amount for variance analysis.

=XO.BUDGET(orgId, budgetName, account, startDate, endDate)

XO.COA

Get the Chart of Accounts as a spilling table.

=XO.COA(orgId, [includeArchived])

XO.CONTACTS

Get the contacts list (customers/suppliers).

=XO.CONTACTS(orgId, [includeArchived])

XO.TRACKING

Get tracking categories and options.

=XO.TRACKING(orgId, [includeArchived])

XO.TAXRATES

Get tax rates configured in Xero.

=XO.TAXRATES(orgId, [includeDeleted])

XO.CURRENCIES

Get all currencies for multi-currency businesses.

=XO.CURRENCIES(orgId)

XO.LACCOUNT

Lookup account properties by code.

=XO.LACCOUNT(orgId, accountCode, property)

XO.LCONTACT

Lookup contact properties by name.

=XO.LCONTACT(orgId, contactName, property)

XO.LITEM

Lookup inventory item properties by code.

=XO.LITEM(orgId, itemCode, property)

Tips

  • Use cell references for dates to make reports dynamic
  • Functions refresh automatically when you open the workbook
  • Combine with other Excel functions for calculations