Manual Spreadsheets vs. STR Hours Voice Logs: Why the IRS Prefers Contemporaneous Records

You've been managing your short-term rental all year. Communicating with guests, coordinating cleaners, handling maintenance calls, restocking supplies. You know you've hit the hours. Then your CPA asks for your participation log and you open a blank spreadsheet and start trying to remember what you did in March.

That moment right there is where the STR loophole gets lost.

TL;DR: The IRS and Tax Court consistently reject hour logs that were assembled after the fact, even honest ones. Contemporaneous records, meaning logs created at or near the time the work happened, are the standard that survives audit. Whether you use a spreadsheet or a voice-logging app matters far less than when you record the entry. Logging in real time is the move.

Jennifer Beadles is a real estate investor and short-term rental owner who uses the STR loophole on her own properties. She writes from hands-on operating experience plus current IRS guidance (IRC §469 and Treas. Reg. §1.469-1T(e)(3)(ii)(A)).

---

Why "Contemporaneous" Is the IRS's Actual Standard

The word contemporaneous just means "recorded at the time." It is not a term the IRS invented to trip people up. It reflects the commonsense idea that a log written on the day you did the work is more reliable than one written six months later from memory.

For STR owners using the short-term rental loophole, the legal framework works like this. Under Treas. Reg. §1.469-1T(e)(3)(ii)(A), a rental whose average guest stay is 7 days or less is not treated as a passive rental activity under IRC §469. That means, if you materially participate, the losses are non-passive and offset your W-2 and other ordinary income directly. No real estate professional status required. No 750-hour test.

Material participation is most commonly shown with the 100-hour test under Treas. Reg. §1.469-5T(a)(3): you logged more than 100 hours AND more than anyone else involved in the property, including cleaners, co-hosts, and property managers. The 500-hour test (Test 1) and the "substantially all" test (Test 2) are also available, but the 100-hour test is where most STR owners land.

Here is the catch. The IRS does not have to take your word for it. If you get audited, your participation hours need to be documented. And the Tax Court has made clear, repeatedly, what "documented" actually means.

---

What Tax Court Says About Reconstructed Logs

Tax Court opinions on passive activity hours are blunt. Judges have seen every variety of after-the-fact log imaginable, and they are not impressed.

In Almquist v. Commissioner, the court rejected hours that were reconstructed from memory without supporting records. The taxpayer was credible. It did not matter. Credibility is not a substitute for documentation.

In Penley v. Commissioner, the taxpayer's log showed hours rounded to the nearest half-day with no start or end times. The court threw it out. Rounded numbers without timestamps read as estimates, not records.

In Moss v. Commissioner, "on call" time and general availability were counted in the hour tally. The court said no. Time counts when you are actually performing a specific task, not when you are theoretically reachable.

The pattern is consistent. Reconstructed hours, vague entries, and rounded estimates do not survive scrutiny. You can read more about the specific mistakes that sink hour logs at audit in the STR hour log Tax Court case breakdown on this site. It's worth twenty minutes of your time before you finalize your tracking system.

---

Manual Spreadsheets: What Works and What Doesn't

A spreadsheet is not automatically bad. A well-kept spreadsheet, updated daily, with specific task descriptions and actual start and end times, can hold up at audit. The format is not the problem. The timing is.

The failure mode with spreadsheets is almost always the same. You plan to update it weekly. Then life happens and you update it monthly. Then it's December and you're trying to reconstruct February. By then you are writing estimates, not records.

Here is what a spreadsheet entry needs, at minimum, to be defensible:

1. Date of the activity
2. Specific task description ("responded to guest inquiry about parking," not "guest stuff")
3. Start time and end time, not just total hours
4. Your name, to distinguish your hours from the cleaner's or co-host's hours

That last point matters more than most people realize. The 100-hour test requires that you logged more hours than anyone else. If your log does not separate your time from your cleaner's time, you cannot prove that threshold. Your cleaner's hours are not invisible, they count against you in the comparison.

See the complete guide to tracking STR hours efficiently for a detailed breakdown of which activities count and how to organize them.

---

Voice Logs: The Contemporaneous Advantage

Voice logging works differently. Instead of opening a spreadsheet after the fact, you speak a quick note at the moment you finish a task. "Tuesday, 10:47 a.m. Responded to guest message about early check-in. About eight minutes." That note is timestamped. It is specific. It exists at the time the work happened.

That is what contemporaneous means in practice, and that is why voice logs are increasingly what CPAs recommend to STR clients who are serious about defending their deductions.

The STR Hours app at strhours.com is built specifically for this workflow. You log in real time by voice, the entry gets timestamped automatically, and your records are organized by property and task type throughout the year. When your CPA asks for your participation log in January, you have a year of timestamped entries, not a blank spreadsheet.

---

The Dollar Stakes: A Worked Example

This is worth making concrete, because the abstract version ("good records matter") does not hit the same way as the dollar version.

Assumptions:

• W-2 income: $300,000
• STR purchase price: $600,000, depreciable basis: $480,000
• Cost segregation reclassifies 30% of depreciable basis into 5- and 15-year components: $144,000
• Bonus depreciation (100% under current law, post-January 19, 2025): $144,000 first-year deduction
• Remaining straight-line depreciation on the 27.5-year residential component: approximately $12,218
• Operating deductions (mortgage interest, insurance, management fees, supplies): $28,000
• Gross rental income: $90,000
• Net paper loss: $144,000 + $12,218 + $28,000 - $90,000 = $94,218

At a 37% marginal federal rate, that $94,218 paper loss is worth approximately $34,861 in federal tax savings, assuming you qualify for non-passive treatment.

Now here is the branching point. If your hours log holds up at audit, that $34,861 stays in your pocket. If the IRS rejects your log because it was reconstructed, the loss gets reclassified as passive under IRC §469. You cannot use it against your W-2. The deduction disappears into a suspended loss carryforward that might never be useful.

The difference between a real-time log and a reconstructed one is not a technicality. It is $34,861.

You can run your own numbers in the STR loophole tax savings calculator to see what your specific situation looks like.

---

Spreadsheet vs. Voice Log: A Direct Comparison

The honest tradeoff: a spreadsheet updated in real time with full detail is roughly equivalent to a voice log. The issue is that consistent real-time discipline is harder to maintain on a spreadsheet. The friction of opening a file, navigating to the right row, typing a detailed entry, and saving it, is just higher than speaking a 15-second note into your phone.

Lower friction means more consistent logging. More consistent logging means better records. Better records mean the deduction holds.

---

Practical Steps to Build a Contemporaneous System

Getting your documentation right does not require a complicated setup. It requires a consistent habit.

1. Choose your medium before the year starts. Decide now whether you are using a spreadsheet or a voice log app. Switching mid-year creates a documentation gap that raises questions.
2. Log at the moment, not at the end of the day. The end of the day is already too late for some entries. Finish a task, log it. That is the standard.
3. Be specific every time. "Managed property" is not a task description. "Called HVAC repair company, scheduled technician for Thursday, 22 minutes" is.
4. Separate your hours from everyone else's. Keep a separate log for cleaner hours, co-host hours, and property manager hours. You need to show yours were more, not just that they were enough.
5. Back up your records. A voice log app that syncs to the cloud is automatically backed up. A local spreadsheet is one laptop failure away from gone.

The STR loophole documentation best practices guide goes deeper on structuring your records to hold up under IRS scrutiny, including what to do if your log has gaps.

---

Sources

• IRC §469, Passive Activity Loss Rules
• Treas. Reg. §1.469-1T(e)(3)(ii)(A), Short-term rental exception
• Treas. Reg. §1.469-5T, Material Participation Standards
• IRC §168(k), Bonus Depreciation (as amended by the One Big Beautiful Bill Act, July 2025)
• IRS Publication 527, Residential Rental Property
• Almquist v. Commissioner, T.C. Memo (contemporaneous records standard)
• Penley v. Commissioner, T.C. Memo (rejection of rounded, timestampless logs)
• Moss v. Commissioner, T.C. Memo (on-call time exclusion)

---

Bottom line: The IRS does not care how organized your spreadsheet looks in January. It cares whether your entries existed when the work happened. Pick your logging method, set it up before you close on the property or before the new year starts, and log every task the same day you do it. A voice log makes that habit easier to keep. A reconstructed one makes it easier to lose $30,000 or more.

This article is for educational purposes only and is not tax or legal advice. Talk to a CPA who knows short-term rentals before you act on it.