Almost everyone builds their first asset register the same way: they open a spreadsheet, start typing in equipment, and only later realise the columns have quietly filled with chaos. One row says the location is "Head Office", the next says "HO", a third says "Main Branch — Accra", and all three mean the same place. The category column mixes "Laptops", "IT Equipment" and "Computers" for identical items.
When it is time to import that spreadsheet into a proper system, the mess comes with it, and someone spends an afternoon untangling what five minutes of planning would have prevented. The fix is to decide your structure before you record a single asset. Three simple lists do most of the work: categories, locations and departments.
Three lenses, three different questions
Categories, locations and departments are not interchangeable labels; each answers a different question about an asset. A category answers "what kind of thing is this?" A location answers "where is it?" A department answers "who is responsible for it?" An office chair in the finance manager's room on the second floor is, all at once, a Furniture category, a second-floor location, and a Finance department asset. Keeping these three lenses separate in your head is the whole trick; problems start when people jam a location into the department column.
| Lens | Answers | Example |
|---|---|---|
| Category | What kind of thing is it? | Furniture & Fittings |
| Location | Where is it? | Head Office — 2nd Floor |
| Department | Who is responsible? | Finance |
Designing your category list: not too many, not too few
Categories group similar assets for reporting and for the tag codes you will generate later, so they should be broad enough to be useful and narrow enough to mean something. Too few — lumping every electronic device into "Equipment" — and your reports tell you nothing. Too many — a separate category for every model of laptop — and staff never pick the same one twice. Aim for a list you could read aloud in under a minute. If you find yourself hesitating over which category an item belongs to, your list is either too fine or badly named.
Locations: physical places, named the way people speak
Locations should mirror the real geography of your organisation and, crucially, use the names your staff actually say out loud. If everyone calls it "the third-floor store", do not record it as "Storage Facility 3B". Decide, too, how finely you want to track location: some organisations stop at the branch, others go down to the individual room. Finer locations make a physical inventory count faster because you know exactly where to look. A good compromise for most is branch plus a meaningful sub-location — a floor, a wing or a named room — which is precise enough to find an item without becoming a burden to maintain.
Departments: who carries the responsibility
Departments attach accountability to an asset. When a laptop goes missing, "which department was it assigned to?" is the first question, because that is who answers for it. Keep the department list aligned with how your organisation is actually structured — the same names that appear on your org chart. A clean department list also makes reporting powerful: you can hand each head their own list of assets and quietly turn a central register into shared responsibility.
How the three build your asset codes
These lists are not just for filtering; in a well-designed system they combine to generate the asset tag itself. A common, readable pattern takes the first letters of the location, the department and the category, then adds a running number — so a Furniture item in the Finance department at Head Office becomes something like HOF/FIN/FUR001. Deciding your three lists first means these codes come out clean from the very first asset. If you want the tag scheme itself to age well, pair this with a proper asset tag numbering system.
Before you import a single row
- Write your category, location and department lists on one page.
- Merge duplicates ("HO", "Head Office", "Main Branch" → one name).
- Use the names staff actually say out loud.
- Keep categories few enough to read aloud in a minute.
- Confirm a newcomer could pick the right value without guessing.
Start lean and leave room to grow
There is a temptation, when setting up for the first time, to anticipate every possibility and build enormous lists — forty categories, a location for every cupboard. Resist it. Over-engineered structure is as harmful as no structure, because staff faced with forty near-identical categories will simply pick at random. Start with the lists you genuinely need today, kept lean, and add values only when a real asset arrives that does not fit. It is far easier to add a category next month than to untangle forty of them next year.
Bringing it together
Fifteen minutes of thinking spares you an afternoon of cleanup, keeps your tags consistent, and means that when audit season arrives your register already answers the three questions that matter: what is it, where is it, and who is responsible. Settle your three lists, then record against them. If you would like a place where categories, locations and departments drive your tags automatically, you can start a free 14-day trial and set the structure up once.