The Columns a Fixed Asset Register Needs
The test for every column is simple: does it help somebody standing in front of an asset confirm what the books say about it, or help the accounts team tie the sheet to the ledger?
The sheet at a glance
One row per asset. Columns in four working groups, plus the audit columns covered later in this guide.
Identity
- Tag number (as printed)
- Description
- Asset class
- Make, model and serial number
- Tag type and date tagged
Place
- Site and location
- Custodian, with date assigned
- Movement history
Value
- Capitalisation date
- Cost
- Useful life and method
- Depreciation to date
- Written down value
Status
- In use, idle, under repair, awaiting disposal or disposed
Identity, place and custodian make physical verification possible: without them a difference cannot be traced to anyone or anywhere. Cost, life and depreciation make the accounting testable. Status separates an asset in use from one that is idle or waiting to be written off, and it is the column most sheets are missing.
Everything else people add tends to be decoration. Supplier name, invoice number, colour, warranty text and long remarks belong in the purchase file, not in a sheet somebody has to reconcile line by line at the end of a count. Where they are needed, a single reference to the purchase document does the job. Kept up to date with every addition, transfer and disposal, the same sheet is the fixed asset register itself: its cost and depreciation columns, totalled by asset class, should agree with the ledger, which is what lets an auditor tie the floor to the accounts.
Identification and Description
Three fields identify an asset, and each does a different job.
Tag number
The key, and the number on the labelOne number, in one column, matching what is printed on the tag. A sheet that keeps an internal code in one column and the tag number in another has two identifiers for one asset, and they will drift apart.
Description
Written for the person at the asset'Plant and machinery' repeated down forty rows makes matching impossible. Name what the thing is and something that tells it apart: '25-tonne power press, bay 3, blue guard'.
Make, model, serial
The corroborationThe only details an asset carries on its own, independent of anything the business attached. They let a row be matched to a machine when the tag is lost, painted over or moved.
Two tag columns earn their place alongside these: the tag type (barcode, QR or RFID, or a plate where no label will hold) and the date it was fixed. Together they show which tags are due for inspection or replacement, and they explain why an area reads badly at a count. A replaced tag keeps the same number; the date column changes, the tag number never does. The order in which numbers are designed, captured and fixed is set out in the asset tagging process, from numbering convention to register reconciliation.
Location, Custodian and Movement
Location has to be recorded at a level somebody can walk to. Site alone is useless on a large campus, and room-level detail cannot be kept up in a warehouse, so the level is chosen per asset class: site, building and floor for office equipment; site, shop and bay for plant. The test is whether a counter given the row can find the asset without asking anybody.
The custodian column names the person or role answerable for the asset, and it carries the date it last changed. Without a date nobody can tell whether it describes the position today or four years ago. Naming a role, such as 'Maintenance in-charge, Plant 2', survives staff turnover better than a name.
Movement history is the column most sheets leave out, and the one that makes reconciliation possible. When each change of location is kept rather than overwritten, an asset missing from its recorded place can be traced through where it has been, and a pattern of unrecorded moves shows up as a control finding instead of a string of unexplained exceptions. In Excel, a separate movements sheet keyed on the tag number keeps the main sheet to one row per asset.
Cost, Depreciation and Book Value
The value columns connect the sheet to the financial statements, so they must be complete enough to recompute each figure, not just report it. Capitalisation date comes first, because it decides the depreciation charged so far. Cost is the amount at which the asset entered the books. Under AS 10 and Ind AS 16 it is the purchase price, including import duties and non-refundable purchase taxes less trade discounts and rebates, plus the costs directly attributable to getting the asset ready for use, such as delivery, installation and testing, and the first estimate of any dismantling and site restoration the business is obliged to carry out. Taxes recoverable as input credit are not part of cost. If the ledger capitalised freight and installation while the sheet carries only the invoice value, the two will never agree.
Hold the method, rate or useful life against each row instead of applying them by class in a separate schedule; then any single row's charge can be checked without rebuilding the whole calculation. Schedule II to the Companies Act sets indicative useful lives, and a company may use a different life where technical advice supports it and the reason is disclosed. Work out the written down value with a formula rather than typing it in, so it cannot drift away from its own inputs.
Components belong in the same block. Where parts of one asset have significantly different lives and each is significant in cost, they are recorded as separate rows with their own dates and lives. Under Schedule II, component accounting has been mandatory for financial years beginning on or after 1 April 2015. A sheet that never split a component capitalises the same part twice when it is replaced.
If the existing sheet cannot be tied to the ledger, or nobody can match its rows to the assets on the floor, a better template will not fix it. An asset tagging exercise that tags every asset and reconciles the tags back to the register rebuilds that link from the floor up.
Fields the Auditor Will Ask For
For a company under CARO 2020, the auditor reports whether proper records are kept showing full particulars, including quantitative details and situation, of property, plant and equipment, and whether management physically verified those assets at reasonable intervals and dealt properly with any material discrepancies. Three columns beyond the standard ones make that easy to show instead of reconstructing it every year.
- Last verified: date, by whom and result. When the asset was last physically seen and what was found. Without it, the sheet cannot show that verification happened at reasonable intervals.
- Condition and impairment flag. An asset recorded as present but damaged, idle or awaiting disposal is carrying a value that assumes none of those things. An asset is impaired when its carrying amount exceeds its recoverable amount (AS 28, Ind AS 36); the flag is what raises the question.
- Disposal reference and approval. When an asset leaves, the row does not vanish; it carries the date, the authorisation and the document behind the disposal, so the sheet can be reconciled backwards.
A sheet from which rows disappear without trace cannot be reconciled backwards, and a reconciliation that cannot run backwards cannot support the closing figure it produces. How these columns feed the verifier's own report is set out in the fixed asset verification report format.
Using the Template Without Breaking It
One row per asset, without exception, is the rule that keeps a spreadsheet usable. The moment two assets share a row, or one asset spans two, every count, filter and reconciliation afterwards returns a number that is quietly wrong.
- Merged cells. They break sorting and filtering and drop rows from totals, so the same sheet gives different answers depending on how it is queried.
Avoid - Blank separator rows and subtotals inside the data. Filters stop at the gap and totals count some rows twice.
Avoid - Typed values in calculated columns. A written down value keyed in by hand stops following its inputs.
Avoid - Drop-down lists for class, location, status and tag type. One spelling per value, so filters and counts work.
Use - A dated copy at each period end. The closing sheet is kept as it stood, so later edits do not rewrite history.
Use
A spreadsheet has outgrown the estate when the file is slow to open, when more than one person needs to edit it at once, when nobody can say which copy is current, or when an asset's history can no longer be rebuilt because rows were overwritten. At that point the answer is a system rather than a better template, and the columns above are the fields to carry across into it.
