Fixed Asset Register Format: The Columns You Need, With a Free Excel Template
Simple Asset Tracker Team · · 6 min read
A fixed asset register format is just a set of columns, but the right columns decide whether your register can answer an auditor's questions or only lists what you bought. Below is the format we'd use, why each column is there, and a free Excel template with all of them set up.
Is there a prescribed fixed asset register format?
No. The Companies Act doesn't lay down a format for the fixed asset register, and neither does CARO 2020. For companies CARO 2020 applies to, paragraph 3(i)(a)(A) asks the auditor to report whether the company maintains proper records showing full particulars, including quantitative details and situation, of its property, plant and equipment. We went through the rest of that clause in CARO 2020 clause 3(i) explained.
ICAI's Guidance Note on CARO 2020 says it isn't possible to specify a single form, because that depends on how the books are kept, how many locations there are and the controls in place. It does list the particulars the records should generally contain, and that list is the best starting point for a format. Our template follows it, and adds the operational columns you need when someone actually goes out to find the assets. If you'd rather keep the register in an app than a spreadsheet, Simple Asset Tracker holds the core of these columns and ties them to physical verification.
Download the free fixed asset register template (Excel)
The columns, and why each one is there
Identifying the asset
Asset ID comes first. It should be the number printed on the asset's tag, so the person standing in front of a machine can match it to exactly one row. Then a description specific enough to identify the asset ("Dell Latitude 5440 laptop", not "Laptop"), the asset class it's shown under in the accounts, and the serial or model number.
Quantity matters more than it looks. The Guidance Note lists quantity among the particulars, and it allows low-value items such as chairs and tables to be grouped on one line. But a line that says "10 office chairs" with one cost is hard to verify chair by chair. Where you can, give each item its own row; where you group, fill in the quantity.
The column headed "Component of" is for significant parts depreciated separately from the main asset, typically because their useful life is different, such as a lift in a building. Record the part on its own row and put the main asset's ID in this column.
Where it is and who has it
Location is what the Guidance Note calls "situation", and it's the column most registers get wrong. "Head Office" against four hundred assets tells a verifier nothing. Use a location someone can walk to: building, floor and room, or branch and store. The Department and Custodian columns say who uses the asset and who answers for it.
The financial columns
These come from your books, not from the floor: date of purchase and date put to use, supplier and invoice number, original cost, any adjustment for revaluation or other increase or decrease in cost, the date of any revaluation, useful life, residual value, depreciation method or rate, depreciation for the year, accumulated depreciation, impairment loss and net carrying amount. The useful life, residual value and method follow your company's accounting policy, so the template leaves them for you to fill in and doesn't calculate depreciation itself.
The Guidance Note expects the aggregate cost, depreciation and impairment in these records to reconcile with the books of account for each asset head. A simple total by asset class at the bottom of each period, compared with the trial balance, catches most problems before anyone else does.
What's happened to it
The Last verified on column holds the date of the most recent physical verification. Status says whether the asset is in use, idle, under repair, held for disposal, disposed or written off. The Disposal date and details column records when and how it left. Keep disposed and fully depreciated assets in the register rather than deleting the rows; the Guidance Note says the records should include assets that are fully depreciated or retired from active use and held for disposal, and having the history in one place saves a lot of searching later.
One laptop's row, from purchase to disposal
Take one example: a laptop bought for ₹78,500 on 8 April 2025 and handed to someone in Finance on 12 April.
On the day it's capitalised, the row gets its Asset ID (FA-0001), description, class, serial number, supplier and invoice, both dates and the cost. Location is "HQ, 2nd floor", the custodian is the person who received it, and Status is "In use". The tag with FA-0001 on it goes onto the laptop before it leaves the IT desk.
Say your policy depreciates laptops on a straight-line basis over three years with no residual value. That works out to about ₹26,167 for each full year of use. The first and last financial years are pro-rated from the date it was put to use, so the charge for 2025-26 is a little less, and twelve months after 12 April the net carrying amount is about ₹52,333. Those figures come from your books; the register just records them so the totals can be reconciled.
In year two the custodian moves to the Pune branch and takes the laptop. The Location and Custodian columns change the day it moves, not at the next audit. At the March verification someone in Pune finds it, and that date goes into the Last verified on column.
In year four the laptop is fully depreciated and replaced. It's sold to an employee. Status becomes "Disposed", the disposal date and details are filled in with the buyer and the amount, and the row stays in the register. When someone asks two years later what happened to FA-0001, the answer is on one line.
Setting the register up so it stays useful
A format only helps if someone keeps the register current. These are the habits we'd put in place:
- Add the asset to the register when it's capitalised, not at year end. By March, nobody remembers which floor the April purchases went to.
- Tag the asset with its Asset ID before it goes into use. We compared tag options in QR code asset tags vs handwritten labels.
- Route transfers and disposals through whoever maintains the register, so a laptop moved to the Pune branch doesn't stay in Mumbai on paper.
- Reconcile the totals to the books every period, not only at audit time.
- Verify against it on a schedule. The checklist in how to do physical verification of fixed assets starts from a register in exactly this shape.
The template's sample rows are marked as samples; delete them before you start. A dropdown is set up for Status, and the header row stays frozen as you scroll.
Where Excel stops being enough
A spreadsheet is fine for a few hundred assets and one person maintaining it. It starts to creak when several people need it at once. Copies multiply, nobody can tell who changed a location or when, and the verification results live in a different file from the register they're checking.
Simple Asset Tracker holds the same information as a shared register. You can import this template once it's saved as CSV: the app recognises its columns, Asset ID included as the tag number, shows you the mapping before anything is imported, and leaves out the columns it has no field for, such as revaluation and impairment. Or connect SAP, Oracle or Zoho Books instead. Each asset carries its tag number, location, department, custodian, cost, depreciation details and the verifier assigned to it. Changes made on an asset's edit screen are logged with what each field was before and after, and which user made them. Physical verification then runs against the register from a phone, and each result is kept in the asset's verification history. It's free for up to 30 assets, so you can download it and try it on one department first.
Try it on your own assets
Simple Asset Tracker runs on your own computer or server. Import your register, print QR asset tags and run a verification from any phone. It's free for up to 30 assets.