Depreciation Excel Templates

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

All templates updated for 2025 tax law (OBBBA)

Our Excel templates are designed by accounting professionals and include all the formulas you need to generate depreciation schedules offline. Each template is pre-loaded with the latest IRS rates and limits, including the 2025 OBBBA changes — 100% bonus depreciation restored and Section 179 limit doubled to $2,500,000.

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 with built-in GDS rate tables for all property classes (3, 5, 7, 10, 15, 20, 27.5, and 39-year). Updated for 2025 with OBBBA 100% bonus depreciation.

Template Features

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

Best For

US federal tax returns, IRS compliance

Car & Vehicle Depreciation Tracker

Coming Soon

Specialized vehicle depreciation spreadsheet with Section 280F luxury auto limits for 2025. Tracks both tax depreciation and estimated market value decline over time.

Template Features

2025 Section 280F limits pre-loaded ($20,200/$12,200 Year 1)
Business vs personal use percentage split
Market value comparison column
SUV Section 179 deduction ($31,300 cap)

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 2025 tax data and OBBBA updates. In the meantime, use our free online calculators for instant depreciation schedules with PDF export.

Browse All Calculators →