Historical Stock

Last Updated: Jul 30, 2019 08:08PM PDT
This report shows stock and inventory financial information for the selected timeframe. Use this report to get a picture of your stock and sales data for a given time period.  Tip: For real-time stock snapshots by warehouse, download the Inventory CSV.

Note: This article applies to both our Stitch X and Stitch Classic Versions.

Parameters

Filter by start and end date.

To appear in this report, a variant must have had stock or been on an order that closed within the timeframe you select.

Note: This report only returns data for periods within the life of your Stitch account.

Data

This report includes the following fields:
Field Definition
Starting Stock  Stock quantity at the beginning of the period
Ending Stock Stock quantity at the end of the time period
Ending Avg. Cost Average unit cost at the end of the period
Ending Assets Inventory asset value at the end of the period
Units Sold Quantity of units on orders closed during the period
Units Returned Quantity of units received from returns during the period
COGS Cost of goods sold for orders closed during the period minus cogs from returned or reopened orders
Units Received  Quantity of units received from purchase orders during the period
Received Purchases Value of units received from purchase orders during the time period
Adjustments Value  Value of adjustments made during the time period 

Use Cases

Use this report to view historical inventory data for any period within the life of your Stitch account. This information can be particularly helpful for monthly or quarterly tax calculations.