Keep the work you did and the money you spent in a record you can review with your tax professional. This free Excel template includes separate hours and expense logs, property and person totals, and space to reference the documents behind each entry.
Download the free Excel template
No email or DeductFlow account required. Includes 250 rows in each log and fictional examples to help you get started.
What is in the template?
| Sheet | What you record | What it calculates |
|---|---|---|
| Hours log | Work date, entry date, property, person, activity, minutes, and supporting-record reference | Minutes converted to hours; recorded hours for a selected person and property |
| Expense log | Payment date, property, vendor, description, category, amount, receipt reference, and review notes | Recorded USD amounts for a selected property |
| Examples and instructions | How to use the file, plus clearly labeled fictional examples | No customer data or claimed tax outcomes |
The template organizes records. It does not decide which activities count, calculate eligible deductions, or determine whether you materially participate.
What should an hours entry look like?
Write enough detail that someone else can understand what happened. Record the actual time spent and link the activity to the relevant property.
Fictional example:
| Field | Example |
|---|---|
| Work date | September 1, 2026 |
| Date recorded | September 1, 2026 |
| Property | Example cabin |
| Person | Alex |
| Activity | Replaced a loose cabinet hinge and checked the repair |
| Time | 40 minutes |
| Supporting record | Cabinet-repair photo and hardware receipt |
“Worked on rental” is harder to interpret than a description of the task and result. Useful context can include the repair performed, the guest issue addressed, or the operational decision made. Whether a particular activity counts for tax purposes is a separate question for your tax professional.
How to use the hours log
- Download and save your own copy. Keep the original blank file so you can start another year without mixing periods.
- Enter the work date and the date you make the entry. If you are catching up, preserve that difference and explain the basis for your entry.
- Use consistent property and person names. The summary matches the names you enter. Keep another person’s time under their name.
- Describe the activity and enter minutes. The Hours column calculates the equivalent hours. Avoid counting the same time twice.
- Add a reference to supporting records. Use a filename, document link, reservation reference, or other identifier you can find later.
- Review the log regularly. Look for missing details, accidental duplicates, and activities your tax professional should assess.
The “Date recorded” field is entered manually. This workbook does not independently timestamp or verify work. Save dated versions or use a file service with version history, and preserve the original supporting documents.
How to use the expense log
Record what you paid, which property it relates to, and where the receipt or other supporting document is stored. Use the notes column for questions about personal use, reimbursements, refunds, or whether a purchase should be treated as an asset.
For example, an entry for a replacement cabinet hinge could include the payment date, hardware store, amount paid, property, receipt filename, and a short explanation of the repair. The amount recorded is the transaction amount; it is not a statement that the full amount is deductible.
Use negative amounts for refunds. The sheet totals recorded USD amounts for the property selected at the top. It does not assign IRS tax lines or calculate depreciation.
Does the IRS require this template?
No. IRS Publication 925 permits reasonable methods of establishing participation; it does not universally require a daily log. A clear record and supporting documents can make the facts easier to explain. This template is one organizational tool, not an IRS form or a guarantee of acceptance. Read IRS Publication 925
Does reaching 100 hours mean I qualify?
No. An hours total alone does not establish eligibility. One of the material participation tests requires more than 100 hours and at least as much participation as any other individual. Other tests and limitations may apply to your circumstances. Your tax professional should review the activity and the underlying facts. Material participation guidance
When might software be more useful?
A spreadsheet can be a good fit when you keep it current and can easily find the supporting records. As your rental work grows, you may prefer to keep expenses, receipts, mileage, and hours in one workspace.
DeductFlow lets short-term rental owners enter expenses and attach receipts, record rental trips, and keep active-hours entries by property. New hours entries preserve the original entry time separately from the work date. That records when an entry was made; it does not independently verify the work.
Try desktop tracking for seven days without a credit card. Reports, exports, and Mobile Companion require paid Pro and are excluded from the trial. Pro is $149/year or $24/month.
Keep the records connected
- How to document material participation
- Expense tracking for your rental
- Mileage records for property trips
- What to bring your CPA
Download the free template and start with your next activity or receipt.
DeductFlow provides recordkeeping software. Your tax professional determines eligibility and reporting treatment.