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
- Run Month-end inventory snapshot and value.
- Look for negative quantities and missing costs.
- Cycle count your A-grade products.
- Read the month's adjustments, especially damaged and theft or loss.
- 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.
