Child pages
  • Bulk updating item tax/GST codes

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
classsection group
classcol span_3_of_5


You can update your item tax codes (GST codes in New Zealand) one at a time, but this can be quite time consuming. If you have lots of items, you can bulk update your item tax codes by exporting your item information, updating the export file in Microsoft Excel then importing the updated information back into AccountRight.

UI Text Box

Don't use Excel?

You can modify the export file in any program that can open text files (like Notepad), but it's easier if you use a spreadsheet program.

OK, let's step you through it.


UI Expand
title1. Exporting your item information
  1. Go to the File menu and choose Export Data then choose Items.
  2. Select the default options: Tab-delimited export file format and First Record is Header record.
  3. Click Continue.
  4. On the Export Data window, click Match All and then click Export. See the example below.
    Export data window with all fields matchedImage Modified
  5. Specify where you want to save the export file, such as the desktop.
UI Expand
title2. Modify the export file in Excel
  1. Open Microsoft Excel.
  2. Go to the File menu and choose Open.
  3. Locate the export file and click Open. In our example this would be the ITEM.TXT file. To ensure the export file is visible when trying to open it, ensure the File Types is set to All Files (*.*) as shown below. File type set to all filesImage Modified
  4. If the Text Import Wizard is displayed, click Finish. The contents of your export file will be displayed. Each column in the spreadsheet represents a field relating to your items, for example Item Number, Item Name, etc.
  5. Update the Tax Code When Bought and Tax Code When Sold columns for each of your items to their new codes. Make sure you don't add any extra columns as AccountRight will only be able to import the same columns (fields) you exported. Item fields as columns in excelImage Modified
  6. Save the export file (File > Save As). Make sure you save the file as a Text (tab delimited) file. This ensures you'll be able to import the file back into AccountRight.
  7. Close Excel.
UI Expand
title3. Import the fiile back into AccountRight
UI Text Box

Before you begin

Create a backup of your company file. If the import doesn't go to plan, you can always "undo" it by restoring the backup. For more information see the AccountRight help (Australia | New Zealand).


  1. In AccountRight, go to the File menu and choose Import Data then choose Items.
  2. Choose the following options: Tab-Delimited; Header Record; Update Existing Record as shown in the following example.
    Import file windowImage Modified
  3. Click Continue. You will be asked to choose the file which you saved from Excel.
  4. Locate the saved file then click Open.
  5. In the Import Data window, click Match All to align all of the imported fields with the records in your company file. See our example below.

    Import data window with all fields matchedImage Modified

  6. Click Import and the updated information will be imported.
  7. At the conclusion of the import, check the details of what was (or wasn't) imported.
    sample import confirmation messageImage Modified
    If there were errors or warnings, check the details in the import log file located in your AccountRight installation folder. See Import troubleshooting for help.
classcol span_1_of_5
classcol span_1_of_5
titleRelated topics

Importing and exporting data (Australia)

Importing and exporting data (New Zealand)

Backing up and restoring company files (Australia)

Backing up and restoring company files (New Zealand)

Import troubleshooting