What belongs in an asset register, and what quietly ruins one

Asset registers usually die of ambition. Someone designs one properly, with purchase order references and depreciation and warranty expiry and a photograph, and it is genuinely excellent for about six weeks. Then a delivery arrives on a busy afternoon and gets entered with four of the twenty-three fields filled in, and after that the register is a mixture of complete rows and stubs, which is worse than either.

So the useful question is not what could be recorded. It is what has to be true of every row for the register to answer the questions people actually ask it.

The four fields that do the work

Almost everything a register is asked comes down to these.

If those four are reliable on every row, you have a register. Everything else is enrichment, and enrichment that is only present on some rows cannot be reported on, which makes it decoration.

Where it goes, versus who has it

This is the single most consequential design decision, and most registers get it wrong by recording a place.

"Site 4" cannot be asked where the SDS drill is. A person can. When custody sits with a named individual, a missing item has someone to ask, an overdue item has someone to chase, and — this matters more than it sounds — the act of taking something becomes an acknowledgement rather than an anonymous withdrawal. Loss rates fall on that alone, before any enforcement.

A location tells you where something was last seen. A name tells you who to ask. Only one of those is actionable at four o’clock on a Friday.

Sites still matter, but as the place custody happened, not as the thing that holds the item.

The states you need, and the ones people forget

Available and issued are obvious. The register earns its keep on the others, because those are the situations where an item is not where the record implies and nobody has said so.

• In for repair — otherwise it reads as available and someone walks to the store for it.
• Quarantined or failed inspection — the most important state on the list, and the one most often missing. See the note on inspection records below.
• Lost, and lost-but-still-searching, which are different. The second is a state; the first is a decision somebody made.
• Retired or disposed of, held rather than deleted. Deleting the row deletes the history you may need to produce later.
• On hire and off-hire date, for kit that is not yours. Hired items belong on the register too.

Identifiers: what to tag and what not to

A manufacturer serial number is the right identifier where one exists, because it survives your systems and matches the paperwork from examinations and warranty claims. Your own tag is a convenience layer on top, not a replacement.

The practical rules are boring and unbreakable:

1. One tag, one physical item. Not one per set, unless the set never separates — and it will separate.
2. Never reuse a tag number when an item is retired. The history collapses, and old records start pointing at new kit.
3. Normalise on entry, or you will have CB4471 and CB-4471 as separate assets within a month. Strip spaces and punctuation and compare on that.
4. Put the tag where hands do not go and abrasion does not reach, then accept that some will still come off and that the serial number is your fallback.
5. Do not tag consumables. Which brings us to the thing that ruins registers.

The mistake that ruins registers

Putting consumables in them.

A register tracks individual things that come back. A stock record tracks quantities of things that get used up. They are different shapes and the moment you mix them you get rows saying "Gloves, qty 340" sitting next to rows saying "Torque wrench TW-0091", and no report can sensibly cover both.

The test is simple: does this specific one come back, and does it matter which one it was? A drill, yes. A box of 100 cable ties, no. Anything genuinely ambiguous — a good example is a decent extension lead — should go wherever its failure hurts more. If losing one is annoying, it is stock. If you would need to know which one and who had it, it is an asset.

A register you can actually start this week

Take the four working fields. Add inspection due date if any of your kit is subject to examination. Add purchase date only if you genuinely use it for replacement planning — most people say they will and do not.

Then walk the store and enter what is there, in whatever order you find it. Do not sort first, do not design a numbering scheme first, and do not wait until you can do it thoroughly. A register with the four fields covering every item beats a beautiful one covering the first forty.

Nilstock holds assets and consumables as genuinely separate things rather than as one list with a quantity column, records custody against a named person with a due date, and keeps the states that matter including quarantined and lost — see the feature list for what is tracked. If your kit is subject to examination, the inspection records guide covers what the register has to prove; IT equipment and media production have their own versions of the same problem.