Back to Tables
Accounts Table
Complete Chart of Accounts from Xero. View all GL accounts with their codes, types, and status.
Filters
Include Archived
Toggle to include archived accounts. By default, only ACTIVE accounts are shown.
Output Columns
| Column | Description |
|---|---|
| Code | GL account code (e.g., "4000", "200") |
| Name | Account name |
| Type | Account type (BANK, CURRENT, FIXED, etc.) |
| Class | Account class (ASSET, LIABILITY, REVENUE, EXPENSE, EQUITY) |
| Status | ACTIVE or ARCHIVED |
| Description | Account description |
| TaxType | Default tax code |
| BankAccountNumber | Bank account number (if bank account) |
| BankAccountType | Bank account type |
| CurrencyCode | Currency code |
| ReportingCode | Reporting code |
| ReportingCodeName | Reporting code description |
| EnablePayments | Whether payments enabled |
| ShowInExpenseClaims | Expense claim visibility |
| AccountID | Xero unique identifier |
Tips
- Use Excel filters to find accounts by Type or Class
- Check the Status column to identify archived accounts
- Reference account codes for use in XO.BALANCE formulas