STR Income & Expense Tracker: Excel & Google Sheets

Know your real profit per property, every month. Built for Airbnb, Vrbo and direct-booking hosts with 1–10 properties.

WHAT IT CALCULATES FOR YOU

- Nights, gross revenue and net payout for every booking

- Monthly occupancy, ADR (average daily rate) and RevPAR: the numbers pros price by

- Net profit by month and year, for one property or all of them (dropdown switch)

- Cleaning fees collected vs. cleaning costs paid

- Lodging/occupancy tax you owe (if you remit it yourself) + an income-tax set-aside estimate

- Expenses grouped by IRS Schedule E line, per property: hand it to your tax preparer

- Mileage log with deduction

- Charts: revenue vs. expenses vs. profit, and occupancy by month

BUILT RIGHT

- Dropdowns for properties, platforms and 20 host-specific expense categories

- Missing receipts are flagged red

- Tested formulas; works in Microsoft Excel and Google Sheets

- Sample-data version included so you can see it working before you start

WHAT'S INCLUDED

- STR-Income-Expense-Tracker.xlsx (blank, ready to use)

- STR-Income-Expense-Tracker-SAMPLE-DATA.xlsx (explore with 2 sample properties)

- Tracker-Quick-Start-Guide.pdf

This is an organizational tool, not tax advice. Short-term rental tax treatment varies; confirm with a tax professional.

COMMERCIAL LICENSE

Use with every property you own, plus up to 3 client properties you co-host or manage. Give filled-in copies to guests, cleaners and owners. Not allowed: reselling or sharing the blank templates. Managing more client properties? Email hello@keyandkit.com.

REAL FILES, NOT CANVA LINKS

You download actual XLSX and PDF files that open in Excel, Google Sheets and Numbers. No account or subscription needed to edit.

VERSIONED

Version 1.0 · October 2026. Free dated updates: register your file (link inside) and we'll email you when it's updated, plus a bonus Seasonal Prep Checklist.

INSTANT DELIVERY

Your files are delivered instantly by email and in your Payhip account after checkout. No physical item will be shipped.

How this was made: designed and written by Key & Kit with the help of AI tools, then reviewed and tested by hand (formulas tested with sample data, every page print-tested).

Not affiliated with Airbnb, Vrbo or Booking.com. Names are used only to describe compatibility.

Questions? Email hello@keyandkit.com — we reply within one business day.