Asset & Lifecycle · Excel template
Free Fleet Depreciation Schedule Template
A depreciation schedule that tracks each vehicle's book value year by year — purchase cost, method, annual depreciation, and remaining value — so your fleet's accounting and remarketing decisions rest on real numbers.
Built and reviewed by the FleetOpsClub research team. Preview it free below. Enter your name and email to unlock the full template and the editable spreadsheet — a CSV that opens in Excel, Google Sheets, or Numbers.
- Editable CSV — yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
What you get
- A row per vehicle with purchase cost, in-service date, and useful life
- Annual depreciation and accumulated depreciation columns
- Current book value and estimated salvage value
- Support for straight-line and a placeholder for accelerated methods
- A worked example showing a vehicle across several years of its life
How to use it
- 1
Enter each vehicle's purchase cost, in-service date, estimated useful life, and salvage value.
- 2
Choose a depreciation method consistent with your accounting policy — straight-line is simplest; tax methods like MACRS differ.
- 3
Let the schedule compute annual and accumulated depreciation and the resulting book value.
- 4
Compare book value to estimated market value when planning disposals and remarketing.
- 5
Review annually and adjust useful life or salvage estimates if usage or resale conditions change.
Preview the template
Here's a real sample of the layout — the actual columns and structure you'll work in. The complete template, plus the editable spreadsheet, unlocks the moment you enter your email.
Preview
Fleet Depreciation Schedule Template
Depreciation method and useful-life assumptions are accounting and tax decisions — defer to your accountant and current tax rules. The figures shown are illustrative straight-line values.
| Unit # | Purchase Cost | In-Service Date | Useful Life (yrs) | Method | Annual Deprec. | Accum. Deprec. | Book Value | Salvage Est. |
|---|---|---|---|---|---|---|---|---|
| VAN-014 | $48,200 | 2023-06-01 | 7 | Straight-line | $5,743 | $17,229 | $30,971 | $8,000 |
| PKP-022 | $52,900 | 2024-08-20 | 7 | Straight-line | $6,414 | $12,828 | $40,072 | $8,000 |
Free unlock
Unlock the full template
Enter your name and email to reveal the complete template and download the editable spreadsheet. You can print it, save it as a PDF, or adapt the columns to your own vehicles. It's a fair trade: the preview costs nothing, and the full file costs you about 20 seconds.
- Editable CSV
- Every row & section
- Branded PDF
Frequently asked questions
Quick answers to the questions buyers usually ask once the category, software, or rollout details start getting more specific.
It depends on whether you are reporting for books or tax and on your accounting policy. Straight-line spreads cost evenly and is simplest for management reporting; tax depreciation often uses accelerated methods such as MACRS. Always defer to your accountant and current tax rules.
Book value is the accounting figure after depreciation; market value is what the vehicle would actually sell for. They rarely match. Comparing the two at disposal time tells you whether you are selling above or below carrying value.
Base useful life on how long you realistically operate that class of vehicle, and salvage on recent remarketing results for similar units. Both are estimates — revisit them as resale conditions and usage patterns shift.
Depreciation gives the financial side of the lifecycle picture, while a replacement tracker handles the operational timing. Used together, you can align the accounting wind-down with the operational decision to retire and replace a unit.
Related guides & tools
- Fleet asset register template
- Vehicle replacement tracker template
- Fleet maintenance cost calculator
- Fleet maintenance category
Looking for more? Browse all fleet templates or run a fleet calculator.