Xero Accounting Endpoint: AccountsTable

Overview

The Xero AccountsTable endpoint allows you to access the chart of accounts located within Xero.

Note this endpoint is an alternate format of the Accounts endpoint. It provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.

Fields

The following fields are available for the Accounts endpoint.

DataFileID: A guid field that provides the id of the xero data file as setup in OdataLink.

DataFileName: A text field provides the name of the xero data file as setup in OdataLink.

DataFileCode: A text field provides the code of the xero data file as setup in OdataLink.

AccountID: A GUID field representing the internal id of an account.; This field can be used to link to other endpoints.

Code: A text field that provides the unique account code or account number.; This field can be used to link to other endpoints.

Name: A text field that provides the account name.

Status

A text field that indicates the status of the account.

Possible values are:

ACTIVE: Indicate the account can be used on transaction.
ARCHIVE: Indicates the account cannot be used on transaction any longer but may have had historical transactions.

Type: A text field that indicates the more detailed type of an account.; See AccountTypes for more information.

TaxType: A text field that indicates the tax type for the account. See TaxTypes for more information.

Description: A text field that provides the description for the account.

Class

A text field that provides the high level classification of an account.

This field can be linked to the AccountsClass endpoint.

Possible values are:

REVENUE
EXPENSE
ASSET
LIABILITY
EQUITY

SystemAccount

A text field that provides the specific system type of an account used within Xero.

Possible values are:

BANKCURRENCYGAIN: Used to identify the bank revaluations account.
CISASSETS: Used to identify the CIS assets account. (UK Only)
CISLABOUREXPENSE: Used to identify the CIS labour expense account. (UK Only)
CISLABOURINCOME: Used to identify the CIS labour income account. (UK Only)
CISLIABILITY: Used to identify the CIS liability account. (UK Only)
CISMATERIALS: Used to identify the CIS materials account. (UK Only)
CREDITORS: Used to identify the accounts payable account.
DEBTORS: Used to identify the accounts receivable account.
GST: Used to identify the GST / VAT account.
GSTONIMPORTS: Used to identify the GST on imports account.
HISTORICAL: Used to identify the historical adjustment account.
REALISEDCURRENCYGAIN: Used to identify the realised currency gains account.
RETAINEDEARNINGS: Used to identify the retained earnings account.
ROUNDING: Used to identify the rounding account.
TRACKINGTRANSFERS: Used to identify the tracking transfers account.
UNPAIDEXPCLM: Used to identify the unpaid expense claims account.
UNREALISEDCURRENCYGAIN: Used to identify the unrealised currency gains account.
WAGEPAYABLES: Used to identify the wages payable account.