Overview
Accounts (aka Ledgers) classify all financial transaction records; Budgets, Bank Transactions, Invoices, Journals, Payments.
Best Practice
Using the same Chart of Accounts across different Xero Organisations means that it is possible to directly compare different Organisations, for example across types of Sales, or aggregate financial information across them.
In this way, a single Microsoft Power BI report can be used across multiple organisations, to help deliver financial insight and value at scale.
Working with multiple Xero Organisations
When working with multiple Xero Organisations, a deduplicated set of Account Codes are returned.
The Account Names for deduplicated codes are taken from the primary Xero organisation. If a Code doesn't exist in the primary organisation's Chart of Accounts, then the first Account Name that is found for the given Code is taken.
Data Dictionary
Field | Type | Notes |
Account Code | Text | The identifier for an Account e.g. 200. If this is empty (eg often the case for Bank Accounts) then the Xero Account ID is substituted here to avoid empty Codes. When multiple Xero Organisations are grouped, then the details of an account are taken from the master connection (the connection that the others are grouped under). |
Account Name | Text | The Account Name. e.g. Sales |
Add To Watchlist | Boolean | True if Add To Watchlist is set. |
Bank Account Number | Text | The Bank Account Number if this account is for a Bank Account. |
Bank Account Type | Text | e.g. {'', 'BANK', 'CREDITCARD', 'PAYPAL'} |
Class | Text | {'ASSET', 'EQUITY', 'EXPENSE', 'LIABILITY', 'REVENUE'} |
Class Sort Order | Integer | The sort order for Class. If you create your own Microsoft Power BI template, ensure that Class is sorted by Class Sort Order. |
Connection Name | Text | The name of the Connection. Typically the name of the Xero Organisation. |
Currency Code | Text | ISO 3 letter Currency Code for the Account. |
Data current as of | Datetime | When the Data was taken from Xero. |
Debit or Credit | Text | Debit or Credit |
Enable Payments To Account | Boolean | True if it is possible to make payments against this account. |
Has Attachments | Boolean | True if the account has attachments. |
Last Updated | Datetime | When the Account was last changed/created. |
Show In Expense Claims | Boolean | True if this is set to show in expense claims. |
Status | Text | {'ACTIVE', 'DELETED'} |
Tax Type | Text | The Tax Type associated with the Tax Amount. E.g. One of (in the UK) {'ECZROUTPUTSERVICES', 'EXEMPTINPUT', 'EXEMPTOUTPUT', 'INPUT2', 'NONE', 'OUTPUT2', 'ZERORATEDOUTPUT'} |
Type | Text | one of {'BANK', 'CURRENT', 'CURRLIAB', 'DIRECTCOSTS', 'EQUITY', 'EXPENSE', 'FIXED', 'LIABILITY', 'OTHERINCOME', 'OVERHEADS', 'PREPAYMENT', 'REVENUE', 'SALES', 'TERMLIAB'} |
Type Sort Order | Integer | The sort order for Type. If you create your own Microsoft Power BI template, ensure that Type is sorted by Type Sort Order. |