Excel Depreciation Schedule for Rental Property (2026 Rules)

⚠️ Q3 estimated tax deadline is 57 days away

September 15, 2026: Q3 federal (Form 1040-ES) and California (540-ES) estimated payments are due — depreciation directly lowers what you owe. Extended S-Corp (1120-S) and partnership (1065) returns are due the same day; late filing runs $235 per shareholder per month under §6699 and §6698.

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

Start With Basis: What Your Rental Depreciation Spreadsheet Must Capture

Creating an Excel depreciation schedule for rental property is one of the most critical steps in real estate tax planning. Your purchase price is not your depreciable basis. Land does not wear out, so it is excluded from depreciation — only the building and improvements qualify. Properly tracking these details ensures you maximize your deductions while staying fully compliant with IRS guidelines.

Land vs. building allocation

Your purchase price is not your depreciable basis. Land does not wear out, so it is excluded from depreciation — only the building and improvements qualify. Riverside County’s assessor already splits land and improvement values on your property tax bill, and many Inland Empire investors use that ratio to allocate acquisition cost. Your workbook needs columns for acquisition date, cost basis, depreciation method, and annual rate for every asset you track. Establishing a precise land allocation depreciation strategy early prevents costly audit adjustments later.

Placed-in-service date and conventions

Depreciation starts when the property is placed in service — ready and available to rent — not the day escrow closes. Rules for residential rental property depreciation use the mid-month convention under MACRS: the building is treated as placed in service at mid-month regardless of the actual day, so first-year depreciation is prorated by month. Templates aligned to Form 4562 lines 19 and 20 build this convention in automatically.

Worked example: a Moreno Valley duplex

A Moreno Valley investor buys a Moreno Valley duplex for $300,000, allocating $60,000 to land and $240,000 to the building. Annual depreciation is $240,000 ÷ 27.5 = about $8,727 — a deduction that reduces taxable rental income every year without another dollar of cash out the door. Across a portfolio of Inland Empire rentals, that math compounds fast.

How to Build an Excel Depreciation Schedule for Rental Property (Step by Step)

Here is the exact build order I recommend to landlord clients — eight steps, one workbook, about an hour per property, and every step maps to a line the IRS actually looks at.

1. Create one tab per property. Schedule E reports income, expenses, and depreciation per property — mirror that structure.
2. Enter total acquisition cost, including closing fees and improvements made before the property was offered for rent.
3. Subtract land value using your assessor’s land/improvement ratio to isolate depreciable building basis.
4. Enter the placed-in-service date and apply the mid-month convention for year one.
5. Add the straight-line formula: building basis ÷ 27.5 (÷ 39 for nonresidential property).
6. Create separate rows for personal property — appliances, carpets, HVAC — at 5- or 7-year MACRS lives.
7. Add columns for prior depreciation, the current-year deduction, and accumulated depreciation.
8. Map each property’s total to Schedule E, page 1, line 18, and flag whether Form 4562 must be attached.

Update the schedule annually and tie it to your books. If that sounds like one more job, our monthly bookkeeping team keeps depreciation workpapers reconciled inside QuickBooks so tax season is a handoff, not a scramble.

Running rentals on a spreadsheet only you understand? Adham will personally review your depreciation schedule, land allocation, and Schedule E mapping in one working session — and show you what missed deductions are costing before the September 15 estimated tax payment deadline.
📞 (951) 223-1826  |  Book a free 30-min diagnostic →

Asset Classes: The Table Your Workbook Should Mirror

Every row in your spreadsheet should match one of these IRS asset classes to ensure you apply the correct MACRS recovery period:

Bonus depreciation in 2026

Shorter-life personal property is where 2026 planning gets interesting: 100% bonus depreciation is now permanent under OBBBA, so qualifying appliances and carpeting placed in service this year can potentially be deducted immediately instead of over 5-7 years. California does not conform to federal bonus depreciation — add a separate state column, because your federal and California numbers will differ (see current guidance at the Franchise Tax Board).

Mid-year and convention adjustments

Personal property placed in service mid-year takes the half-year convention — treated as placed in service at the year’s midpoint, with six months of depreciation in the first and last years. Bunch too many purchases in the fourth quarter and the mid-quarter convention can apply instead. IRS Publication 946 publishes the MACRS table factors your formulas can reference.

From Spreadsheet to Schedule E: Reporting Rules That Trip Up Landlords

Moving numbers from your spreadsheet to your tax return requires precision. Working with an experienced real estate tax accountant ensures that your calculations align perfectly with IRS expectations, preventing red flags.

Line 18 and Form 4562

IRS Publication 527 is blunt: list total income, expenses, and depreciation for each rental property, then enter the depreciation on Schedule E line 18. You may also need to attach Form 4562 to claim some or all of it — and in the year property is placed in service, Publication 527’s own example requires calculating Form 4562 depreciation to figure the deduction.

More than three properties

Schedule E’s page 1 fits three properties. Own more — common for Temecula rental property and Murrieta real estate investors with multiple doors — and Publication 527 says to attach as many Schedules E as needed to list each property separately, but fill in lines 23a through 26 on only one, using combined totals across all properties.

Personal-use days and loss limits

Line 2 asks for fair rental and personal-use days — answer it, because mixed use changes what you can deduct. Rental losses can also trigger Form 6198 (at-risk limitations) and the passive activity rules in Publication 925 before they offset other income. A dedicated rental property CPA reconciles those limits to your workbook so the spreadsheet and the return never disagree.

“The number one error I see on rental spreadsheets is depreciating the land. The second is expensing a $14,000 roof as a repair. Both distort basis, and both surface at the worst possible time — when you sell. Build the schedule right in year one and every year after is copy-paste.”

Five Mistakes That Distort a Rental Depreciation Schedule

1. Depreciating land. A bad allocation inflates basis and invites adjustment.
2. Expensing capital improvements. Improvements get added to depreciable basis — not deducted as repairs.
3. Starting too early. Depreciation before the placed-in-service date is a compliance problem, not a planning win.
4. Never updating. Review the schedule annually as assets are added or retired.
5. Mixing repairs and improvements on one row. Keep separate ledgers so nothing gets misclassified.

Each of these is a spreadsheet-design failure, not a math failure — which is exactly why a purpose-built template beats a blank worksheet. Partnering with a professional for Inland Empire bookkeeping ensures your records remain flawless.

Frequently Asked Questions

How do I set up an Excel depreciation schedule for rental property?

Use one tab per property. Enter acquisition cost, subtract land value, note the placed-in-service date, apply the 27.5-year straight-line mid-month convention to the building, and add separate 5- or 7-year rows for personal property. Each property’s annual total maps to Schedule E, page 1, line 18.

Can I depreciate the land my rental property sits on?

No. Land is not depreciable because it does not wear out. Allocate your purchase price between land and building — your county assessor’s tax bill ratio works — and depreciate only the building and improvements.

What is the recovery period for residential vs. commercial rental property?

Residential rental property depreciates over 27.5 years; nonresidential commercial property over 39 years. Both use the straight-line method with the mid-month convention.

Do I need to file Form 4562 every year?

Attach Form 4562 in the year each property is placed in service — Publication 527 requires it to figure depreciation on newly placed-in-service assets. In later years, recurring straight-line depreciation generally goes directly on Schedule E, line 18.

How do I report depreciation if I own more than three rental properties?

Attach as many Schedules E as you need to list each property separately. Fill in lines 23a through 26 on only one Schedule E, using combined totals for all properties (IRS Publication 527).

Can I deduct appliances and carpets faster than 27.5 years?

Yes. Appliances, carpets, and HVAC are 5- or 7-year MACRS property, not 27.5-year. As of 2026, 100% bonus depreciation is permanent federally under OBBBA, though California does not conform — keep a state-only column in your workbook.

Can I use Excel for IRS Schedule E reporting?

Yes. Excel is widely used to organize depreciation before transferring totals to Schedule E, and a multi-property workbook keeps every asset’s basis, method, and accumulated depreciation in one audit-ready place.