Import a chart of accounts
When you set up your organization in Xero and before you start entering transactions, you can import your own chart of accounts if you don't want to use the default Xero chart of accounts.
You might want to use a chart of accounts you export from another Xero organization, or a chart of accounts you create using Xero's template.
- Before you start
- Download a file in the Xero chart of accounts file format
- Prepare data in the file
- Format your import file
- Save your import file
- Import your file into Xero
Before you start
Make sure you have all the tax rates you want to use set up in Xero before you import. If the tax rates on an imported file can't be found in Xero, they'll default to 'Tax Exempt (0%)'.
Download a file in the Xero chart of accounts file format
Use one of Xero's downloadable files to make sure your file contains data Xero will accept.
- Export your chart of accounts from another Xero organization, or
- Download a Xero chart of accounts file template.
Prepare data in the file
Navigate to the downloaded file on your computer and open it.
Complete all mandatory fields
Mandatory fields are marked with an asterisk (*) on the column header in the CSV file.
Use letters, numbers or symbols, up to 150 characters. You can use symbols within the name, but not at the start.
The name must be unique.
- Tax Code
Add a tax rate for each account. If you don't select a tax rate, Xero will import the account with the rate Tax Exempt (0%), which you can update later.
For bank accounts, you must use the code Tax Exempt (0%).If you use a custom tax rate, include the rate value in brackets. For example, 'Tax on Expenses (8.5%)'.
Include optional fields you require
- Enable Payments
Specify if the account you're creating should appear in the drop-down list of accounts when you're entering a payment directly on an invoice, bill or expense claim. Enter only Yes or No.
For bank accounts, this field must be No or left blank.
If you want to import account balances, enter the balances immediately prior to your conversion date.
Xero imports positive balances as debits, and negative balances as credits.
Xero ignores symbols and non-numeric data, other than negative signs and brackets (showing a negative balance).
If you don't want to import balances, leave the Balance column blank.
(Optional) Make changes for multi-currency
If you use foreign currencies in your organization, you can't import a chart of accounts that includes balances in other currencies. You'll need to import the chart of accounts in your base currency, then add accounts for the foreign currency balances later.
Talk to your accountant or bookkeeper before making these changes.
Format your import file
If your file includes account balances they will be imported with your chart of accounts. But, if you've already entered balances for some of your accounts, importing balances will overwrite them.
- Every column on the import file must have a column header.
- Your file can have up to 700 rows (1 column heading row + 699 value rows). If you have more than 699 accounts, you'll need to add the extra accounts to your chart of accounts after importing.
- If you don't want to include an optional field in your import, you can either delete the column or have all cells in the column blank.
Format the Code column as text.Microsoft Excel removes the leading zeros from account codes from the exported chart of accounts CSV file.
- If your file has non-English characters, save your chart of accounts as a text file in Microsoft Excel. This will ensure any non-Roman (UTF8) characters aren't removed from the file. You can then import the text file into Xero using the CSV import process.
Save your import file
Save the file to your computer in CSV format, for example XeroChartofAccounts.csv.
Import your file into Xero
- In the Settings menu, select General Settings.
- Under Reports, select Chart of Accounts.
- Click Import.
- Select the Xero system option.
- Select whether your file includes balances. If Yes, enter your conversion date.
- Click Browse to locate your saved file on your computer.
- Click Import.
- Review the chart of accounts file import
- Click Confirm.
If your import file includes bank accounts, select your bank account type (Bank, Credit Card, or PayPal) and add your bank account number. Click Save.