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 a week 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.

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.

Did this answer your question?