Depreciation Excel Templates

Professional accounting spreadsheets with pre-built formulas for depreciation schedules, asset tracking, and tax planning.

Templates will reflect current IRS tax law (OBBBA)

Our Excel templates are being designed by accounting professionals and will include all the formulas needed to generate depreciation schedules offline. Each template will reflect the latest IRS rates and limits, including the OBBBA rules — 100% bonus depreciation restored and a Section 179 limit of $2,560,000 for 2026.

While our templates are being finalized, you can use our online calculators for instant results with the same accuracy and export capabilities.

Straight-Line Depreciation Schedule

Coming Soon

Track asset depreciation using the straight-line method. Includes columns for asset name, cost, salvage value, useful life, annual depreciation, and accumulated depreciation. Pre-formatted with formulas.

Template Features

Automatic annual depreciation calculation
Year-by-year schedule with book value tracking
Support for partial-year (mid-month/mid-quarter) start
Summary dashboard with totals

Best For

GAAP financial reporting, simple asset tracking

MACRS Depreciation Schedule (GDS)

Coming Soon

Complete IRS MACRS depreciation worksheet that will include GDS rate tables for all property classes (3, 5, 7, 10, 15, 20, 27.5, and 39-year), reflecting current IRS limits and the OBBBA 100% bonus depreciation rules.

Template Features

IRS percentage tables (half-year & mid-quarter)
Bonus depreciation toggle (100% restored under OBBBA)
Section 179 deduction integration ($2,560,000 limit for 2026)
Automatic convention selection

Best For

US federal tax returns, IRS compliance

Car & Vehicle Depreciation Tracker

Coming Soon

Specialized vehicle depreciation spreadsheet that will reflect current-year Section 280F luxury auto limits. Tracks both tax depreciation and estimated market value decline over time.

Template Features

Reflects current IRS Section 280F luxury auto limits
Business vs personal use percentage split
Market value comparison column
SUV Section 179 deduction ($32,000 cap for 2026)

Best For

Business vehicle tax deductions, fleet management

Rental Property Depreciation Worksheet

Coming Soon

Real estate depreciation template for residential (27.5-year) and commercial (39-year) rental properties. Includes land/building separation and cost segregation tracking.

Template Features

Automatic land vs building value allocation
Mid-month convention for real property
Cost segregation component tracking (5/7/15-year items)
Depreciation recapture estimate on sale

Best For

Rental property investors, real estate tax planning

Multi-Asset Register & Schedule

Coming Soon

Comprehensive fixed asset register for managing a portfolio of assets. Supports multiple depreciation methods per asset with consolidated reporting and disposal tracking.

Template Features

Unlimited assets with individual settings
Mixed methods (MACRS, SL, DB) in one workbook
Asset disposal and gain/loss calculation
Monthly and annual summary reports

Best For

Accounting teams, multi-asset businesses

Templates Launching Soon

We are finalizing our template library with current IRS tax data and OBBBA updates. In the meantime, use our free online calculators for instant depreciation schedules with PDF export.

Browse All Calculators →