An IT asset register is a list of the equipment your company owns, such as laptops, monitors, phones and chargers, with ten details per item: name, type, make and model, serial number, purchase date, cost, warranty expiry, who has it, where it is, and the receipt. For a small business, a spreadsheet is enough to start.
Setting one up takes an afternoon. Keeping it up to date afterwards is where most registers fall down, so this post covers what to track, how to build it, and how to stop it drifting.
Why does a small business need an asset register?
An asset register gives you one place to answer four questions: what do we own, who has it, what did it cost, and is it still under warranty. Without one, you usually find out what's missing when something goes wrong, like a laptop that doesn't come back at offboarding, an insurance claim that needs a serial number nobody wrote down, or a warranty that ran out because nobody checked.
It doesn't need to be perfect, just complete enough that the information is there when you need it. A spreadsheet with ten columns is enough to start with.
What fields should an IT asset register include?
Ten fields are enough for most small businesses, and together they cover warranty claims, insurance, offboarding and replacement planning without turning data entry into a job nobody keeps up:
- Asset name: a human-readable label like "Ingrid's MacBook Pro" or "Conference room monitor".
- Type/category: laptop, monitor, phone, headset and so on, so you can filter and count by category later.
- Make and model: "Dell XPS 15 9530" or "Apple MacBook Air M3". You need it for warranty claims and replacements.
- Serial number: insurers, manufacturers and police reports all ask for it.
- Purchase date: needed for depreciation, warranty tracking and knowing when it's time to replace something.
- Purchase cost: for insurance, budgeting and knowing what you've spent on equipment in total.
- Warranty expiry: so you can make a claim or plan a replacement while it's still covered.
- Assigned to: who has it now, which is what you check when someone leaves to see what they should hand back.
- Location: office, home (for remote workers), storage or a specific room, which hybrid teams especially need.
- Receipt/proof of purchase: a link to or copy of the original receipt. Without it, warranty and insurance claims tend to go nowhere.
Most of these take about thirty seconds per item, since you're mostly copying the serial number off the bottom of a laptop and noting who has it. Our free equipment tracker template has columns for eight of them (with make and model split in two), plus a tag number, vendor, condition and notes, so add a Location column and a receipt link column if you want those.
How do you build an asset register from scratch?
Walk through the office with your phone and log everything that costs more than about $50, then fill in the purchase details from your email. For a team of 20 it takes about an afternoon.
- Check everywhere. Open every drawer, look in the storage cupboard and under desks, and photograph serial numbers as you go.
- Save receipts as you go. Search your email for purchase confirmations and attach each one to the right row.
- Tell your team. Let people know the register exists and that new purchases need logging. One sentence in Slack is enough.
If you already have a spreadsheet with some data in it, don't throw it away and start over. Make the columns match the fields above, fill the obvious gaps and remove rows for equipment you've already got rid of, because the data you've already collected is the slow part to recreate. If your current spreadsheet is reaching its limits, our guide on moving beyond spreadsheets for equipment tracking walks through the switch.
What are the most common asset register mistakes?
The two most common mistakes are tracking so much that nobody keeps the register up to date, and tracking so little that it can't help with a warranty claim or an audit.
Tracking too much
It's tempting to add columns for firmware version, IP address, colour, condition notes and three different dates. Every extra column is one more thing to fill in, and people tend to stop updating a register that asks too much of them. Start with the ten fields above and add more later if you find you need them.
Not tracking enough
A register that only says "laptop" and "John", with no serial number, purchase date or cost, won't help with warranty claims, insurance, budgeting or audits. The serial number and purchase date are the minimum.
How do you keep an asset register up to date?
Make updating it part of the things you already do: log every new purchase the day it arrives, and check the register as part of every offboarding. Otherwise it's accurate on the day you create it and drifts from there, as new hires get laptops nobody adds and leavers' rows stay put. Once people stop trusting it, they tend to stop updating it.
A five-minute check once a month catches most of what slips through. Set a calendar reminder and look for new hires whose equipment wasn't logged and warranties that are about to expire.
When should you move from a spreadsheet to asset tracking software?
A spreadsheet works well up to about 25 assets and starts to strain around 50 (when spreadsheets stop working). Past that, or once several people need to update it, it starts to struggle: there's nowhere to keep photos or receipts with each item, it won't remind you when a warranty is about to expire, and if it's an Excel file passed around by email, two people editing at once end up with conflicting versions.
The other sign is that it's become more work to keep up than it's worth, or that it's already let you down, through equipment lost at offboarding, a missed warranty deadline or a receipt you couldn't find. Our guide to equipment management for small businesses goes into these growing pains in more detail, and if there's no IT department doing this for you, see our guide on tracking equipment without IT.
If you move to AssetJay, you can import your existing spreadsheet as a CSV (import your people first, and the "Assigned to" column links each asset to its person) and get photo attachments, receipt storage, assignment history and warranty alerts without retyping anything.
Free: IT Equipment Tracker Template
A ready-to-use asset register with the right columns, sample data, and field-by-field guidance. No signup needed.
Get spreadsheet template
