How to count the laptops before the auditor does
A spreadsheet is complete on the day it is made. Here is what an asset register needs to survive twelve offices and an annual audit.
Almost every agency we visit has an IT asset register. It is a spreadsheet, it was accurate on the day it was written, and it has been drifting ever since. The gap shows up once a year, when staff spend weeks counting laptops that moved between offices and a few are never found at all.
Why the spreadsheet drifts
Not because anyone is careless. A spreadsheet records a decision after the fact, and the decisions happen elsewhere: a laptop is handed to a new officer in a corridor, a printer is moved to the regional office for a week and stays for a year, a machine goes for repair and comes back with a different serial. Nothing in the file knows any of that happened.
What a register has to do
- Identify the item, not the row. A QR label on the machine, so a count is a scan rather than a transcription.
- Name a custodian. Every item belongs to a person and a location, and a transfer is recorded when it happens, not at audit.
- Carry the money. Purchase cost, date, depreciation method and current book value, so the register answers the finance question as well as the IT one.
- Remember maintenance. Service schedules and repair history against the item, so a machine that fails every quarter is visible as a pattern.
- Produce the disposal schedule. When equipment reaches end of life, the board needs a list with values and condition, not a memory.
The audit is the easy part
If the register is accurate on an ordinary Tuesday, the audit is a report rather than a project. That is the actual test of an asset system: not whether it can produce a document, but whether the document was already true before anyone asked.
Disposal is where the risk sits
A retired laptop leaves the building with whatever was on it. Wiping to a recognised standard, recording the certificate against the asset, and keeping that record for the auditor is not optional for an agency handling citizen data. We treat disposal as part of the register rather than as a separate errand.
Starting without a clean slate
Nobody starts from zero. Import what the spreadsheet has, label and scan one office at a time, and accept that the first count will find items the file does not know about and items the file invented. That first reconciliation is the point of the exercise.
See how Glide Asset Manager handles this, or ask for a quote by office count.