Import a chart of accounts
When you set up your organisation in Xero and before you start entering transactions, you can import your own chart of accounts. This is an alternative to the default chart of accounts Xero sets up for new organisations. You might want to use a chart of accounts you export from another Xero organisation, 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 the rates used in the file also exist in Xero before you import your file. If you're importing accounts from MYOB, the MYOB tax rates are mapped to the default rates in Xero. If the tax rates on an imported file can't be found in Xero, they'll default to 'No GST (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 organisation, or
Download a Xero chart of accounts file as a template. You'll need to log in to Xero before downloading the file.
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 No GST, which you can update later.
For bank accounts, you must use the code No GST.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
- Reporting Name
(Adviser role only) In Partner Edition, add a reporting name to an account. The name does not have to be unique.
Reporting name will only appear on new reports and report templates. The option is available for all accounts except bank accounts, PayPal and credit card accounts.
- 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 organisation, 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
- 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. You must format the Code column as text before importing the file back into Xero.
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.
Save your selection.