Is there a way to run a report that shows the total retail value of my inventory?

Hello there, kt19.

You can run the Stock Valuation Summary. This report displays the transactions for each stock item, and how they affect the quantity on hand, value, and cost. For the Stock Valuation Detail report, this shows the quantity on hand, value, and the average cost for each stock item.

Here's how you can run the report:

1. Go to Reports.
2. Scroll down to Sales and customers section.
3. Select the Stock Valuation Summary or Stock Valuation Detail.
4. Choose the Report period and click the Run report button.

Please see the sample screenshot below:

You can also check the following articles below on how to customise the report as well as run other reports for stocks:

• Customise reports in QuickBooks Online
• Stock Reports
• Use reports to see your sales and stock status

Let me know in the comments if you need anything else. Thanks.

Hi Renjolyn C,

Thank so much for your reply.   Stock Valuation Summary is not listed as a report.  I have QB Plus—maybe it's only avaiable with Advanced or can I find this report another way?

Thank you!

Nice to hear from you again, kt19.

The Stock Valuation Summary report is also available in QuickBooks Plus. It's possible that we haven't turned on the Track stock quantity on hand feature in the settings.

Let's go to the Account and Settings and enable this feature. This way, you'll be able to pull up the Stock Valuation Summary in your book.

Here's how to turn on this feature:

1. Go to the Gear icon.
2. Click Account and Settings under Your Company.
3. Select Sales on the left side.
4. Click the Pencil icon for the Product and Services section.
5. Mark check inside the Track stock quantity on hand box.
6. Tap Save. Then, Done.

Once done, you can follow the steps provided by my colleague RenjolynC.

Please get back to us if you have additional questions about the Inventory reports in QuickBooks Online. We are all right here to help! Take care!

Hi SarahannC,

Thanks so much for the info.  I followed the steps you provided and 'Track Inventory Qty on hand' was checked already.   I uncheck, rechecked & refreshed but there is still not an option to add the 'price' to the Inventory Valuation Detail Report.  Any other ideas?

Thanks again!

Chiming in to share more reports that will show the prices of your products, kt19.

The best report I can suggest is the Product/Service List report. This will give us not only the sales price, but also the name, description, purchase cost and also the quantity on hand. Simply search and open it on the Reports tab.

If the value/price still isn't showing, please check the way you set up the products. It's possible that we're unable to enter a Sales price/rate. Just go to Sales tab and select Products and Services. From the Action column, click Edit.

You can also read these guided on how to make your reports more presentable:

• Run reports

• Customise reports in QuickBooks Online

Comment again if you have more clarifications. I'll be glad to help.

Hello AlexV,

Thanks very much.  This report is quite helpful and the sales price is showing, which is great.  Only thing is that there isn't a total for the price column, which is what I need.  Is there a way to find this information?

Thanks again!