Fixed asset depreciation schedule: guide, example, and template

A depreciation schedule turns a fixed asset list into a time-based financial record. It shows the cost being depreciated, the method and life applied, the expense recognized through a chosen date, and the remaining net book value.

The difficult part is rarely the division. It is agreeing on which assets belong in the schedule, when depreciation begins, which useful life and salvage value apply, how partial periods work, and who reconciles changes to the accounting record.

This guide provides a copyable straight-line template and a worked example. It is designed for internal book-value planning and reconciliation. It is not a tax-depreciation calculator.

What is a depreciation schedule?

A fixed asset depreciation schedule is a table that carries each capitalized asset from its original recorded cost to its remaining book value over time. One row may hold the current calculation for an asset, while a supporting annual or monthly schedule shows how that value changes by period.

The schedule should let a reviewer answer five questions without reconstructing the math:

1. Which asset does this row describe?
2. What amount is being depreciated?
3. When did depreciation begin?
4. Which method, useful life, salvage value, and timing convention were used?
5. How does the resulting accumulated depreciation and net book value reconcile to the accounting record?

The asset register guide and template explains the broader operational record. A depreciation schedule is one financial view of that register, not a replacement for identity, custody, location, maintenance, and disposal history.

Straight-line depreciation formula

Straight-line depreciation allocates the depreciable amount evenly across the useful life selected for the asset.

Depreciable base = recorded cost − salvage value

Annual straight-line depreciation = depreciable base ÷ useful life in years

Net book value = recorded cost − accumulated depreciation

Net book value should not fall below the approved salvage value under this simplified method. If the cost is $18,000, the salvage value is $2,000, and the useful life is eight years, the calculation is:

After three complete years, accumulated depreciation is $6,000 and net book value is $12,000. The schedule stops at the $2,000 salvage value after eight complete years unless the accounting policy changes or an impairment, disposal, or correction requires different treatment.

Fields every fixed asset depreciation schedule needs

Use fields that make the calculation identifiable, repeatable, and reconcilable.

Do not substitute the purchase date automatically for the in-service date. The IRS likewise distinguishes acquisition from the point when property is ready and available for its specific use, although tax treatment then follows rules outside this template. See the current IRS depreciation topic and Publication 946 for the federal tax framework.

Copyable fixed asset depreciation schedule template

Copy this tab-separated block and paste it into cell A1 in Excel, Google Sheets, or another spreadsheet. The second row is a worked example. Replace it with an approved asset before extending the formulas down the schedule.

Asset ID	Asset name	Category	In-service date	Recorded cost	Salvage value	Useful life (years)	As-of date	Method	Depreciable base	Annual depreciation	Elapsed years	Accumulated depreciation	Net book value	Status	Accounting reference
AC-000184	Commercial mower	Grounds equipment	2023-01-01	18000	2000	8	2026-01-01	Straight line	=MAX(0,E2-F2)	=IF(G2>0,J2/G2,0)	=MAX(0,YEARFRAC(D2,H2,1))	=MIN(J2,K2*L2)	=MAX(F2,E2-M2)	In service	Fixed assets reconciliation

The formulas use an actual-day year fraction for the example. That makes the file easy to test, but it does not choose an accounting convention for you. Before using it for a close, replace the elapsed-time formula if your policy uses whole months, half months, mid-month, full-year, half-year, or another approved convention.

Format dates as dates, cost and value columns as currency, useful life and elapsed years as numbers, and the Asset ID as text. Keep input cells visibly different from formula cells so a reviewer can see which values were approved and which were calculated.

Optional annual roll-forward

For a simple annual schedule, create one column for each fiscal year and calculate depreciation consistently from the same approved inputs. The worked example becomes:

If the asset enters service partway through a fiscal year, the first and last rows depend on the approved timing convention. Record that convention next to the method rather than burying it inside a formula no one can explain later.

How to build the schedule step by step

1. Define the population

Start from the approved fixed asset register or general-ledger detail. Exclude land, consumables, items held for resale, and purchases expensed under the organization's capitalization policy. Investigate duplicates and assets without a stable identifier before calculating anything.

If the population still mixes equipment used in operations with resale stock or expensed tools, apply the current-versus-non-current equipment classification test before calculating depreciation.

The population should reconcile to the opening asset-cost balance. If it does not, record the difference and resolve it instead of adding an unexplained plug row.

2. Confirm recorded cost and in-service date

Trace cost to the accounting record and supporting evidence. The operational register may contain purchase price, delivery, installation, or other costs, but the accounting owner decides the amount capitalized.

Use the date the asset became ready and available for its intended use under the approved policy. Keep the acquisition date separately when it helps purchasing, warranty, or lifecycle analysis.

3. Apply useful life and salvage policy

Useful life should come from the organization's approved accounting policy or an authorized category mapping, not from a guess made while filling the row. Salvage value needs the same ownership.

Store the rule in a visible assumptions table when several assets share it:

The row above is an illustration, not a recommended life for every mower or equipment category.

4. Calculate the current period and accumulated amount

Calculate the depreciable base first, then annual or monthly expense, then the portion applicable through the as-of date. Keeping intermediate values visible makes errors easier to find than one long formula.

Cap accumulated depreciation at the depreciable base and net book value at the salvage value for the simplified straight-line schedule. Flag zero or negative lives, salvage values above cost, missing in-service dates, and disposed assets that still show current-period expense.

5. Reconcile the schedule

At each close or review date, reconcile at least these totals:

• opening asset cost plus additions, transfers, corrections, and disposals to closing asset cost;
• opening accumulated depreciation plus current expense, corrections, and removals to closing accumulated depreciation;
• closing asset cost less closing accumulated depreciation to closing net book value;
• schedule totals to the relevant general-ledger or accounting-system balances.

Explain timing differences and approved adjustments. A schedule that calculates perfectly but does not reconcile is not complete.

Book depreciation and tax depreciation are different jobs

The template above is intentionally narrow. It calculates a simple straight-line planning view from recorded cost, salvage value, useful life, and elapsed time.

Federal tax depreciation can involve MACRS recovery periods and conventions, Section 179, special depreciation allowances, listed-property rules, business-use tests, basis adjustments, and recapture. The IRS describes depreciation as recovering the cost of qualifying property over time and explains those rules in Topic 704 and Publication 946.

Do not use this schedule to prepare a tax return or select a tax treatment. Keep tax books, statutory books, and management views distinct when their methods or conventions differ, and have the accounting or tax owner approve the source of record for each.

Common depreciation schedule mistakes

Starting from the purchase date without checking service readiness

An asset may be purchased before installation, configuration, delivery, or another step makes it available for use. Retain both dates and apply the approved rule.

Letting category defaults replace review

A default useful life can make entry consistent, but it should not silently override an approved exception. Record who approved changes and when they take effect.

Continuing depreciation after disposal

Connect the schedule to retirement, sale, recycling, loss, or other disposal events. The physical asset audit guide provides count and discrepancy templates for finding records whose physical status no longer matches the register.

Mixing tax claims into an operational schedule

A straight-line report may help plan replacement and explain book-value context. It does not become tax software because it contains the word depreciation.

Overwriting prior-period values

Retain the close date, approved inputs, and resulting totals for each period. A reviewer should be able to reproduce last year's schedule without guessing which assumptions changed afterward.

How AssetCenter fits

AssetCenter's fixed asset management software records acquisition cost and date, category useful life, salvage value, straight-line depreciation, accumulated depreciation, net book value, asset age, and projected end-of-life dates beside the operating history.

That operating history includes the asset's identity, people and location assignments, files, maintenance, costs, events, and final disposition. It makes the depreciation number traceable to the item and its lifecycle rather than leaving it as a disconnected spreadsheet balance.

AssetCenter does not calculate MACRS, Section 179, special depreciation allowances, declining-balance methods, multi-book depreciation, tax returns, or journal entries. Keep those responsibilities with the accounting and tax systems designed for them.

If the current spreadsheet is also failing at assignments, documents, deadlines, or history, use the small-business fixed asset software guide to decide whether a maintained system is justified.

Next step: test one category and reconcile it

Copy the template and enter one representative asset category. Have the accounting owner approve the population, in-service rule, useful life, salvage value, timing convention, and source balances before extending the schedule.

Then perform one complete roll-forward and reconciliation. If another reviewer can reproduce the result, trace every total, and explain every exception, the schedule is ready to expand. If not, repair the definitions and ownership first; adding more rows will only multiply the ambiguity.

By Jeremy Francis

Founder & CEO, AssetCenter