Shopify's Month-end inventory value report, under Analytics > Reports in the Inventory category, multiplies each variant's cost per item by its on-hand quantity at the end of the month, and totals it. It only values variants that have a cost per item entered, so a product with no cost shows no value at all. Since October 1, 2026, the report counts on-hand stock (including committed and unavailable units) rather than available, so values can be higher than in earlier months.
The short version
- Total inventory value = cost per item × ending quantity, per variant, summed.
- Variants without a cost per item don't add to the total. Fill costs in first.
- Ending quantity is on hand at the end of the last day: available, committed and unavailable, not incoming.
- From October 1, 2026, the report uses on hand. Earlier months still show available.
- Historical inventory data starts on October 1, 2023. Deleted locations don't appear.
Running the report
- Go to Analytics > Reports.
- Filter Category to Inventory.
- Open Month-end inventory value and pick the months.
- Export it for your accountant.
The columns are product title, variant title, variant SKU, cost, ending quantity, and total inventory value, with a summary row at the bottom. The report includes variants adjusted or ordered in the last three years.
Getting the cost right
The report is only as good as Cost per item, which you enter on each variant. Shopify uses the cost recorded at the time of sale for its profit reports, so a cost entered late won't fix past months' profit.
For a reseller, cost per item is the supplier's price plus freight. For a maker, it's what one unit took to make, and that changes with every batch. A made-up example:
| Batch of Lilikoi Butter | Cost |
|---|---|
| Passion fruit, 20 lb | $64.00 |
| Butter, sugar, eggs | $41.50 |
| 60 jars, lids, labels | $57.00 |
| Total for 60 jars | $162.50 |
| Cost per jar | $2.71 |
If passion fruit goes up 40% next month, the next batch costs more, but Shopify keeps the $2.71 until someone changes it. Shopify cost per item and Shopify production cost cover working it out.
Negative and odd values
A negative ending quantity, from overselling or from products without tracking, appears in the snapshot. Check for them before sending the report anywhere. Shopify month-end inventory covers a short close routine.
Where this stops working
The report values finished products only. A maker's stock is mostly upstream: the fruit, butter, jars and labels on hand at month end don't exist in Shopify, so they're missing from the total. For a bakery or a jam kitchen, that can be half of what the business owns. The report also takes one cost per variant, not the cost of each batch, so it can't value two batches made at different costs. Inventory valuation methods explains why that difference matters.
How TaroStack does it
TaroStack for Shopify runs inside your Shopify admin and values everything on hand: ingredients, packaging and finished products, by site and by month. Each batch's true cost comes from what it actually used, at what those ingredients cost, including freight. Stock is valued first in, first out, so two batches made at different costs are each valued at their own. Free for 14 days.
