Skip to main content

Inventory Value Reports

Written by ShipTop

The Inventory Value Report provides a snapshot of the total value of your inventory stored at ShipTop.

This report helps you understand the value of your inventory based on the cost assigned to each SKU, making it useful for inventory planning, financial reporting, and month-end reconciliation.


Accessing the Inventory Value Report

  1. Navigate to Reports.

  2. Select Inventory Value.


What the Report Shows

The Inventory Value Report displays the current or historical value of the inventory stored in your warehouse.

Each row represents a SKU and includes information such as:

  • SKU

  • Product Name

  • Warehouse

  • On Hand Quantity

  • Available Quantity

  • Unit Cost

  • Total Inventory Value

  • Currency

  • Vendor (if applicable)

The total inventory value is calculated using:

On Hand Quantity × Unit Cost


Available Filters

Use the filters at the top of the report to narrow your results by:

  • Warehouse

  • Snapshot Date

  • Vendor

  • Currency

These filters allow you to quickly review inventory values for a specific warehouse or reporting period.


Monthly Inventory Snapshots

The Inventory Value Report includes monthly inventory snapshots, allowing you to view your inventory as it existed at the end of previous months.

Snapshots are automatically generated near the end of each month and can be used for:

  • Month-end accounting

  • Financial reporting

  • Inventory reconciliation

  • Historical inventory analysis

If you don't select a previous snapshot date, the report will display your current inventory values.


Common Uses

The Inventory Value Report is commonly used to:

  • Review the current value of your inventory

  • Prepare month-end financial reports

  • Reconcile inventory values with accounting records

  • Analyze inventory by warehouse

  • Review inventory investment by supplier

  • Monitor inventory levels over time


Things to Consider

Before using the report, keep the following in mind:

  • Inventory value is based on the unit cost assigned to each SKU.

  • If multiple currencies are used, filter the report by currency to calculate accurate totals.

  • Only inventory that is currently On Hand is included in the report.

  • Historical snapshots reflect inventory as it existed at the time the snapshot was taken and do not change after they are created.


Exporting the Report

Click Export to download the report as a CSV file.

The exported report can be opened in Microsoft Excel or Google Sheets for further analysis, financial reporting, or reconciliation.

Did this answer your question?