Read the month-end inventory report in Shopify
The month-end inventory reports are the stocktake in numbers: what was on hand at the end of the month, and what it was worth at cost. This tutorial reads the month-end snapshot and the month-end value for 31 October 2026.
Written · Shopify admin, desktop steps · 6 minutes read
The worked example
| Month end | 31 October 2026 |
| Units on hand | 269 |
| Inventory value at cost | $2,908.25 |
| Measure since 1 October 2026 | On hand, not Available |
| Reports used | Month-end inventory snapshot, Month-end inventory value |
Download the record: inventory-value.csv (159 bytes).
An inventory value record for the worked example month end. Each row is ending quantity times cost per item, and the rows sum to $2,908.25.
1Open the reports list
From your Shopify admin, go to Analytics then Reports. Click the Category filter and click Inventory to show only the inventory reports.
2Open the Month-end inventory snapshot
Click Month-end inventory snapshot. It shows the quantity of each product variant you had in stock at the end of each month, and covers variants adjusted or ordered in the last three years.
3Read the ending quantity
Read the Ending quantity column. Since 1 October 2026 the reports measure stock by On hand quantity, which includes Available, Committed and Unavailable units, and excludes Incoming units in a transfer.
4Open the Month-end inventory value
Click Month-end inventory value. It totals the On hand inventory on products with a cost per item value assigned at the time of sale. The total value for each variant is its cost per item times its ending quantity.
5Check the sell-through rate
Open Products by sell-through rate. Sell-through is total quantity sold divided by total quantity sold plus total quantity still in inventory, so it shows how fast stock is actually moving.
6Watch for negative quantities
A negative ending quantity means you oversold a variant, or the variant has no inventory tracking switched on. A variant with 5 units at the start of the day and 8 orders fulfilled during the day ends the day at −3.
7Export the report
Click Export to download the report as a CSV file. Inventory reports are not real time, so check the date at the top of the report before you act on the numbers.
The arithmetic
| Product | On hand | Value at cost |
|---|---|---|
| Trail Crew Tee, $9.50 cost | 120 | $1,140.00 |
| Summit Hoodie, $18.00 cost | 64 | $1,152.00 |
| Canvas Tote, $7.25 cost | 85 | $616.25 |
| Total | 269 | $2,908.25 |
Sell-through for the tee is 42 units sold divided by 42 sold plus 120 still on hand, which is 25.93%. The month-end value is $1,140.00 plus $1,152.00 plus $616.25, which is $2,908.25.
Held at the counter
On hand is not Available. Since 1 October 2026 the reports measure On hand, which includes Committed units for orders pending fulfilment and Unavailable units set aside by apps or held for other reasons. The number can read higher than the stock a customer can actually buy.
A negative ending quantity means overselling. If you oversell a variant, the Available quantity drops below zero. While the orders are unfulfilled the oversold units sit as Committed and offset the negative, so On hand does not drop below zero until the orders are fulfilled.
Inventory history stops at 1 October 2023. Historical data for inventory-based metrics goes back only to 1 October 2023. A report that reaches further back will show nothing for the earlier dates, which is a gap in the data, not empty shelves.
Sources
- Inventory reports — Shopify's help pages: the month-end snapshot, the month-end value, the On hand change, the sell-through formula, and the negative quantity rules.