Adjust inventory quantities

This feature is available only for companies that track inventory items in QuickBooks Plus.

Sometimes you might discover that you have either more or fewer of an inventory item than QuickBooks shows. If that happens, you can easily adjust that item's quantity in QuickBooks to match what you actually have in stock.

Need to count your physical inventory before adjusting quantities? Print the Physical Inventory Worksheet, enter your actual counts on it, and then adjust your inventory quantities in QuickBooks. To get your worksheet, in the navigation bar click Reports > All Reports > Manage Products and Inventory > Physical Inventory Worksheet.

  1. If you have a lot of inventory items to adjust:
    1. Click the Gear icon > Products and Services.
    2. Select the inventory items you want to adjust.
    3. Click the Batch actions drop-down arrow and select Adjust quantity.

    Otherwise, click Create (+) > Inventory Qty Adjustment.

  2. If necessary, change the adjustment date.
  3. If necessary, click the Inventory adjustment account drop-down arrow and select a different account. We set up one for you already, but you can change it if you want to.
  4. If the table is empty, add the inventory items you want to adjust:
    1. In the first row in the table, click the Product field.
    2. Click the drop-down arrow and select an inventory item.
    3. Repeat steps a and b to add other inventory items as needed.
  5. For each inventory item in the table, enter either a new quantity or a change in quantity.
  6. For example, the Qty on Hand column shows that you have 10 widgets, but you discover that 2 widgets are missing. You can adjust the quantity either by entering 8 in the New Qty column or by entering -2 (negative 2) in the Change in Qty column.

  7. (Optional) Do your future self (and your accountant) a favor by entering a reminder in the Memo field about why you made this adjustment.
  8. Click Save.

See also

Edit an inventory quantity adjustment

Adjust an inventory item's starting value