Import discount items into QuickBooks

Overview of importing discount items

In QuickBooks Desktop a discount item is used to record percentage or fixed amounts subtracted from the total or subtotal. You can import discount items from Excel or text files into QuickBooks desktop using the Zed Axis import utility.

Follow these steps

  1. Open your QuickBooks company file as Administrator and open Zed Axis
  2. Connect Zed Axis to your company file
  3. Browse to the file that contains the Discount Items
  4. Set up a new mapping for the columns in your import file and the corresponding fields in QuickBooks
  5. Click Import and your discount items will be imported directly into QuickBooks company file.

More help?

Below is a detailed description of all the fields that you can import on a discount item and also a template you can use to arrange your import data.  Sample Discount Item Template

Where the fields appear in QuickBooks Desktop

Detailed description of the fields you can map

QuickBooks fieldTypeDescription
NameStr 31Name of the discount Item not including the Parent
Bar Code ValueStr 50Bar code for the item
Is ActiveBoolWhether the item is active or not (true or false)
Class Ref Full NameStr 159Class or category for the item (must match class list)
Parent Full NameStrParent name for the item if the Item is a sub item
Item DescStr 4095Description for the item used on sales forms
Sales Tax Code Full NameStr 3Indicates if the item is Taxable (NON or TAX for US editions) Tax code for other countries
Discount RatePriceDiscount rate in a dollar rate ie 5 for a discount of $5
Discount Rate PercentPercentDiscount percentage for the item ie 20 for 20% discount
Account Full NameStr 159Full Account name for the item to be recorded against ie Cost of Goods Sold