A fixed asset register template, free

What it is: Tag ID, Category, Make, Model, Serial number — the tag is the label on the physical thing, and the register’s whole trick is that the two always match.

What it cost: Purchase date, In-service date, Purchase amount, Purchase currency — plus Opening depreciation and Opening balance as at, for assets that already have a depreciated history when the register starts. Write the currency as a three-letter code, such as INR for rupees.

Where it is and who has it: Status, Location, Holder, Notes, and Part of — which nests an accessory under the asset it belongs to, the way a dock belongs to a laptop.

The two example rows show each column’s format. Replace them with your own assets and keep the heading row exactly as it is.

A fixed asset register is the list your auditor asks for: what the business owns, what each item cost, where it is, who holds it, and what it is worth after depreciation. For most Indian companies it is also where the CARO 2020 answer starts: the Order asks the auditor whether property, plant and equipment were physically verified at reasonable intervals. One person companies, small companies, banking, insurance and Section 8 companies, and some private companies below the thresholds, sit outside CARO, and the register is worth keeping either way. A spreadsheet with these sixteen columns is a legitimate start — most registers begin exactly this way.

Spreadsheets hold the list, not its history. Who holds a thing is a cell anyone can overwrite, a deleted row leaves no trace, and at year-end someone rebuilds depreciation by hand. When that day comes, this exact file imports into Blacrex: the columns map themselves (the headings are the importer’s own labels), and nothing is written until a dry run shows you what every row would do.

The free plan has no asset cap — the paid plans add the year-end Schedule II depreciation download and the Tally export. How the import works.