Overview
Accounts (aka Ledgers) are the records that create the Chart of Accounts, which Xero uses to classify financial transactions.
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.
Using the same Account Code, but with different meanings or Names, means multiple organisations data is aggregated, but financially may be meaningless.
Data Dictionary
Field | Type | Notes |
Account Code | Text | The Primary Key for the table. If this is empty (eg often the case for Bank Accounts) then the Xero Account ID is substituted here to avoid empty Codes. e.g. 200 |
Account Name | Text | The Account Name. e.g. Sales |
Add To Watchlist | Logical |
|
Bank Account Number | Text |
|
Bank Account Type | Text | eg {'', 'BANK', 'CREDITCARD', 'PAYPAL'} |
Class | Text | {'ASSET', 'EQUITY', 'EXPENSE', 'LIABILITY', 'REVENUE'} |
Class Sort Order | Number | The sort order for the Class field. |
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. |
Enable Payments To Account | Logical |
|
Has Attachments | Logical |
|
Last Updated | Datetime | When the Account was last changed/created. |
Reporting Code | Text |
|
Reporting Code Name | Text |
|
Show In Expense Claims | Logical |
|
Status | Text | {'ACTIVE', 'DELETED'} |
Tax Type | Text | eg {'EXEMPTINPUT', 'INPUT2', 'NONE', 'OUTPUT2', 'RRINPUT'} |
Type | Text | {'BANK', 'CURRENT', 'CURRLIAB', 'DIRECTCOSTS', 'EQUITY', 'EXPENSE', 'FIXED', 'LIABILITY', 'OTHERINCOME', 'OVERHEADS', 'PREPAYMENT', 'REVENUE', 'SALES', 'TERMLIAB'} |
Type Sort Order | Number | The sort order for the Type field. |