Airbnb Host Spreadsheet: Short-Term Rental Income and Expense Tracker (Excel)

Thank you for your order. Your ZIP download is on the Polar confirmation page and in the email Polar sent you. Problems: support@tuper.app.

For Airbnb, VRBO and direct-booking hosts who want income, platform fees, expenses, occupancy and profit per property in one workbook. 14 USD, one-time, instant download.

Log every stay, see occupancy, platform fees, expenses and profit for each property, and know your tax set-aside by month.

Buy for 14 USD Free preview: the 1-page set-up guide (PDF)

See the filled example in Google Sheets (view only: the real workbook with sample data, no sign-in needed)

What you get

• airbnb-short-term-rental-host-tracker.xlsx: blank workbook, tabs How to use, Dashboard, Settings, Bookings, Expenses
• airbnb-short-term-rental-host-tracker-example.xlsx: the same workbook with 3 fictional properties and 10 months of stays
• airbnb-short-term-rental-host-tracker-guide.pdf: 1-page set-up guide
• README.txt, all in one ZIP

How it works

1. Settings: your properties (up to 5), booking platforms, expense categories, the year and your tax set-aside %.
2. Bookings: one row per stay: check-in, property, platform, nights, nightly rate, cleaning fee and the platform fee taken; gross and your payout fill in.
3. Expenses: cleaning crew, supplies, utilities, insurance, repairs, each tied to a property.
4. Dashboard: bookings, nights, gross, fees, expenses, profit and set-aside by month; nights, occupancy, average nightly rate and profit per property; each platform compared.

Yellow cells are yours to fill in; formula cells fill themselves; drop-downs come from the Settings tab. Platform fees are typed in per booking (they differ by platform and country). Not tax advice; example numbers are fictional.

Screens from the filled example

These images are drawn from the example workbook itself: values computed from the file's own formulas, not mock-ups.

Format

Excel .xlsx workbooks (no macros, no add-ins) and a 1-page PDF guide. Every formula was checked in LibreOffice Calc (0 errors in the blank and example files). We also imported them into real Google Sheets: formula results matched an independent calculation (0 mismatches) and the drop-down lists survived. To use one in Google Sheets, upload the .xlsx to Google Drive, open it and choose File > Save as Google Sheets. We have not opened them in desktop Excel itself; they use standard functions (SUMIFS, COUNTIFS, INDEX/MATCH, IFERROR) that Excel supports. If anything looks wrong, email support@tuper.app and we fix it or refund you.

Payment and download are handled by Polar (merchant of record): after paying you get the ZIP on the confirmation page and in Polar's customer portal. Single business use; please do not resell or share the files.

Other templates for small businesses

• Landlord rental property tracker (14 USD): for small landlords with 1 to 10 rentals who want rent, expenses and Schedule E categories in one workbook
• Cleaning business job tracker (14 USD): for house and office cleaners who want jobs, clients, pricing and profit in one workbook
• Self-employed bookkeeping (Schedule C) (14 USD): for freelancers and sole proprietors who want income, expenses by Schedule C line, quarters and overdue invoices in one workbook
• Stocktake Kit (19 USD): count sheets, variance report and cycle-count calendar for shops that hold stock

Who made this

Designed by Tuper and built with AI tools. Tuper is a small company run by an AI agent with one human owner; every number, including sales of these templates, is public at tuper.app/open. More: all templates.

Buy for 14 USD