Asset register template: what fields to include and how to structure it
A practical guide to building an asset register template that's actually useful — for accounting, insurance, CapEx planning, and operational asset management.
Most organisations have some version of an asset register. Very few have one they'd describe as genuinely useful when they actually need it — at insurance renewal, during a CapEx planning process, when something needs replacing urgently, or at an inspection.
The difference usually isn't effort. It's structure. A template with the right fields, populated consistently, is worth far more than an elaborate system that gets maintained inconsistently.
This guide covers the field structure that makes an asset register useful across its different use cases: accounting, insurance, compliance, and operational planning.
The two jobs an asset register has to do
An asset register is asked to serve two distinct audiences, and most templates optimise for one at the expense of the other.
The finance and accounting audience needs: original cost, purchase date, depreciation method, current book value, and disposal records. This is the fixed asset register in its traditional form.
The operations and maintenance audience needs: what each asset is, where it is, what condition it's in, when it needs replacing, and what it costs to replace at current prices.
A template that only serves finance produces a register that's useless for maintenance planning. A template that only serves operations misses the financial data needed for accounting and insurance. A well-structured template covers both.
Core field structure
Here is a working template structure for a property-based asset register. Fields are grouped by purpose.
Identity
| Field | Notes |
|---|---|
| Asset ID | Unique reference code (e.g. BDR-0041) |
| Asset name | Descriptive name (e.g. "King bedroom headboard") |
| Category | Broad grouping: furniture, electrical, IT, plant |
| Sub-category | e.g. Bedroom seating, Corridor lighting |
| Manufacturer | Brand name |
| Model name | Specific model |
| Model reference | SKU or product code |
| Description | Brief specification (finish, material, dimensions) |
Location
| Field | Notes |
|---|---|
| Site / property | For multi-site organisations |
| Building | Where relevant |
| Floor | Level number |
| Room / zone | Specific location (e.g. "Room 214 — sleeping area") |
Financial
| Field | Notes |
|---|---|
| Purchase price (£) | Original cost ex-VAT |
| Purchase date | yyyy-mm-dd |
| Supplier | Who it was purchased from |
| Depreciation method | Straight-line, reducing balance |
| Useful life (years) | Expected service life from new |
| Residual value (£) | Expected value at end of useful life |
| Current book value (£) | Calculated field |
| Replacement cost (£) | Current market cost — update annually |
Condition and lifecycle
| Field | Notes |
|---|---|
| Condition rating | Good / Fair / Poor / End of life |
| Last inspection date | yyyy-mm-dd |
| Next inspection due | yyyy-mm-dd |
| Estimated replacement year | Based on condition and useful life |
| Warranty status | In warranty / Expired |
| Warranty expiry date | yyyy-mm-dd |
Compliance
| Field | Notes |
|---|---|
| Applicable standard | e.g. BS 5852 (fire), CE marking |
| Certificate reference | Document ID or file path |
| Compliance status | Compliant / Due for review / Non-compliant |
| Next compliance review | yyyy-mm-dd |
Notes
| Field | Notes |
|---|---|
| Installation notes | Any non-standard installation requirements |
| Substitution history | Record of changes from original specification |
| Disposal date | When the asset was removed |
| Disposal method | Sold, donated, scrapped, returned |
How to calibrate the level of detail
Not every asset warrants the same depth of record. A practical approach is to tier the register by asset value and criticality:
Tier 1 — High-value or compliance-critical assets: full record including all fields above. Applies to assets above a cost threshold (say, £500 unit cost) or assets with compliance requirements (fire-rated upholstery, electrical equipment).
Tier 2 — Medium-value operational assets: condensed record focusing on identity, location, financial, and condition fields. Applies to mid-range furniture and fittings.
Tier 3 — Low-value assets tracked collectively: group record for low-value items held in quantity (desk accessories, standard tableware, minor furnishings). Record the category, quantity, unit cost, and condition — not individual items.
This tiering prevents the register from becoming unmanageably granular while ensuring the assets that matter most are tracked in sufficient detail.
The fields most commonly missed
Replacement cost, not just purchase cost. Purchase prices from five years ago are significantly less useful than current replacement costs. An asset register that records what you paid but not what it would cost to replace today consistently leads to under-funded replacement budgets. Update replacement costs annually, particularly in categories affected by materials inflation — upholstered furniture, engineered timber, and imported goods have all seen significant cost movements in recent years.
Condition rating with a review date. A condition rating without a review date is a point-in-time observation that becomes misleading as time passes. Link every condition rating to a last-assessed date, and set a next-review date. This turns the condition column into a living field rather than a snapshot.
Substitution history. For assets that were originally specified as part of a fit-out project, the original specification and any subsequent substitutions should be recorded. When a model is discontinued and replaced with an alternative, the register should note both — otherwise the specification record diverges from the installed reality and the register becomes unreliable.
Compliance certificate references, not just status. Recording "compliant" is less useful than recording "compliant: certificate ref CERT-2024-0341, valid until 2027." The certificate reference links the register to the actual evidence of compliance, which matters at inspections and during insurance claims.
When to move beyond a spreadsheet
An asset register template in Excel works well for:
- Single-site organisations with fewer than 300 assets
- Teams where one person is primarily responsible for maintenance
- Situations where the asset base doesn't change frequently
It starts to strain when:
- Multiple people need to update it simultaneously
- Version control becomes a problem (which version is current?)
- The register needs to be accessible on-site from a phone or tablet
- Multiple properties each have their own assets to track
- The register needs to integrate with accounting software or procurement workflows
For property-intensive businesses — hotels, student accommodation, care homes — the asset register intersects directly with the FF&E specification record from the fit-out project, which contains precisely the detailed product data that makes a good asset register useful. Bridging these two data sets — fit-out specification and operational register — is where most of the operational value lies.
Controlbook is built to maintain that live record across the full lifecycle. Book a demo if you'd like to see how it handles the fields above in practice.
Frequently asked questions
Can I use a free asset register template Excel download?
Yes — and for smaller organisations, a free Excel template is a perfectly reasonable starting point. The important thing is whether the template captures the right fields rather than whether it costs money. The templates that come with the most limitations are usually those that optimise for accounting fields only, without condition, lifecycle, or compliance columns.
How do I build an asset register for a hotel or hospitality property?
Start with the fit-out documentation from the most recent refurbishment — the specification book or O&M manual from the interior design and procurement phase. This contains item-level specification data (manufacturer, model, reference) that would otherwise take weeks to recreate. Transfer this to your register structure, add condition assessments from a physical walk-through, and layer in financial data from procurement invoices. The result is a starting asset register that reflects both what was specified and what was installed.
What's the right depreciation method for hotel furniture?
Most hotel operators use straight-line depreciation over an expected useful life — typically 7–10 years for casegoods, 5–7 years for soft seating, and 3–5 years for soft furnishings. The specific rates used often follow the hotel brand's guidelines or accounting policy rather than a universal standard. Whatever method is chosen, the register should record both the method and the expected useful life, so the depreciation schedule can be reconstructed.
Should the asset register include leased assets?
Leased assets under IFRS 16 are recognised on-balance-sheet and should appear in the financial record. Whether they appear in the operational asset register depends on whether the lessee is responsible for maintenance. For long-term operating leases where the lessee manages the asset day-to-day, including them in the operational register makes practical sense.