Managing rental properties requires a robust tracking system, and an Excel depreciation real estate professional schedule is the ultimate tool to bridge the gap between your tax return and your daily operations. By maintaining a clean, per-property workbook, you can seamlessly defend your deductions during an audit.
An Excel depreciation real estate professional schedule is a spreadsheet that tracks MACRS depreciation for every rental property while documenting the 750-hour and material-participation tests that let qualifying investors deduct rental losses against W-2 income. As of July 2026, the One, Big, Beautiful Bill makes 100% bonus depreciation permanent for qualified property acquired after January 19, 2025 (IRS Notice 2026-11), which makes an accurate workbook more valuable than ever.
Written and reviewed by Adham Abadier, CPA — a California Board of Accountancy licensed Certified Public Accountant (License #158599) and founder of Catalyst CPA Corporation. This is the same framework we use when we set up bookkeeping for our clients using our specialized real estate tax accountant services: one workbook, per-property tabs, and hour logs that tell the same story as the tax return.
⚠️ September 15 extension deadline is 54 days away
S-Corp Form 1120-S and partnership Form 1065 returns on extension are due, plus Q3 federal and California estimated tax. The late-filing penalty runs $235 per shareholder, per month under §6699 and §6698 (per the IRS Form 1120-S guidance).
Key Takeaways
- ✓ Real estate professional (REP) status under IRC §469(c)(7) requires 750+ hours in real property trades or businesses — and more than half of all your working time.
- ✓ REP status alone is not enough: you must also materially participate in each rental activity, or elect to aggregate all rentals as one activity.
- ✓ 100% bonus depreciation is permanent for qualified property acquired after January 19, 2025 (IRS Notice 2026-11).
- ✓ Land is never depreciable — IRS Publication 946 requires excluding land cost from your depreciable basis.
- ✓ Worked example below: a $520,000 Moreno Valley duplex produces a $23,927 first-year loss and roughly $5,742 of federal tax savings for a REP household.
- ✓ Residential rental buildings depreciate over 27.5 years; nonresidential over 39 years (IRS Publication 946).
What Qualifies You as a Real Estate Professional Under §469(c)(7)?
The 750-Hour Test
You must perform more than 750 hours of services during the tax year in real property trades or businesses in which you materially participate (IRC §469(c)(7)). Qualifying work includes development, construction, acquisition, conversion, rental, operation, management, leasing, and brokerage. A part-time agent who closes three deals rarely clears this bar; a full-time property manager, broker, or hands-on landlord with a meaningful portfolio usually can.
The More-Than-Half Test
More than half of all personal services you perform in every trade or business during the year must land in real property. That is why a W-2 engineer working 2,000 hours at a day job generally cannot qualify personally. REP status is determined per individual, though — so on a joint return, one spouse can qualify for the household.
REP Status Alone Doesn’t Unlock the Losses
Qualifying as a real estate professional only removes the default rule that rental activity is automatically passive. You must still materially participate in each rental activity — or attach an election to treat all of your rentals as a single activity. Both the hours log and the election belong in the same file as your depreciation schedule.
“The investors I worry about aren’t the ones with small deductions — they’re the ones claiming real estate professional status with a depreciation schedule in one file, their hour log in their head, and no connection between the two. When the IRS asks questions, the spreadsheet and the calendar have to tell the same story.”
Build Your Excel Depreciation Real Estate Professional Schedule
The mechanics of depreciation are covered in our rental-property schedule guide; here is how to structure the workbook specifically around REP documentation.
Core Columns for Every Property Tab
One tab per property with: address, placed-in-service date, total cost, land value, depreciable basis, recovery period, convention, method, prior-year depreciation, current-year deduction, and accumulated depreciation. The MACRS worksheet in IRS Publication 946 is explicit: if real estate, do not include the cost (basis) of land.
Use the Mid-Month Convention for Buildings
Residential rental property uses a 27.5-year straight-line recovery period (IRS Publication 946); nonresidential real property uses 39 years. Both use the mid-month convention: multiply the full-year amount by (12.5 − placed-in-service month) ÷ 12 in year one. A building placed in service in June gets 6.5/12 of a full year. Full-year formula thereafter: depreciable basis ÷ 27.5.
A Separate Tab for Personal Property and Bonus
Appliances, carpet, furniture, and land improvements belong on their own tab — they are the assets eligible for 100% bonus depreciation (IRS Notice 2026-11) when acquired after January 19, 2025. Keeping them separate prevents the classic error of dumping everything into 27.5-year property.
| Asset type | Recovery period / treatment | Authority |
|---|---|---|
| Residential rental building | 27.5-year straight line, mid-month convention | IRS Publication 946 |
| Nonresidential (commercial) building | 39-year straight line, mid-month convention | IRS Publication 946 |
| Land | Not depreciable — excluded from basis | IRS Publication 946 |
| Qualified personal property (appliances, flooring) | 100% first-year bonus if acquired after 1/19/2025 | IRS Notice 2026-11 |
| Qualified Production Property | 100% special allowance under §168(n) | IRS Notice 2026-16 |
Tracking 750 hours in your head while your depreciation schedule lives in five half-finished spreadsheets? Adham will personally review your REP documentation, workbook structure, and passive-loss position — and flag exactly what an IRS examiner would challenge.
📞 (951) 223-1826 | Book a free 30-min diagnostic →
How REP Status Turns Depreciation Into W-2 Tax Savings
The Default: Rental Losses Are Passive
Without REP status, rental activity is passive by default under §469. Passive losses generally cannot offset W-2 wages or active business income — they suspend and carry forward. Qualifying as a real estate professional plus materially participating flips the activity to non-passive, which is what lets the depreciation loss reach your other income.
| Rule | Typical passive investor | REP + material participation |
|---|---|---|
| Rental loss classification | Passive | Non-passive |
| Deduct against W-2 / active income | No — carried forward | Yes |
| Hours requirement | None | 750+ hours and over half of total work time |
A Moreno Valley Duplex, by the Numbers
A Moreno Valley couple buys a duplex for $520,000. Allocating 20% to land leaves a $416,000 depreciable basis — $15,127 per year over 27.5 years. Rent brings in $31,200; operating expenses run $22,000; depreciation adds $15,127, producing a $5,927 rental loss. They also place $18,000 of appliances and flooring in service and deduct it fully under 100% bonus, growing the loss to $23,927. One spouse manages the portfolio full-time (800+ documented hours, no other job) and qualifies as a REP, so the $23,927 deducts against the other spouse’s $140,000 W-2 — roughly $5,742 of federal savings at a 24% marginal rate. Without REP status, that loss simply sits suspended.
Why the Workbook Is Your Audit File
Reconcile the workbook to Form 4562 (line 17) and Schedule E every year, and pair it with monthly bookkeeping so the rent and expense numbers match the depreciation file. The six-step workflow we install for clients:
- Log real-estate hours weekly — date, activity, property, hours.
- File the election to aggregate all rentals as one activity if needed.
- Build one Excel tab per property using the mid-month convention.
- Split land from building basis at closing using the settlement statement.
- Add a personal-property tab for 100% bonus assets.
- Reconcile the workbook to Form 4562 and Schedule E before filing.
What’s New for 2026: Permanent Bonus and Production Property
Notice 2026-11: 100% Bonus Is Permanent
The IRS guidance on the One, Big, Beautiful Bill confirms a permanent 100% additional first-year deduction for qualified property acquired after January 19, 2025. Taxpayers may instead elect 40% (60% for certain longer-production-period property and aircraft) for the first tax year ending after that date — useful when you would rather spread deductions forward.
Notice 2026-16: 100% for Qualified Production Property
Interim guidance in Notice 2026-16 implements a 100% special depreciation allowance under IRC §168(n) for Qualified Production Property — certain commercial real property used in production activities (per the Withum summary of the notice). For Inland Empire investors eyeing industrial or warehouse conversions in Ontario and Fontana, this is a planning conversation to have before closing, not after.
Frequently Asked Questions
What is an Excel depreciation real estate professional schedule?
It is a workbook with one tab per rental property tracking basis, placed-in-service date, convention, and annual MACRS depreciation, paired with a contemporaneous log of your real-estate hours. Together they support both the depreciation deduction on Form 4562 and your REP status under §469(c)(7).
How many hours do you need to qualify as a real estate professional in 2026?
More than 750 hours of services in real property trades or businesses in which you materially participate, and those hours must exceed half of all the personal services you perform in every trade or business for the year (IRC §469(c)(7)).
Can a real estate professional deduct rental losses against W-2 income?
Yes — provided the real estate professional also materially participates in the rental activity, or elects to aggregate all rentals as a single activity. REP status removes the automatic passive classification; material participation makes the loss non-passive and deductible against wages.
Is bonus depreciation still 100% in 2026?
Yes. The One, Big, Beautiful Bill made the 100% additional first-year depreciation deduction permanent for qualified property acquired after January 19, 2025, per IRS Notice 2026-11.
Should land appear in my Excel depreciation schedule?
List land as its own line item so your total cost reconciles to the closing statement, but never depreciate it. IRS Publication 946 is explicit that real-estate basis for depreciation excludes the cost of land.
What if I missed depreciation in prior years?
IRS Publication 946 describes correcting depreciation through a change in accounting method on Form 3115, which catches up missed deductions via a section 481(a) adjustment, rather than relying solely on amending prior returns.
Does each spouse need to qualify separately for REP status?
REP status is determined per individual, not per couple. On a joint return, only one spouse needs to satisfy the 750-hour and more-than-half tests for the household to use the benefit.
FREE FOR INLAND EMPIRE BUSINESS OWNERS
Free Rental Tax Strategy Call
In 30 minutes, Adham personally reviews your depreciation workbook, REP hour log, and passive-loss exposure, then maps the fastest corrections — including whether cost segregation or the aggregation election would increase your 2026 deduction.
Depreciation is only valuable if your status lets you actually use the loss. If you own rentals anywhere from Riverside to Temecula — or remotely nationwide — our rental property CPA services build the workbook, the hour log, and the return positions as one system, and our tax planning strategy work times bonus depreciation and cost segregation around your income. Call (951) 223-1826 or email adham@catalyst-cpa.com to get your 2026 schedule right before the September 15 deadline.
About the Author
By Adham Abadier, CPA — California CPA License #158599, QuickBooks Gold ProAdvisor. Adham is the founder of Catalyst CPA Corporation, specializing in real estate tax strategy and bookkeeping for small businesses and real estate investors throughout Moreno Valley and the broader Inland Empire. Contact: (951) 223-1826 / adham@catalyst-cpa.com / 13114 Yellowwood St, Moreno Valley, CA 92553.
Disclaimer: The information contained in this article is for general educational purposes only and does not constitute formal tax, legal, or financial advice. Tax laws are subject to change and individual circumstances vary. Please consult with a licensed CPA or tax professional regarding your specific situation.
Last reviewed: July 22, 2026 by Adham Abadier, CPA (CA #158599).
Catalyst CPA Newsletter
Get 2026 tax-saving tips in your inbox
Real, CPA-written guidance for Inland Empire small businesses — bookkeeping, tax planning, IRS updates. No spam, unsubscribe anytime.
By subscribing you agree to receive emails from Catalyst CPA. We never share your email. Unsubscribe with one click anytime. Questions? Call (951) 223-1826.
