Nexus Logic SystemsShopify apps

Year-end inventory value without Stocky: your closing stock for 31 December 2026

Updated · By Senoussi, developer of True COGS at Nexus Logic Systems

Short answer

If you used Stocky, this is your first year-end without it. Your accountant still needs the value of your stock on 31 December 2026, and Shopify works it out as units on hand × Cost per item. Shopify keeps that cost fixed when stock arrives, so it may not be what you paid. Before the year ends: export your Stocky history while you still can (until 29 November 2026 at the earliest), get each Cost per item to what you really paid, and count your stock.

What changed this year

Many retailers ran their year-end in Stocky. One wrote on the Shopify Community that without it they can't do year end stock takes, report on our year end numbers for the government (Shopify Community). Three facts from Shopify's migration guide:

  • Stocky stopped working on 31 August 2026. Read-only export access lasts at least 90 days after that date.
  • Each variant has a single static Cost per item, and it stays fixed when you receive a purchase order or transfer.
  • For weighted-average costing or landed cost allocation, Shopify points to a third-party inventory app.

The dates that matter

For a store whose year ends on 31 December. If yours ends in another month, move the last three rows to that month.
ByDo
29 November 2026Export your Stocky purchase orders, stocktake history and cost data. Shopify gives no later date. How to export
DecemberGet each Cost per item to what you really paid, including freight and duty if your books include them.
31 December 2026Count your stock, or count close to the date and adjust for what moved. Fix any stock below zero.
January 2027Send closing inventory, with the method it was valued by, to your accountant.

Getting the figure from Shopify alone

Run Analytics > Reports > Month-end inventory value for 31 December. It multiplies each variant's On hand units by its Cost per item. Variants without a cost, untracked variants and stock below zero count as 0 (Shopify Help). The report is only as right as Cost per item. The steps and the Schedule C lines are in Shopify closing inventory value for taxes.

What a stale Cost per item does

Illustrative figures.
Mug, 300 on hand on 31 DecemberCost per itemClosing value
Last year's cost, never updated$12.00$3,600.00
What you paid: 40 at $12.00 and 60 at $15.00, averaged$13.80$4,140.00
Difference$540.00

Closing inventory moves cost of goods sold by the same amount, the other way, and so moves taxable profit. It also becomes next year's beginning inventory.

Year-end with True COGS

  • Cost per item at what you paid. Each received purchase order or transfer is averaged into Cost per item (moving weighted average, or FIFO on a paid plan), with freight and duty shared into each unit on paid plans.
  • Your Stocky history, by date. Drop in many Stocky purchase order CSV files at once; lines are placed by date. This is for day one, before any delivery is recorded in True COGS.
  • Year-end close. Your year ends on 31 December unless you name another month in Settings. The first night after it ends, True COGS seals the year and emails you its figures: opening inventory, purchases, revaluations, cost of goods sold and closing inventory, with the method. Nothing is sealed that does not add up: opening + purchases + revaluations − cost of goods sold = closing.
  • Stock value on any date on the Inventory value page, including 31 December, next to Shopify's own figure. On the Free plan.
  • The year file for your accountant and the per-item table are on paid plans.
Install before 1 December. A year is stated from the first whole month True COGS recorded. Installed in November, December is in it and your year is sealed on the night of 31 December, saying which months it covers. Installed during December, there is no whole month in 2026 to seal, but Inventory value still gives your stock value on 31 December.

Questions merchants ask

Is this my first year-end without Stocky?

If you used Stocky, yes. Stocky stopped working on 31 August 2026, so its stocktakes and reports can't produce this year's closing figures.

Can I still export my Stocky data?

Shopify's help says read-only export access lasts at least 90 days after 31 August 2026, which is 29 November 2026. Export your purchase orders, stocktake history and cost data before then.

Does Shopify update Cost per item when stock arrives?

No. Shopify's help says each variant has a single static Cost per item that stays fixed when you receive a purchase order or transfer.

What do I need for my tax return?

Your inventory at the end of the year, which is also next year's beginning inventory. On Schedule C that is line 41; corporations and partnerships use Form 1125-A. Your accountant decides the costing method.

When should I install True COGS to have the year sealed?

Before 1 December. The year is stated from the first whole month True COGS recorded, so December must be in it. Installed later, you can still read the stock value on 31 December from Inventory value.

Try True COGS free. True COGS is an inventory costing app for Shopify by Nexus Logic Systems. It records the price you paid on every delivery (a received purchase order or a transfer), with its share of freight and duty on paid plans, keeps every price with its date, and writes your moving weighted average cost, or FIFO cost on a paid plan, to Shopify's Cost per item. It is free for up to 25 variants with a cost on record; paid plans start at $29 a month or $290 a year.

Install from the App Store

Sources