cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
Minette-du-Plessis
Level 1

Stock Valuation Summary shows wrong quantities; drill‑down shows different balances to the Stock Valuation Summary, Why?.

Both the Modern and Classic Views are showing incorrect quantities for several stock items. When we click on the quantity to drill down into the transaction details, the balance shown there differs from the balance displayed on the main report. This inconsistency makes it extremely difficult to complete our stock reconciliation.

1 Comment 1
Lyn_D
QuickBooks Team

Stock Valuation Summary shows wrong quantities; drill‑down shows different balances to the Stock Valuation Summary, Why?.

Hi, Minette. I hear you, and it’s tough to balance the books when the reports don't align. Stock reports can show different results because they rely on different data and dates.

 

To identify the root cause, reproduce the reports with All Dates to see if the totals match. If they do, you have a dating/timing issue.

 

Here's how:

 

  1. Go to the Reports menu.
  2. Search the Stock Valuation Summary report.
  3. In the Report period dropdown, select All Dates.

  4. Pull up the Drill-down report and apply the same filter.

 

Once done, check the setup and method. Ensure that the items are marked as inventory and that your costing method (like FIFO) is set correctly. I've also added some helpful articles for future reference:

 

Please try these steps and let us know if the summary report now matches the detail report. If the reports still do not align after trying these steps, please reply to this thread. I'd be happy to provide additional steps.