STRTally

Free calculator

Average stay calculator (average period of customer use)

Type the length of each stay in nights. The average period of customer use is the days in all stays divided by the number of stays; 7 days or less takes the property out of the rental-activity rule of Treas. Reg. §1.469-1T(e)(3)(ii)(A).

Sample data: eight made-up stays. Replace them with yours.

Have the booking export? The home tool reads it and does the merging and the year boundary for you. Nothing you type leaves this browser.

Result

Average period of customer use
4.50 days
7-day test
Met
Stays
8
Days (nights)
36
30 days or less
Met
Longest next stay that keeps it at 7 or less
27 nights

Average = days in all stays / number of stays (Treas. Reg. §1.469-1(e)(3)(iii)(C)). Seven days or less: not a rental activity under §1.469-1T(e)(3)(ii)(A). 30 days or less counts only with significant personal services, (ii)(B). Arithmetic, not tax advice.

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

How it works

The average period of customer use is the aggregate number of days in all periods of customer use (taking into account only periods that end during the taxable year or that include the last day of the taxable year), divided by the number of those periods.

Each period during which a customer has a continuous or recurring right to use the property (whether under a single agreement or renewals of it) is one period of customer use; a period that includes the last day of the year may be measured by reasonable estimates. So two bookings by the same guest that follow each other are usually one stay; add their nights together here.

One long stay moves the average a lot. Sample data: ten 3-night weekends average 3.00 days; add one 30-night stay and it is 5.45 days; add a second and it is 7.50 days, over 7.

The regulation counts days, not nights, and does not say whether the check-out day is one. Pick the count your CPA uses: calendar days add one day to every stay (ten 3-night weekends become 4.00 days).

30 days or less only helps when significant personal services are provided with the stay (§1.469-1T(e)(3)(ii)(B)); the calculator shows the number, not the services test. With several properties of very different daily rents in one activity, the average is weighted by rent: When one activity holds several classes of property (daily rents that differ significantly), the activity's average is the sum of each class's average weighted by that class's share of gross rental income.

With a booking export, use the export tool: it merges back-to-back bookings, handles stays across 31 December and splits the property's days for §280A.

Sources of the rules

Frequently asked questions

How do you calculate the average period of customer use?
Add the days of every period of customer use that ends in the tax year or includes 31 December, and divide by the number of those periods (Treas. Reg. §1.469-1(e)(3)(iii)(C)). Ten weekends and one 30-night stay: 60 / 11 = 5.45 days.
What is the Airbnb 7 day rule for taxes?
It is the tax rule, not an Airbnb rule: if the average guest stay at a property is 7 days or less, renting it is not a rental activity under Treas. Reg. §1.469-1T(e)(3)(ii)(A), so the per-se passive rule for rentals does not apply to it.
Is the average stay counted in nights or days?
The regulation says days and does not define whether the check-out day is one. Most exports give nights; the calculator lets you count calendar days (nights + 1) instead. Use one method consistently and agree it with your CPA.
Does a stay that started last December count this year?
Yes: a period counts in the year it ends, with all its days, and a period still running on 31 December also counts in that year (§1.469-1(e)(3)(iii)(C)).
What if my average is just over 7 days?
The test is the average for the year, so the stays still to come change it. The calculator shows the longest next stay that keeps the average at 7 or less. Do not split one guest's stay into two bookings to lower it: renewals are one period of customer use (§1.469-1(e)(3)(iii)(D)).

Guides