At year end, your accountant needs the value of everything you own that you'll sell or use to make things: finished products, ingredients, packaging and anything half-made, counted on the last day of the year and valued at cost. Shopify gives you part of that: a stock count to correct finished-product quantities, an inventory export, and the Month-end inventory value report for December. The rest, everything that isn't a Shopify product, has to be counted and priced separately.
This is general information, not tax advice. Your accountant decides how inventory is treated for your business.
The short version
- Count on the last day of the year, or as close as you can, with orders paused.
- In Shopify: a stock count per location, reviewed and approved.
- Export inventory (All states) right after approval. Stock counts themselves can't be exported.
- Run Month-end inventory value for December. It needs cost per item on every variant.
- Count ingredients, packaging and work in progress on a separate sheet, with costs from invoices.
Step 1: Prepare in early December
- Fill in cost per item for every variant. Without it, the value report leaves the product out.
- Receive every open transfer and purchase order.
- Fix duplicate barcodes and label shelves.
- Print a sheet for everything not in Shopify: ingredients, packaging, supplies for resale, work in progress.
Step 2: Count on December 31
Create a stock count for each location, count, request review, approve. Shopify stocktake covers the day. Count the non-Shopify sheet at the same time, so both are a picture of the same moment.
Step 3: Record it
- Export inventory from Products > Inventory, All states, all locations.
- Run Month-end inventory value for December under Analytics > Reports. Since October 1, 2026 it uses on-hand quantities, including committed and unavailable units.
- Price the sheet: each ingredient and packaging item at its most recent cost, or the method your accountant uses.
A made-up example
Kāneʻohe Kombucha closes its year:
| Stock | Source | Value at cost |
|---|---|---|
| Cans and kegs of kombucha | Shopify Month-end inventory value | $6,820 |
| Tea, sugar, fruit, ginger | Count sheet, priced from invoices | $2,140 |
| Empty cans, lids, labels, cartons | Count sheet | $4,310 |
| Kombucha fermenting (work in progress) | Count sheet, at ingredient cost | $1,050 |
| Total closing inventory | $14,320 |
Shopify's report alone would have said $6,820, less than half.
What the accountant does with it
Closing inventory feeds cost of goods sold: opening inventory, plus purchases, minus closing inventory. Undercount closing stock and the year's cost looks higher and profit lower; overcount it and the reverse. Shopify cost of goods sold covers how Shopify's own COGS differs from the accountant's.
Where this stops working
Shopify's half of the close is quick. The other half, the count sheet, is where errors live: an ingredient priced from an old invoice, a box of labels forgotten in the garage, fermenting tanks guessed. And it's done once a year, so nobody remembers how last year's was priced. Shopify month-end inventory covers a monthly close that makes year end routine.
How TaroStack does it
TaroStack for Shopify runs inside your Shopify admin and keeps ingredients, packaging and finished products in one count, valued first in, first out, including freight. Stock value by site and month is ready to print or export as a spreadsheet for your accountant, and finished products' counts go to Shopify. Free for 14 days.
