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.

Example rows
AssetPlaced in serviceCostBusiness use %Method and lifeSection 179 or bonusPrior yearsThis yearBook value
Ford F-1502026-02-10$52,000.0090.0%5-yr MACRS$46,800.00$0.00$0.00$0.00
Laptops (3)2026-03-01$4,800.00100.0%De minimis$0.00$0.00$0.00$4,800.00
Shop equipment2024-07-15$18,000.00100.0%7-yr MACRS$0.00$5,508.00$2,186.00$10,306.00
Office furniture2023-05-01$6,500.00100.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 service
Questions

Still wondering?

Ask anything else on a free 30-minute call.

Book a call
What 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.

Get started

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.

Get a free quote

Your name, plus an email or a phone number, whichever you prefer.

A sentence or two is plenty. Please don't include Social Security numbers, bank or card numbers, or tax documents here.

Thanks. This is a design preview, so nothing was sent.