Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI commend you for identifying the cause of the imbalanced quantity of your inventory item through your reports and screenshots you've provided above, @DanOR.
You're able to correct the inventory and asset values on your reports (Inventory Valuation Detail and Summary) by manually adjusting the item's quantity. With this, you'll have an accurate number of stocks without recording a purchase or sale. The process will automatically record appropriate adjustments to your stock Asset and Cost of Goods Sold (under stock Shrinkage) accounts.
Inventory adjustments can be a tricky process since it can greatly impact your accounting records. With this, I'd also recommend consulting your accountant for further assistance. Once ready, here's how:
I've attached a screenshot below that shows the last four steps.
After that, compare the two inventory reports (Inventory Valuation Detail and Summary) again and see the update.
Additionally, there are a variety of reports where you can get helpful insights on the things you buy and sell and the status of your inventory. You can learn more about this through this article: Use reports to see your sales and inventory status. Then, you can customize them to focus on the details that matter the most to you.
Please let me know how it goes. Feel free to leave a comment below if you need anything else or follow-up inquiries about managing inventory items and accounts in QBO. I'm just around to help. Keep safe always, @DanOR.