What Is an Asset Register?

An asset register is a complete record of an organisation’s assets - one entry per item, listing details such as location, owner, value, and condition. It is the single place where “what do we own, where is it, and who has it” can be answered without a search party. Each entry is tied to the physical item by an asset tag, and kept honest by a periodic asset inventory that checks records against reality.

The same register covers everything worth tracking: IT hardware such as laptops, monitors and phones; vehicles, machinery and tools; safety equipment and keys; and intangibles such as software licences. Keeping IT and physical assets in one place, rather than two disconnected lists, is what stops items falling through the cracks between teams.

Why keep an asset register

The purpose of an asset register is to turn vague institutional knowledge into a record you can actually rely on. The benefits compound:

• You know what you own and where it is. A current register is the first defence against loss and theft - missing items are obvious when every asset has an owner and a last-known location.
• Financial reporting and depreciation are accurate. Reliable purchase data and useful-life figures feed clean depreciation and book-value numbers, instead of estimates dredged up at year-end.
• Audits go faster. When an asset audit can trace any item to a record and any record to an item, the audit stops being an archaeology project.
• Insurance is right-sized. You insure what you actually hold - no paying to cover disposed equipment, no nasty gaps - and claims are cleaner because you can prove ownership, value, and condition.
• Repair-or-replace decisions improve. Repair history and age sitting on each entry make it obvious when an item has cost more in fixes than a replacement would.
• Compliance is easier. Whatever your reporting obligations, they are simpler to meet from a single maintained record than from memory and scattered receipts.

A register the organisation does not trust delivers none of this, which is why accuracy - covered below - matters as much as the data model.

What each entry should include

Competitors and accountants tend to group an entry’s fields into three buckets. The grouping is worth borrowing, because it scans well and makes gaps obvious:

• Identification - a unique asset ID, name, category and sub-category, and the manufacturer’s serial number.
• Custody and status - current owner or assignee, location, and status (in use, in storage, in repair, retired).
• Financial - purchase date and price, supplier, warranty end date, and expected useful life; for capitalised items, also cost basis, depreciation method, accumulated depreciation, and net book value.
• Condition and history - condition notes, repairs, and attached documents such as receipts and manuals.

The discipline is to record what will be maintained and acted on. Twenty pristine fields beat sixty abandoned ones.

Asset register format you can copy

Treated as a reusable format, the core of any register is a single row per asset with these columns. Start here and add only the fields your organisation will keep current:

For a fixed asset register you would extend the same row with depreciation method, accumulated depreciation, and net book value. The shape stays identical - the finance columns simply ride along on each entry.

A simple example entry

A production company registers a new drone:

• ID: DR-0007 · Category: Drones
• Serial: 3XK9-44021-B · Status: In use
• Owner: Field team · Location: Equipment store, shelf 3
• Purchased: 2026-02-12, €1,850, from the usual supplier · Warranty until: 2028-02-12
• Notes: Spare propeller set stored with case; receipt and manual attached

The same structure fits an everyday office asset just as well - a laptop assigned to a new hire, a forklift in a warehouse, or a software licence seat - only the category and a few fields change. Six months later, anyone scanning the label on the case sees who has it, when it is due back, and that the warranty still has time to run.

How to build an asset register

Building a register from scratch is mostly about scoping it sensibly and then capturing reality once, accurately:

1. Decide scope and a threshold. Choose which assets count - everything, or everything above a capitalisation threshold or value floor. A threshold keeps the register focused on items worth the effort to track.
2. Standardise fields and an ID scheme. Agree the columns from the format above and a consistent ID pattern (a prefix per category plus a number works well). Inconsistent IDs are the first thing to rot.
3. Do a physical walkthrough. Walk the building and capture what actually exists, not what the purchase records imply. This is where most zombie assets - real items never recorded - get caught.
4. Gather the documents. Pull receipts, invoices, manuals, and warranty cards as you go, and attach them to each entry.
5. Enter and validate. Type the data in, then sanity-check it: duplicate IDs, blank owners, impossible dates.
6. Assign an owner and define update triggers. Name a person responsible for the register, and write down the events that must trigger an edit - purchase, transfer, repair, disposal.

Tag each item as you go with an asset tag so the physical asset and its record stay linked. From there, the register becomes a stage in each item’s asset lifecycle rather than a one-off project.

Register vs inventory

The register is the living record, updated as events happen; the inventory is the counting exercise that verifies it. An inventory without a register produces a list that starts ageing immediately. A register without inventories drifts until nobody trusts it. Healthy organisations run both: continuous updates day to day, a reconciliation walk-through at sensible intervals.

Keeping the register accurate

Registers decay in two characteristic ways. A ghost asset is an entry whose item is gone - lost, broken, or disposed of - yet still being insured and depreciated. A zombie asset is the mirror image: a real item that never made it into the records at all. Both come from the same root cause, events that happened to equipment but never reached the register. The cure is making updates effortless at the moment of the event - which is why scannable labels matter more than any field layout.

Fixed asset register and depreciation

A fixed asset register is the finance side of the same idea: the subset of capitalised, long-lived assets carried on the balance sheet. The line between it and the general register is the capitalisation threshold - the value above which a purchase is treated as a capital asset and depreciated over time, rather than expensed immediately.

For each capitalised item, the fixed asset register carries the figures accounting needs: original cost, the chosen depreciation method, useful life, accumulated depreciation, and the resulting net book value (cost minus accumulated depreciation). Those figures matter because the register is reconciled against the general ledger and balance sheet - the totals in the register should match the asset and depreciation balances in the accounts. When they diverge, the difference is usually a ghost asset still depreciating or a disposal that was never recorded.

In AMPthilly, each entry can hold the maintenance and financial context this depends on - purchase price and date, supplier, invoice number, warranty dates, expected useful life, and replacement value - and you can export to CSV for finance. Asset valuation and depreciation come in on the Pro plan, so the register can produce the book-value figures rather than leaving them in a separate spreadsheet.

Formats: spreadsheet or software

A spreadsheet is a legitimate first register, and far better than nothing. It starts to fail when assets change hands frequently, when several people edit it, or when you need to know who changed a record and when. Dedicated software adds the things a sheet cannot: scan-to-open from the label, checkout and return workflows, and an audit trail. In AMPthilly, the register supports CSV import to bring an existing spreadsheet across, and every later change - checkouts, transfers, edits, attachments - is logged automatically in the asset’s history.

FAQ

What should an asset register include? Each entry needs a unique asset ID, a name and category, the serial number, the current owner and location, a status, and the purchase details - date, price, supplier, and warranty end. Beyond that, record what you will actually act on: condition notes, attached receipts and manuals, and expected useful life. Resist recording fields nobody will maintain; an empty column is harmless, a stale one is misleading.

Can you keep an asset register in a spreadsheet? Yes, and many organisations start that way. A spreadsheet handles the list itself fine; what it cannot do is enforce updates. There is no scan-to-open from a label, no log of who changed what, and no checkout workflow, so accuracy depends entirely on people remembering to edit a file. Spreadsheets tend to break down once assets change hands often or more than one person maintains the register.

What is the difference between an asset register and a fixed asset register? A fixed asset register is the finance-flavoured subset: it lists capitalised long-term assets with the figures needed for accounting - cost, depreciation, and book value. A general asset register is broader and operational, covering anything worth tracking regardless of accounting treatment, including items under the capitalisation threshold. Many organisations keep one register that serves both purposes, with financial fields on each entry.

How often should you update an asset register? Update it in real time, at each event - a purchase, a transfer, a repair, a disposal - rather than saving everything for a year-end scramble. Then reconcile against a periodic physical inventory to catch anything the live updates missed. Event-driven editing keeps the register trustworthy; the periodic count keeps it honest. A register touched only once a year is out of date for most of that year.

What is the difference between an asset register and an asset inventory? The register is the living master record, updated continuously as assets are bought, moved, repaired, and retired. The inventory is the periodic count that verifies it - someone physically checking that each recorded item still exists, in the recorded place, in the recorded condition. The register is the source of truth; the inventory is the audit that proves the source of truth is still true.

How do you create an asset register in Excel? List one row per asset with the core columns: ID, name, category, serial, owner, location, status, purchase date, price, supplier, and warranty end. Add a second tab to log additions, transfers, and disposals so you have a rough history. A spreadsheet works until assets change hands often or more than one person edits it - there is no scan-to-open, no change log, and concurrent edits clash. At that point a tool that imports your CSV is the cleaner path forward.

Tools that make this easier

AMPthilly keeps the register and the reality of your assets in step. CSV import brings an existing spreadsheet across in one go; QR labels let anyone open an asset profile from a phone browser - no app to install - to check it in or out or report an issue; and every checkout, transfer, edit, and attachment lands in the asset’s audit history automatically. Roles (Admin, Manager, Employee, Client) make it clear who maintains what, and the free plan needs no card to start.

The takeaway

An asset register is the master record of what you own, where it is, and what it is worth - and its whole value rests on staying current. Decide your scope, standardise a handful of fields, capture what physically exists, and then update at the moment things change rather than once a year. Whether it lives in a spreadsheet or in software, the register that earns trust is the one that is maintained.

Related terms

• Asset Inventory - the physical count that keeps the register honest
• Asset Lifecycle - the stages every register entry moves through
• Asset Tag - the label connecting each entry to its item
• Ghost Asset - a register entry whose item no longer exists
• Zombie Asset - a real item missing from the register