Why We'd Retire the Clipboard for Physical Verification of Fixed Assets
Simple Asset Tracker Team · · Updated · 5 min read
If your company still runs physical verification of fixed assets on paper, you know the routine. Someone prints the register, splits it by floor and hands out clipboards. Three weeks later someone else is still typing ticks into a spreadsheet and chasing the handful of items nobody could find. There's a quicker way, and your verifiers can do it with the phones they already carry.
Why physical verification of fixed assets matters
Your fixed asset register is a claim about the real world. It says the laptops, machines, furniture and vehicles on your balance sheet exist, sit where the register says they do, and haven't been lost, scrapped or sold without anyone updating the books. Physical verification is how you check that claim, and how you catch the things that moved to another branch and never got updated. A good count also turns up assets that are damaged or sitting idle, which your accountants will want to know about when they look at impairment.
Auditors ask about it, too. In India, for companies that CARO 2020 applies to, the statutory auditor has to report whether management has physically verified property, plant and equipment at reasonable intervals, whether any material discrepancies were noticed, and whether they were properly dealt with in the books of account (clause 3(i)(b)). Where the auditor also reports on internal financial controls under section 143(3)(i) of the Companies Act, the verification process is usually one of the controls they look at.
Finance teams generally accept that they have to verify. Where they differ is in how far they'd trust their own results if an auditor started asking how each asset was checked.
Where the paper process quietly breaks
A typical paper verification follows the same path. Export the register, print it (often hundreds of pages), split it by location, walk the floors, tick or scribble against each line, collect the sheets and type the results back into a spreadsheet. Then compare, chase and write it up.
Errors creep in at almost every step. Take transcription. An asset ID is read off a faded label and written on paper, then read off that paper and typed into Excel. That's two chances to swap a 1 and a 7. One wrong character turns a verified laptop into a missing one, and somebody loses an afternoon looking for a machine that was on a desk the whole time.
Then there's evidence. A tick doesn't say who saw the asset, when they saw it, or whether they saw it at all rather than assuming it was there, which gives an auditor very little to rely on.
Paper is also bad at telling missing from misplaced. The projector that belongs in Conference Room B but turns up in the second-floor store room isn't missing. On paper it becomes a note in the margin, the note rarely reaches the register, and next year the same projector is flagged again.
And nobody knows how far along the count is until the sheets come back. By the time the results are typed up, people have changed desks, assets have moved again and chasing an exception means re-walking a floor from memory. Sheets go missing too: left in a drawer, taken home by someone who then goes on leave.
Counting with a phone instead of a printout
The digital version swaps the printout for a phone. The register lives in one system, every asset carries a scannable QR label, and each verifier works through the list of assets assigned to them.
In Simple Asset Tracker, a verifier opens the app on their phone and scans the asset's QR tag, and the right asset comes up, so nothing gets copied by hand. They mark it verified, missing or misplaced. The app stores who submitted the result, when, whether the asset was scanned or picked from the list, and any notes. For a misplaced asset the verifier has to enter where it was actually found, so whoever follows up knows exactly where it is and can either move it back or update its location in the register.
Basements, warehouses and remote sites often have no signal, so results are saved on the phone and sent once it reconnects. Back at the office, admins can check results as they come in and sort out exceptions the same day, while people are still on site.
| Paper and spreadsheet | Phone-based | |
|---|---|---|
| Identifying the asset | Read a label, write it down, type it up later | Scan the QR tag in the app |
| Evidence for each asset | A tick, maybe initials | Result, verifier, time, scan or manual, notes |
| Misplaced assets | A margin note that gets lost | Recorded with where it was found |
| Progress | Unknown until the sheets return | Visible as results come in |
| Following up exceptions | Weeks after the count | During the count |
Switching over without a big-bang count
You don't need a big-bang switch, and you don't need to count everything at once. CARO 2020 doesn't say how often to verify; it asks the auditor to report whether management verified at reasonable intervals. ICAI's Guidance Note on CARO 2020 says annual verification may be reasonable and, where that isn't practicable, the programme should still cover every asset at least once in three years. So a phased count is common. Whichever cycle you pick, this is the order we'd suggest:
- Start with a clean register. Import it from your ERP or a CSV export of your spreadsheet and fix duplicates and missing locations before anything gets a label.
- Tag every asset with a QR label, and keep track of which labels have been printed and which are actually stuck on. We cover this in QR code asset tags vs handwritten labels.
- Assign verifiers by location so nobody counts the same room twice. Where you can, use people who don't look after those assets day to day.
- Pilot one floor or branch. It shows you where labels are missing and how long the full count will really take.
- Run the count, then close the loop: correct locations for misplaced assets, investigate the missing ones, and write off anything confirmed lost only with proper approval, so the books match what you found.
- Give the auditors the verification report and each asset's history instead of a box of paper.
Count in both directions, too. Checking that every asset in the register exists is only half the job. Anything your verifiers find on the floor that isn't in the register should be noted and followed up. Some of it will belong to someone else, such as leased or vendor-owned equipment. Some of it may be spending that ought to have been capitalised.
The usual objections are easy to answer. Anyone who can take a photo with a phone can scan a QR code, and there's less to learn than with paper because there's nothing to transcribe. Poor signal is covered by offline scanning. And if putting your asset data in someone else's cloud is a problem, it doesn't have to go there. Simple Asset Tracker is self-hosted, so the register stays on your own computer or server.
If you'd like to see the difference on your own floor, download Simple Asset Tracker and verify a single room this week. It's free for up to 30 assets.
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.