Skip to main content
D
DanOR
December 18, 2020
Question

How to correct my Inventory Valuation Summary Report not matching my Inventory Valuation Detail Report? Is there a way to determine which one is correct?

  • December 18, 2020
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

C
Catherine_B
December 18, 2020

Hello there, DanOR.

 

The Inventory Valuation Summary shows the quantity on hand, value, and the average cost for each product. Inventory Valuation Detail report on the other hand gives you the transactions for each inventory item, and how they affect quantity on hand, value, and cost.

 

Let's ensure that you used the same report period for both reports to show the same amounts. Then, look into the quantity on hand and asset value if they're correctly posted. You'll want to open a new tab and pull up one report from there so you'll just have to switch tabs. 

 

For more details on handling your inventory, you can check out these articles:

 

Let me know if you have other questions. Take care!

D
DanORAuthor
December 18, 2020

Catherine_B

Thank you for your response.  I have attached a few screen shots of the two reports, Inventory Valuation Summary and Detail, for one of the items with the quantity difference.  They were both run for the period All Dates a few seconds apart.  (We update our inventory through receipts and invoices in batch around midnight.)

For context, we have around 50 inventoried items, seven of which have this issue being off between 1 to 7 units.  In all of the seven cases the Asset Value is identical in the two reports though the Qty is different.

M
MaryAnn_E
December 18, 2020

Hi there, @DanOR.

 

 

Let's make sure that the setup of the inventory is accurate. You'll want to check each transaction on the reports to verify the quantities.

 

Also, you can attach the screenshot again for visual a guide. If the same things happen, let's perform some troubleshooting steps to get this fixed.

 

There are times that the browser stores accessed data, thus causing websites, like QuickBooks Online (QBO), to act weirdly. Let's try logging in to your QBO account using a private browser and run the reports.

 

Here's how:

 

  • Press Ctrl + Shift + N on your keyboard for Google Chrome and Mozilla Firefox. 
  • Press Command + Shift + N for Safari. 

 

If this works, it means that you need to clear the browser's cache so the system can start fresh. 

 

If you get the same result while using a private browser, I recommend switching to a different one.

 

Stay in touch with us if you have other questions. We're always willing to help. Take care! 

Terms & ConditionsAccessibility statement