STRTally

Free · average stay · §280A days · hours

Short-term rental tax tests from your booking export

Your Airbnb or Vrbo CSV in; per property the average stay against 7 and 30 days, rental and personal days and the §280A tests out. Never uploaded.

Sample data: two made-up properties so you can see the results. Import your export below, or .

1. Your booking export

Read in this browser, never uploaded. Airbnb: Today > Menu > Earnings > Paid (or Upcoming), filter the dates, Get report, Create report (Airbnb help). Vrbo: download your reservations. Include the stays from late last year and early next year: they can count.

Or paste the CSV text

2. Tax year and the choices the rules leave to you

The regulation counts "days" and does not say whether the check-out day is one. Use the count your CPA uses, and the same one every year.

3. Results per property, tax year 2026

City condo (sample)

9 stays with nights in 2026 · 9 check-outs in 2026

Average period of customer use
7.75 days
62 nights / 8 periods counted for 2026
7-day test
Not met
Average 7 days or less: not a rental activity under §1.469-1T(e)(3)(ii)(A).
30 days or less
Met
(ii)(B) also needs significant personal services, which this tool does not judge.

8 periods would need 6 days fewer (or more short stays) to average 7.

Days only you know (2026)
Fair-rental days in 2026
62
Personal days (home test)
3
Limit: greater of 14 or 10% of 62
14
Used as a residence (§280A(d)(1))
No
Rented fewer than 15 days while a home (§280A(g))
No
Rental-use share of expenses (§280A(e))
95.4% (62/65)
Personal use, not used as a home
Some personal use, but not more than 14 days or 10% of the fair-rental days: split the expenses by rental days / total days used (§280A(e)).

Lake cabin (sample)

14 stays with nights in 2026 · 13 check-outs in 2026

Average period of customer use
4.00 days
52 nights / 13 periods counted for 2026
7-day test
Met
Average 7 days or less: not a rental activity under §1.469-1T(e)(3)(ii)(A).
30 days or less
Met
(ii)(B) also needs significant personal services, which this tool does not judge.

One more stay of up to 46 nights keeps the average at 7.00 or less.

Days only you know (2026)
Fair-rental days in 2026
47
Personal days (home test)
12
Limit: greater of 14 or 10% of 47
14
Used as a residence (§280A(d)(1))
No
Rented fewer than 15 days while a home (§280A(g))
No
Rental-use share of expenses (§280A(e))
79.7% (47/59)
Personal use, not used as a home
Some personal use, but not more than 14 days or 10% of the fair-rental days: split the expenses by rental days / total days used (§280A(e)).

Your stays and days stay in this browser (local storage) so the hours check and Pro can use them. Nothing is uploaded or sent to analytics.

Your CPA will ask for these numbers. Pro hands them over.

An Excel file with live formulas (a sheet per property, the tests, the expense share), an hours log with one row per turnover, and a one-page printable summary with the rule citations.

See the CPA pack

The tools

How the numbers are worked out

  1. Periods of customer use. Each booking is one period; two bookings by the same guest back to back are one, if you keep that choice on (a renewal of the right to use, Treas. Reg. §1.469-1(e)(3)(iii)(D)). Stays marked personal are left out.
  2. Which periods count for the year. Those that end during the year or include 31 December, with all their days, even the ones outside the year (§1.469-1(e)(3)(iii)(C)). So a stay from 29 December 2025 to 2 January 2026 counts in 2026 with its 4 nights.
  3. The average. Days in the counted periods divided by their number. 7 days or less: not a rental activity under §1.469-1T(e)(3)(ii)(A). 30 days or less: not a rental activity only if significant personal services are provided, (ii)(B), which the tool does not judge.
  4. Rental and personal days (§280A). Fair-rental days are the guest nights inside the year. Personal days are the days you type plus stays you mark personal. More than 14 days or 10% of the fair-rental days makes the unit a residence (§280A(d)(1)); a residence rented under 15 days falls under §280A(g); any personal use splits the expenses by rental days / days used (§280A(e)).

Sample data: the made-up cabin above has 13 periods and 52 nights, an average of 4.00 days (without merging the back-to-back booking: 14 periods, 3.71 days). The condo averages 7.75 days: over 7. The cabin has 12 personal days against a limit of 14: its 3 repair days are not personal days (IRS Pub 527, the default), so it is not used as a residence and 79.7% of its expenses are rental. Counting the repair days as personal (the conservative reading) makes it 15 days, over the limit, and 75.8% rental. The condo's one family stay is 3 personal days: 95.4% rental.

Hours are on the hours check: yours against the cleaner's (turnovers x hours per turnover) for the 100-hour test.

What the tool does not decide

Whether significant or extraordinary personal services are provided, grouping elections (each property is treated on its own), your spouse's hours in detail, real estate professional status, depreciation or cost segregation, and state rules. It does the arithmetic of the rules on the stays you enter and shows the choices the rules leave open; your CPA decides the treatment.

Arithmetic under Treas. Reg. §1.469-1T(e)(3), §1.469-5T and IRC §280A applied to the stays you enter. Not tax advice; confirm the treatment with your CPA. Not affiliated with Airbnb or Vrbo.

Sources

Sources of the rules (primary text)

Frequently asked questions

What is the short-term rental loophole?
A rental activity is passive whatever your hours (IRC §469(c)(2)). But an activity whose average period of customer use is 7 days or less is not a rental activity (Treas. Reg. §1.469-1T(e)(3)(ii)(A)), so it is passive only if you do not materially participate (§469(c)(1)). The tool checks the average and the two hour tests people use most; whether that changes your return is for your CPA.
What are the short-term rental loophole requirements?
Two numbers per property and year: an average stay of 7 days or less (or 30 days or less with significant personal services), and material participation under one of the seven tests in §1.469-5T(a), most often more than 500 hours or more than 100 hours and not less than anyone else. A unit used as your residence under §280A is outside §469 for that use (§469(j)(10)).
Does the short-term rental loophole work for a W-2 employee?
The rules the tool applies do not look at your job: §1.469-1T(e)(3) looks at the average stay and §1.469-5T at your hours on the property. A full-time job matters only through the hours you can put in.
Is there an STR loophole calculator that reads my Airbnb CSV?
This one. Export the earnings CSV (Today > Menu > Earnings, Paid or Upcoming, Get report), drop it above, check which column is which and pick the rows that are bookings. A Vrbo reservations CSV or any sheet with check-in and nights works the same way.
Is my booking data uploaded anywhere?
No. The file is read by your browser and the stays are kept in its local storage so the hours check and Pro can use them. Nothing is sent to a server or to analytics.
Is this a short-term rental tax deduction calculator?
It computes the share of your expenses that are rental expenses when you also use the place (§280A(e)) and whether §280A(g) removes the rental altogether. It does not compute your deduction, depreciation or tax.

Guides