Airbnb Expense Tracker: A Spreadsheet Hosts Can Use

Quick Answer: A useful Airbnb expense tracker has four tabs: reservations (gross booking, host service fee, net payout), expenses by category, a day-by-day use log, and a payout match against your bank deposits. The day log matters most, because IRS rules on personal-use days and short rentals decide how much you can deduct and which schedule the income goes on.

An Airbnb expense tracker is a spreadsheet that records each stay at its gross amount with the platform's fee as a separate expense, logs cleaning, supplies, utilities and occupancy taxes, and counts every night as rented, personal or repair. Those day counts drive the IRS personal-use test and the share of shared costs you can deduct.

Why a short-term rental needs a different tracker

A long-term rental produces twelve similar rent deposits a year. A short-term listing produces dozens of payouts of different sizes, each already reduced by the platform's fee, plus cleaning turnovers, restocking runs and nights you or your family stay there yourselves. If you only record what lands in your bank account, three things go wrong:

• Income is understated on paper. The payout is net of the host service fee. Recording the gross booking and the fee separately means your income line shows what guests actually paid, which makes any tax form the platform sends you far easier to reconcile.
• The fee disappears as a deduction. IRS Publication 527 lists commissions and management fees among deductible rental expenses. The host fee works the same way in your ledger, so it needs its own column.
• Day counts go unrecorded. The IRS tests for personal use are counted in days, not dollars. Nobody remembers in April how many nights a cousin stayed for free last June.

If your property is a standard twelve-month lease, the rental property expenses guide is the better fit. What follows is built for nightly and weekly stays.

Tab 1: the reservations log

One row per booking. Pull these from the platform's earnings or transaction history export, which Airbnb lets hosts download from their account (menu names change, so check Airbnb's Help Center for the current path).

Two notes on that layout. Column E holds what the guest paid you for the stay, including any cleaning fee you charge, because that cleaning fee is rental income to you. Column G exists because in some jurisdictions the platform collects and remits occupancy or lodging tax on your behalf, and in others you collect and file it yourself. Taxes the platform handles never touch your books. Taxes you collect are money you hold for the city or state, so track them apart from rent and pay them out on the local schedule.

The numbers in the example row are illustrative. Read your own fee from each reservation rather than assuming a percentage; fee structures differ by account setup and change over time.

Tab 2: expenses, split by category and by allocation rule

Every cost goes in one table: date, payee, category, amount, and an allocation column that says whether the cost is 100% rental or shared with personal use.

Useful categories for a short-term unit:

1. Cleaning and turnover (cleaner invoices, laundry service)
2. Supplies and guest consumables (toiletries, coffee, linens)
3. Utilities and internet
4. Repairs and maintenance
5. Insurance
6. Mortgage interest and property tax
7. Platform and software fees (host service fee from Tab 1, pricing or messaging tools)
8. Occupancy tax remitted (only the part you file yourself)
9. Furniture and appliances (these may need to be depreciated rather than expensed; ask your preparer)

Costs that exist only because of guests, such as a cleaner paid per turnover, are 100% rental. Costs the property carries all year, such as utilities, insurance, interest and property tax, are shared whenever you also use the place yourself. Publication 527 divides those by the ratio of days rented at a fair price to total days the unit was used for any purpose. Put that ratio in one cell on Tab 3 and point the expense tab at it:

=IF(E2="Shared", D2*Days!$F$8, D2)

where D is the amount, E the allocation flag, and Days!F8 the rental-use ratio. A SUMIFS by category then gives you the totals your preparer asks for:

=SUMIFS($H:$H, $C:$C, "Utilities")

Tab 3: what counts as a personal-use day?

This tab is a calendar with one row per date of the year and a single dropdown column: Rented, Personal, Repair, or Vacant. Publication 527 counts as personal use any day you or a family member use the unit, any day someone uses it under a reciprocal arrangement, and any day it is rented below a fair price. A day spent mainly on repairs and maintenance is not personal use, even if relatives were there. Note one trap from the IRS's own beach-cottage example: if a paying guest lets you stay over a weekend during their booking with no rent reduction, those days count as personal use for the home test.

The summary block:

Worked example: you rent 180 nights at market rates, stay 20 nights yourself, and spend 6 days on repairs. Ten percent of 180 is 18, which beats 14, so the threshold is 18. Twenty personal days exceeds it, so the unit counts as used as a home. The ratio is 180 / 200 = 90%, so a $4,200 utility bill contributes $3,780 to rental expenses. Under the used-as-a-home rules, rental deductions are limited if the property shows a loss; your preparer applies that limit, but they need your day counts to do it.

How do the day counts change where the income is reported?

Three thresholds in the IRS rules hinge on the numbers this tracker keeps:

• Rented fewer than 15 days in the year, and used as a home. Publication 527 says you don't include that rent in income, and the related expenses aren't treated as rental expenses. Your F3 cell tells you immediately whether you are in this case.
• Schedule E or Schedule C. Most rental income goes on Schedule E. Publication 527 says that if you provide substantial services primarily for your tenant's convenience, such as regular cleaning, changing linen, or maid service, the income and expenses go on Schedule C, and self-employment tax may apply. Whether what you provide meets that bar is a judgment call for your preparer, so note it in the tracker: mid-stay housekeeping, linen changes, meals, tours or transport.
• Average stay of seven days or less. IRS Publication 925 says an activity where the average period of customer use is 7 days or less is not treated as a rental activity for the passive activity rules. Your reservations tab can compute that average: =SUM(D:D)/COUNTA(A2:A).

Each of these has detail and exceptions this article does not cover. The tracker's job is to put the facts in front of whoever prepares the return, not to decide the answer.

Tab 4: tie payouts to bank deposits

The last tab proves that every expected payout actually arrived. Paste your bank statement lines for the rental account here: date, description, amount. Then, for each deposit, look for a reservation whose net payout and payout date match:

=COUNTIFS(Reservations!$H:$H, C2, Reservations!$I:$I, ">="&A2-3, Reservations!$I:$I, "<="&A2+3)

A result of 1 means one clean match within three days. Zero means the deposit doesn't correspond to a single reservation, which usually means the platform batched several payouts together, a guest's extra charge or a refund adjusted the amount, or a resolution payment arrived. For batched deposits, total the expected payouts for that date with =SUMIFS(Reservations!H:H, Reservations!I:I, A2) and compare.

Going the other way, any reservation still showing FALSE in column J at month end is money you were promised and have not seen.

Getting the bank side into the sheet is the tedious part if your bank only gives you PDF statements. If its online banking offers a CSV export for the period, use that. If not, QuickBankConvert can turn a statement PDF into rows with date, description and signed amount, which you paste straight into Tab 4; see PDF to Excel for what the output looks like.

A monthly routine that keeps it current

1. Download the platform's transaction history for the month and paste new rows into Tab 1.
2. Mark the calendar on Tab 3 for every night, including vacant ones.
3. Enter receipts and card charges into Tab 2. If your card statement is a PDF, converting it once a month with QuickBankConvert beats retyping each line.
4. Paste the bank statement into Tab 4 and clear any unmatched rows.
5. File any occupancy tax you collect yourself, and record the payment in Tab 2.

If you would rather build this in Google Sheets from scratch, the layout in our expense tracker for Google Sheets shows the dropdown and SUMIFS setup step by step. Hosts who own several properties will want one tracker per unit, rolled up the way the real estate bookkeeping guide describes.

Related guides

• Rental property expenses from bank statements: long-term leases and Schedule E categories
• Real estate bookkeeping: ledgers across multiple properties
• Expense tracker in Google Sheets: building the category tab
• IRS Publication 527, Residential Rental Property: the official rules on personal use and dividing expenses