The 60-second answer
- §280A(d)(1) sets a per-property annual ceiling. Personal-use days above the greater of 14 days or 10% of rental days reclassify the property as a residence. Once classified, §280A(c)(5) caps deductions at rental income for the year (any excess suspends and carries forward against future §280A rental income from the same property).
- Not every day counts. Owner-days spent substantially full time on repair or maintenance are excluded under the flush language following §280A(d)(2)(C), as implemented in IRS Publication 527. Property showings to prospective renters are not "personal purposes" under §280A(d)(1) in the first place. The template's category dropdown carves both out with the right reg trace.
- Family stays and below-market rentals do count. §280A(d)(2) reaches use by family members per §267(c)(4) (spouse, siblings including half-blood, ancestors such as parents and grandparents, and lineal descendants such as children and grandchildren) regardless of rent charged, use by any individual at below fair-market rent, and reciprocal-use arrangements. If a family member stayed rent-free for a weekend, log it.
- Track continuously, not once at year-end. The Summary tab shows per-property status pills (Below ceiling / Approaching ceiling / At ceiling (one more day triggers reclassification) / Over §280A(d)(1) ceiling (reclassified as residence) / No data) so the ceiling risk is visible mid-year while corrective options remain (declining a family stay, deferring optional personal use to the next tax year).
- §280A(d) is one of two day-count records the STR loophole depends on. The other is the §1.469-1T(e)(3)(ii)(A) 7-day average-stay computation, tracked in the companion guest-stay tracker template. Both need to line up on the same per-property basis for a defensible loophole return.
Not tax advice; general framework only. Confirm with a qualified tax professional how §280A(d) applies to your specific facts.
What §280A actually says
§280A limits the deductions a taxpayer can claim on a dwelling unit used as a residence. §280A(d)(1) defines when a dwelling unit is a residence: personal-use days exceed the greater of 14 days or 10% of the number of days the unit was rented at fair rental value. §280A(d)(2) defines what counts as personal use, and includes use by the owner, family members (§267(c)(4): spouse, siblings including half-blood, ancestors such as parents and grandparents, and lineal descendants such as children and grandchildren) regardless of what they paid, someone renting at below fair-market rent, or a reciprocal-use arrangement.
Two doctrinal carve-outs matter for STR operators. First, the flush language following §280A(d)(2)(C), as implemented in IRS Publication 527, excludes owner-days spent substantially full time on repair or maintenance from personal use, even if a family member accompanies for recreational purposes. Second, §280A(d)(1) analysis treats property showings to prospective renters as outside "personal purposes" in the first place. The template's Category column returns each carve-out with the reg trace attached, so the record shows why a day was excluded, not just that it was.
The consequence of crossing the §280A(d)(1) ceiling: the property is reclassified as a residence for that tax year. Deductions attributable to the rental use are then limited by §280A(c)(5) to rental income; any excess is disallowed for the current year and carries forward to future years subject to the same income limitation. Reclassification also changes how §280A(e) allocates expenses between rental and personal use. Losing either day-count record (this one or the 7-day-rule guest-stay average) can undo the STR loophole strategy for that year.
What's in the sheet
Personal Use Days tab: one row per day of use
Log a row for every day the property was used personally, every repair-or-maintenance day, and every property-showing day. Columns: property (dropdown fed by the Properties tab), date, category (4-value dropdown: personal / family stay, repair or maintenance day, property showing, other), person or occupant, notes. Two formula columns compute automatically: whether the day counts as personal use (with the reg trace for each "No" case), and whether the row lands in the current tax year set on the Summary tab.
200 rows of formulas are pre-seeded. Add more by dragging the row-201 formulas down. Optional notes column is a good place to record the day's actual time-mix (hours on repair, hours recreational) since the repair-day exception's "substantially full time" test turns on evidence of what was actually done.
Summary tab: per-property ceiling + status
Row 1 is the tax year picker (cell B1); every formula in the sheet filters to this year. The per-property table (10 slots) takes each property's rental-days-this-year as input, computes the §280A(d)(1) ceiling (MAX of 14 or rental_days × 0.10), counts the personal-use-counted days from the log, and returns a status pill: Below ceiling (green) / Approaching ceiling within 3 days (yellow) / At ceiling with one more day triggering reclassification (yellow) / Over §280A(d)(1) ceiling and reclassified as residence (red) / No data (gray, rental-days or property not yet entered). §280A(d)(1) is a strict-inequality threshold, so hitting the ceiling exactly is the last safe day; the next day is what triggers reclassification. A reference card below lists the four cited reg sub-sections.
Properties tab: the dropdown source
Up to 10 property slots: short name (feeds all the dropdowns), address (optional), rental type (STR / LTR / mixed), notes. The short-name column drives every other tab's property dropdown, so add your properties here first and the rest of the sheet's dropdowns populate.
§280A reference tab: the categorization card
Static reference: what each of the four categories means, which reg section supports it, and what the effect is on the personal-use count. Skim it once before you start logging days; keep it open when a marginal call comes up (a day that was half maintenance, half family lunch on the porch: which category?).
README tab: the how-to
Setup steps, the four categories in short form, the §280A(d)(1) threshold logic, what "residence" reclassification means, and the reg-cite index. Also lists what the template deliberately does NOT do (material-participation hour tracking, expenses, income) so hosts know what to pair it with.
When to log a day (the 30-second rhythm)
A per-day log only works if you actually log the day. The habit that survives: log the day the day after it happened. Any of the following triggers a new row:
- You or a family member stayed at the property overnight (log as Personal / family stay).
- You visited the property and spent the majority of the day on repair or maintenance (log as Repair or maintenance day). Keep a photo or a receipt in a linked file.
- You showed the property to a prospective renter (log as Property showing). Optional: note the platform, listing update timestamp, or applicant name.
- A contractor was on-site alone but you want the day in the record (log as Other with a note).
- A family member (per §267(c)(4): spouse, siblings including half-blood, ancestors, or lineal descendants) stayed, regardless of what they paid (log as Personal / family stay; §280A(d)(2)(A) reaches family use without a rent test).
- A non-family individual (friend, in-law, cousin, aunt or uncle) stayed and paid less than fair-market rent (log as Personal / family stay; §280A(d)(2)(C) reaches below-market use by any individual, family or not).
Aim for a weekly check on the Summary tab: fifteen seconds to scan whether any property's status pill has moved from Below to Approaching. If it has, decide before booking or personal-use decisions are made whether the property has room for a family stay this month or is now off-limits for the rest of the year.
Where the spreadsheet stops (and Field Ledger picks up)
A spreadsheet works if you actually maintain it. Most hosts start strong in January and lose the habit by May. That's the honest failure mode of any download: it depends on the reader remembering to open it each week.
Field Ledger is a record-keeping tool for STR hosts. AI-assisted natural-language capture is the default landing experience on every plan (including the trial): describe the day in one sentence and Field Ledger stages Trip:/Activity:/Expense: draft lines you review and confirm before anything saves. Nothing is machine-asserted for you. If you'd rather type the structured lines yourself, switch to the Form tab; both paths land in the same review queue. Either path produces the same §280A(d) day-count records this template captures, plus the §469 material-participation hour log and the §1.469-1T(e)(3)(iii)(A) average-customer-use computation the loophole strategy also needs, plus §274(d)-substantiation-aware mileage and per-property Schedule E CSV export at year-end. Material participation is a fact-specific IRS determination; the tool never machine-asserts it, and the §469(h) call stays with you and your CPA.
No pressure. The template is yours whether you try Field Ledger or not. But if the "start strong, lose the habit" pattern is what happens to your records, that's the exact gap the app is designed to close.
Start free trial714-day free trial, no credit card required. Renews monthly or annually at the plan price you select until canceled. Cancel anytime in Manage Billing. Plus applicable US sales tax. Not tax advice.
Frequently asked questions
What counts as a personal-use day under §280A?
Under §280A(d)(2), a day counts as personal use if the property was used as a residence by the owner, a family member (§267(c)(4): spouse, siblings including half-blood, ancestors such as parents and grandparents, and lineal descendants such as children and grandchildren), someone renting at below fair-market rent, or under a reciprocal-use arrangement. Two important exclusions: (a) owner-days spent substantially full time on repair or maintenance are excluded under the flush language following §280A(d)(2)(C), as implemented in IRS Publication 527; (b) property showings to prospective renters are not "personal purposes" under §280A(d)(1) in the first place. The template's category dropdown categorizes each day accordingly so the count reflects only the days that actually matter for the §280A(d)(1) threshold. Not tax advice; consult a qualified tax professional.
Does a day I spent fixing the property count as personal use?
No, under the flush language following §280A(d)(2)(C) and IRS Publication 527, an owner-day spent substantially full time on repair or maintenance is not treated as personal use, even if a family member accompanies. "Substantially full time" is the doctrinal test: the day has to be spent on repair or maintenance in a work-day sense, not a bare-majority-of-the-day sense. IRS Publication 527 illustrates this by contrasting a taxpayer who works 8-hour days on repairs (excluded from personal use) with one who spends 3 to 4 hours on repairs while the rest of the time is spent fishing, hiking, and relaxing (still personal use). In the template, pick "Repair or maintenance day" from the Category dropdown; the Counts column returns "No (repair-day exception, flush language following §280A(d)(2)(C))" and the day is excluded from the personal-use count. Keep evidence of the work (photos, receipts, contractor invoices, hours logged) in case the categorization is questioned. Not tax advice; consult a qualified tax professional about how the "substantially full time" test applies to your specific day-mix.
What about days I stopped by to show the property to prospective renters?
Property-showing days are not "personal purposes" under §280A(d)(1) in the first place, so they are outside the personal-use definition entirely. The template categorizes these as "Property showing" and the Counts column returns "No (not personal purposes under §280A(d)(1))". This is a different doctrinal route than the repair-day exclusion: repair days are personal-use days that get carved out under §280A(d)(2)(C); showing days are simply not personal-use days to begin with. Both end up excluded from the count, but the reg trace matters if the categorization is examined. Not tax advice; consult a qualified tax professional.
What's the 14-day-or-10% threshold, exactly?
Under §280A(d)(1), a dwelling unit is treated as a residence for tax purposes if personal-use days exceed the greater of 14 days or 10% of the number of days the unit was rented at fair rental value. The threshold is strict inequality; at exactly the ceiling the unit is not yet reclassified, but one more day triggers it. The formula runs per property, per tax year. For a property rented 150 days at fair rental value, the ceiling is MAX(14, 150 * 0.10) = 15 days of personal use. Cross the ceiling and the property is reclassified as a residence; deductions are then capped by §280A(c)(5) to rental income (any excess suspends and carries forward). The template's Summary tab computes the ceiling per property based on the rental-days number you enter and returns a status pill (Below ceiling / Approaching ceiling / At ceiling (one more day triggers reclassification) / Over §280A(d)(1) ceiling (reclassified as residence) / No data). Not tax advice; consult a qualified tax professional on the classification consequences for your specific facts.
What happens if I cross the §280A(d)(1) threshold?
The property is reclassified as a residence for that tax year. Deductions attributable to the rental use are then limited by §280A(c)(5): they can be taken only up to the amount of rental income for the year, with any excess disallowed for the current year and carried forward to future years (where they can be taken again subject to the same income limitation). This is different from §469 passive-loss suspension: §469 losses release on a qualifying disposition or against future passive income; §280A(c)(5) excess carries forward only against future §280A rental income from the same property. Note that §280A(e) allocation of expenses between rental and personal use applies whenever there is any personal use, not only after reclassification; reclassification adds the §280A(c)(5) income cap on top of that year-round allocation. Not tax advice; consult a qualified tax professional on the return-preparation and multi-year consequences.
How does this template pair with the guest-stay tracker?
They cover the two day-count axes of the STR loophole: this template tracks §280A(d) personal-use days against the 14-day-or-10%-of-rental-days ceiling; the guest-stay tracker at /airbnb-guest-stay-tracker-template/ tracks the §1.469-1T(e)(3)(ii)(A) 7-day-average-stay rule, computed per §1.469-1T(e)(3)(iii)(A), from booking data. There is overlap: the guest-stay tracker includes a lightweight Personal Use tab that uses the same 4-category dropdown and status logic. This standalone version adds a dedicated tax-year picker, an occupant/person column for each row, a Summary tab that is scoped entirely to §280A, and a full §280A category reference tab. Hosts who already use the guest-stay tracker and log only a handful of personal-use days per year can keep using its built-in tab; hosts with more personal-use activity, multi-owner households, or a preference for one focused sheet per axis benefit from the standalone template. Losing either day-count record can undo the strategy: a property that clears the 7-day rule still gets reclassified as a residence under §280A(d)(1) if personal-use days exceed the ceiling; a property that stays under the personal-use ceiling still fails the §469 exception if the average stay exceeds 7 days. Not tax advice; the two-axis discipline is a general framework, not personalized planning.
Related guides
- The companion guest-stay tracker template (7-day rule)
- The 7-day rule for Airbnb hosts and the STR tax loophole
- How to track material participation for the STR tax loophole: a year-long walkthrough
- How to qualify for the STR tax loophole
- Multi-property STR record-keeping (§1.469-4 grouping)
- Best Airbnb accounting software for hosts pursuing the STR tax loophole
- Free Airbnb Schedule E template
Statutory sources
- IRC §280A: disallowance of certain expenses in connection with dwelling units (including §280A(d)(1) 14-day-or-10% threshold, §280A(d)(2) personal-use definition, §280A(d)(2)(C) flush language repair-day exception, §280A(c)(5) income-limited-deduction consequence, §280A(e) expense-allocation rule)
- IRC §267(c)(4): family-member definition referenced by §280A(d)(2)
- Treas. Reg. §1.469-1T(e)(3)(ii)(A) (≤7-day rental-activity exception) and §1.469-1T(e)(3)(iii)(A) (average-period-of-customer-use computation): the companion day-count axis
- IRC §469: passive activity losses (broader framework the STR loophole strategy sits within)
General information about U.S. federal tax rules for §280A personal-use record-keeping; not tax advice.
The key takeaway
§280A(d)(1) is a hard per-property annual ceiling: cross it and the property is reclassified as a residence for the year, with §280A(c)(5) capping deductions at rental income. Repair-and-maintenance days (flush language following §280A(d)(2)(C)) and property-showing days (§280A(d)(1) analysis) are correctly excluded; family stays and below-market rentals are correctly included. The template's job is to make the per-property status visible mid-year while corrective options are still open (decline a family stay, defer optional personal use), and to keep the reg trace attached to each excluded day so the record can defend itself. Paired with the companion guest-stay tracker, it covers the two day-count axes the STR loophole depends on. Not tax advice: this is a general framework, not personalized planning. Consult a qualified tax professional on how §280A applies to your specific facts.
714-day free trial, no credit card required. Renews monthly or annually at the plan price you select until canceled. Cancel anytime in Manage Billing. Plus applicable US sales tax. Not tax advice.