How to Map Your Fixed Asset Register to IT Assets and Employees
Simple Asset Tracker Team · · 4 min read
Finance has a fixed asset register. IT has a list of laptops and who uses them. HR has a list of employees. Ask all three how many laptops the company owns, and who has them, and you'll probably get three different answers.
Three lists that drift apart
Many organisations describe the same equipment in at least three places. Finance's fixed asset register records what was bought, what it cost, which cost centre owns it, how it depreciates and when it was disposed of. IT's inventory tracks devices by serial number, model and hostname, and who each one is assigned to. HR's list says who works here today, in which department, and who has joined or left.
Each list belongs to a different team, lives in a different tool and exists for a different reason. Left alone, they drift apart, and the differences tend to surface at the worst moment: when someone leaves, or halfway through a physical verification.
What the gaps cost you
The most familiar one is the leaver who keeps a laptop. If devices aren't tied to a named person in a record somebody actually checks during offboarding, equipment walks out of the door, often with company data still on it.
Then there are assets that are dead in one list and alive in another. Finance records a laptop as disposed while it's still on someone's desk. IT scraps a device that's still depreciating in the books. One or two of these are easy to fix. The trouble is that they pile up quietly, and by the time anyone notices, nobody is sure which list is right.
Capitalised assets with no owner and no location are the ones most likely to turn up missing in a physical verification, and the hardest to explain to an auditor. It works the other way round too: equipment that was expensed by mistake instead of capitalised, or transferred in from a group company, sometimes never reaches the register at all. And without a joined-up view, one team orders new laptops while spare ones sit in a cupboard two floors up.
How to map the fixed asset register to IT assets and employees
Mapping means every asset can be traced across all three lists using keys they share: a unique asset ID (ideally the number on a scannable QR tag), the manufacturer's serial number, and the custodian's employee ID or work email rather than a name that gets spelt three different ways. Once those line up, the location and cost centre should agree across the lists as well.
For a first reconciliation, this is the order we'd follow:
- Export the fixed asset register from your ERP or accounting system, with serial numbers, locations, cost centres and status.
- Export the IT inventory from your device management tool or spreadsheet: serial number, model and assigned user.
- Export the active employee list from HR, with employee IDs and work emails.
- Match on serial number first, then on asset tag. Descriptions like "Dell laptop" won't get you far.
- Put every asset in a bucket: matched to a current employee, in the register but not in IT's list, in IT's list but not in the register, assigned to someone who has left, or disposed in the books but still assigned.
- Fix the records, give every IT asset a named custodian and put a QR tag on anything that hasn't got one.
- Walk the floor. A physical verification proves the reconciled register matches reality.
Each bucket needs an owner. Finance decides, under your capitalisation policy, whether an unregistered device should have been capitalised. Not every one is an error: some will be below the threshold, personally owned, or leased and handled by your lease accounting. IT and HR recover devices from leavers. Anything disposed in the books but still assigned needs finance and IT in the same room, because the disposal entry may need reversing.
Keeping the lists in sync
A one-off clean-up won't stay clean by itself. Issue and recover equipment through one process: when a new joiner gets a laptop, record them as its custodian by employee ID and email, and make getting it back part of offboarding, before their account is closed. If you keep a separate asset register, keep it synchronised with the ERP's fixed asset module so purchases, transfers and disposals flow through without re-keying. When finance marks an asset as disposed, sold or written off, follow up with whoever holds it. And verify on a schedule, because even good processes miss things.
We built Simple Asset Tracker with exactly this problem in mind. Registers exported from SAP, Oracle and Zoho Books import with their own column names, including serial numbers, company codes, cost centres and currencies, or you can connect the ERP for regular syncs. The Issue Tracker records who holds each asset, by name and optionally employee ID and email, with issue and recovery dates and who handled them, one at a time by scanning or in bulk from a CSV. When a sync or import marks an asset as disposed, sold or written off, the app raises a flag so someone follows it up. Physical verification from a phone then confirms the register matches the floor.
If you can't say today who holds each of your laptops, start with one department. Export the three lists, match them on serial number and see what falls out. Then load the result into Simple Asset Tracker, free for up to 30 assets. For the groundwork, read our pieces on QR code asset tags and digital physical verification.
Try it on your own assets
Simple Asset Tracker runs on your own computer or server. Import your register, print QR asset tags and run a verification from any phone. It's free for up to 30 assets.