Fixed Asset Register

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 β€” […]

πŸ”„ Published Jul 2026

Trusted by 6,00,000+ CA professionals across India

⬇ Available Downloads

Excel Format (Editable) πŸ”’

XLSX Pro 17 KB ✏️ Editable

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.

Get Unlimited Access with Pro Membership

Download unlimited formats, get editable files, and access premium CA resources.

  • Unlimited downloads
  • Editable Word / Excel formats
  • Premium CA toolkit access
  • GST / ROC / Audit templates
  • Priority format updates
  • AI drafting tools (coming soon)
β‚Ή99
per month
β‚Ή1,499
lifetime
πŸ‘‘ Upgrade to Pro

What is Included in This Format?

This format includes a professionally structured template ready for immediate use. Fields are clearly labeled for easy customization.

Disclaimer: This format is provided for general information only. Please review applicable laws and professional requirements before use.