Inventory Value Reports Overview

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

  • If an item has no inventory at all – no physical, reserved, or available inventory – the item/warehouse for that day is not saved.
  • Inventory is not stored on non-independent kits.
  • Inventory is stored on shadow parent SKUs, not on shadow SKUs.
  • Inventory quantity and value is stored each day for the past 180 days. After that time period elapses, SellerCloud only keeps a record of the first and last day of each month. For example (assume the following dates are past the 180-day mark):
    • Using the As of Date filter:
      • As of 11/3 report will show inventory as of 11/1, the last date inventory was recorded before 11/3.
      • As of 11/30 report will show inventory as of 11/30, the last date inventory was recorded.
    • Using the Date Range filter:
      • 11/4 through 2/28 report will show inventory on the following dates: 11/30, 12/1, 12/31, 1/1, 1/31, and 2/1.
      • 11/4 through 11/29 (same month) will not show any results.

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:

Was this article helpful?

Related Articles