Importing Your Xero Chart of Accounts: What Finance Teams Need to Know

When you connect Xero to an external tool, one of the first steps is importing your chart of accounts. This sounds simple, but there are a few things worth checking beforehand — particularly around how Xero's account types translate to the categories your reconciliation tool uses.

How Xero Categorises Accounts

Xero assigns every account a "type" from its own taxonomy. These types are used internally for reporting but do not always map neatly to the categories that a finance team uses for reconciliation purposes. The key types relevant to prepayments and accruals are:

• CURRENT — current assets (where prepaid expenses often sit)
• PREPAYMENT — Xero's own prepayment account type for supplier overpayments
• CURRLIAB — current liabilities (where accrued liabilities sit)
• LIABILITY — non-current liabilities
• EXPENSE — operating expenses
• OVERHEADS — overhead expenses (common in UK Xero setups)
• DIRECTCOSTS — cost of sales

How Account Types Map to Reconciliation Categories

A reconciliation tool needs to know whether an account is a prepaid asset, an accrued liability, or an expense account. It infers this from Xero's account type:

• CURRENT or PREPAYMENT → suggested as Prepaid Asset
• CURRLIAB or LIABILITY → suggested as Accrued Liability
• EXPENSE, OVERHEADS, or DIRECTCOSTS → suggested as Expense

Common Problems When Importing

1. Generic Account Names

Many Xero setups have accounts called "Other Current Assets" or "Accruals" with no further detail. These accounts often contain multiple types of items — which makes it impossible to reconcile meaningfully. Before importing, review your chart of accounts and split any catch-all accounts into specific ones.

2. Duplicate Account Codes

If your Xero chart of accounts has accounts with no code, or duplicate codes, the import may produce unexpected results. Xero allows duplicate names within the same type, which causes ambiguity when mapping. Clean up account codes before importing.

3. Legacy Accounts Still Active

Old accounts that should have been archived are sometimes still active in Xero — particularly after a system migration or acquisition. During import, these will appear as mappable accounts even though they carry no current balance. Archive them in Xero first to keep your imported list clean.

Before You Import: A Quick Checklist

• Every prepaid expense account has a specific name (not "Other Assets")
• Every accrued liability account is clearly named (e.g., "Accrued Payroll", "Accrued Professional Fees")
• Each expense account that pairs with a prepaid or accrued liability is correctly coded
• Legacy or unused accounts are archived in Xero
• Account codes follow a consistent numbering pattern (1300s for prepaid assets, 2300s for accrued liabilities, for example)