Template · Accounting
Fixed asset register and depreciation schedule
Straight-line, declining balance and sum-of-the-years'-digits depreciation for each asset, by fiscal year.
Downloads are included in the $19.85 yearly membership. Sign in
XLSXCSVODSXMLNumbers| Fixed asset register and depreciation schedule | |||||
| Example data — replace the blue input cells with your own. | |||||
| TOTAL COST | DEPRECIATION, REPORT YEAR | ACCUMULATED DEPRECIATION | NET BOOK VALUE | ||
| 396,050.00 | 48,801.78 | 236,898.15 | 159,151.85 | ||
| Report settings | |||||
| Fiscal year to report | 2026 | Calendar year. A full year of depreciation is taken in the year placed in service. | |||
| Register totals (all rows) | |||||
| Assets passing the input check | 12 | ||||
| Total cost | 396,050.00 | ||||
| Total salvage value | 24,100.00 | ||||
| Depreciation for the report year | 48,801.78 | ||||
| Accumulated depreciation at year end | 236,898.15 | ||||
| Net book value at year end | 159,151.85 |
Showing the first 16 of 30 rows and 6 of 6 columns. Cells with formulas show the formula on hover.
| Asset register | |||||||||||
| Inputs in blue. Columns I to M are formulas for the report year on the Summary tab. | |||||||||||
| Asset ID | Description | Category | In-service date | Cost | Salvage value | Life (years) | Method | Year of service | Depreciation, report year | Accumulated depreciation | Net book value |
| VAN-01 | Delivery van, cargo, unit 1 | Vehicles | Mar 15, 2024 | 42,500.00 | 6,000.00 | 5 | SL | 3 | 7,300.00 | 21,900.00 | 20,600.00 |
| CNC-01 | CNC router, 4 by 8 ft bed | Machinery | Jul 1, 2023 | 118,000.00 | 8,000.00 | 7 | DDB | 4 | 12,286.55 | 87,283.63 | 30,716.37 |
| LAP-26A | Laptop computers (4), lot 1 | Computer equipment | Jan 10, 2026 | 6,400.00 | 0.00 | 3 | SL | 1 | 2,133.33 | 2,133.33 | 4,266.67 |
| LAP-24B | Laptop computers (5), lot 2 | Computer equipment | Sep 3, 2024 | 8,250.00 | 0.00 | 3 | SYD | 3 | 1,375.00 | 8,250.00 | 0.00 |
| FUR-22A | Office furniture, reception area | Furniture and fixtures | Apr 20, 2022 | 14,800.00 | 1,000.00 | 7 | SL | 5 | 1,971.43 | 9,857.14 | 4,942.86 |
| FUR-25B | Office furniture, workshop office | Furniture and fixtures | Feb 12, 2025 | 9,600.00 | 500.00 | 7 | DDB | 2 | 1,959.18 | 4,702.04 | 4,897.96 |
| BLD-21A | Building improvements, roof and insulation | Building improvements | Jun 30, 2021 | 86,000.00 | 0.00 | 10 | SL | 6 | 8,600.00 | 51,600.00 | 34,400.00 |
| BLD-25B | Building improvements, office partitions | Building improvements | Oct 1, 2025 | 22,400.00 | 0.00 | 10 | SL | 2 | 2,240.00 | 4,480.00 | 17,920.00 |
| MCH-20A | Air compressor, 80 gallon | Machinery | Nov 16, 2020 | 4,900.00 | 300.00 | 7 | SYD | 7 | 164.29 | 4,600.00 | 300.00 |
| MCH-18B | Electric forklift | Machinery | May 2, 2018 | 27,500.00 | 2,500.00 | 8 | DDB | 9 | 0.00 | 25,000.00 | 2,500.00 |
| SRV-25A | Server and network equipment | Computer equipment | May 19, 2025 | 15,800.00 | 800.00 | 5 | DDB | 2 | 3,792.00 | 10,112.00 | 5,688.00 |
| VAN-26B | Delivery van, cargo, unit 2 | Vehicles | Aug 1, 2026 | 39,900.00 | 5,000.00 | 5 | SL | 1 | 6,980.00 | 6,980.00 | 32,920.00 |
Showing the first 16 of 65 rows and 12 of 14 columns. Cells with formulas show the formula on hover.
| Depreciation schedule by year | |||||||||||
| One row per register row. Years 1 to 10 of each asset's life; the row total must equal cost less salvage. | |||||||||||
| Depreciation by year of service (year 1 is the year placed in service) | |||||||||||
| Asset ID | Method | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| VAN-01 | SL | 7,300.00 | 7,300.00 | 7,300.00 | 7,300.00 | 7,300.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| CNC-01 | DDB | 33,714.29 | 24,081.63 | 17,201.17 | 12,286.55 | 8,776.11 | 6,970.13 | 6,970.13 | 0.00 | 0.00 | 0.00 |
| LAP-26A | SL | 2,133.33 | 2,133.33 | 2,133.33 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| LAP-24B | SYD | 4,125.00 | 2,750.00 | 1,375.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FUR-22A | SL | 1,971.43 | 1,971.43 | 1,971.43 | 1,971.43 | 1,971.43 | 1,971.43 | 1,971.43 | 0.00 | 0.00 | 0.00 |
| FUR-25B | DDB | 2,742.86 | 1,959.18 | 1,399.42 | 999.58 | 713.99 | 642.49 | 642.49 | 0.00 | 0.00 | 0.00 |
| BLD-21A | SL | 8,600.00 | 8,600.00 | 8,600.00 | 8,600.00 | 8,600.00 | 8,600.00 | 8,600.00 | 8,600.00 | 8,600.00 | 8,600.00 |
| BLD-25B | SL | 2,240.00 | 2,240.00 | 2,240.00 | 2,240.00 | 2,240.00 | 2,240.00 | 2,240.00 | 2,240.00 | 2,240.00 | 2,240.00 |
| MCH-20A | SYD | 1,150.00 | 985.71 | 821.43 | 657.14 | 492.86 | 328.57 | 164.29 | 0.00 | 0.00 | 0.00 |
| MCH-18B | DDB | 6,875.00 | 5,156.25 | 3,867.19 | 2,900.39 | 2,175.29 | 1,631.47 | 1,223.60 | 1,170.81 | 0.00 | 0.00 |
| SRV-25A | DDB | 6,320.00 | 3,792.00 | 2,275.20 | 1,365.12 | 1,247.68 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| VAN-26B | SL | 6,980.00 | 6,980.00 | 6,980.00 | 6,980.00 | 6,980.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Showing the first 16 of 65 rows and 12 of 15 columns. Cells with formulas show the formula on hover.
| Fixed asset register and depreciation schedule |
| Notes: what this workbook does, how to use it and the method behind it. |
| What it does |
| Keeps a fixed asset register and calculates depreciation for a chosen fiscal year. For each asset it shows the year of service, the depreciation for the report year, accumulated depreciation and net book value. The Schedule tab shows the a… |
| How to use it |
| 1. On the Summary tab, enter the fiscal year to report. |
| 2. On the Register tab, enter each asset's ID, description, category, in-service date, cost, salvage value, useful life in years (1 to 10) and method (SL, DDB or SYD). |
| 3. Read the Status and Input check columns. Fix any row that does not read OK. |
| 4. Read the totals and the by-category table on the Summary tab. The checks confirm that every asset depreciates to salvage over its life and that the categories add up to the register total. |
| 5. Add assets in the spare rows. The register holds 60 assets. |
| Formulas and method |
| Convention: a full year of depreciation in the year placed in service, and no mid-month or mid-year adjustment. Year of service = report year - year of in-service date + 1. |
| Straight-line (SL): (cost - salvage) / life, every year of the life. |
Showing the first 16 of 32 rows and 1 of 1 columns. Cells with formulas show the formula on hover.
What does this template do?
This workbook keeps a fixed asset register and calculates depreciation for a chosen fiscal year. Each asset has a cost, a salvage value, a useful life in years and a method: straight-line (SL), double-declining balance (DDB) or sum-of-the-years'-digits (SYD). For the report year, the Register tab shows the year of service, the depreciation, the accumulated depreciation and the net book value of each asset.
The Schedule tab computes the depreciation for years 1 to 10 of each asset's life. Straight-line uses (cost minus salvage) divided by the life. SYD uses the remaining life over the sum of the years. DDB takes twice the straight-line rate on the opening book value, and it switches to straight-line on the remaining depreciable amount when that charge is larger, so each asset reaches salvage at the end of its life. Each row total is checked against cost minus salvage. A full year of depreciation is taken in the year placed in service.
The example register holds 12 fictional assets, from a delivery van and a CNC router to laptops, office furniture, building improvements and an electric forklift.
What’s inside
- Straight-line, double-declining balance and sum-of-the-years'-digits methods for each asset
- Year of service, depreciation, accumulated depreciation and net book value for the report year
- Year-by-year schedule for years 1 to 10, with row totals checked against cost minus salvage
- DDB switches to straight-line so every asset reaches salvage at the end of its life
- Totals and a by-category table on the Summary tab, with input checks
Which tabs does the workbook have?
| Tab | What it holds |
|---|---|
| Summary | Fiscal year, totals, the by-category table and the checks. |
| Register | One row per asset with its inputs, year of service, depreciation and net book value. |
| Schedule | Annual depreciation for years 1 to 10 of each asset's life, with a row check. |
| Notes | Purpose, steps, formulas used, assumptions and limits. |
What formulas does this template use?
This template holds 1,320 formulas in 1,512 cells across 4 tabs, so 87% of its cells calculate. They use 17 distinct functions; the longest formula is 404 characters and 1,113 of them read from another tab.
| Function | Uses | What it does |
|---|---|---|
IF | 3,903 | one result when a test is true, another when false |
SUM | 1,707 | adds numbers |
MAX | 1,260 | largest value |
MIN | 660 | smallest value |
ISNUMBER | 240 | true for a number |
NOT | 240 | reverses true and false |
SUMPRODUCT | 62 | multiplies matching entries, then adds them |
ABS | 61 | absolute value |
AND | 60 | true when every test is true |
COUNTA | 60 | counts non-empty cells |
INDEX | 60 | value at a position in a range |
OR | 60 | true when any test is true |
The 12 most used of 17 functions. Counted from the workbook itself. Only functions that Excel, LibreOffice Calc, Google Sheets and Apple Numbers evaluate the same way are used, so the formulas survive every download format.
How do you use it?
- On the Summary tab, enter the fiscal year to report.
- On the Register tab, enter each asset's cost, salvage value, in-service date, useful life and method.
- Read the Input check and Status columns, and fix any row that does not read OK.
- Read the totals and the by-category table on the Summary tab.
- Confirm the check cells read OK.
What is it good for?
- Depreciation schedule for a small business's equipment and vehicles
- Book depreciation for a year-end close
- Checking net book value before selling or replacing an asset
- Planning depreciation by category for a budget
Questions about this sheet
Is the first year a full year of depreciation?
Yes. The workbook takes a full year in the year placed in service and does not apply a mid-month or mid-year convention.
Why does a DDB asset switch to straight-line?
Declining balance alone never reaches salvage. Switching to straight-line on the remaining amount when it gives the larger charge brings the book value to salvage at the end of the life.
Can an asset have a life longer than 10 years?
Not in this schedule. Assets with a life above 10 years fail the input check and are left out of the totals until the schedule is extended.
Does it calculate tax depreciation?
No. The workbook calculates book depreciation. Tax methods such as MACRS and bonus depreciation are not modeled.