Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Im using QBO inventory. My business switched software to one that is integrated with QBO and which created all our inventory items when the syncing process was done. When it did this I selected the each items expense and revenue accounts but never was given the option to select the "Inventory adjustment account". QBO set that account for me to a random paid in capital account that was created by me for the start-up capital we invested. I have since learned that all 1617 inventory items are being adjusted to this paid in capital account because the subaccount matched the preferences set by QBO (see screenshot). This has caused me a huge headache.
How do I correct this to have all 1617 items point to the right account without taking a week vacation to do ever single item individually. Ive gone through the motions for one and it takes 5 clicks and the typing of a 6 letter word to change it to the proper account. That's 17,787 clicks/keystrokes to correct them all. There has to be a better way.
If anyone comments with "Just do a journal entry" I might just lose my mind. I shouldn't have to remember to do that ever month or year.
From doing my own research, it is my understanding that QBO does not allow you to set your default adjustment account and that is the reason I'm in this situation.
I highly appreciate the details you've included in your post and the screenshot you've provided, @Akervin. I've got a way to help you change all the items in bulk. No worries, let's work together to achieve this.
In QuickBooks Online (QBO), we can utilize the Advanced Search feature to streamline the process of adjusting your inventory quantities. This way, you can quickly identify the items that need adjustments. This feature allows you to search and filter through your inventory items efficiently.
For visual reference, I've added a screenshot below:
By doing this, you can optimize your workflow, making the task of updating inventory levels more manageable and less time-consuming.
In addition, I'll be dropping this helpful article for you to learn how to check your inventory so you can always have an accurate inventory count: Fix negative inventory issues in QuickBooks Online.
Should you need further assistance or have additional queries about your inventory adjustment, please don't hesitate to reach out. I want to ensure that everything is taken care of just for you.
@Sherrie_F Okay, from the top.
@Akervin said "I have since learned that all 1617 inventory items are being adjusted to this paid in capital account because the subaccount matched the preferences set by QBO (see screenshot)." and "How do I correct this to have all 1617 items point to the right account without taking a week vacation to do ever single item individually."
You, @Sherrie_F , replied, in part "This feature allows you to search and filter through your inventory items efficiently. This way, you can quickly identify the items that need adjustments without having to manually search through your entire inventory list."
Do you see why your solution doesn't really accomplish anything?
It's okay, take as long as you need.
I'm not sure if this is answering your question but try going to Settings > Products and services. Click the filter (funnel) icon and under 'Type' select Inventory. Then click the 'Batch actions' drop-down and select 'Adjust quantity'. That will allow you to adjust all 1,617 items on one screen using the same inventory adjustment account. You can try other filters as needed to make it more manageable.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here