Free fixed asset register template

Yes, there is no charge for the template itself. We ask for basic contact details before sending it because it is a document for direct use, not a page to browse, and it lets us follow up if you have questions applying it to your own asset base.

IPSAS if you are a public entity reporting under National Treasury and IPSAS requirements; IFRS, particularly IAS 16, if you are a private company. If you are unsure which applies, ask your auditors or accounting officer, it is a reporting framework decision, not a tagging decision.

It includes a straight-line depreciation formula you can adapt, but it will not automatically handle every depreciation method, mid-year additions, revaluations or componentised assets without manual adjustment. For those, proper accounting or asset management software is more reliable. The formula is a starting point for organisations without dedicated fixed asset software, useful for a straightforward annual write-down calculation, but treat it as a working aid rather than a substitute once your asset base grows past a few hundred lines.

No, the template only gives you the structure to record data; it does not generate asset numbers or verify what you physically own. You still need a tagging and verification exercise to populate it accurately in the first place.

Comfortably a few hundred to low thousands on a single site with one careful editor. Beyond that, or across multiple departments and editors, error rates rise and audit trail gaps become a real risk, that is the point to move to dedicated software.

Many auditors will accept a well-maintained spreadsheet for a smaller entity, provided the data is accurate, consistently updated and reconciled to physical counts. What auditors will not accept is an unreliable or unreconciled register, spreadsheet or otherwise, so accuracy matters more than the tool.

Yes, our fixed asset register service and comprehensive tagging tier both deliver a populated register in this structure, built from an actual on-site count rather than existing records alone. That matters because a register built purely from old paperwork often carries forward errors nobody has checked in years, whereas a physical count against each tag corrects mismatches between what's on paper and what's actually still on site.

Not by default, but it is a straightforward column to add if you use mixed tag materials across your estate and want to track that alongside condition and location. It's worth adding if your estate mixes aluminium, polyester and stainless steel, since replacement cost and expected life differ by material, and a single combined column makes it harder to forecast future tagging spend accurately by category.

You can map your existing columns to the template's structure, or send us your current register and we will advise on reconciling it into either the IPSAS or IFRS structure as part of a register or verification project. Most reconciliation work is spent matching old reference numbers or serial numbers to a new tag number, so keep a record of that mapping until your first full verification count is complete.