I appreciate you messaging us here. QuickBooks is a dynamic program that offers a variety of features that help you streamline your work. I'll be happy to assist you from here so you can find the info you need in QuickBooks.
Based on what you've described, I recommend running the Inventory Valuation Detail Report. This report shows the quantity on hand, value, and average cost for each inventory item. The good thing is you can filter the dates on the reports so you can get a historical view of your inventory. You can run this report by clicking Reports on the left menu and searching for the Inventory Valuation Detail Report.
Here's a helpful article that shows you how to: Customize reports in QuickBooks Online. I encourage you to try this out and let me know how you make out. I'll be one message away in case you additional support.
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.