Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowBasically, I previously asked why there would be a difference between The Physical Inventory Worksheet quantity and the Inventory Valuation Summary quantity if both are run at the same time and date. Giovann replied that one gives you the actual availability of the items for sales while the other will show the quantity on hand.
Do I understand correctly that the actual availability of the items for sale as listed on the Physical Inventory Worksheet may Not be the actual quantity on hand as presented on the Inventory Valuation Summary Report. Is this correct?
My question then becomes how do you reconcile the 2 reports since the Inventory Valuation Summary Report calculates inventory incorporating future transactions and the Inventory Detail Valuation does not show any future transactions?
Thank you,
Bob1221
Thanks for posting your concern here in the Community, bob1221.
I've got you covered. We want to ensure that we're giving you the correct information to answer your question.
Can you please provide me with some screenshots for both of your reports in QuickBooks?
I hope you can respond to me on this thread so we can work on your concern together. I'm always here to help. Keep safe!
Kevin,
Currently I cannot recreate the issue.
As such, I know the steps to find inventory transactions post inventory valuation summary report date. How do I see view the transactions which effect the physical inventory worksheet?
Thank you,
Bob1221
Hello, @bob1221.
Thanks for getting back to us. Allow me to chime in and share information about the report that you're referring to in QuickBooks Online (QBO).
Currently, there isn't a way to view the transactions that affect the Physical Inventory Worksheet. As mentioned by my colleague in your other post, this report will only show the actual availability of the items for sales. This report will help you keep track of your inventory count.
The Worksheet shows the actual count after all transactions, whether dated in the past or the future, while the Valuation Summary shows the count as of the date indicated in the report.
To learn more about managing inventory and other reports in QBO, consider checking out these articles:
For tips and other resources, I also recommend visiting our website for future reference: Self-help articles.
If you have additional questions about these reports or anything else QuickBooks, please let me know, and I'll get back to you right away. I'm always here to help. 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.