Import inventory adjustment into QuickBooks Online

Axis

Overview

If you need to adjust the quantity of inventory items held in stock in a QuickBooks Online company file you can do that in batch using Zed Axis v2025 and above.  




Steps to update the item inventory quantities

Follow these steps to update the quantity on hand for inventory items in QuickBooks Online
  1. Open Zed Axis and connect to your QuickBooks Online company file
  2. Browse to the file that contains the items and the quantities on hand you want to adjust
  3. Create a new mapping for Inventory Adjustment and map the fields shown in the table below.
  4. Click Import and the items quantities will be updated in QuickBooks Online

Fields that can be mapped when importing inventory adjustments


QuickBooks Online FieldFormatDescription
Adjust Account Ref NameStr 21Mandatory Field - The Full Name of the GL Account which will be debited for the value of the adjustment
Item Ref Full NameStrMandatory Field - The Full Name of the Inventory Item whose quantity will be adjusted (must be Inventory Type and match in QuickBooks Online) 
Doc NumberStr 21The reference number for the inventory adjustment, used to group rows together.  If left blank or unmapped then auto populated by incrementing the last reference number by one.
Txn DatedateThe date of the adjustment, If you leave TxnDate out the mapping, the current date in QuickBooks Online will be used.
Private NoteStr 4000User entered, organization-private note about the transaction. 
Quantity Adj Quantity DiffDecimalMandatory Field - The change in the quantity of the item held in inventory, positive to increment or negative for decrementing the quantity.

Where the fields appear


Article ID: 387, , Modified: 4/15/2025 at 6:46 AM

Was this article helpful?

Share this article