What the Shelves Owe You: A December Stocktake Built Around Cash
For many UK SMEs, the annual stocktake is an inconvenience to be endured: counters arrive early, the warehouse is shut for a day, clipboards are filled in, and the figure is handed to the accountant. The count is then forgotten until the following December.
That is a missed opportunity. A stocktake is one of the few moments in the year when the balance sheet meets the physical reality of the business. In a market where small firms are protecting margins carefully, the value is not in knowing how many boxes are on the shelves. It is in knowing which of those boxes can be sold, which must be written down, and how much cash is trapped in the space between.
As December 2026 approaches, the stocktake should answer three practical questions: what do we own, what is it really worth, and what will we do about it before the year-end? The plan below is designed to be run by an owner-manager without closing the business for a week.
Start with the decision, not the count
Before anyone picks up a clipboard, agree what the count is for. A stocktake that produces only a valuation figure is a compliance exercise. A stocktake that produces a list of actions is a management tool.
Set out the outputs in advance. At minimum, the exercise should generate:
- a list of lines for write-down or write-off, with reasons;
- a slow-moving stock schedule, with an owner and an action for each major line;
- a work-in-progress (WIP) schedule that reconciles to job numbers and sales invoices;
- a cut-off log covering goods received and goods despatched around the count date;
- a cash estimate showing what can realistically be released by 31 March 2027.
Bring finance, operations and sales into the same short conversation. Sales will know which lines still have demand; operations will know what is damaged, obsolete or taking up space; finance will know what the accounts currently assume. The aim is not a perfect count of every item. It is a reliable count of the items that matter.
That means setting a materiality threshold. High-value lines, high-volume lines and anything with a history of shrinkage should be counted physically. Low-value consumables can be sampled or covered by a roll-forward, provided the approach is documented and consistent with the accounting policy.
Cut-off is where valuation is won or lost
Most stocktake errors do not come from miscounting. They come from cut-off. Goods received before the year-end but not invoiced, goods despatched but not invoiced, customer-owned stock held on site, sale-or-return arrangements and consignment stock can all distort the valuation if they are not identified.
Keep a one-page cut-off log. Record the last goods received note and the last despatch note before the count, and the first of each afterwards. Note any stock on site that the business does not own. For WIP, list jobs that are complete but not yet invoiced, and jobs where costs have been incurred but no sales value has been recognised. Match those schedules to the sales ledger before the accounts are finalised.
The objective is to avoid double counting and to make sure the year-end balance sheet reflects obligations as well as assets. A short, disciplined cut-off review is usually more valuable than a second day of counting low-value items.
Separate the four kinds of stock
A single stock figure hides very different problems. For management purposes, split the count into four groups: raw materials, finished goods, slow-moving or obsolete stock, and WIP.
Age the stock. Use last movement dates, forward order books, design changes, expiry dates and customer returns to identify lines that are unlikely to sell at full price. Ask the sales team a direct question: which lines would you buy again, and which would you not? The answers are often more useful than a system report.
Write-downs should not wait for the accountant's year-end adjustments. If a line is damaged, superseded or clearly unsaleable, record it and act on it. The accounting entry is only the record of a decision that operations should already have taken.
For WIP, review the stage of completion rather than simply the cost incurred. A job that is 90% complete but has unresolved variations may not be worth its accumulated cost. A job that is complete but unbilled is a cash-flow issue, not just a valuation issue.
Value at the lower of cost and net realisable value
Under UK accounting practice, stock is generally valued at the lower of cost and net realisable value. Cost should include the direct costs of bringing the stock to its present location and condition. For WIP, that normally means materials, direct labour and an appropriate share of production overheads, depending on the policy used.
Do not use selling price as a short-cut. Net realisable value is the estimated selling price less the costs of completion and sale. If the business uses standard costs, review the variances before the count is finalised; an out-of-date standard cost can overstate stock just as easily as an incorrect count.
Document the assumptions. A short valuation memo, signed off by the owner-manager and the finance lead, is enough. It should explain the cut-off, the write-down policy, the WIP basis and any material judgements. That memo will be useful to the accountant and to anyone reviewing the business later.
A one-page December plan
The count does not need to close the business. A workable plan looks like this:
- By late November: agree scope, materiality and cut-off dates. Brief the counting teams and print the schedules.
- First week of December: count high-value and high-risk lines. Use two-person teams and spot-check afterwards.
- Second week of December: reconcile the count to the stock system. Investigate differences above the threshold.
- Third week of December: review slow-moving and obsolete stock with sales and operations. Agree write-downs and disposal actions.
- Before the year-end: finalise the cut-off log, WIP schedule and valuation memo. Give the accountant a clean pack.
- January 2027: review what was written down, what was sold at a discount, and what cash was released. Assign owners to the remaining actions.
Where the warehouse cannot be closed, count in sections during quiet periods. The key is to control the movement of stock in and out of the counted areas, and to record any transfers. A targeted count of the lines that drive the valuation is usually better than a rushed count of everything.
Turn the count into cash
A stocktake pays for itself only when the results change behaviour. The write-down itself does not release cash; it records a loss that has already happened economically. Cash comes from acting on the information.
A practical sequence is to stop reordering slow-moving lines, return saleable stock to suppliers where terms allow, bundle or discount stock that is close to obsolete, and scrap items that cost more to store than they will ever realise. Review reorder points and minimum order quantities at the same time. Many SMEs discover that the stocktake problem is really a purchasing problem.
Estimate the cash effect line by line. If £50,000 of slow-moving stock can be sold at a 30% discount, the business releases £35,000 of cash but accepts a £15,000 margin hit. If £25,000 of obsolete stock is scrapped, the cash benefit is the avoided storage, insurance and handling cost, not the book value. Put both numbers in front of the owner-manager so the trade-off is explicit.
The stocktake should end with a short action list, not a lengthy report. Name the owner, the action, the expected cash effect and the deadline. Then review it in January 2027, while the decisions are still fresh. That is how a December count becomes a margin review rather than a annual chore.
