Physical assets are often among the largest items on an organisation’s balance sheet: buildings, vehicles, machinery, ICT equipment, furniture. Yet in many organisations they are tracked in a spreadsheet that one person updates when they remember to. The result is a register nobody fully trusts and a steady leak of value that rarely shows up until an audit, an insurance claim or a procurement decision exposes it.
This article explains why spreadsheet-based asset tracking breaks down, what a modern asset management system provides and how to make the move.
Where spreadsheet registers break down
Spreadsheets are flexible and familiar, which is why they are used. For managing assets across their lifecycle, though, they have structural weaknesses.
No reliable history. A spreadsheet shows the current state of a record, if it has been updated, but not who changed it, when or why. Movements, repairs and custody changes disappear.
Multiple versions. Copies circulate between departments and branches. Which one is correct?
No link to the physical asset. Without tags and scanning, matching a laptop on a desk to a row in a spreadsheet depends on serial numbers that are hard to read and descriptions that vary.
Manual depreciation. Formulas get copied incorrectly, rates are applied inconsistently and disposals are not removed, so book values drift away from reality.
Disconnected from finance and procurement. New purchases are added late or not at all, and the register no longer agrees with the general ledger.
The hidden costs
These weaknesses carry real costs:
- Ghost assets: items that remain in the register, and attract depreciation and sometimes insurance premiums, but no longer exist.
- Unrecorded assets: items in use that were never captured, leaving them unprotected and unaccounted for.
- Unnecessary purchases: buying new equipment when identical items sit unused in another office or store.
- Loss and theft: without custody records, it is difficult to know who had an item last.
- Missed maintenance: equipment fails early because servicing is not scheduled or tracked.
- Audit findings: incomplete or unreconciled registers are a common source of audit queries, especially in the public sector.
What a modern asset management system provides
A purpose-built asset management system treats each asset as a record with a full lifecycle rather than a row in a table.
A single, authoritative register
One system holds every asset, with consistent classifications, locations, custodians and values, and the right access for each department or branch.
Tagging and mobile scanning
Each asset carries a barcode or RFID tag linked to its record. Staff scan assets with mobile devices to look them up, move them or verify them, which is far faster and more accurate than reading serial numbers.
Lifecycle tracking
Acquisition, commissioning, transfers, repairs, revaluations and disposal are recorded as events, building a complete history for every asset.
Custody and accountability
Assets are issued to named individuals or departments, with acknowledgements, returns and handovers recorded, including when staff leave.
Depreciation
Depreciation methods and rates are configured by asset class and calculated consistently, with schedules and journals ready for finance.
Maintenance management
Preventive maintenance is scheduled automatically, and repair costs and downtime are logged against each asset.
Integration
Integration with procurement and finance means new purchases flow into the register, and depreciation and disposals flow into the ledger. Integration with IoT sensors can add usage and condition data for vehicles and equipment.
Reporting and audit trails
Registers by location, class, custodian or cost centre, movement histories, verification results and complete audit trails are available on demand.
The benefits
Organisations that move to a modern system typically gain:
- Financial accuracy: asset values and depreciation that agree with the financial statements.
- Accountability: a named custodian and a complete history for every asset.
- Lower costs: better utilisation, fewer duplicate purchases and longer asset life through planned maintenance.
- Audit readiness: a register that can be verified quickly and explained clearly.
- Better decisions: reliable data for budgeting, replacement planning and insurance.
Making the move
Adopting a new system is mainly a data and process exercise. A practical sequence is:
- Establish a clean baseline. Run a tagging and verification exercise so the new system starts with accurate data. Our guide to asset tagging and verification for public institutions explains how; the same approach works for companies and NGOs.
- Agree classifications and policies. Define asset classes, capitalisation thresholds and depreciation methods.
- Configure and integrate. Set up locations, departments and users, and connect the system to finance and procurement.
- Define the processes. Decide who records receipts, transfers, repairs and disposals, and when.
- Train users. Store keepers, custodians, finance staff and managers each need role-specific training.
- Verify regularly. Use the system for rolling or annual verifications so the register stays accurate.
What to look for in a system
- Barcode and RFID support with mobile scanning
- Flexible asset classes and depreciation rules
- Multi-location, multi-branch and multi-department structure
- Custody, transfer and disposal workflows
- Maintenance scheduling and cost tracking
- Integration with your ERP or accounting system
- Complete audit trails and flexible reporting
- Local implementation and support
GetSharp provides asset management software, tagging and verification services through AssetWise, our asset management platform. Learn more about our asset management solutions or talk to our team.