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.

QuickBooks field Type  Description 
 Name Str 31   Name of the non inventory item
 IsActive  true or false  Whether the item is active
 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 159 Account associated with the item 
 SalesAndPurchaseSalesDesc  Str 4095  Sales description used on item
 SalesAndPurchaseSalesPrice  Price Sales price 
 SalesAndPurchaseIncomeAccount  Str 158 Income 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


Feedback

Add Feedback
What do you enter for the IsActive column shown above? Thanks Marty
Martin Sammon (December 9, 2015 at 8:37 PM)

Add Feedback