Inventory Value Reports Overview

Updated 3 months ago

Please read this first!

Inventory report data is not real-time. Your server has built-in services that run daily to check for any changes to items and record the inventory count accordingly at that time. (See the Timestamp column in the exported Excel file of the Inventory by Product Detail report.) Therefore, your report accuracy will vary based on the time of day that you run an Inventory report.

Inventory Value reports provide a detailed reporting of your inventory  - available and physical - in any warehouse.

The reports show the value of your inventory, product aging, and unsold inventory, and detail the quantity on hand (QOH) for any given day.

Inventory Value does not include inventory in warehouses that are marked as a "Dropship" warehouse type.

For answers to general questions about SellerCloud's Financial Reporting Suite, see the Reports FAQs.

Key points

  • Inventory information is stored each day for the past 180 days. We store each product per warehouse. For inventory older than 180 days, only the first and last day of the months' information is stored.

  • If an item has no inventory at all - no physical, reserved, or available inventory - we will not save that item/warehouse for that day.

  • Inventory is not stored on non-independent kits.

  • Inventory is stored on shadow parent SKUs, not on shadow SKUs.

Inventory Value Dashboard

The Inventory Value Dashboard offers several graphs (use the date filter to select by a preset date range or a custom range. The selection will affect all graphs except the Inventory Turnover):

  • Inventory Value - Shows current total inventory value for each day in the selected date range, available and reserved, sellable and unsellable warehouses 

  • Total Value - Shows Average Inventory Value for the selected date range (sum of values for each day/number of days)

  • Reserved Qty Value - Shows Average value of reserved quantity (unshipped orders etc.)

  • On Order Value - Shows actual value of item in unreceived PO (PO must be marked as approved)

  • Top Products By Inventory Value - Shows products with the highest cost

  • Inventory Turnover - Shows how many times inventory is sold and replaced over a period. Uses its own date range filter.
    • Inventory Turnover calculation: Cost of Goods Sold / Average Inventory.  For example, if over 180 days COGS was 200,000 and Average Inventory is 20,000, then Inventory Turnover = 10. This means that inventory turned over 10 times in the past 180 days.

    • Average Inventory calculation: Calculate each month's average inventory, add these figures, and divide by the number of months. This accounts for fluctuations in inventory.

Inventory value reports

You can run 8 inventory value reports:

How did we do?