Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
JoniB
Level 1

Inventory Valuation Detail

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. 

 

 

3 Comments 3
JonpriL
Moderator

Inventory Valuation Detail

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

  1. Go to File.
  2. Click Utilities.
  3. Select Rebuild Data.
  4. Click OK.

B. To Verify Data

  1. Go to File.
  2. Click Utilities.
  3. Select Verify Data.
  4. 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.

JoniB
Level 1

Inventory Valuation Detail

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.

ZackE
Moderator

Inventory Valuation Detail

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:

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


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!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us