Sheet 1 β Fixed Asset Register (Navy tab) 10 sample assets with 20 columns covering Asset ID, Description, Category, Location, Custodian, Purchase Date, Supplier, Invoice No., Cost, Salvage Value, Useful Life, Depreciation Method (SLM/WDV), Rate, Opening/Closing Accumulated Depreciation, and Net Book Value. Status cells are colour-coded green (Active) or orange (Under Repair).
Sheet 2 β Summary by Category (Blue tab) Roll-up view of all 6 asset categories with totals for cost, accumulated depreciation, and net book value.
Sheet 3 β Depreciation Schedule (Green tab) Year-wise depreciation workings per asset with auto-calculated “% of Total Dep.” column.
Sheet 4 β Asset Disposal (Orange tab) Ready-to-fill register for recording disposals, write-offs, and gain/loss on sale.
Sheet 5 β Instructions (Purple tab) User guide explaining colour coding, depreciation methods, and year-end rollover process.
All monetary values use βΉ formatting, formulas are live (57 verified, zero errors), and rows alternate shading for readability. Simply replace the sample data with your actual assets.