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

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

OR 

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.