How to import non inventory items into QuickBooks

You can import non inventory 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 non inventory items that you want to import.
  4. Set up the a Mapping of the columns in your non inventory item import file to the corresponding fields in QuickBooks, as shown below
  5. Click Import and your non inventory items will be directly added to your QuickBooks company file.
Sample template Item_NonInventory.txt

QuickBooks fieldType Description 
 NameStr 31  Name of the non inventory item
 BarCodeValueStr 50 Bar code value for the item
 IsActive true or false Whether the item is active
 ClassRef Full NameStr 159 Full class name for the item
 Parent Str Parent name of the non inventory item (ie Subitem of)
 ManufacturerPartNumber Str 31 The part number used by the manufacturer of the item
 Unit of Measure Str 31 Unit of measure for the item
 IsTaxIncluded true or false Whether the price includes tax (CA, UK, AU only) 
 SalesTaxCode Str 3 Sales tax code
 SalesOrPurchaseDesc Str 4095 Description for the non inventory item (not purchased)
 SalesOrPurchasePrice Price Price
 SalesOrPurchasePricePercent Percent Percentage
 SalesOrPurchaseAccount Str 159Account associated with the item 
 SalesAndPurchaseSalesDesc Str 4095 Sales description used on item
 SalesAndPurchaseSalesPrice PriceSales price 
 SalesAndPurchaseIncomeAccount Str 158Income account for the item
 SalesAndPurchasePurchaseDesc Str 4095 Purchase description used on item
 SalesAndPurchasePurchaseCost Price Cost to purchase
 SalesAndPurchaseTaxCode Str 3 Tax code used on purchases
 SalesAndPurchaseExpenseAccount Str 159 Expense account used on purchases
 SalesAndPurchasePrefVendor Str 41 Preferred vendor for the non inventory item

Troubleshooting Errors

There was an error when modifying a ItemNonInventory. Cannot use SalesAndPurchaseMod aggregate when the item is not reimbursable. - The non-inventory item that you are modifying has purchase information information active, you should not use the SalesAndPurchase fields instead use the SalesOrPurchase  fields


Add Feedback
What do you enter for the IsActive column shown above? Thanks Marty
Heidi Goedecke (December 10, 2015 at 1:37 AM)
You can enter either true or false
Steve (April 26, 2019 at 5:12 AM)

Add Feedback