Read the month-end inventory snapshot in Shopify
The month-end inventory snapshot is the stock count your books close on: the quantity of each variant on hand at the end of the month, and what it is worth at cost. This tutorial reads the snapshot for the Trail Crew Tee and checks its value line by line.
Written · Shopify admin, desktop steps · 6 minutes read
The worked example
| Report | Month-end inventory snapshot |
| Product | Trail Crew Tee |
| Ending quantity | 36 units |
| Cost per item | $11.00 |
| Inventory value | $396.00 |
| Where to find it | Analytics, then Reports |
Download the record: trail-crew-tee-month-end-snapshot.csv (126 bytes).
A month-end snapshot record for the Trail Crew Tee: ending quantity and value at cost for each variant, adding to $396.00.
1Open Reports
From your Shopify admin, go to Analytics, then Reports. Reports are the home of every built-in inventory report.
2Filter to Inventory reports
Click the Category filter, then click Inventory. The list narrows to the inventory reports only, including the month-end snapshot and the month-end value reports.
3Open the month-end inventory snapshot
Click Month-end inventory snapshot. The report shows the quantity of each product variant you had in stock at the end of each month.
4Find the Trail Crew Tee rows
Find the two rows for the Trail Crew Tee: Medium Blue with an ending quantity of 24, and Small Blue with 12. The snapshot counts On hand quantity, which includes Available, Committed, and Unavailable units.
5Check the value
Multiply each ending quantity by its cost per item: 24 times $11.00 is $264.00, and 12 times $11.00 is $132.00. Together the two variants are worth $396.00 at cost at month end.
6Note what the snapshot leaves out
On hand excludes Incoming units that are part of a transfer, so a shipment on its way does not appear in the snapshot until it is received. Historical data for inventory reports goes back only to 1 October 2023.
The arithmetic
The inventory value is the ending quantity times the cost per item:
| Variant | Ending qty | Cost | Value |
|---|---|---|---|
| Medium Blue | 24 | $11.00 | $264.00 |
| Small Blue | 12 | $11.00 | $132.00 |
| Total | 36 | $396.00 |
24 times $11.00 is $264.00 and 12 times $11.00 is $132.00, which add to $396.00 for 36 units on hand. The value uses cost per item, not the selling price.
Held at the counter
On hand is not the sellable count. Since 1 October 2026 the reports measure On hand, which includes Committed and Unavailable units, so reported quantities can read higher than the Available count you sell from. Read the column name before quoting the number.
Incoming stock is not in the snapshot. Units on their way in a transfer are excluded from On hand until they are received. A snapshot taken the day before a delivery lands will look thin even when the stock is already bought.
Deleted locations vanish from history. Historical inventory for deleted inventory locations does not display in inventory reports. Only inventory from active locations shows, so a closed location takes its history with it.
Sources
- Inventory reports — Shopify's help pages: the month-end inventory snapshot, the On hand definition, the 1 October 2026 change, and the history limits.