Free asset register template
A ready-to-use fixed asset register template with the columns you actually need — preview it below and download the spreadsheet free.
Template columns (live preview)
| Column | Example |
|---|---|
| Asset ID | AST-0001 |
| Name / description | MacBook Pro 16" |
| Category | IT equipment |
| Location | HQ · Floor 2 |
| Custodian | A. Kessy |
| Purchase date | 2026-01-15 |
| Purchase cost | 2400 |
| Depreciation method | Straight-line |
| Useful life (yrs) | 4 |
| Accumulated depreciation | 600 |
| Net book value | 1800 |
| Status | In use |
A fixed asset register is the single source of truth for everything your organisation owns: what it is, where it is, who has it, what it’s worth and how it’s depreciating. This free asset register template gives you a clean, well-structured starting point in Excel or Google Sheets, with the columns finance and operations teams rely on — asset ID, name, category, location, custodian, purchase date, cost, depreciation method, useful life, net book value and status.
Preview the exact columns below before you download, so you know it fits your process. Use it to move off scattered spreadsheets, get an accurate count for your next audit, and build a base for depreciation. When your register outgrows a spreadsheet — when you need barcode/RFID tagging, mobile stock-takes, check-in/out and automated depreciation across sites — Asetavo turns the same structure into a live, multi-user asset register.
How to build an asset register
Start from the template
Download the template with the standard asset-register columns.
List your assets
Enter each asset with a unique ID, location and custodian.
Add cost & depreciation
Record purchase cost, method and useful life to track net book value.
Keep it current
Update locations, custody and status after every move or audit.
Questions, answered
Take it further
Ready to account for every asset?
Tag, track and audit everything you own — from a handheld scanner to a boardroom report.
No card required · Live in a day · TZS/USD/GBP