Import inventory adjustment into QuickBooks

You can import inventory adjustments from text files or from Excel spreadsheets directly into QuickBooks using the Zed Axis software.  
  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 inventory adjustments that you want to import.
  4. Set up the a Mapping of the columns in your inventory adjustment import file to the corresponding fields in QuickBooks, as shown below
  5. Click Import and your inventory adjustments will be directly added to your QuickBooks company file.

For more information about importing inventory adjustments into QuickBooks, search the Knowledge Base, watch the movies in the Learning Centre, or raise a ticket with Zed Support.
Inventory Adjustment sample template

Import inventory adjustments

Note: You can either do a Quantity Adjustment which either adds or subtracts, or sets a new quantity (QuantityAdj.NewQuantity) in QuickBooks, 


you can do a Value Adjustment that sets the new $ value (ValueAdj.NewValue) of the inventory and optionally the new quantity (ValueAdj.NewQuantity).

BUT, if you combine both a QuantityAdj and ValueAdj you will get an error.

QuickBooks field Format  Description 
Account Ref Str 159  The adjustment account that the inventory adjustment will be posted to in QuickBooks 
Txn Date Date The date of the inventory adjustment
Ref Number Str 11 The reference number for the Inventory Adjustment, Axis uses this field to group rows together
Inventory Site Str 31 The inventory site that that adjustment is being made too
Customer Ref Str 209 The customer job that the adjustment is allocated to
Class Ref Str 159 The class used to categorize the transaction
Memo Str 4095 The Memo description used on the transaction
ItemRef Str 209 The full name of the inventory item as appears in QuickBooks 
QuantityAdj.NewQuantity   Sets the new quantity of the item held in stock
QuantAdj.QuantityDifference   Adjust the quantity of the item held in stock
ValueAdj.NewQuanity   Sets the quantity of items held in stock 
ValueAdj.QuantityDifference   Adjusts the quantity of the item held in stock
ValueAdj.NewValue   Sets the new value of the item held in stock
ValueAdj.ValueDifference   Adjusts the value of the item held in stock
Serial Number Str 4095 Records the serial number of the item, more
Lot Number Str 40 Records the lot number of the item held in stock, more
Troubleshooting Errors
Error: This transaction doesn't support items of this type.
This error occurs when you have specified an Item that is not an Inventory type ie a Service, or Non-inventory, QuickBooks can only adjust inventory quantities of items that are held in stock

Add Feedback