Short-Term Rental Expense Tracker Excel: Categorize Every Schedule E Deduction

Most short-term rental hosts treat tax season like a fire drill. They dump twelve months of Airbnb statements, Home Depot receipts, and credit card exports into a folder, then hand it to a CPA who charges by the hour to sort it out. Or worse, they upload everything to TurboTax and guess which line items go where. Either way, the same thing happens every April: a deduction gets missed, a category gets misclassified, and the host pays more tax than they owed.

A proper short term rental expense tracker Excel file fixes this in about an hour of setup. Not a generic expense log. A tracker built around the actual line items on Schedule E, with category codes that map straight onto the IRS form your accountant fills out. This guide walks through what that tracker needs, why each piece matters, and where most STR hosts leave money on the table.

Why STR Expense Tracking Is Not the Same as Long-Term Rental

The IRS treats short-term rentals differently from regular rental property in two ways that matter for how you track expenses.

First, if your average guest stay is seven days or less, the property is not a rental for passive activity loss purposes. It is treated more like a hotel. That changes which losses you can deduct against ordinary income and whether you file on Schedule E or Schedule C. Most hosts still file on Schedule E because they do not provide substantial services like daily cleaning during the stay or meals. But if you provide concierge services, you are a Schedule C business with self-employment tax exposure. Your tracker needs to flag this.

Second, personal use days kill deductions fast. Use the property more than 14 days personally or more than 10% of rental days, whichever is greater, and the IRS limits your deductions to the rental income. No loss carryforward. Your tracker needs a personal use day counter because that single number determines whether you take a $12,000 loss this year or carry it forward forever.

The expense tracker most hosts download from a blog ignores both of these. It has a "supplies" column and a "utilities" column and calls it done. Then at tax time, the CPA asks: "Was that toilet paper for the rental or your house?" and nobody knows.

The Schedule E Category Map

Open IRS Schedule E. The expense lines run from 5 to 19. Your tracker columns should map directly onto these. Here is the layout that works:

That gives you 15 codes. Every transaction in your expense tracker gets one of these codes in column D. No category column with free text. No "miscellaneous." If you cannot decide which code applies, the answer is almost always you need to learn the difference between Repairs and Improvements, because that is the most common confusion and it has real tax consequences.

The Tracker Layout That Works

Set up your spreadsheet with these columns from A to J: Date, Property, Vendor, Category Code, Description, Amount, Payment Method, Receipt Link, Personal Use %, Deductible Amount.

The two columns that earn their keep are H and I. Receipt Link points to a PDF or photo in your Google Drive or Dropbox. Personal Use % is a number from 0 to 100. Deductible Amount in column J is then a single formula:

=F2*(1-I2/100)

Suppose on June 14 you bought $342 of patio furniture for the rental. You also use the patio yourself when you stay there 8 days a year out of 320 rental days. Personal use is 8/(320+8) = 2.4%. Your deductible amount is $333.79. That precision matters when the IRS asks you to defend it.

For 100% rental expenses, Personal Use % is 0 and the deductible equals the spend. For an expense that is 100% personal that you accidentally logged, set Personal Use % to 100 and the deductible drops to zero. Keeping bad transactions in the log with a zero deductible is better than deleting them, because if the bank statement shows a charge, you want a record of why it is not deducted.

Where Hosts Lose the Most Money

Platform fees and channel deductions

Airbnb takes 14% to 16% with the host-only fee structure. Vrbo takes around 8% plus payment processing. These come out before you ever see the money. Many hosts only record gross revenue, then their CPA only sees gross revenue, then they pay tax on gross revenue. The platform fee is a deductible expense under Other (OTH) on line 19. On a property doing $60,000 gross, that is $9,000 you forgot to deduct. At a 24% bracket plus state, you just overpaid by $2,500.

Use a SUMIFS formula on a summary tab to surface it:

=SUMIFS(F:F,D:D,"OTH",B:B,"Property A")

That gives you total Other expenses for Property A. If the number is suspiciously low and you have $40,000 in Airbnb revenue, you have not logged platform fees. Build that flag into your tracker.

Cleaning fees that pass through

Guests pay a cleaning fee. You pay your cleaner. These are two separate transactions. The cleaning fee from the guest is income on Schedule E line 3. The amount you pay the cleaner is an expense on line 7. They do not net out on the platform statement, but they net out on your bank account, and that creates confusion.

If your cleaning fee charged is $150 and your cleaner gets $120, you have $30 in income and $120 in expense. Some hosts only book the $30 net, missing $120 in deductions. Track them separately:

=SUMIFS(F:F,D:D,"CLEAN")

Compare that to your cleaning fees collected from your booking log. The difference should match what you pocket as a markup.

The depreciation nobody runs

Residential rental property depreciates over 27.5 years. Furniture and appliances depreciate over 5 or 7 years. STR hosts who buy a $400,000 property and furnish it for $25,000 are sitting on roughly $14,545 a year in building depreciation plus $3,500 to $5,000 a year in furniture depreciation. That is $18,000 to $19,500 in non-cash deductions per property. Most hosts never run this calculation.

In your tracker, create a Depreciation tab with columns: Asset, Date in Service, Cost Basis, Recovery Period, Annual Depreciation. Annual depreciation is:

=C2/D2

Pull the sum into your main category summary as DEPR. If you bought the property mid-year, prorate the first year using the IRS mid-month convention for real property and the half-year convention for personal property. A $400,000 building placed in service on June 15 gets $400,000 / 27.5 * (6.5/12) = $7,879 in year one, not the full $14,545.

Mileage to the property

The 2026 standard mileage rate is 70 cents per mile. If you drive 90 minutes to your STR for a turnover check, that round trip might be 120 miles. At 70 cents, that is $84 deductible per trip. Six trips a year is $504. Hosts who own a property in the same metro often skip this entirely. Log it under AUTO with the date and odometer reading. The trip log itself becomes your audit defense.

The Quarterly Reconciliation That Catches Everything

Once a quarter, sit down with three things: your tracker, your bank statement, and your platform payout reports. Three checks take 30 minutes:

1. Bank statement reconciliation. Every debit related to the property should appear in the tracker. Filter your spreadsheet by date range. If the statement shows charges your tracker does not, log them.
2. Platform payout reconciliation. Sum platform deposits to your bank. Compare to gross revenue minus platform fees on your booking log. They should match. If platform fees on Schedule E (line 19, OTH code) are zero but you got Airbnb deposits, you have a problem.
3. Category sanity check. Run a SUMIFS by code. Flag anything that looks wrong. Repairs over $5,000 might actually be capitalized improvements that get depreciated, not deducted in one year. Supplies over $4,000 for a single property is unusual, double check what got coded there.

The quarterly cadence is the difference between a clean tax season and a panic. Hosts who do this finish their Schedule E in 90 minutes in March. Hosts who skip it spend two weekends and still pay too much.

What to Build Next

The expense tracker is one half of the equation. The other half is the income side: per-property revenue, occupancy, and net cash flow that ties out to your bank account. Layer those on top and you have a system that answers "should I buy another STR?" with real numbers, not vibes.

If you want to skip the setup, the SheetCraft rental property analyzer ships with the Schedule E category map preloaded, depreciation schedules built in for both building and personal property, and per-property reconciliation tabs that flag missing platform fees automatically. Drop your transactions in, code them once, and your Schedule E line items populate themselves. That is the difference between an expense log and a tax-ready system.