Fixed Asset Register Depreciation preview
Asset Register sheet with columns for asset ID, class, location, cost, depreciation method, accumulated depreciation, and net book value. 1/4

About this fixed asset register and depreciation spreadsheet template

This Fixed Asset Register Depreciation template provides a complete system for tracking capital assets, calculating monthly depreciation, and monitoring net book value across asset classes. The four-sheet workbook includes a detailed asset register with columns for cost, salvage value, useful life, depreciation method, accumulated depreciation, and disposal gain or loss, plus a review queue that flags assets needing attention.

A summary dashboard consolidates key metrics such as total asset value, monthly depreciation charges, and net book value by class, while the Lists & Guide sheet documents the depreciation rules, formulas, and review cadence. Sample data for IT equipment, machinery, vehicles, and leasehold improvements illustrates the structure and can be replaced with your own fixed asset ledger.

Every cell, label, and formula is fully editable in WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers. The template uses USD as the sample currency; change the cell number format and currency label for your market before use.

4 structured sheets

Asset Register, Review Queue, Dashboard, and Lists & Guide cover the full fixed asset lifecycle.

Built-in depreciation formulas

Straight-line depreciation calculations with cost, salvage, and useful life inputs ready to extend.

Clean dashboard layout

Summary metrics and asset counts by class presented in a scannable, print-ready format.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

Frequently asked questions
The Fixed Asset Register Depreciation template is designed for tracking capital assets, calculating monthly depreciation, monitoring net book value, and reviewing asset status across your organization. Customize the sample data, formulas, and layout in WPS Office for your own fixed asset ledger.
Use the native XLSX in WPS Office, Microsoft Excel, Google Sheets, or Apple Numbers. For Notion workflows, reuse the asset tracking structure in a Notion database; for branded financial reports, adapt the dashboard content in Adobe Express.
Download the template, open it in WPS Office, and replace the sample asset data, class names, cost figures, and depreciation parameters with your own fixed asset records. Adjust the currency format and labels for your market.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for capital asset tracking, depreciation schedules, month-end close reconciliations, and audit-ready fixed asset reporting. It is available for personal and commercial projects, subject to the applicable template license.