Year-End Inventory Count in WooCommerce: Closing Stock You Can File

Most stock counts exist to help you run the shop. The year-end inventory count exists to produce one number for someone else: your closing stock figure, which goes into your accounts and changes how much tax you pay.

That different purpose changes how you should run it — the timing, the counting mode, what you value the stock at, and what you have to keep afterwards. This covers all four, for a WooCommerce store.

What the year-end count is actually for

Your closing stock is an asset on the balance sheet, and it’s one side of the calculation that produces your cost of goods sold:

Opening stock + Purchases − Closing stock = Cost of goods sold

Read that formula again with an eye on the middle of your profit and loss. A closing stock figure that’s too low inflates your cost of goods sold, which understates your profit. Too high does the reverse. This is not a number you want to estimate, and it’s not a number you want to be unable to defend if anyone asks.

It’s also the one count of the year where “we counted everything” has to be literally true.

When to count

The instinct is to count on the last day of the financial year. In practice that’s often the worst day available — you’re trading, stock is moving, and everyone is tired.

What actually matters is that the count corresponds to a known point in time. Two workable approaches:

• Count while closed, as near to year-end as you can. The evening of the last trading day, or the morning before reopening. No movements during the count means no reconciliation afterwards.
• Count on a different date and roll the figure. If you count a week early, your closing stock is the counted quantity plus everything received since, minus everything sold since. This is legitimate and common, but every movement in that window has to be documented — which is more work than closing for an evening.

Two practical points in favour of counting slightly late rather than slightly early: stock is usually at its lowest after a year-end sale, so there’s less to count, and any deliveries that arrive in the gap are easier to track than sales.

Prepare the floor first

An hour of tidying saves three hours of counting:

• Consolidate the same product into one place. Stock split between a shelf and a stockroom is the single most common cause of a double count.
• Quarantine damaged, obsolete and expired stock somewhere separate. You still count it — you just value it differently, and you need it identifiable.
• Deal with goods in transit. Something you’ve paid for that hasn’t arrived may still be yours depending on the shipping terms. Ask your accountant which of your incoming deliveries belong on this year’s balance sheet.
• Separate anything that isn’t yours — consignment stock, customer repairs, items awaiting collection.

Full or zero-based: the one setting that matters here

For every other count in the year you’ll use a partial (spot) count, which only updates the items you actually scan. For the year-end count you want the opposite: full or zero-based mode, where anything you didn’t count is set to zero.

This feels alarming and it’s exactly right. The statement you’re making at year-end is “this is everything we have”. If a product wasn’t found during a complete count of the premises, then you have none of it, and recording zero is the truthful answer — usually with a variance worth investigating attached.

Using partial mode for a year-end count quietly leaves the untouched products at whatever the system already believed, which is precisely the assumption the count was supposed to test.

Running the count

The mechanics are the same as any other session — snapshot, count, review, apply — with a few year-end specifics:

1. Create the session in full / zero-based mode, scoped to all stock-managed products.
2. Count blind. If ever there’s a count where you want an independent measurement rather than a confirmation, it’s the one that goes to your accountant. Blind counting is a per-session toggle.
3. Work by physical area, not by category, and mark each area done as you finish it. Missed sections are the classic year-end failure, and in zero-based mode a missed section produces a very loud, very wrong result.
4. Review before you apply. Investigate the outliers now — after you apply, the evidence of what was wrong is gone.
5. Export the count sheet. This is not optional at year-end; see below.

Turning the count into a closing stock value

You counted units. Your accounts need money. The conversion is straightforward in principle and has one trap:

Closing stock value = Σ (counted units × unit cost)

The trap is cost, not retail price. Valuing your shelves at what you’d sell them for records profit you haven’t earned yet. If you have WooCommerce Cost of Goods data set, the count can price the variance for you at cost; if you don’t, you’ll be doing this in a spreadsheet against a supplier price list.

Two adjustments that usually apply:

• Damaged and obsolete stock. Standard practice in many jurisdictions is to value stock at the lower of cost and what you could actually get for it. A box of last season’s product you’ll clear at half price isn’t worth what you paid. This is why you quarantined it before counting.
• Stock that isn’t yours. Consignment items get counted for the supplier’s benefit, not valued as your asset.

Both of these are accounting judgements rather than software settings, and the rules vary by country. Agree the treatment with your accountant before you count, not after — it changes what you need to record while you’re on the floor.

If you want a deeper look at costing methods and what WooCommerce can and can’t calculate, the inventory valuation guide covers that ground.

What your accountant will ask for

Keep these five things. They take minutes at the time and are painful to reconstruct in March:

• The count date and time, and whether the shop was trading.
• The count sheets — the exported CSV of products, expected, counted and variance.
• The valuation basis — cost, and where those costs came from.
• The treatment of damaged or obsolete stock, itemised if it’s material.
• Who counted, and whether anything was recounted.

A count with an audit trail is worth considerably more than a bigger count without one.

Five ways a year-end count goes wrong

• Counting during trading. Items sold mid-count get counted on the shelf and shipped the same afternoon. Close, or use a snapshot-based count and accept the reconciliation work.
• Valuing at retail. Inflates your assets and your tax bill.
• Double-counting. A product in two locations counted twice. This is what the tidying step prevents.
• Missing a section entirely. In zero-based mode this writes zero across real stock. Tick off areas on paper as you finish them.
• Keeping no record. The count happened, the numbers were applied, and six months later nobody can explain the adjustment. Export the sheet.

If you cycle count all year, do you still need this?

For running the shop, largely no — a good cycle-counting rota covers everything at least once a year, finds errors far sooner, and leaves a per-session audit trail that an annual count doesn’t.

For the accounts, it depends on your jurisdiction and your auditor. Some are entirely satisfied by a documented cycle programme with good accuracy; others want a full count at year-end regardless. Ask before you assume — and if they do want one, arriving with twelve months of clean cycle records means the year-end count confirms what you already knew instead of ambushing you.

A realistic schedule

1. Four weeks out: ask your accountant about count date, goods-in-transit treatment and obsolete stock. Fix your unit costs.
2. One week out: tidy and consolidate. Quarantine damaged stock. Run a cycle count of your highest-value lines so year-end isn’t the first time you’ve counted them.
3. Count day: close, create the zero-based blind session, count by area, tick off areas.
4. Same evening: review variances, recount the outliers, apply, export.
5. Next day: send the sheet and the valuation basis to your accountant while it’s fresh.

The count itself is the easy part. Everything that makes the number defensible happens before and after it.

Year-end count FAQ

When should I do my year-end inventory count?

As close to the end of your financial year as you can manage, ideally while the shop is closed so nothing moves during the count. If you have to count on a different date, that is fine as long as you document every receipt and sale between the count and the year-end so the figure can be rolled forward or back.

Do I have to close the shop to count?

Not necessarily. A snapshot-based count measures against a frozen baseline, so trading during the count does not corrupt the variance. But a year-end count uses zero-based mode and needs to be complete, so closing for an evening removes a category of reconciliation work you would otherwise have to do by hand.

Should I value stock at cost or at retail price?

At cost. Valuing your shelves at what you would sell them for records profit you have not earned yet, which inflates both your assets and your tax bill. Retail value is useful for insurance conversations, not for the balance sheet.

Which counting mode should I use for a year-end count?

Full or zero-based, where anything you did not count is set to zero. That is what the statement “this is everything we have” actually means. Partial mode leaves uncounted products at whatever the system already believed, which is the assumption the count exists to test.

What records should I keep afterwards?

The count date and whether you were trading, the exported count sheets showing expected against counted, the valuation basis and where your costs came from, how you treated damaged or obsolete stock, and who counted. A count with an audit trail is worth more than a larger count without one.

Does cycle counting replace the year-end count?

For running the shop, largely yes. For your accounts it depends on your jurisdiction and your auditor — some are satisfied by a documented cycle programme, others want a full count regardless. Ask before you assume, and if they do want one, twelve months of clean cycle records means it confirms what you already knew.