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 nowMy Inventory Valuation Details report does not agree with my Balance Sheet Inventory account.
On the Inventory Valuation Detail report, there are several inventory items that have an on hand counts and values. These items were sold and recorded on create invoices. As a result of the create invoices - those items were credited to the inventory account on the balance sheet and not listed on the physical inventory worksheet, but they still appear on the inventory valuation detail report which in turn, does not agree to the balance sheet. Some were sold in 2018 & 2019 as well as the current year. I don't understand why they are appearing in the details when they were sold. I'm not sure how to fix this. Any help would be greatly appreciated.
Hello @JoniB,
Let's run the QuickBooks Utility tools and fix the incorrect data showing on your reports related to your inventory accounts. Let me show you how.
A. To Rebuild Data
B. To Verify Data
In addition, here's an article you can read to learn more about the QuickBooks tools: How to fix possible data damage on your QuickBooks Desktop company file?
Lastly, I've also included this reference for a compilation of articles you can use while working with us: Know where you stand financially.
If there's anything else that I can help you with, let me know in the comments. I'll be happy to help.
Thanks for your help
However, my Inventory Valuation Detail still does not agree to the Balance Sheet.
In addition to your suggestion, I downloaded QuickBooks Tool Hub. I ran the Quick Fix my File, QuickBooks File Doctor, QuickBooks Program Diagnostic Tool as well as updating Windows.
Unfortunately the Inventory Valuation Detail still does not agree to the Balance Sheet.
Thanks for following up with the Community, JoniB. I appreciate you performing my colleague's recommended troubleshooting and informing me of what else you've tried.
Since your Inventory Valuation Detail and Balance Sheet reports still aren't matching, I'd recommend getting in touch with our Customer Care team. They'll be able to pull up the account in a secure environment and conduct further research with you.
They can be reached while using QuickBooks.
Here's how:




Be sure to review their support hours so you'll know when agents are available.
Please don't hesitate in sending a reply if there's any questions. Have a wonderful day!
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