Bulk Inventory Adjustments

Thanks for reaching out to the Community, 9130350041850136.

When making an inventory quantity adjustment, you can select multiple products and update each item's quantity.

Here's how:

1. In your left navigation bar, use the + New button.
2. Choose Inventory qty adjustment.
3. Enter an Adjustment date.
4. Pick an appropriate account using your Inventory adjustment account drop-down list.
5. Choose each of the products in your Product field. Their descriptions and current quantities will auto-populate.
6. Enter the new quantity for each item.
7. In your Memo field, enter details about the adjustment.
8. Select Save and close.
   

I've also included a couple detailed resources about working with inventory quantity adjustments which may come in handy moving forward:

• Adjust inventory quantity on hand
• Edit an inventory quantity adjustment

If there's any additional questions, I'm just a post away. Have a lovely Tuesday!

We have 1200 items to adjust all of them one at a time would take 7 business days. I am looking link in QuickBooks that would allow us to adjust everything all at once up or down. Not one at a time.

Thank you. Now that I have the list I have noticed that I added a few items that do not need adjustment, how do I remove them from the adjustment list before I start making the adjustments?

It's great to see you again here in the thread, Terry. I'll be happy to help you remove items that don't need any adjustments when making an inventory adjustment in QuickBooks Online (QBO).

Before anything else, I'd like to ensure that we're on the same page. May I ask if you're still in the Inventory qty adjustment screen? If so, and you've got all your items added in the Product field, you can use the list you have to determine which item you don't want to include in the adjustment. Once you've found them, click the Delete or Trash icon beside the Change In QTY section.

Feel free to refer on the screenshot that I've attached below:

In addition, here's an article to help you keep track of your inventory items in QBO: Set up and track your inventory in QuickBooks Online.

You can also check this page about modifying reports and adding details to it: Customize reports in QuickBooks Online.

Thanks for dropping here today, Terry. Feel free to post here again if you have any additional QuickBooks-related concerns or needed help performing specific tasks in QuickBooks. As always, I'll be here, ready to assist you. Take care, and have a nice day!

No this slow and cumbersome solution. I am looking for something that will show all the inventory at once (without having to type in each manually) adjust up or down the amounts we need and save. When doing a large inventory we can pull items A-G, G-P, and P-Z to do the inventory in sections instead of typing each one by one. We have thousands of part numbers and typing them in one by one would take days. Please rework you solution to a faster better solution for the us the clients. 

Thanks for following up, 9130350041850136.

Since the steps mentioned above didn't do the trick, one other option to consider would be to export your inventory list as an Excel file, make any necessary changes, and then re-upload the file which would overwrite the previous entries. You can do this by:

1. Hovering over the Sales tab in the left navigation menu and click Products and Services.

2. Select the icon above the Action column on the right to Export to Excel.

Once you've updated the list you can import it by going back to the Products and Services page, click the drop down arrow beside of the green New button and select Import.

Double check the updated list before importing because as mentioned, the old entries will be replaced.

The following article offers additional info about exporting reports, lists, and other data from QuickBooks Online.

If you'd like to be able to make bulk adjustments within your account I recommend submitting feedback to the Product Development Team. This isn't currently an option in QuickBooks Online but would be a great addition to that platform. You can relay this to the Development Team directly through your account by clicking the Gear icon in the top right corner and then select Feedback.

Many product updates and feature releases come directly from great suggestions like yours. You can keep an eye out for these updates by checking out the Firm of the Future site. 

Please don't hesitate to reach back out if you have any other QuickBooks questions for the Community.

Does this create an inventory adjustment for accounting? We can't just update quantities- we need to be able to account for loss or gain.

Yes, it does, CGregory. QuickBooks automatically creates an inventory adjustment record to ensure that changes are accurately reflected in your inventory management and accounting records. Allow me to provide more details about this. 

When you import the updated list and quantities into your QuickBooks Online, as suggested by my previous colleague, please tick the Overwrite all values for each product or service that you import with the identical name option. Doing so will ensure the existing one in the system will be replaced and overwritten.

Refer to this article for more information: Import products and services into QuickBooks Online.
 

Additionally, we can generate an Inventory Valuation Detail report to view your inventory levels, costs, and value. It also provides insights into system adjustments, enhancing your inventory management.

Here's how:

1. Head to the Reports menu, then enter Inventory Valuation Detail on the search bar.
2. Customize it the way you want.
    

Moreover, I'm adding these resources as a guide in managing your inventory and sales transactions in the future:

• Record invoice payments
• Use reports to see your sales and inventory status

Ensuring the success of your inventory management is incredibly important to us. If you have any other questions or concerns you'd like to discuss, please share them with me.

Is there a way to do this in the desktop version  of quickbooks?

Is there a way to do this in the desktop version of QB?

@KristyK 

You can prepare your Inventory Adjustment data with the following template

then use an importer tool to proceed. It's a $199 one time license and you can purchase it thru a partner + you can get $100 cashback.

https://get.transactionpro.com/qbd

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 Quantity, Total 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!