Eiduk Tax & Wealth

Strategy #27 · Real Estate Material Participation Log

IRC §469 Compliance Documentation — Companion to Bottom-Up Excel Workbook

Pay Less. Keep More. Build Wealth.

📊 How to Use This Log with Your Excel Workbook

This HTML log and the Excel workbook work together to create complete IRS audit defense:

Excel Workbook (Daily Detail)

Simple daily time entry
1,000 rows for daily tracking
Date, property, hours, activities
Contemporaneous documentation
Property-by-property detail
10 activity categories

HTML Log (Summary & Narrative)

Quarterly hour summaries
Portfolio-level totals
REP status calculations
Material participation analysis
Supporting documentation checklist
Tax advisor certification

Simple Workflow: Track daily activities in Excel as they occur → Quarterly: Sum hours by property → Enter totals in this HTML log → Add narrative descriptions → Print both for IRS audit binder

Taxpayer & Real Estate Business Information

Taxpayer Name:

Tax Year:

Filing Status:

Real Estate Professional Status Claimed:

Annual Summary - Portfolio Level

Real Estate Professional Status Dashboard

Total RE Hours

Number of Properties

Avg Hours/Property

INCOMPLETE

REP Status

Quarterly Breakdown (From Excel Workbook)

Q1 (Jan-Mar)

hours

Q2 (Apr-Jun)

hours

Q3 (Jul-Sep)

hours

Q4 (Oct-Dec)

hours

Transfer from Excel: At end of each quarter, sum your daily Excel entries by property, then enter Q1-Q4 totals in the boxes above.

Real Estate Professional Status Tests (IRC §469(c)(7))

✓ Test 1: More Than 750 Hours in Real Estate

More than 750 hours of services during the tax year must be performed in real property trades or businesses in which you materially participated.

Total Real Estate Hours (All Properties):

Test 1 Result:

✓ Test 2: More Than 50% of All Personal Services

More than one-half of the personal services performed in trades or businesses during the year must be in real property trades or businesses in which you materially participated.

Total Personal Service Hours (All Businesses):

Real Estate Hours (from above):

Real Estate % of Total:

Test 2 Result:

Non-Real Estate Work Hours Breakdown:

Real Estate Portfolio - Property-by-Property Detail

Excel Integration: Summarize your daily Excel entries by property for each quarter. Enter Q1-Q4 hours for each property below.

Property Name/Address	Property Type	Q1 Hours	Q2 Hours	Q3 Hours	Q4 Hours	Annual Total	Material Participation Test Met	Action

PORTFOLIO TOTALS:		0	0	0	0	0

Grouping Election (IRC §469(c)(7)(A) and Reg. §1.469-9(g))

Grouping Election Made - Treating All Rental Real Estate as Single Activity

Grouping Election Details:

Important: If grouping election made, you only need to materially participate in the grouped activity as a whole (not each property individually). Once made, the election is binding for future years unless circumstances change materially. Election must be disclosed on the original or amended tax return for the election year.

Material Participation Tests - Property-by-Property Analysis

Seven Tests for Material Participation (IRC §469(h) and Temp. Reg. §1.469-5T)

Test 1 - 500+ Hours: You participate in the activity for more than 500 hours during the year.
Test 2 - Substantially All: Your participation constitutes substantially all of the participation in the activity of all individuals (including non-owners).
Test 3 - 100+ Hours & No One Else More: You participate more than 100 hours during the year, and you participate at least as much as any other individual (including non-owners).
Test 4 - Significant Participation Activities: Activity is a "significant participation activity" (you participate more than 100 but not more than 500 hours), and your aggregate participation in all significant participation activities exceeds 500 hours.
Test 5 - Prior 5 of 10 Years: You materially participated in the activity for any 5 (whether consecutive or not) of the prior 10 tax years.
Test 6 - Personal Service Activity: The activity is a personal service activity, and you materially participated in the activity for any 3 prior tax years (whether consecutive or not).
Test 7 - 100+ Hours & Facts/Circumstances: You participate in the activity more than 100 hours during the tax year, and based on all facts and circumstances, you participate on a regular, continuous, and substantial basis. (Note: Cannot use this test if any individual receives compensation for managing the activity or if any person spends more hours managing the activity than you.)

Material Participation Analysis for Each Property/Activity:

Supporting Documentation Checklist

Check all supporting documents maintained for IRS audit defense. These documents corroborate your time logs and material participation claims.

Calendar/schedule showing property visits and activities

Email correspondence with tenants, vendors, contractors

Mileage logs for property travel (per Moss v. Commissioner)

Repair/maintenance invoices and work orders

Lease agreements, amendments, and tenant communications

Property inspection photos/reports with dates

Bank/credit card statements showing property expenses

Tenant screening documents and applications

Property management software records/reports

Contracts with vendors/contractors

Acquisition/disposition closing documents (HUD-1, settlement)

Phone logs/call records for tenant/vendor communications

Excel time tracking workbook (Bottom-Up Material Participation)

This completed HTML Material Participation Log

Additional Documentation Notes:

Relevant Tax Court Precedent

Moss v. Commissioner, T.C. Memo 2013-145: Travel time to and from rental properties counts toward material participation hours. Contemporaneous records are critical.

Assaf v. Commissioner, T.C. Memo 2008-128: IRS will scrutinize time logs that appear to be reconstructed after-the-fact. Contemporaneous documentation is essential for credibility.

Carlstedt v. Commissioner, T.C. Memo 2016-172: Grouping election requirements and material participation standards for grouped rental real estate activities.

Tax Advisor Review & Certification

Advisor Assessment of Documentation Quality:

Real Estate Professional Status Conclusion:

Material Participation Analysis:

Recommendations / Documentation Gaps:

I have reviewed the real estate material participation log and supporting Excel workbook for and find the documentation:

✓ Adequate for IRS audit defense of real estate professional status and material participation

⚠ Needs improvement (see recommendations above)

✗ Insufficient - substantial additional documentation required

Tax Advisor Signature

Print Name

Professional Credentials

Date

Document Information

Prepared By:

Date Prepared:

Last Updated:

Tax Year End:

Retain Both Documents: This HTML log and the Excel Bottom-Up Material Participation Workbook together provide comprehensive IRS audit defense for real estate professional status. Store both in your compliance binder with all supporting documentation.

This material participation log documents real estate professional status qualification under IRC §469(c)(7). Maintain detailed contemporaneous records of all activities for audit defense purposes.