Jewellery Inventory Management: Methods and Common Mistakes

Most jewellers keep two sets of records: the stock list they actually use, and the paperwork they do for the accountant. It is worth noticing how similar those two things want to be. The stock book HMRC requires for the VAT margin scheme asks for a per-item stock number, purchase price, seller, description, sale price and margin. A good operational inventory record asks for almost exactly the same fields.

They are the same record. Keeping them separately is how both end up unreliable.

The argument that costs money

If you need one reason to take stock records seriously, it is not tidiness. It is this, from HMRC's own manual:

"If a business fails to keep the prescribed records, it forfeits its right to opt to use the margin scheme in relation to those transactions not properly recorded... This means that tax on those supplies is due on the full selling price and not on the margin."

HMRC's specimen letter to second-hand dealers puts it more plainly still: if the records are not kept and produced, "VAT is due on the full selling price of the goods."

Understand what that means commercially. On margin-scheme goods you pay 16.67% — one sixth — of the margin, where margin is selling price minus purchase price. Lose the record and you pay VAT on the whole selling price. On second-hand and part-exchange pieces, where the margin is often a modest fraction of the ticket, that difference can comfortably exceed the profit on the item. You do not get fined; you simply stop making money on the sale.

What the stock book must actually contain

Per item — not per batch. On purchase: stock number, date of purchase, purchase invoice number, purchase price, seller's name, and an item description. On sale: stock number, date of sale, sales invoice number, selling price or method of disposal, buyer's name, the margin on the sale, and the VAT due.

A spreadsheet can hold all of that perfectly well. The format is not the issue; the per-item discipline is.

Which brings up a structural point specific to this trade. Jewellery is largely one-off, bespoke or serialised, so quantity-based SKUs — 12 × silver bangle — break down immediately. Each piece generally needs its own stock number. That feels like a chore until you notice it is precisely what the stock book demands anyway. The operational record and the compliance record can be one record, built once.

On descriptions, the NAJ's cautionary example is worth pinning up: a record reading "a 3 stone diamond ring, purchase price £750" is useless. It won't support an insurance replacement, it won't help you resell, and it doesn't satisfy the required item description. Metal type, cut, weight, stone colour and clarity, and for watches the make, model and serial number.

The six-year trap

VAT records must be kept for six years. But there is an extension that catches people out: for stock bought more than six years ago and still unsold, you must keep the records until the item is sold.

Read that against how jewellery ages. The pieces still sitting in the safe after six years are, by definition, your slowest movers — and they are exactly the ones a routine six-year purge destroys the paperwork for. You lose the records for the only stock the extension applies to, and with them the margin scheme on the eventual sale.

Capture the hallmark at intake

Most systems treat hallmarking as something that happened before the goods arrived. It is more useful as an inventory field.

Record the sponsor's mark, the fineness and the assay office as structured fields at the moment goods come in, alongside a tag — barcode or RFID — applied at intake rather than reconstructed later. Provenance, insurance and resale all become tractable years afterwards, instead of requiring someone with a loupe to re-read the piece and guess.

While you are at intake, remember the exemption weights are per metal and specific: gold under 1g, silver under 7.78g, platinum under 0.5g, palladium under 1g. There is no general "it's tiny" allowance, and silver intuitions mislead badly on platinum — the platinum threshold is half the gold one. Above those weights, an item described as that metal must bear a hallmark from one of the four assay offices at the point of sale.

Consignment is not your stock

Consignment, sale-or-return and memo stock sit in the same drawer as owned stock and behave identically on the shop floor. Financially they are opposites.

Mixing them into one inventory class misstates your assets and confuses the VAT position, and margin-scheme eligibility differs between them. This is a five-minute fix at setup — one field — and an expensive unpicking exercise later.

Dead stock, and why it is emotionally difficult

Jewellery doesn't spoil. It ages by fashion, which is slower and much harder to see.

The diagnostic is inventory turnover: cost of goods sold divided by average inventory. It measures how quickly stock converts back into cash, and a falling ratio means capital is freezing into pieces that aren't moving. There is no credible published benchmark for what a healthy figure looks like in UK jewellery — the ratios that circulate come from non-UK vendor blogs — so track your own trend rather than chasing someone else's number. The direction of travel is the signal.

Trade guidance commonly cites rules of thumb like marking down after six months or writing off as dead after twelve. Treat those as prompts, not thresholds; they aren't sourced to anything UK-specific.

The real obstacle isn't analytical anyway. Marking down a beautiful piece feels like an admission, so it gets deferred — which is exactly how it becomes dead stock. The ratio's job is to make that decision boring and numerical rather than aesthetic.

Valuations drift quietly

Metal and stone prices do not track general inflation, so index-linking a valuation produces under-insurance without anybody noticing. The NAJ recommends precious items are valued at least every three years, because prices fluctuate — a concrete, citable cadence you can build into a review.

Valuations are the responsibility of a qualified valuer; the Institute of Registered Valuers, regulated by the NAJ, is the relevant body, and some insurers specifically require an IRV Member or Fellow.

The online blind spot

The framed Dealer's Notice by the till is a habit; the website is an afterthought. Two versions exist: Notice A for physical premises, displayed where customers can see it, black and white, minimum A4 portrait (210 × 297mm); and Notice B, which must be prominently displayed on retail websites.

Section 11 of the Hallmarking Act 1973 requires dealers to "keep exhibited at all times, in a conspicuous position" a notice describing approved hallmarks, and makes it "an offence for any dealer to fail to exhibit or keep exhibited" it. You will see a £5,000 figure attached to this online; it does not appear in the section itself, so treat the number with scepticism even while treating the duty seriously.

Count more often than once a year

An annual stocktake means shrinkage and mis-picks surface up to twelve months after they happen, when nobody remembers the transaction and the trail is cold. Rolling cycle counts — continuously counting subsets — surface the same problems within weeks and don't require closing the shop.

The bottom line

Give every piece its own number and a real description at intake. Capture the hallmark data while the piece is in your hand. Keep consignment separate from owned. Don't purge records on ageing stock. Count in rolling subsets. Do those, and the margin-scheme stock book HMRC wants is something you already have — rather than something you reconstruct in April and hope holds up.