Depreciation schedule template
A depreciation schedule lists every business asset with its cost, the date you started using it, the method and life, and how much you've written off so far. This free template keeps the book value of each asset, so your balance sheet, Form 4562 and any gain when you sell all agree.
Updated November 2026
What does the template look like?
Type one row per entry. Totals add themselves in Excel. Here it is with sample figures, so you can see how it fills in.
| Asset | Placed in service | Cost | Business use % | Method and life | Section 179 or bonus | Prior years | This year | Book value |
|---|---|---|---|---|---|---|---|---|
| Ford F-150 | 2026-02-10 | $52,000.00 | 90.0% | 5-yr MACRS | $46,800.00 | $0.00 | $0.00 | $0.00 |
| Laptops (3) | 2026-03-01 | $4,800.00 | 100.0% | De minimis | $0.00 | $0.00 | $0.00 | $4,800.00 |
| Shop equipment | 2024-07-15 | $18,000.00 | 100.0% | 7-yr MACRS | $0.00 | $5,508.00 | $2,186.00 | $10,306.00 |
| Office furniture | 2023-05-01 | $6,500.00 | 100.0% | 7-yr MACRS | $0.00 | $3,375.00 | $812.00 | $2,313.00 |
| Total | $81,300.00 | $46,800.00 | $8,883.00 | $2,998.00 | $17,419.00 |
What goes on a depreciation schedule?
Every asset that lasts more than a year and costs more than your expensing policy: vehicles, equipment, computers, furniture, improvements to a building you own or rent. For each one, the date placed in service, cost, business-use share, method and life, any Section 179 or bonus amount, and depreciation taken each year. It's the record behind Form 4562.
What changed for 2026?
The 2025 tax law made 100% bonus depreciation permanent for property acquired after January 19, 2025, and raised the Section 179 limit to $2,560,000 for 2026. So many small businesses can write off equipment in the year they buy it. That isn't always the best choice, since a big write-off in a low-income year can waste deductions. We look at it in tax planning.
Why keep it after the write-off?
Because the asset is still there. When you sell it, the depreciation you took is usually taxed back as ordinary income. Without the schedule, nobody knows the basis, and you may pay more tax than you should.
Sources
General information, not tax advice for your situation.
Want your business return done?
One fixed price, agreed before we start.
See our business tax returns serviceWhat is the de minimis safe harbor?
An election to expense items up to $2,500 each (or $5,000 with audited financial statements) instead of depreciating them.
Can I depreciate a vehicle used partly for personal trips?
Only the business-use share, and passenger vehicles have yearly limits. Keep a mileage log to prove the share.
Does depreciation affect my balance sheet?
Yes. Accumulated depreciation lowers the book value of your assets each year.
Tell us what's messy. We'll tell you what it takes.
Tell us what you need and get a fixed price before any work starts. No pressure and no contract.