Free Airbnb income and expense spreadsheet

An Excel .xlsx workbook that also opens in Google Sheets. Made for Airbnb, VRBO and other short-term rental hosts. Formulas done, no macros. Free direct download: no email, no sign-up.

Download the blank Airbnb spreadsheet (.xlsx) Filled example (.xlsx) · 1-page guide (PDF)

What it does

• A booking log: check-in, property, platform, guest, nights, nightly rate, cleaning fee and platform fee
• Gross and your payout worked out for each stay
• An expenses log tied to each property (cleaning, supplies, utilities, insurance, repairs)
• Bookings, nights, gross, fees, expenses and profit for each month and for the year
• Nights, payout, expenses and profit for each property; 500 bookings, 500 expenses, 5 properties

How to track Airbnb income and expenses in a spreadsheet

1. Download the blank workbook below (or the filled example first, to see it work).
2. Settings tab: your properties, booking platforms and expense categories, and the year.
3. Bookings tab: one row per stay with dates, nights, rate, cleaning fee and the platform fee.
4. Expenses tab: one row per expense, tied to a property.
5. Open the Dashboard tab: monthly totals and profit for each property.

Use it in Google Sheets

Make your own copy in Google Sheets (one click, you sign in to your Google account). Or upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets. Excel 2010 or newer opens the .xlsx directly.

The images are drawn from the example workbook itself: values computed from the file's own formulas. Example data is fictional.

How we checked it

Every formula was evaluated by a second spreadsheet engine with 0 errors, and the Google Sheets copy shows 0 error cells. The example's gross (32,890), expenses (14,430) and profit (17,483) equal an independent sum of its rows, and the three properties' profits add up to the same 17,483. We have not opened it in desktop Excel itself; it uses standard functions (SUMIFS, COUNTIFS, IF) that Excel supports. This is a record-keeping tool, not tax advice. If something is wrong, email support@tuper.app.

Need occupancy, a platform comparison and a tax set-aside?

This free sheet records stays, expenses and profit. The paid host tracker adds occupancy %, average nightly rate, a comparison of booking platforms and a tax set-aside:

• Airbnb and short-term rental host tracker (14 USD): for Airbnb, VRBO and direct-booking hosts who want income, platform fees, expenses, occupancy and profit per property in one workbook
• 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
• 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

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 is public at tuper.app/open. Free for your own business use; please do not resell the file.