Skip to content

A Month-End Inventory Routine for Shopify

A 30-minute month-end inventory routine for a Shopify store: the snapshot and value reports, a cycle count, adjustments to review, and costs to update.

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 has two month-end reports: the Month-end inventory snapshot, which shows each variant's on-hand quantity at the end of the month, and Month-end inventory value, which multiplies it by cost per item. A short monthly routine around them catches problems while they're small: run both reports, count the products that matter most, read the month's adjustments, and update costs that moved. About 30 minutes on the first working day of the month.

The short version

  1. Run Month-end inventory snapshot and value.
  2. Look for negative quantities and missing costs.
  3. Cycle count your A-grade products.
  4. Read the month's adjustments, especially damaged and theft or loss.
  5. Update cost per item for anything whose ingredients changed price.

The reports

Both are under Analytics > Reports, category Inventory, and include variants adjusted or ordered in the last three years.

Report Columns Watch for
Month-end inventory snapshot Product, variant, SKU, ending quantity Negative numbers (oversold, or untracked)
Month-end inventory value Same, plus cost and total inventory value Products with no cost, value jumping

Since October 1, 2026, ending quantity is on hand (committed and unavailable included), so October onward reads higher than September and before.

The routine

1. Negatives. A negative ending quantity means you sold more than Shopify thought you had. Either continue selling was on (fine if you meant it), or stock arrived without being entered. Fix the cause.

2. Missing costs. Any variant without a cost per item is missing from the value total. Fill them in.

3. A quick count. Count your A-grade products at the main location with a stock count. Shopify cycle count covers choosing them.

4. Adjustments. Open Inventory adjustment changes for the month, grouped by reason. A rising Damaged line is a handling problem; a rising Correction line is a process problem.

5. Costs. If an ingredient changed price, recalculate the products that use it and update cost per item.

A made-up example

On November 1, Kīhei Kettle Chips runs the routine:

  • Snapshot: Sea Salt 2 oz is at -18. Wholesale bags were packed from retail stock without an adjustment. Fixed with a transfer habit.
  • Value: $9,600, up from $7,900. A new flavor launched with 400 bags. Expected.
  • Count: 5 A-grade flavors counted; one is 6 short. The history shows samples at a fair, unrecorded.
  • Adjustments: 31 bags damaged, up from 8. A new shipping box crushes the bags. Box changed.
  • Costs: potatoes up 12%. Cost per item updated on all 2 oz bags.

Keep a one-page log

Write five lines each month: total value, the biggest count difference and its cause, the top adjustment reason, any cost changed, and one thing to fix. Twelve months of that page is the best preparation for year end there is, and it shows whether the fixes worked. A spreadsheet tab or a note on the shared drive is enough.

Where this stops working

The routine covers finished bags. Potatoes, oil, seasoning and bags aren't in Shopify, so the value is incomplete and nobody counts the ingredients until something runs out. Shopify inventory value report and Shopify raw materials inventory cover the missing half.

How TaroStack does it

TaroStack for Shopify runs inside your Shopify admin and closes the month for everything: stock value by site and month including ingredients and packaging, batch costs from what was actually used, a price-creep report per supplier, and what each count difference was worth. Free for 14 days.

Questions people also ask

What is the month-end inventory snapshot in Shopify?

A report of each variant's on-hand quantity at the end of each month, for variants adjusted or ordered in the last three years.

Why does my month-end snapshot show negative inventory?

Overselling, or products without tracking. Untracked products start at 0 and drop with each fulfilled order.

Can I see last year's month-end inventory in Shopify?

Yes, back to October 1, 2023, when Shopify's inventory data starts.

Do I need to count every month?

Not everything. A cycle count of your top products monthly, and a full count yearly, works for most small makers.

Sources

  1. Shopify Help Center: Inventory reports · read October 27, 2026
  2. Shopify Help Center: Viewing inventory adjustment history · read October 27, 2026
  3. Shopify Help Center: Creating and managing stock counts · read October 27, 2026
  4. Shopify Help Center: ABC inventory analysis · 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.