About this tool
What you need to know
A fixed asset register is the single source of truth for everything your organisation owns: what it is, where it is, who has it, what it cost and what it is worth now. This free asset register template gives you that register in Excel with the calculations built in. Enter the cost, in-service date, residual value, useful life and depreciation method for each asset, set your reporting date once, and the workbook works out accumulated depreciation, net book value (NBV), this year’s depreciation charge and the gain or loss when you dispose of an asset.
It supports the four common book depreciation methods: straight-line, reducing balance (also called written-down value or WDV, with your own annual rate), double-declining balance and sum-of-the-years’-digits, using a full-month convention. A separate Depreciation schedule sheet shows any single asset year by year, and a Summary sheet totals cost, accumulated depreciation, NBV and the year’s charge by category for the assets you still hold. The first 32 columns use the same names as Asetavo’s asset fields, so when the register outgrows a spreadsheet you can bring it into Asetavo with the self-serve Excel/CSV import wizard.
The formulas give book (accounting) depreciation. Tax depreciation — capital allowances, MACRS or prescribed wear-and-tear classes — follows local rules, so confirm tax treatment with your accountant.
