Five Columns and a Cupboard Full of Laptops: The Kit List Your Office Can Actually Keep
Photo: small office manager updating spreadsheet with laptops on desk UK, via pawtangle.com
There's a laptop in the cupboard behind the printer. Nobody's quite sure whose it was. It might be the one bought for the temp who left in 2023, or it might be the spare, or it might be the machine that had the accounts software on it. Everyone walks past it. Nobody opens it.
That cupboard is not a technology problem. It's a record-keeping problem, and it's the same one that shows up when an insurer asks what you'd claim for, when a warranty lapses three weeks before a hinge fails, and when someone leaves and you realise you don't know whether their old files are in the cloud, on the disk, or both.
The answer isn't a platform
There are excellent asset management tools out there, and most of them are aimed at organisations with an IT department and a budget line labelled "tooling". A fifteen-person firm in Sheffield doesn't need that. It needs a spreadsheet that gets updated, and the honest reason registers fail is that they're too big to maintain. Twelve columns of drop-downs look impressive on day one and are stale by Easter.
So: five columns. That's the whole design constraint. If a field can't help you answer a question someone will actually ask, it doesn't go in.
Column one: what the thing actually is
Make, model, and the serial number printed on the bottom — not the hostname, not the sticker someone wrote "LAPTOP-04" on. Serial numbers are what warranty portals and insurers want. If you're buying refurbished or from a reseller, note the supplier too, because "where did this come from" is a question that arrives at the worst possible moment.
While you're at it, take a photo of the bottom of each machine and drop it in the same folder. Thirty seconds per laptop, and it saves a Tuesday afternoon of squinting at tiny print.
Column two: who has it, and where it lives
A named person, not a job title. Job titles change; people change desks; the laptop follows the person. Add whether it's office-based, home-based, or hybrid, because that shapes everything from insurance to how you'd recover it.
Crucially, add a row type for "spare" and "in the cupboard". Those machines exist and pretending otherwise is how you end up with four laptops and three people.
Column three: when you bought it and when the cover stops
Purchase date, supplier, warranty end date, and where the invoice sits. That last one matters more than people expect — small firms are brilliant at buying kit and terrible at keeping the paperwork findable when a finance query lands eighteen months later.
If the machine is covered by your business insurance rather than a manufacturer warranty, note the policy and the renewal month. When the renewal comes round in 2026 and the broker asks for a schedule of equipment, you'll be copying and pasting instead of reconstructing from memory.
Column four: what it can reach
This is the column people skip, and it's the one that earns its keep. Not an exhaustive list — just the headlines: which email account, which cloud file storage, which line-of-business application, whether multi-factor authentication is set up, and a plain-English yes/no on whether personal data (customer records, staff files, payroll) sits on the disk.
That single cell is what turns a panic into a plan when you're working out the scope of a breach, filling in a cyber insurance questionnaire, or deciding whether a stolen bag is a nuisance or a notification to the ICO.
Column five: the exit instruction
One line describing what happens when this laptop and this person part company. Who collects it, what gets wiped, who confirms the wipe happened, where the encryption recovery key is stored, and whether the licence needs reassigning.
It sounds bureaucratic written down. In practice it's the difference between a leaver's last day running smoothly and a fortnight of "did anyone get the laptop back?".
Keep it somewhere dull, with two owners
A shared drive with version history, not someone's desktop. One person maintains it, one person can step in — because a register that lives in a single head is just the single point of failure with extra steps.
Be a bit careful about who can see it, mind. A list of who has which laptop and what it connects to is genuinely useful to the wrong person. Restrict it to the people who need it, and don't email it round as an attachment out of habit.
The habit bit
A register rots if the only instruction is "keep it up to date", because that's not a task, it's a wish. Give it a trigger instead: every new starter, every leaver, every purchase, every disposal gets a row updated on the day. Then once a quarter, pull five rows at random and check they're still true. Ten minutes, tea in hand, and you'll catch the drift before it becomes archaeology.
Start with the cupboard. That laptop nobody owns is row one, and once it's written down, it stops being a mystery and starts being a decision.