How to import sales tax item lists into QuickBooks

You can import sales tax items into QuickBooks from text files or Excel spreadsheets using Zed Axis:

  1. Download and install the Zed Axis software on your computer
  2. Open your QuickBooks company file as Administrator and open Zed Axis
  3. Select your text file or spreadsheet which contains the sales tax items that you want to import.
  4. Set up the a Mapping of the columns in your sales tax items list import file to the corresponding fields in QuickBooks, as shown below
  5. Click Import and your sales tax item items will be directly added to your QuickBooks company file.
tax item list


QuickBooks fieldTypeDescription
NameStr 31 Name of the sales tax item
Is Activetrue or falseWhether the item is active
Item DescStr 4095The description of the sale tax item
Tax RatePercentThe tax rate, if non zero you must specify a Tax Vendor
Tax Vendor Full NameStr 41The tax agency to whom taxes collected are owned
Sales Tax Return LineStr 41The tax return line to be used (CA, UK and AU only)

Troubleshooting Errors



Add Feedback