Question

Inventory Valuation Detail

Forum|Forum|5 years ago
March 15, 2021
3 replies
18 views

My 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.

QuickBooks Desktop

J

JonpriL

Level 9

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

Go to File.
Click Utilities.
Select Rebuild Data.
Click OK.

B. To Verify Data

Go to File.
Click Utilities.
Select Verify Data.
Click OK.

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.

J

JoniBAuthor

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.

Z

ZackE_

Moderator

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:

In your top menu bar, go to Help, then QuickBooks Desktop Help.
Choose Contact Us.
Enter a brief description of the issue in our Ask a question (or tell us what's wrong) field.
Click Continue.
Select We’ll contact you for callbacks or Message Us to start an instant messaging session.