Get Your Free

Xero Courses Now

Tired of bad quality homemade Xero tutorials? Our easy-to-follow FREE Xero courses will help you learn the essentials in only 2.5 hours.

Xero – How to Import a Chart of Accounts

by | 15 May 2018 | Chart of Accounts

Making bulk changes to your general ledger accounts in Xero is a great way of saving time and effort. This can be done by exporting your chart of accounts to a CSV file, editing the accounts, then importing the edited file back into Xero.

In this tutorial, I will show you how to import the chart of accounts back to Xero’s demo company after you have made your changes. To follow this guide properly, please first export the chart of accounts into a CSV file by following the instructions in my guide on how to export a chart of accounts from Xero.

Chart of Accounts Section in Xero

To get to the right area of Xero, go to Accounting → Chart of accounts from the main menu.

0056-xero-chart-of-accounts-import-01

How to Import a Chart of Accounts

Once you have downloaded the CSV file you can make some changes. Although you can make lots of changes, I will keep this demonstration simple by making a small number of changes to the names of a few accounts.

Let’s take a look at the accounts in the general ledger before any changes are made. If you go to the main Chart of Accounts screen you should see the following accounts:

  • 300 – Purchases
  • 310 – Cost of Goods Sold
  • 400 – Advertising

0056-xero-chart-of-accounts-import-02

Now go to the CSV file that downloaded when you exported your chart of accounts. You should be able to open the file in Microsoft Excel or Google Sheets. Go to the lines containing the three general ledger accounts listed above and change their names to:

  • 300 – Stock Purchases
  • 310 – COGS
  • 400 – Online Advertising

0056-xero-chart-of-accounts-import-03

Save and Close the file to get it ready for importing into Xero.

Back in the Chart of Accounts screen of Xero’s demo company, click on the Import button:

0056-xero-chart-of-accounts-import-04

On the next screen, you will be presented with a few options. For this exercise, you can leave the settings as they are and click on the Browse button. Find the CSV file to import and click on Import when ready:

0056-xero-chart-of-accounts-import-05

Your file will now be checked for errors by Xero. A confirmation screen will show you the results of the checks. As we only made changes to the names of a few accounts, we shouldn’t have any problems to worry about so will ignore the warnings on the confirmation screen and click on Confirm to finish our import:

0056-xero-chart-of-accounts-import-06

Note: If you are importing a chart of accounts for a real business using Xero, please check the messages on the confirmation screen thoroughly and fix any errors before finishing your import.

You should now be back at the main Chart of Accounts screen. Here, you should see that the names of the three general ledger accounts have been changed:

0056-xero-chart-of-accounts-import-07

That’s it for this lesson. There are many more changes you can make in bulk to charts of accounts in Xero so be sure to save yourself lots of time and effort by exporting and importing in future when making bulk edits.

ultimate-guide-to-setting-up-xero-550x623
xero-big-bundle-course-600x600

Get All 6 Xero Courses and Save 57%

Do you want all our Xero courses? Save 48% by getting them all today for one low price!

  • The best value Xero training anywhere online today.
  • With 270+ lessons and 1400+ minutes of learning you will become a Xero expert fast!
  • Get on top of your Payroll, BAS & GST, Bank Accounts, Projects and much more much faster than you can going it alone.

$49.00 $34.30

Great time to visit. Take 30% off your purchase.
Offer valid until the timer hits zero!
x