Stocktaking for Trade Businesses UK 2026 — How to Count and Value Materials at Year End

What a Stock Take Is — and Why Trades Need One

A stock take is simply the process of counting everything you hold in stock at a point in time and putting a value against it. For a shop that's shelves of products. For a trade business it's the materials, parts and consumables you've bought but not yet used or sold on a job — copper pipe and fittings for a plumber, cable and accessories for a sparky, timber and fixings for a joiner, tiles and adhesive for a tiler, boilers sitting in the unit, that pallet of plasterboard in the yard.

Merchants and installers who buy in bulk to get trade discounts carry the most. If you're a kitchen or bathroom fitter holding units, worktops and appliances ahead of jobs, or a heating engineer with boilers, cylinders and radiators on the shelf, you may have several thousand pounds tied up at any moment. Even a sole-trader sparky doing first-fix work often has £1,000–£3,000 of cable, accessories and consumer units sitting in the van and the garage. That value belongs in your accounts — it doesn't just disappear because it's out of sight.

Why It Matters at Year End: Stock and Your Tax Bill

Here's the part most people miss. When you buy materials, you record the cost as a purchase. But for tax you can only deduct the cost of materials you've actually used in the year. Anything still sitting on the shelf at year end is "closing stock" — and closing stock is added back into your profit. In plain terms: unused materials you've paid for don't reduce your tax bill until the year you actually use them.

The mechanism is the cost of sales calculation: opening stock + purchases − closing stock = cost of materials used. The higher your closing stock, the lower your cost of sales, and the higher your taxable profit. That's why HMRC cares about it and why your accountant needs an accurate closing-stock figure to prepare your accounts and your Self Assessment or company tax return. Guess too low and you understate profit (a problem if HMRC ever looks); guess too high and you pay more tax than you owe.

One genuine relief for very small businesses: if you use the cash basis (available to many sole traders and partnerships under the turnover thresholds), you generally don't need to value closing stock at all — you deduct materials when you pay for them. But if you use traditional accruals accounting, or you're a limited company, closing stock matters every single year. If you're not sure which basis applies to you, that's a question for your accountant.

How Stock Is Valued: Lower of Cost or Net Realisable Value

You don't value stock at what you'd charge a customer for it, and you don't value it at the brochure RRP. The standard rule under UK accounting practice is the lower of cost or net realisable value (NRV). Take each item and use whichever of these two figures is lower:

• Cost — what you actually paid for it, net of VAT if you're VAT-registered, including any direct costs of getting it to you (such as delivery).
• Net realisable value — what you could realistically sell or recover it for now, minus any costs of selling it.

For most live, usable stock the cost figure is lower and that's what you use. NRV only bites when something has lost value — a discontinued boiler model you can no longer fit, tiles from a range that's been deleted, a damaged pallet of plasterboard, fittings that have corroded in a damp unit. If an item is now worth less than you paid, you value it at the lower NRV and the difference is effectively written down. This stops you carrying dead or damaged stock on the books at a value you'll never recover.

A worked example makes it concrete. Say you bought ten of a particular combi boiler at £620 each. Eight are current and saleable — value those at cost. Two are an older model the manufacturer has superseded, and the most you'd now get for them is £400 each after a discount to shift them. The table below shows how the valuation lands.

Worked Example: Valuing Stock at Lower of Cost or NRV

Notice the superseded boilers and the damaged radiators are written down to what you can actually recover, not what you paid. That lower closing-stock figure increases your cost of sales for the year, which reduces your taxable profit — a fair reflection of the fact that some of what you bought is no longer worth full price.

How to Run a Stock Take, Step by Step

A good stock take is methodical and boring — that's the point. The aim is a defensible number, not a perfect one. Here's a process that works for a trade business.

1. Freeze movements

Ideally count on a day when nothing is going in or out — a weekend, or first thing before the vans load. If you can't fully stop work, at least mark a clear cut-off so you know what counts as "in stock" at the count date. Goods received that morning but not yet booked in, and materials already loaded for a job leaving site, are exactly where errors creep in.

2. Count systematically

Work one area at a time — unit shelf by shelf, then the yard, then each van — and don't jump around. Use a two-person system where you can: one counts, one records. Count physical quantities first and worry about value afterwards. For high-volume consumables (screws, clips, cable clips, sealant) it's fine to estimate by box or by weight rather than counting individual items — be consistent in how you estimate year to year.

3. Record quantities and values

For each line, record the description, the quantity, the unit cost (from supplier invoices or your buying records, net of VAT if registered) and the line total. Tie the unit cost back to a real invoice rather than guessing — recent merchant statements are your friend here. Don't forget van stock and any materials sitting on a customer's site that you own until the job's invoiced.

4. Spot slow-moving and dead stock

As you count, flag anything that hasn't moved in 12 months, anything obsolete or superseded, and anything damaged. This is where you apply net realisable value and write items down (or off entirely if they're unsaleable). Be honest — carrying dead stock at full cost overstates your profit and ties up cash you could be using. A genuine write-off of unsaleable stock is a legitimate reduction in your stock value.

5. Total it and hand it over

Add up the value of everything, save the working (date it, keep the count sheets), and give the single closing-stock figure plus the detail to your accountant. Keep the count sheets for your records — if HMRC ever queries your figures, a dated, itemised count is exactly the evidence you want to have.

How Often Should You Count? Annual vs Periodic vs Perpetual

There's no single right answer — it depends on how much stock you hold and how much it's costing you not to know. The three common approaches:

• Annual: a full count at your financial year end. This is the legal minimum most accrual-basis trades need, because it produces the closing-stock figure for your accounts. If you hold modest stock, this may be all you need.
• Periodic: a full count every quarter or every month. Worth it if you carry significant value, if stock goes missing, or if you want tighter control over buying. More frequent counts catch shrinkage and dead stock earlier.
• Perpetual / continuous (cycle counting): you count a small section of stock regularly on a rolling basis so the whole lot gets checked over the year without ever doing a big shutdown count. This works best with stock software that tracks quantities in real time as you buy and use materials.

A practical middle ground for a growing installer: a full annual count for the accounts, plus a quick monthly look at your highest-value lines (boilers, units, anything over a few hundred pounds each) so nothing expensive walks out the door unnoticed.

Tools: Spreadsheets vs Stock Software

You don't need fancy software to do a perfectly valid stock take. A spreadsheet with columns for description, quantity, unit cost, line total and a note for write-downs is enough for most trade businesses, and it's easy to hand to your accountant. Build a template once and reuse it every year — that consistency makes year-on-year comparison far more useful.

Stock software earns its place when volume and value grow. If you're booking in deliveries, allocating materials to jobs and want a running stock figure rather than an annual scramble, software that tracks stock movements in real time saves the shutdown count and gives you live visibility of what's tied up. The trigger to upgrade is usually pain: counting takes a full day, you keep over-ordering things you already have, or materials go missing and you can't tell. Until then, a disciplined spreadsheet beats expensive software you don't use properly.

Reducing Tied-Up Cash and Waste

Stock is cash you've spent but can't use. Every boiler on the shelf, every pallet in the yard, is money that isn't in your bank or paying your VAT. The stock take is the moment you see exactly how much, and it usually prompts a few obvious moves:

• Clear dead stock. Sell superseded or surplus items to other trades, return what suppliers will take back, or accept a small loss to free the cash — a £400 sale beats £620 of stock you'll never fit.
• Buy to the job, not to the discount. Bulk deals only pay off if you actually use the stock before it dates or damages. Tying up £5,000 to save £300 is a poor trade if half of it sits for two years.
• Store it properly. Damp units and exposed yards turn good stock into write-offs. Damaged materials are pure loss — protect what you've paid for.
• Track what you use. Knowing your real consumption rates stops you over-ordering the same fittings every month out of habit.

Quick Reference: Stocktaking Methods

Stocktaking FAQ for Trade Businesses

Do I have to do a stock take if I'm a sole trader?

If you use traditional accruals accounting, yes — you need a closing-stock figure for your accounts and tax return. If you use the cash basis (available to many smaller sole traders and partnerships), you generally deduct materials when you pay for them and don't value closing stock. Check which basis you're on with your accountant.

What value do I put on my materials?

The lower of what you paid (cost, net of VAT if you're VAT-registered) or net realisable value — what you could actually recover for it now. For live, usable stock that's normally cost. For obsolete or damaged items it's the lower recoverable figure.

Does van stock count?

Yes. Materials you own count wherever they physically are — in the van, in the unit, in the yard, or sitting on a customer's site before you've invoiced the job. Count it all.

Can I write off old stock I'll never use?

You can write down genuinely obsolete or damaged stock to its realistic recoverable value (which may be nil for unsaleable items). It has to be a real fall in value, not just a wish to reduce your tax bill — and it's worth documenting why each item was written down.

How long do I keep the records?

Keep your count sheets and stock workings with the rest of your business records. HMRC generally expects business records to be kept for several years, so date everything and file it with the year it relates to. Your accountant can confirm the retention period for your situation.

This article is general guidance for UK trade businesses and is not formal accounting or tax advice. Stock valuation and the right accounting basis depend on your specific circumstances — always confirm anything material with a qualified accountant.