Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have an inventory item that I want to make inactive as it was entered as a duplicate in error. I made an inventory adjustment December 18th to reduce the inventory levels to be zero and then I made it inactive. When I ran my financial statements at the end of November, the Inventory Valuation Summary did not balance to my GL. After doing some digging, I figured out that that particular inventory item that I made inactive had a Asset Value attached to it, which is the amount that I was out.
I can see where the discrepancy is; however, I am not sure how to fix the Asset Value (or even if that is what I need to fix?) for this item because it was posted in a previous fiscal year and I am unable to go in and correct it. I am not overly familiar with the inventory aspect of Quickbooks so I would really appreciate any help regarding fixing this error and potentially any help to avoid this happening again.
Thank you!
Can someone please advise on the best way to fix this problem?
Thanks for posting in the Community space, @RLSS.
You can create a journal entry to zero out the amount of that inventory item. This way, it will balance your Inventory Valuation Summary and General Ledger. Let me guide you how:
Also, once you zero out the inventory item it will not affect your historical transactions in QuickBooks.
However, I'd suggest consulting an accountant to help and guide on which account to debit and credit. Your accountant can provide more expert ways of dealing with this situation.
For more details, see this article: Create a journal entry in QuickBooks Online.
In case you need an additional reference about what you can adjust, I'm adding the article below: Adjust inventory quantity or value.
Also, you can run inventory-related reports in QBO. Simply go to the Reports menu, and then refer to the Sales and customers section.
Feel free to leave a comment below if you have other questions in mind. I'll be sure to get back to you.
Thank you for the information.
I suppose my question is, what happens when you make an inventory item inactive? Because when I do that, it changes the Inventory Valuation in all previous periods.
Is there no way of making a product inactive without it affecting the value in previous periods?
Thanks for your help!
Hello again, @RLSS.
Once you inactivate an item in QuickBooks Online (QBO), it won't affect historical transactions. But before doing so, ensure first the item has zero quantity. If the item has quantity when making it inactive, you'll need to adjust, then make inactive.
To adjust Inventory Quantity to zero, here's how:
You can check the Adjust inventory quantity or value for more information.
Additionally, to know more about modifying the products and services in QBO, see this link: Remove or merge a product or service.
Let me know if you have any other concerns. I’m always ready to answer them for you. Have a good one.
I have a min. of three items that have a negative Asset Value.
Two of the items have Zero inventory, therefore they should have a zero asset value. see attached, they have a negative asset value.
The other items has a qty of 2035, should have an asset value of 0.25, with a Calc. Ave of $508.75, see attached.
Once these three asset value are fixed, how do I check to make sure other items have the correct asset value and calc. avg.?
Meredith
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