Fixed asset depreciation schedule: guide, example, and template
Build a fixed asset depreciation schedule with cost, salvage value, useful life, annual expense, accumulated d...
Quick answer
Accumulated depreciation is the total depreciation recorded against an asset since it entered service. It is a contra-asset account: it sits with property and equipment but carries a credit balance that reduces their carrying amount. It is not a liability and not an expense.
Accumulated depreciation is the running total of depreciation recorded against an asset since it was placed in service. A laptop bought for $1,500 and depreciated by $500 a year carries $1,000 of accumulated depreciation after two years, leaving a carrying amount of $500.
The word accumulated is the key. Depreciation expense is the amount recognized in one period. Accumulated depreciation is every period's expense added together, held against the asset until the asset is sold, scrapped, or otherwise removed from the books.
This guide explains what kind of account it is, how to calculate it, and where it appears in the financial statements. It does not choose a depreciation method or tax treatment for a specific business.
Accumulated depreciation is a contra-asset account. It is reported in the asset section of the balance sheet, next to the property and equipment it relates to, but it works in the opposite direction:
So it is an asset-section account that lowers total assets rather than adding to them. That is why people search both "is accumulated depreciation an asset" and "is it a liability": it behaves like neither ordinary category.
| Question | Answer |
|---|---|
| What type of account is it? | A contra-asset account |
| Normal balance | Credit |
| Is it a liability? | No. It is not an amount the business owes anyone |
| Is it an expense? | No. The period's charge is depreciation expense; the running total is accumulated depreciation |
| Is it a current asset? | No. It belongs with the non-current property and equipment it reduces |
Under the straight-line method, the calculation has three steps:
Salvage value is the amount the business expects to recover at the end of the asset's useful life. Our salvage value guide covers how to estimate it.
A delivery van costs $42,000, has an estimated salvage value of $6,000, and a useful life of six years.
| End of year | Depreciation expense | Accumulated depreciation | Net book value |
|---|---|---|---|
| 1 | $6,000 | $6,000 | $36,000 |
| 2 | $6,000 | $12,000 | $30,000 |
| 3 | $6,000 | $18,000 | $24,000 |
| 4 | $6,000 | $24,000 | $18,000 |
| 5 | $6,000 | $30,000 | $12,000 |
| 6 | $6,000 | $36,000 | $6,000 |
At the end of year six, accumulated depreciation equals the depreciable base and net book value equals the salvage value. The Federal Reserve's own property and equipment accounting manual states the same end point: at the end of an asset's estimated useful life, its net book value should equal its salvage value and depreciation should stop.
Most assets are not bought on the first day of the year. Organizations adopt a convention for the first period, such as counting months in service or starting the month after the asset is placed in service. The Federal Reserve manual, for example, starts depreciation in the month following placement in service. Whatever convention you choose, apply it consistently and record it in the asset policy.
If the van above entered service on October 1, a monthly convention would record three months in year one: $6,000 × 3 ÷ 12 = $1,500 of accumulated depreciation at year end.
Accumulated depreciation is shown against the asset it relates to, usually within property, plant, and equipment:
| Property and equipment | Amount |
|---|---|
| Vehicles, at cost | $42,000 |
| Less: accumulated depreciation | ($12,000) |
| Vehicles, net | $30,000 |
Some statements show only the net figure on the face of the balance sheet and disclose cost and accumulated depreciation in a note. For companies filing with the SEC, Regulation S-X Rule 5-02 requires accumulated depreciation, depletion, and amortization of property, plant, and equipment to be set forth separately in the balance sheet or in a note.
The two are linked by one journal entry each period:
| Account | Debit | Credit |
|---|---|---|
| Depreciation expense | $6,000 | |
| Accumulated depreciation | $6,000 |
Depreciation expense appears on the income statement and resets every period. Accumulated depreciation appears on the balance sheet and keeps growing until the asset leaves the books. Depreciation is a non-cash charge: no money moves when the entry is made. The cash left when the asset was bought.
When an asset is disposed of, both its cost and its accumulated depreciation are removed from the books. Any difference between the proceeds and the net book value is recorded as a gain or loss on disposal.
If the van is sold for $14,000 at the end of year four, when its net book value is $18,000, the business removes $42,000 of cost and $24,000 of accumulated depreciation and records a $4,000 loss. Our asset disposal process and checklist covers the operational side: approvals, evidence, and closing the record without deleting its history.
A fully depreciated asset that is still in use stays on the books at its salvage value, with no further depreciation, until it is disposed of.
The schedule above is book depreciation: the figure used in the financial statements. Tax depreciation often follows different rules. In the US, IRS Publication 946 sets out the tax methods, including MACRS, and requires the tax basis of property to be reduced by the depreciation allowed or allowable. Publication 946 also notes that land is not depreciable.
Because book and tax depreciation can differ, many businesses keep two sets of accumulated depreciation figures for the same asset. Keep them clearly labeled, and let the accountant or tax preparer own the tax figures.
AssetCenter's fixed asset management software includes a straight-line depreciation report that shows, for every asset, the annual depreciation, accumulated depreciation, and net book value. Each asset's salvage value is subtracted before the cost is spread, so it never depreciates below that value, and the first year is prorated from the month of purchase. The report exports to Excel.
AssetCenter keeps the operational record behind those numbers: which asset it is, where it is, who has it, and when it was sold or retired. It does not calculate tax depreciation, post journal entries, or replace the general ledger.
A credit. It is a contra-asset account, so its normal balance is the opposite of the debit-balance asset accounts it reduces.
No. A liability is an amount owed to someone else. Accumulated depreciation is a reduction in the recorded value of assets the business owns.
No. Depreciation stops once the carrying amount reaches the salvage value, so accumulated depreciation can never exceed cost minus salvage value.
On the balance sheet within property and equipment, or in the notes to the financial statements. In an asset register or depreciation report, it is usually shown for each asset.
Pick one asset with a known cost, in-service date, useful life, and salvage value, and work through the formula above. Then use the fixed asset depreciation schedule guide to extend the same calculation to every asset and reconcile the total to the general ledger. If you are still deciding how equipment should be classified in the first place, start with is equipment a current asset?
Founder & CEO, AssetCenter
Build a fixed asset depreciation schedule with cost, salvage value, useful life, annual expense, accumulated d...
Salvage value is what a business expects to recover from an asset at the end of its useful life. Learn how to...
Operational equipment is a non-current asset. The exceptions are equipment held for resale, items expensed und...