Skip to content

Shopify Inventory Value Report: Month-End Stock at Cost

How Shopify's month-end inventory value report works, why it needs cost per item, what changed on October 1, 2026, and what it leaves out for makers.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed October 27, 2026 · 3 min read

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

  1. Go to Analytics > Reports.
  2. Filter Category to Inventory.
  3. Open Month-end inventory value and pick the months.
  4. 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.

Questions people also ask

Why is my Shopify inventory value zero?

Usually because cost per item is blank on your variants. Add costs, and the report values them from then on.

Does Shopify's inventory value include incoming stock?

No. Ending quantity excludes incoming units on transfers. They're counted once received.

What inventory value does my accountant need?

Usually the value of everything you own at the year's last day, at cost: finished goods, work in progress, ingredients and packaging. Shopify's report covers the first. The rest comes from a count of the shelves and your supplier invoices. Shopify year-end inventory walks through the count.

Is Shopify's inventory value at cost or retail?

At cost, using cost per item. The ABC product analysis report also shows a total value at the selling price.

Sources

  1. Shopify Help Center: Inventory reports · read October 27, 2026
  2. Shopify Help Center: Profit reports · read October 27, 2026
  3. Shopify Help Center: Cost per item · read October 27, 2026

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

TaroStack for Shopify

Free for 14 days.