Skip to content

Year-End Inventory for a Shopify Business

How to close the year's inventory on Shopify: the count, the export, the value report, and the ingredients and packaging your accountant needs too.

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

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

  1. Export inventory from Products > Inventory, All states, all locations.
  2. Run Month-end inventory value for December under Analytics > Reports. Since October 1, 2026 it uses on-hand quantities, including committed and unavailable units.
  3. 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.

Questions people also ask

Do I have to count inventory at year end for a Shopify store?

Most businesses that hold stock count at year end so closing inventory is accurate. Ask your accountant what your business needs.

Can I count inventory a few days after December 31?

Yes, if you adjust for what was sold and received in between. Counting on the day is simpler.

Does Shopify calculate my closing inventory?

For finished products with a cost per item, the Month-end inventory value report does. Everything else is up to you.

What cost should I use for ingredients?

The method your accountant uses: often first in, first out, or the most recent price for small businesses.

Sources

  1. Shopify Help Center: Creating and managing stock counts · read October 27, 2026
  2. Shopify Help Center: Performing and reviewing stock counts · read October 27, 2026
  3. Shopify Help Center: Exporting and importing inventory with a CSV file · read October 27, 2026
  4. Shopify Help Center: Inventory reports · 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.