Fixed Assets Register Template Excel with Depreciation Schedule

Fixed Asset Register & Depreciation Schedule is an asset register template in Excel built the way accountants keep one. Record each asset once with its ID, description, category, location, custodian, supplier, invoice reference, serial or tag number, purchase date, in-service date and cost. The register then shows the method and life used, the monthly charge, depreciation for the year, accumulated depreciation, net book value, % depreciated, age, the month it will be fully depreciated and a status of in use, fully depreciated, disposed, not depreciated or below threshold.

Each category sets a default method, useful life, residual value % and ledger accounts, and any asset can override them. Straight-line, declining balance and sum-of-years' digits are built in. Declining balance uses a factor you choose, such as 2.0 for double declining or 1.5, and switches to straight-line when that gives more, so every asset reaches its residual value at the end of its life. Land and assets under construction can be set to not depreciated.

Depreciation is worked out by month from the in-service date, with a choice of convention: a full month in the month acquired, or starting the month after. Monthly, year-to-date and full-year figures always agree. Change the report month on Settings and every tab rolls forward. The Depreciation Schedule shows depreciation by category for each month of the fiscal year, actual and forecast, with the journal entry for the report month using your account codes.

Disposals record sales, trade-ins, scrapping and write-offs with the date, proceeds and costs of disposal. Depreciation stops, the asset leaves the totals and the gain or loss is calculated against book value. The Fixed Asset Schedule gives the roll-forward your accounts need: cost and accumulated depreciation opening, additions, disposals, charge and closing by category, net book value, and checks that tie it back to the register and the monthly schedule.

The Asset Card prints one asset's details and year-by-year depreciation schedule over its whole life for audit or insurance files. The Dashboard shows cost, net book value, depreciation year to date, gains on disposal, book value by category, a six-year depreciation forecast, assets by location and items that need attention. Capacity covers 200 assets and 100 disposals, with any fiscal year start. This is for book depreciation; tax depreciation rules differ by country. Calculated cells are locked and sheet protection has no password. Sample data from a fictional company is included. Built for Microsoft Excel 2016 or later (desktop or Excel for the web) and contains no macros.