Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
We have idenfitied instances where the Quantity Sold on the Sale Receipts in Quickbooks are not reflected as quantity out in the Inventory Valuation Detail Report (IVD). However, the total COGS on our PnL is the same as the total COGS on the IVD. This means that our COGS is understated by the cost of the missing quantity in IVD which is very alarming for us.
Hi wajihshafiq,
Thank you for visiting the QuickBooks Community. Let's check to see why the quantities on your reports aren't matching.
One of the reasons why there's a mismatch in the number of quantities on the reports you mentioned is the period covered. You'll want to match the date range on both reports. Aside from that, you can also switch the Accounting method in your PnL to Accrual.
If you still get the same thing, please do the basic browser troubleshooting steps. That way, we can check if this behavior is caused by random browser issues.
You can start by signing in to your QBO company using a private window. This step will disable the extensions and stops the cache from saving your search history.
If private browsing shows fixes the quantities, you can clear your browser's cache. If not, please use a different browser to see if this only happens to the one you are using.
Feel free to post back if you need further assistance. We're just around to help.
Hi JessT,
Thank you for your reply. I have tried all the steps you have suggested however the issue still remains. I'm attaching with this message.
I have a Sales Receipt J-221101-7 where quantity sold for one product is 23 units. On the Sales by Product/Service Summary report, the same Sales Receipt J-221101-7 for the same product shows quantity sold as 23 units. However, on the Inventory Valuation Detail report for the Sales Receipt J-221101-7 for the same product the quantity sold is 15 units. Please help me figure out why this is the case. Thank you!
I appreciate you for following the troubleshooting steps shared by my colleague above, @wajihshafiq.
Let me make it up to you by ensuring you get the best help available so this gets sorted out immediately.
Since you're still getting the same results after performing the suggested steps above, I recommend reaching out to our Customer Care Team. They have the necessary tools to check your account securely and perform a screen-sharing session to conduct further investigation into this behavior.
Here’s how to get in touch with them:
Please check out our support hours to ensure we can address your concerns promptly.
Additionally, you can focus on the details that matter most when you pull up reports in QBO. If you wish to know more about this process, I'd recommend checking out this article: Customize reports in QuickBooks Online.
You're always welcome to post again if you have other questions about managing reports in QBO. We're ready to help you all the time. Stay safe!
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