Excel Depreciation Tax Schedule: 100% Bonus for 2026

Introduction

A working excel depreciation tax schedule helps business owners support each fixed-asset deduction before amounts flow to Form 4562.

An excel depreciation tax schedule is a working worksheet that tracks each business asset’s cost, placed-in-service date, recovery period, convention, and current-year deduction so the amounts flow correctly to Form 4562. IRS guidance says taxpayers generally depreciate business property over several years using depreciation schedules, while the One, Big, Beautiful Bill provides a permanent 100% additional first-year depreciation deduction for qualified property acquired after January 19, 2025 (IRS Notice 2026-11). By Adham Abadier, CPA — Licensed in California, License #158599.

Key Takeaways

• The IRS says taxpayers generally must depreciate capital property used in a trade or business or income-producing activity over several years rather than deducting the entire cost in one year (IRS Topic 704).
• Notice 2026-11 provides guidance on the permanent 100% additional first-year depreciation deduction for eligible depreciable property acquired after January 19, 2025 (IRS).
• For qualified property placed in service after December 31, 2024, and before January 20, 2025, the special depreciation allowance is 40%, or 60% for long-production-period property and certain aircraft (IRS Topic 704).
• The special depreciation allowance is taken after any allowable Section 179 deduction and before any other depreciation is allowed (IRS Topic 704).
• Property placed in service after 1986 generally must use the Modified Accelerated Cost Recovery System (MACRS); property placed in service before 1987 generally uses ACRS or the prior method (IRS Topic 704).
• Land is never depreciable, and property held for personal purposes cannot be depreciated; mixed-use property is depreciated only for the business or investment use portion (IRS Topic 704).
• Notice 2026-11 allows taxpayers to generally rely on existing additional first-year depreciation regulations as interim guidance (IRS).

Main Content: Excel Depreciation Tax Schedule

Why an Excel Depreciation Tax Schedule Belongs in Every Business File

When a Moreno Valley contractor buys equipment, a Riverside retailer installs shelving, or an Inland Empire professional buys computers, the tax treatment does not always match the bookkeeping entry. The IRS explains that capital expenditures generally cannot be fully deducted in one year; instead, the cost is recovered over a number of years by deducting part of the cost annually until the cost is recovered (IRS Topic 704). That multi-year recovery is why a separate business asset schedule is useful: it preserves the facts needed to support each deduction when the return is prepared.

A tax depreciation spreadsheet is bookkeeping-adjacent. It starts with transaction-level detail from the general ledger and converts that detail into tax-position data. If asset additions are not captured cleanly during the year, the year-end tax schedule becomes a reconstruction project. For business owners who want asset additions identified as they occur, monthly bookkeeping creates the clean source data needed before depreciation rules are applied.

What the schedule should prove

The IRS says depreciable property generally must meet several requirements: it must be owned by the taxpayer, used in a business or income-producing activity, have a determinable useful life, be expected to last more than one year, and not be excepted property (IRS Topic 704). Excepted property includes certain intangible property, certain term interests, equipment used to build capital improvements, and property placed in service and disposed of in the same year (IRS Topic 704).

Your Excel file should therefore include columns that answer those questions, not merely columns for cost and deduction. A practical minimum includes:

• Asset description and asset class (machinery, equipment, building, vehicle, furniture, or land improvement).
• Business-use percentage, because only the business or investment use portion can be depreciated when property is mixed-use (IRS Topic 704).
• Date acquired and date placed in service.
• Cost basis and any Section 179 election applied before bonus depreciation (IRS Topic 704).
• Special depreciation allowance, if applicable.
• MACRS or ACRS system, recovery period, convention, method, current-year deduction, accumulated depreciation, and adjusted basis.
• Disposition date and disposition details when the asset is sold, abandoned, or otherwise retired.

Why the placed-in-service date matters

The placed-in-service date can determine which first-year rule applies. IRS Topic 704 distinguishes qualified property placed in service after December 31, 2024, and before January 20, 2025 from qualified property acquired and placed in service after January 19, 2025 (IRS Topic 704). Notice 2026-11 similarly frames the permanent additional first-year deduction around property acquired after January 19, 2025 (IRS). If your schedule does not record acquisition and placed-in-service dates separately, you cannot test the correct rule at year-end.

The 2026 Depreciation Rules That Belong in Your Excel Depreciation Tax Columns

The schedule should separate ordinary depreciation from the special first-year rules. Three layers matter most for current-year planning: Section 179, the special depreciation allowance, and MACRS depreciation.

Section 179 depreciation comes first

The IRS says a taxpayer may elect under Section 179 to recover all or part of the cost of qualifying property, up to a determinable dollar limit, in the taxable year the property is placed in service. The total cost deductible after applying the dollar limit is limited to taxable income from the active conduct of any trade or business during the year (IRS Topic 704). Section 179 may also apply to qualified real property, including qualified improvement property and certain improvements to nonresidential real property placed in service after the building was first placed in service: roofs; heating, ventilation, and air-conditioning property; fire protection and alarm systems; and security systems (IRS Topic 704).

Bonus depreciation after January 19, 2025

Notice 2026-11 provides guidance on the permanent 100% additional first-year depreciation deduction under the One, Big, Beautiful Bill for eligible depreciable property acquired after January 19, 2025 (IRS). IRS Topic 704 states that for qualified property acquired and placed in service after January 19, 2025, the special depreciation allowance is 100%, and that the allowance is taken after any allowable Section 179 deduction and before any other depreciation is allowed (IRS Topic 704).

For the short window involving property placed in service after December 31, 2024, and before January 20, 2025, the special depreciation allowance is 40%, or 60% for long-production-period property and certain aircraft (IRS Topic 704). Notice 2026-11 also permits a taxpayer to elect to deduct 40%—60% for certain property having longer production periods or certain aircraft—instead of the 100% additional first-year depreciation deduction for qualified property placed in service during the first tax year ending after January 19, 2025 (IRS).

MACRS depreciation schedule and older systems

For property placed in service after 1986, the IRS says taxpayers generally must use MACRS. For property placed in service before 1987, taxpayers generally must use ACRS or the same method used in the past (IRS Topic 704). Older assets still appear on schedules for rental properties and long-lived buildings, so the Excel file should identify the system rather than assume one method for every row.

Asset list scattered across QuickBooks, invoices, and last year’s return? Adham reviews your fixed-asset register, placed-in-service dates, Section 179 and bonus layers, and Form 4562 flow before the next filing deadline.
📞 (951) 223-1826  |  Book a free 30-min diagnostic →

Building the Excel Depreciation Tax Workbook: Column Map and Process

The following structure works for most small-business schedules. It is intentionally conservative: every column exists because a tax rule or filing detail depends on it.

Step-by-step workflow

1. Import additions and disposals. Pull fixed-asset additions from the general ledger each quarter. Flag any asset placed in service and disposed of in the same year because the IRS identifies that as excepted property (IRS Topic 704).
2. Confirm depreciable status. Remove land, personal-use assets, and assets that fail the ownership, business-use, useful-life, or one-year requirements (IRS Topic 704).
3. Apply Section 179. Record any Section 179 election and test the active-trade-or-business taxable income limitation (IRS Topic 704).
4. Apply the special depreciation allowance. Determine whether the asset is qualified property and whether it falls under the 40%/60% window or the 100% rule for property acquired and placed in service after January 19, 2025 (IRS Topic 704). Review any election under Notice 2026-11 to take 40% or 60% instead of 100% for the first tax year ending after January 19, 2025 (IRS).
5. Compute remaining MACRS depreciation. Use the recovery period, convention, and method appropriate for the asset. For property placed in service after 1986, MACRS is generally required (IRS Topic 704).
6. Roll balances forward. Current-year depreciation becomes part of accumulated depreciation; adjusted basis carries to the next year.
7. Map to the return. Tie the schedule to Form 4562 and to the applicable business return, including Form 1120-S or Form 1065 where applicable.

Illustrative non-numeric scenario

A Corona landscaping company purchases machinery during the year and places it in service after January 19, 2025. The worksheet first records cost and placed-in-service date. If the machinery qualifies, the 100% special depreciation allowance may be applied after any allowable Section 179 deduction and before other depreciation (IRS Topic 704). If the company instead acquired an asset in early January 2025 and placed it in service before January 20, 2025, the worksheet would test the 40% or 60% allowance for that window (IRS Topic 704). No dollar result is assumed because the deduction depends on cost, eligibility, elections, taxable income limitations, and other facts.

Common Excel Depreciation Tax Mistakes That Create Return Errors

Most tax depreciation spreadsheet errors are not formula errors; they are classification errors. The following issues appear frequently in small-business files.

Depreciating land or personal-use property

The IRS states that land is never depreciable, although buildings and certain land improvements may be depreciable. Property held for personal purposes cannot be depreciated, and mixed-use property is depreciable only for the business or investment use portion (IRS Topic 704). An Excel schedule should separate land from land improvements and require a business-use percentage.

Confusing placed-in-service dates with purchase dates

The 2025 transition dates are precise. Qualified property placed in service after December 31, 2024, and before January 20, 2025 uses one allowance rule, while qualified property acquired and placed in service after January 19, 2025 uses the 100% rule (IRS Topic 704). Notice 2026-11 also discusses specified plants that are planted or grafted after January 19, 2025 (IRS). A single date column is not enough if acquisition and placed-in-service occur in different periods.

Skipping listed-property notes

IRS Topic 704 notes that there are special rules and limits for depreciation of listed property, including automobiles, but computers and related peripheral equipment are not included as listed property (IRS Topic 704). The schedule should flag vehicles separately so those special rules are reviewed.

Forgetting method-change documentation

Treasury guidance distinguishes changes in method of accounting from changes in useful life where the useful life is not specifically assigned by the Code, regulations, or other published guidance. A change in the period of recovery specifically assigned by the Code, regulations, or published guidance is a change in method of accounting, and a change in depreciation method or convention is also a change in method of accounting (U.S. Treasury). Treasury also issued a revenue procedure permitting a taxpayer to change its method of determining depreciation after disposition of depreciable property in certain circumstances so that less-than-allowable depreciation is not permanently lost (U.S. Treasury). Keep a note column in Excel whenever a method, convention, or recovery-period correction is made.

How the Excel Depreciation Tax Schedule Flows to Business Returns

The schedule is not a substitute for the return; it is the support behind it. For sole proprietors and single-member LLCs, depreciation generally supports the applicable individual return and related business schedules. For partnerships and S-corporations, the schedule supports entity-level depreciation on business tax returns before amounts pass through to owners. The 2026 filing calendar makes this especially important: calendar-year S-corporation Form 1120-S and partnership Form 1065 returns on extension are due September 15, 2026, and the late-filing penalty is $255 per shareholder or partner per month under §§ 6699 and 6698 (IRS).

Before filing, reconcile the Excel schedule to three sources: the general ledger fixed-asset account, prior-year depreciation carryforward, and the current-year return forms. If the schedule includes Section 179 or special depreciation allowance rows, confirm the ordering rule from IRS Topic 704: Section 179 first, then the special allowance, then other depreciation (IRS Topic 704).

Mid-CTA

If your fixed-asset list is scattered, a brief diagnostic review can identify missing placed-in-service dates, Section 179 elections, and bonus depreciation layers before the next filing deadline.

Frequently Asked Questions

What is an excel depreciation tax schedule?

It is a spreadsheet that tracks each business asset’s cost, acquisition date, placed-in-service date, business-use percentage, recovery details, and annual depreciation deduction. The IRS says capital business property generally must be depreciated over several years rather than deducted all at once (IRS Topic 704).

What bonus depreciation applies to property acquired after January 19, 2025?

The OBBB provides a permanent 100% additional first-year depreciation deduction for qualified property acquired after January 19, 2025, and Notice 2026-11 provides guidance on eligibility and amount (IRS). IRS Topic 704 also says the allowance is taken after any allowable Section 179 deduction and before other depreciation (IRS Topic 704).

What rule applies to qualified property placed in service before January 20, 2025?

For qualified property placed in service after December 31, 2024, and before January 20, 2025, the special depreciation allowance is 40%, or 60% for long-production-period property and certain aircraft (IRS Topic 704).

Can I depreciate land or personal-use property in Excel?

No. The IRS says land is never depreciable, although buildings and certain land improvements may be. You also cannot depreciate property held for personal purposes; if property is mixed-use, only the business or investment portion is depreciable (IRS Topic 704).

Should I use MACRS or ACRS?

Generally, property placed in service after 1986 must use MACRS. Property placed in service before 1987 generally uses ACRS or the method used in the past (IRS Topic 704).

What elections does Notice 2026-11 discuss?

Notice 2026-11 discusses interim guidance on elections including electing 40% (60% for certain longer-production-period property or certain aircraft) instead of 100% for qualified property placed in service during the first tax year ending after January 19, 2025, electing additional first-year depreciation for specified plants, treating certain components of larger self-constructed property as eligible, and not deducting additional first-year depreciation for a qualified sound recording production (IRS).

When are calendar-year Form 1120-S and Form 1065 extension returns due in 2026?

They are due September 15, 2026. The late-filing penalty for Forms 1120-S and 1065 is $255 per shareholder or partner per month under §§ 6699 and 6698 (IRS).

Get Help With Your Excel Depreciation Tax Schedule

A disciplined excel depreciation tax schedule turns fixed-asset records into defensible tax positions. It captures the facts the IRS requires—ownership, business use, determinable useful life, more-than-one-year life, and non-excepted status—and separates Section 179, bonus depreciation 2026, and MACRS layers in the correct order (IRS Topic 704). With Notice 2026-11 confirming interim reliance on existing additional first-year depreciation rules, businesses should make sure their schedules reflect the January 19, 2025 transition and any applicable elections (IRS).

Catalyst CPA Corporation provides small business depreciation help in Moreno Valley, Riverside, Corona, Eastvale, Murrieta, Temecula, Ontario, San Bernardino, Fontana, Orange County, the Inland Empire, and remotely nationwide. If you need Moreno Valley business tax support, Riverside fixed-asset review, or Inland Empire bookkeeping before a Form 1120-S, Form 1065, or individual return is filed, business tax and depreciation planning can identify missing dates, misclassified land, unsupported elections, and reconciliation gaps. For broader support, explore our CPA services. Call (951) 223-1826 or email adham@catalyst-cpa.com.

About the Author

By Adham Abadier, CPA — California CPA License #158599 — QuickBooks Gold ProAdvisor.

Adham helps Moreno Valley and Inland Empire small-business owners build clean depreciation schedules and defensible return positions. He focuses on practical fixed-asset, bookkeeping, and business-tax support for local and remote clients.

Phone: (951) 223-1826 | Email: adham@catalyst-cpa.com | Address: 13114 Yellowwood St, Moreno Valley, CA 92553 | Meet our team

Disclaimer

This article is general information, not tax, legal, or accounting advice. Facts and elections vary; consult a qualified professional about your situation.