Free Template

Free REP Hours Tracking Template

A structured starting point for tracking Real Estate Professional hours manually. Select the IRS qualifying activities that apply to you, enter hours by property, and download a formatted CSV. Use this until you are ready to automate.

All 14 IRS qualifying categories
Multi-property support
Download as CSV, no signup
Manual tracking requires discipline. IRS guidance and Tax Court rulings require contemporaneous records — entered at the time of activity, not reconstructed later. Enter hours weekly at minimum, and corroborate with calendar events, emails, or invoices. A year-end reconstruction is a significant audit risk.

1Tax Year

2Properties

3Qualifying Activities

Select the IRS qualifying activity categories you want to track. You can always add more later.

4Enter Hours & Notes

Enter hours per activity per property. Add notes for important dates, contacts, or corroborating documentation references.

ActivityProperty 1TotalNotes
Rental Operations & Management
IRC §469(c)(7)(C)(iii)
—
Record Keeping & Administration
IRC §469(c)(7)(C)(x)
—
Market Research & Analysis
IRC §469(c)(7)(C)(xi)
—
Inspection & Condition Assessment
IRC §469(c)(7)(C)(vii)
—
Contractor Oversight & Coordination
IRC §469(c)(7)(C)(xii)
—
Total Hours——

Download Your Template

Generates a CSV with all your activities, hours, and notes — ready to open in Excel, Google Sheets, or Numbers.

Starting point, not the destination

Automate This → Try REPSShield Free

This template is your manual foundation. REPSShield syncs with your calendar, logs qualifying activities automatically, and generates IRS-compliant audit packages on demand — so you stop worrying about spreadsheets and start focusing on deals.

Start Free — 14 days, no card requiredSee How It Works

Why Manual Tracking Is a Starting Point, Not the End Goal

Spreadsheets work until they do not. Understanding the limitations helps you decide when it is time to automate.

Retroactive entry risk

The single biggest audit trigger for REP status claims. Logging a month of hours in one sitting is easily spotted by the IRS and may be discounted entirely.

REPSShield logs automatically from your calendar — every entry is timestamped at the time it occurs.

Vague descriptions

Generic entries like "property work" do not satisfy IRS specificity requirements. Each entry should name the activity type, the property, and what was accomplished.

REPSShield classifies activities against IRS categories and generates specific descriptions automatically.

Property attribution gaps

Hours not tied to a specific property address cannot be attributed for material participation purposes, weakening per-property qualification.

REPSShield links every event to a property address from your existing portfolio.

Lost records

Spreadsheets stored locally can be lost or damaged. The IRS requires records to be kept for at least 3 years from the filing date.

REPSShield stores records in the cloud with automatic backups and version history.

No audit package

If you receive an IRS notice, a raw spreadsheet is not sufficient. Examiners expect organized, corroborated documentation presented professionally.

REPSShield generates a formatted audit package on demand — ready to hand to your CPA or directly to the IRS.

Time cost

Manually logging and categorizing hours for multiple properties can take 15–30 minutes per week — over 20 hours per year spent on record-keeping alone.

REPSShield automates this entirely. Setup takes 15 minutes; maintenance takes zero.

Frequently Asked Questions

Why is a separate hours tracker necessary for Real Estate Professionals?
The IRS requires Real Estate Professionals to document qualifying hours to claim REP status under IRC §469(c)(7). Without contemporaneous records, the IRS can and frequently does disallow REP status during an exam — even if the investor genuinely spent the required hours. This tracker gives you a structured starting point aligned with the 14 IRS qualifying activity categories.
What is the 750-hour threshold and the more-than-half-time test?
To qualify as a Real Estate Professional, a taxpayer must: (1) spend more than 750 hours in qualifying real estate activities during the tax year, AND (2) spend more time in real estate activities than in any other trade or business. Both tests must be satisfied. The tracker shows your progress toward 750 hours, but the half-time test depends on your hours in other occupations, which you should calculate separately.
Does downloading a CSV create any legal compliance on its own?
No. A downloaded CSV template is a starting point, not a compliant tax record. IRS guidance (and Tax Court precedent) requires that records be contemporaneous — meaning entered at or near the time the activity occurred, not reconstructed from memory at year-end. The template becomes defensible only when entries are made regularly and are corroborated by calendar data, emails, receipts, or other contemporaneous evidence.
Can I use this for multiple tax years?
Yes. The tool lets you select the tax year for each download. Run it separately for each year and save each CSV with a distinct filename. Keep these files organized in a dedicated folder with your other tax records.
What file format does the download use?
The download is a .csv (comma-separated values) file, which opens natively in Microsoft Excel, Google Sheets, Apple Numbers, and any other spreadsheet application. No special software is required.
I have dozens of properties. Can this tracker handle that?
You can add as many properties as you need using the "Add Property" button. However, for investors with many properties, a manual spreadsheet becomes increasingly error-prone and time-consuming. REPSShield handles multi-property tracking automatically by syncing with your calendar and attributing hours per property.
How is REPSShield different from this template?
This template is a manual tool — you enter hours yourself, typically at the end of the week or month. REPSShield tracks your hours automatically by reading your calendar, classifies activities against the 14 IRS categories, and generates a full audit-ready report with timestamped entries. The difference is: this template prevents forgetting to track; REPSShield prevents tracking errors and retroactive entry.

Related Tools

REP Status Calculator

Check if your tracked hours meet the 750-hour threshold and more-than-half-time test.

Use free tool

REP Hours Audit Scan

Upload your completed spreadsheet and receive a documentation quality score before filing.

Use free tool

Rental Property Calculator

Calculate cap rate, cash flow, and return on any rental property in under 3 minutes.

Use free tool
Start for free today

Ready to Track Your REP Hours?

Stop using spreadsheets. Get audit-ready documentation automatically.

Start Free Trial See How It Works

14-day free trial · No credit card required · Cancel anytime