Which depreciation method is used?

Straight-line: the cost is divided by the useful life in months. Other methods, revaluation and bonus depreciation are not implemented.

From which month does depreciation start?

From the month after the in-service month, and it ends when the cost has been written off or in the month of disposal.

Where do I get the useful life from?

It is determined by the classification and accounting policy that apply to your organization. Check the data against your local rules before use; the calculation is indicative.

How do I see the net book value at another date?

Enter the date on the "Settings" sheet: accumulated depreciation, net book value and status are recalculated.

← All templates

Fixed Assets and Depreciation in Excel: Asset Register and Monthly Schedule — Excel Template

A fixed asset register, straight-line depreciation, accumulated amount and net book value at a chosen date, a monthly schedule for the year, a summary by group and a chart.

≈ $7.39

590 ₽

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

When you have more than a few dozen fixed assets, calculating depreciation by hand is slow and error-prone. From the in-service date, cost and useful life, the spreadsheet calculates monthly depreciation, the accumulated amount and the net book value at any date, and builds a monthly schedule for the year.

What is inside

"Settings": the calculation date, the schedule year and the fixed asset groups.
"Register": up to 300 assets — inventory number, group, in-service date, cost, useful life, disposal date, depreciation, net book value, wear and status.
"Depreciation sheet": depreciation for each asset for each month of the chosen year and the annual total.
"Summary": figures by group, accumulated depreciation and net book value, monthly charges and a chart.

Who it is for

Accountants and managers of small organizations, sole traders, facilities managers and anyone who needs working fixed asset records in a spreadsheet.

Compatibility

Excel 2007 and later, LibreOffice. No macros. Only the straight-line method is implemented. Useful lives and groups are set by the rules that apply to you; the calculation is indicative and does not replace accounting or tax records. The file is in English.

📘 Fixed Asset Register and Depreciation Schedule in Excel

Questions and answers

Which depreciation method is used?: Straight-line: the cost is divided by the useful life in months. Other methods, revaluation and bonus depreciation are not implemented.
From which month does depreciation start?: From the month after the in-service month, and it ends when the cost has been written off or in the month of disposal.
Where do I get the useful life from?: It is determined by the classification and accounting policy that apply to your organization. Check the data against your local rules before use; the calculation is indicative.
How do I see the net book value at another date?: Enter the date on the "Settings" sheet: accumulated depreciation, net book value and status are recalculated.