How to track IT assets in a small business

For most small businesses there is no moment when someone decides to start tracking IT equipment. There is a moment when not tracking it becomes expensive: somebody leaves and nobody can say what they had, an insurer asks for serial numbers after a break-in, or the accountant wants a figure for what the kit is worth and the honest answer is a shrug.

This is a guide to doing it properly without buying IT asset management software, and an honest account of the point where that software starts to earn its price.

Where the usual methods break

The purchase folder

Invoices in a folder tell you what you bought. They do not tell you what you still own, who has it, or whether it still works. Three years in, the folder is an archaeology project.

Memory, plus one person

This works until roughly twenty devices, and it fails in exactly the way you would expect: the person who remembers is on holiday, or has left, and their knowledge left with them.

A flat spreadsheet list

This is where most small businesses land, and it is genuinely most of the way there. The problem is that a list records the present tense only. When you edit the “assigned to” cell, last month’s answer is gone. You cannot answer “who had this laptop in March”, which is the question that actually comes up.

Full ITAM software

Real asset management platforms are good, and for a large fleet they are the correct answer. For twenty to a hundred devices, look closely at what you are signing up for:

• Per-asset or per-agent pricing that scales with the exact thing you are trying to grow.
• An agent to deploy on every machine, which means a rollout, and machines that quietly stop reporting.
• Discovery that only sees what is powered on and on the network — so the spare laptop in a drawer, the monitor in storage and the phone in a coat pocket are all invisible, and those are the ones that go missing.
• A subscription that outlives the person who championed it.

The five questions your records have to answer

Question	Why it comes up
Who has it?	Offboarding, and the day something goes missing.
Where is it?	Office, home, storage, or with a repairer. Remote work made this the hard one.
What is it, exactly?	Make, model and serial number. This is what an insurer and a police report both ask for, and neither accepts “a Dell”.
What is it worth?	Original cost, and book value after depreciation. Your accountant asks once a year.
When does cover end?	Warranty or lease expiry. Knowing a week before is free; knowing a week after costs a repair.

Setting it up in a spreadsheet

1. One row per device, with these columns

Asset tag, name, category, make, model, serial number, status, condition, assigned to, department, location, purchase cost, purchase date, warranty expiry, supplier, notes. That looks like a lot, but every column there is one you will be asked for eventually, and adding a column later to a hundred rows is worse than having it empty now.

2. Give every device a tag

A short code — LT-0042 — on a printed label. The serial number is the legal identifier, but nobody reads a twelve-character serial aloud correctly. A tag is what people use day to day, and it is what makes the sheet searchable by something a person can see on the device.

3. Never overwrite history — append to a log

Keep a second sheet: date, asset tag, action, from, to, who recorded it. The main sheet answers “where is it now”; the log answers “how did it get there”. This is the single change that turns a list into an asset register, and it is the one most people skip.

4. Make offboarding a query, not a memory test

The real test of any system is the hour after someone resigns. If you can filter to their name and get a list — laptop, dock, monitor, phone, security key — you have a working system. If you are asking around the office, you do not, no matter how tidy the spreadsheet looks.

5. Put depreciation in the same file

Straight-line depreciation is not complicated: cost minus salvage, divided by useful life, multiplied by years elapsed. Doing it in the same place as the asset list means the year-end number is a report rather than an evening’s work.

6. Diarise warranty expiry

A date column, colour-coded so anything inside 30, 60 or 90 days stands out. Warranty is the one field with a deadline attached, and it is worth real money on the day a machine dies.

When you should buy the software instead

It would be convenient to claim a spreadsheet always wins. It does not. Buy the platform when:

• You need automatic discovery. Past a few hundred machines, walking round reading labels stops being realistic and agent-based inventory earns its keep.
• You are metering software licences. Counting installs and reclaiming unused seats is a genuinely different job, and a spreadsheet is bad at it.
• You are under a compliance regime — ISO 27001, SOC 2, HIPAA — that wants a demonstrable, tamper-evident audit trail with access controls. A shared file will not satisfy an auditor.
• Several people must update it at once, from different places. This is the hard limit. Shared files sync; they do not merge two simultaneous edits, and the loser is silent.

If none of those describe you — and for a business with one IT-ish person and under a couple of hundred devices, usually none of them do — you are paying a subscription to solve somebody else’s problem.