Import inventory adjustment into QuickBooks Online


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.

Note:  If the inventory item has been used on a memorized transaction in QuickBooks Online you will get an error when trying to adjust the quantity.  This is a limitation of QuickBooks Online that we have notified Intuit Developer support about but at the moment we do not have a way to address that.

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 Item and map the following fields
    • Name - The name of the inventory item (Product)
    • Fully Qualified Name - The full name of the inventory item, which may include the 
    • Type - The type of item which should be Inventory
    • Income Account - The income account for the item
    • Expense Account - The expense of cost of goods sold account for the item
    • Asset Account - The inventory asset account for the item
    • Inventory Start Date - When updating and existing inventory product this will be the adjustment date
    • Qty On Hand - The quantity on hand for the item as at the date mapped in the field above
  4. And select the option to Append
  5. Click Import and the items quantities will be updated in QuickBooks Online