Skip to main content
Accounts

Accounts (aka Ledgers) are the records that create the Chart of Accounts, and are used to classify financial transactions.

Nick Maxwell avatar
Written by Nick Maxwell
Updated over 2 weeks ago

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.

Did this answer your question?