Use the Inventory Value Report to find the total wholesale and retail value of inventory on hand currently, or for any date in the past. The Inventory Value Report is commonly used to show your end-of-year inventory for accounting purposes.
Run an Inventory Value Report
In Back Office, go to Reports > Other Reports. The Inventory Value Report is at the top of the page.
Enter the same date in both the Start Date and End Date fields, then Run Report.
The Inventory Value Report provides a "snapshot" of inventory as of a certain date. Running this report for more than one date will generate multiple daily snapshots and compile them into one report, which isn't useful for most purposes.
Running an Inventory Value Report for the current date will provide a snapshot of inventory as of the time the report was run. Reports for previous dates reflect inventory as of 11:59pm on that date.
When the report is ready, a Download button will appear. You can also download the report later from the Tasks page.
If the report opens in a new browser tab instead of downloading to your computer, resulting in a screen full of illegible data, select File > Save As to download it manually.
View an Inventory Value Report
If your Inventory Value Report opens as a page of illegible data in your web browser instead of your chosen spreadsheet application, right-click the file and select Open With, then select your spreadsheet application, or, open your spreadsheet application first, then select File > Open and select the file.
Apply filters and calculate totals
Because the Inventory Value Report includes every product you've ever had in your inventory, organized by SKU, filtering the data is often necessary. Also, although the Inventory Value Report includes the total value of each SKU, it does not include the total value of all SKUs.
To quickly find the information you need, apply filters and use the AutoSum feature where necessary. For more details, see tips and tricks for working with spreadsheets.