Excel Depreciation: Build a Rental Schedule for 2026

An “excel depreciation” real estate spreadsheet is only as reliable as the IRS rules underneath it. Get the recovery period, convention, or land exclusion wrong, and every future year inherits the error. This guide gives rental owners a build-from-scratch blueprint grounded in IRS Publication 946 — plus a major 2026 law change that can turn a 39-year write-off into a single first-year deduction for certain property. It is the same framework we apply in our rental property accounting setup for real estate investors across the Inland Empire.

By Adham Abadier, CPA — Licensed in California, License #158599. QuickBooks Gold ProAdvisor, AICPA member, and California Society of CPAs (CalCPA) member, serving Moreno Valley, Riverside, Corona, Eastvale, Murrieta, Temecula, Ontario, San Bernardino, and remote clients nationwide.

Direct answer: To build a correct real estate depreciation schedule in Excel, subtract land from your cost basis, apply the MACRS straight-line method over 27.5 years (residential rental) or 39 years (nonresidential), and prorate the first and last years by the placed-in-service month under the mid-month convention. Publication 946’s MACRS worksheet uses the identical basis-times-rate structure your formulas should mirror.

How the IRS Computes Real Estate Depreciation

Three gating questions and three inputs

Publication 946 gates depreciation on ownership, use in a business or income-producing activity, and a determinable useful life lasting more than one year. Land fails outright — it appears under property that cannot be depreciated. Once a rental qualifies, every calculation runs on three inputs: cost basis (generally the purchase price plus certain other expenses, minus land), the placed-in-service date (when the property is ready to rent, which also controls first-year proration), and the IRS-assigned recovery period. The overall system is the Modified Accelerated Cost Recovery System (MACRS), which includes the general depreciation system (GDS) and the alternative depreciation system (ADS), each with different recovery periods and methods. For residential and nonresidential real property, MACRS prescribes straight-line because even expense distribution suits long-lived buildings.

Recovery periods as summarized by the REI Grove real estate depreciation spreadsheet, consistent with the framework in Publication 946.

The IRS worksheet math your formulas should copy

Publication 946’s MACRS worksheet flows in four moves: start with basis (line 11); multiply by the applicable percentage for any special depreciation allowance (line 12 — enter -0- when none applies); subtract to get the basis for depreciation (line 13); then multiply by the depreciation rate (line 14) to get the MACRS deduction (line 15). The publication’s own example multiplies a $10,000 basis by a 0.1429 rate and arrives at a $1,429 deduction. If your spreadsheet reproduces that structure — basis, special allowance, remaining basis, rate, deduction — it will agree with professional tax software. One more checkpoint: Publication 946 includes a section on whether you must file Form 4562, which is where depreciation is reported; confirm your filing obligation each year.

Build Your “Excel Depreciation” Real Estate Schedule Step by Step

The layout below mirrors both the IRS worksheet and the six-section structure used in the REI Grove template (property information, asset type, cost basis, placed-in-service date, annual schedule, and reference data with IRS monthly depreciation rates):

1. Property information. Name and address, so the schedule stays tied to the right rental and reads cleanly at tax time.
2. Asset type. Residential or commercial — this one field selects the 27.5- or 39-year recovery period.
3. Cost basis block. Separate cells for purchase price, land value, and depreciable closing costs; a formula cell computes depreciable basis = purchase price + depreciable closing costs − land value.
4. Placed-in-service date. Depreciation begins here, and the month drives the mid-month proration.
5. Annual schedule. Full-year deduction = basis ÷ recovery period. Prorate the first and last years using the IRS monthly depreciation rates from your reference tab rather than taking a full year.
6. Running total and review flag. Sum total depreciation cost across the schedule, and note that accelerated methods, safe harbors, and specific IRS regulations warrant a tax professional’s review.

A supported worked example

Assume you buy a Riverside County residential rental. After adding depreciable closing costs to the price and subtracting land value, your depreciable basis is $220,000. The full-year straight-line deduction is:

$220,000 ÷ 27.5 years = $8,000 per full year

That equals roughly 1/27.5 of the basis annually, as straight-line prescribes. Your first and last years will be smaller because they vary based on the month the property was placed in service — use the IRS monthly rate for that month. If you model a commercial building instead, the same logic divides basis by 39.

Build in a special-allowance row now

Give every asset two rows — one for a special depreciation allowance, one for regular MACRS — exactly as lines 12 through 15 do. That design future-proofs the sheet for the 2026 allowance covered below and for personal property (appliances, furniture, equipment) where accelerated methods may apply.

One wrong cell — a land value left in basis, a 39-year formula on a residential rental — compounds for every year you hold the property. Adham will personally audit your spreadsheet’s basis, dates, and rates so the schedule you file is the schedule the IRS worksheet produces.
📞 (951) 223-1826  |  Book a free 30-min diagnostic →

Spreadsheet Mistakes That Become Accounting-Method Problems

Editing the formula is not a fix

Per Treasury and IRS depreciation guidance, a change in depreciation method or convention is a change in method of accounting, and so is a change in a recovery period specifically assigned by the Code, regulations, or other published guidance. A change in useful life that is not specifically assigned is not a method change. So if your sheet used the wrong recovery period for years, correction follows Publication 946’s accounting-method-change path — IRS approval and a Section 481(a) adjustment — or an amended return where timing allows, not a quiet cell edit.

Missed years are recoverable — even after a sale

The same Treasury guidance confirms that a taxpayer who claimed less than the depreciation allowable may change methods to claim the full amount, and the accompanying revenue procedure permits that change even after disposition of the property, so the allowable deduction is no longer permanently lost. This matters because Publication 946 adjusts basis for depreciation allowed or allowable — skipping a deduction does not protect basis at sale. Whether an amended return or a method change fits depends on the years involved; that is a CPA judgment call. And none of it works if the underlying books are unreliable — investors who have fallen behind usually need catch-up bookkeeping before the depreciation schedule itself can be trusted.

Recapture makes the schedule a permanent record

Depreciation recapture taxes the portion of your sale profit attributable to the deductions you took, though a 1031 like-kind exchange can delay recognition further. Keep the schedule, totals, and placed-in-service documentation for the entire holding period. Also flag related strategies in your model: cost segregation can move components into shorter recovery periods (separating a swimming pool from the building), the De Minimis Safe Harbor allows fully deducting property under its $2,500 cap, bonus depreciation applies to personal property, and Section 179 expensing exists under its own election rules in Publication 946.

2026 Update: The 100% Special Allowance for Qualified Production Property

As of July 2026, the most significant real-estate depreciation development is Notice 2026-16. On February 20, 2026 (IR-2026-25), Treasury and the IRS issued interim guidance under the One, Big, Beautiful Bill, with proposed regulations to follow, for an elective special depreciation allowance of up to 100% of the unadjusted depreciable basis of qualified production property placed in service during a taxable year.

Qualified production property is, generally, nonresidential real property used as an integral part of a qualified production activity — manufacturing, chemical production, agricultural production, or refining that results in the substantial transformation of the property comprising a qualified product. Among other requirements, the allowance applies only to property placed in service after July 4, 2025, and before January 1, 2031. The notice covers the definitions, how to determine the allowance, how and when to elect, and how recapture applies if the property ceases to qualify. Taxpayers may rely on it until proposed regulations are issued; comments were requested within 60 days of issuance.

In a spreadsheet, an eligible facility shifts from a 39-year straight-line row to a potential full first-year deduction — the exact scenario your special-allowance row exists for, with a recapture flag if use changes. A standard Temecula or Moreno Valley rental house stays on ordinary 27.5-year straight-line; the allowance targets production facilities.

⚠️ September 15, 2026 extension deadline is 49 days away

Extended S-corp (Form 1120-S) and partnership (Form 1065) returns for calendar-year filers are due Sept. 15, 2026, and Q3 federal and California estimated payments land the same day. Late 1120-S/1065 filing runs $235 per shareholder or partner per month under §§6699 and 6698 (IRS).

Call (951) 223-1826 →  |  Book 15-min planning call →

Frequently Asked Questions

What should an “excel depreciation” real estate template include?

At minimum: property name and address, asset type, purchase price, land value, depreciable closing costs, the placed-in-service date, an annual depreciation schedule across the recovery period, and a totals row. A reference tab with IRS monthly depreciation rates supports the mid-month proration.

How do I calculate rental property depreciation in Excel?

Divide your depreciable basis — purchase price plus certain expenses, minus land — by 27.5 for residential rental or 39 for nonresidential property. Prorate the first and last years by the placed-in-service month using the IRS monthly rates under the mid-month convention.

What recovery period applies to my property?

Residential rental real property uses 27.5 years; nonresidential real property uses 39 years; non-building permanent structures such as fences and sidewalks use 15 years; manufactured homes use 10 years; and computers, equipment, and furniture use 5 years. Confirm classification against Publication 946.

Can I fix depreciation I missed in prior years?

Yes. Publication 946 allows correction through an amended return or by changing your accounting method, and a Treasury revenue procedure permits the change even after the property is sold, so the allowable deduction is not permanently lost. The right route depends on how many years are affected.

Is land ever depreciable?

No. Publication 946 lists land as property that cannot be depreciated, and its MACCS worksheet tells filers not to include the cost of land in real estate basis. Subtract land value before applying any formula.

What is the new 100% special depreciation allowance?

Under Notice 2026-16, taxpayers may elect a deduction of up to 100% of the unadjusted depreciable basis of qualified production property — generally nonresidential real property integral to manufacturing, chemical production, agricultural production, or refining — placed in service after July 4, 2025, and before January 1, 2031. Recapture applies if the property ceases to qualify.

Does depreciation permanently lower my taxes?

No — depreciation is a deferral. At sale, depreciation recapture taxes the part of your profit attributable to the deductions, though tools such as a 1031 like-kind exchange can delay that recognition further.

FREE FOR INLAND EMPIRE BUSINESS OWNERS

Free Rental Tax Strategy Call

Adham personally walks your spreadsheet line by line: land-versus-building basis split, placed-in-service dates, recovery periods, missed prior-year deductions, and whether any property could qualify for the new special allowance — so your numbers hold up at filing and at sale.

Book Your Free Diagnostic →

File With a Schedule You Can Defend

A disciplined Excel depreciation real estate schedule pays you every year you own the property; a sloppy one compounds quietly until a sale or an IRS letter exposes it. Whether you hold one Moreno Valley rental or a portfolio stretching from Corona to Temecula, Catalyst CPA’s real estate investor bookkeeping setup builds depreciation on Publication 946 logic from day one. Call (951) 223-1826 or email adham@catalyst-cpa.com to get your schedule reviewed before the next filing deadline.

Last reviewed: July 27, 2026 by Adham Abadier, CPA (CA #158599).