Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
RhoiceW
QuickBooks Team

Reply to message

Yes, Kristy, bulk inventory adjustments can be done through the QuickBooks Desktop version. I'd be glad to provide you with the steps.

 

If you're trying to do this on the QuickBooks Online Desktop app, you can follow the same steps provided by my colleagues above.

 

For QuickBooks Desktop (QBDT), you don't have to re-import your items. In QBDT, there's a feature that lets you adjust your inventory directly.

 

First, you’ll need to create an adjustment account to track your adjustments, if you haven't already.

 

Here's how:

 

  1. Select Company from the menu, then select Chart of Accounts.
  2. Select the Account dropdown, then click New.
  3. In the Other Account Types dropdown, select Cost of Goods Sold.
  4. Name this account "Inventory Adjustments," then click Save and Close.

 

Next, proceed to adjust a product's quantity, value, or both:

 

Here's how:

 

  1. Go to Inventory, then select Adjust Quantity/Value on Hand.
  2. In the Adjustment Type dropdown, select QuantityTotal Value, or Quantity and Total Value.
  3. Select your adjustment account and enter the adjustment date.
  4. In the Adjust Account field, select the account you set up earlier.
  5. Add a reference number.
  6. Select Find & Select Items and choose the items you want to adjust.
  7. Click Add Selected Items.
  8. Add the new quantity or new value for each item.
  9. Select Save and Close.

 

Finally, ensure your inventory status is correct by running a report. You can refer to this article for detailed steps: Adjust Your Inventory Quantity or Value in QBDT.

 

Additionally, you can refer to this article to know how to fix issues arising from negative inventory.

 

If you have any more questions or need extra help, don't hesitate to reach out. We're always here to assist and ensure you have a seamless experience with QuickBooks. Wishing you a fantastic day ahead!

Need to get in touch?

Contact us