Airbnb Host Spreadsheet, Rental Income & Expense Tracker (Excel, Google Sheets)
This Airbnb host spreadsheet tracks rental income, expenses, occupancy and profit for every short-term rental you run. Paste in the earnings CSV Airbnb already gives you, and it reads every booking, matches it to the right property and shows your real profit, occupancy and nightly rate for every month. Works in Excel and Google Sheets.
Who it is for: Airbnb and short-term rental hosts with one or more properties who want their real profit, occupancy and nightly rate.
What it does
- Paste your Airbnb Transaction History CSV. Every reservation is read automatically: gross earnings, cleaning and pet fees, Airbnb fees and net payout.
- Bookings are matched to your properties by listing name. Bank transfers and pass-through taxes are skipped, so nothing is counted twice.
- US (MM/DD) and UK/EU (DD/MM) date formats are detected automatically, including dates Excel swaps when it opens a US file.
- Add Vrbo, Booking.com and direct bookings in seconds. Nights and net payout calculate themselves.
- Dashboard: gross revenue, platform fees, expenses and NET PROFIT for every month, with charts.
- Occupancy, average nightly rate (ADR) and revenue per available night (RevPAR) for every month.
- Switch the whole dashboard between all properties and any single property.
- Compare up to 10 properties, and see revenue and fees by platform.
- Expenses by property and category (mortgage interest or rent, cleaning, utilities, supplies, repairs, insurance and more), plus "Shared" costs.
- Set aside a share of your profit for income tax.
What's included
- 1 spreadsheet (.xlsx) with 9 tabs: Start Here, Dashboard, Airbnb CSV, Airbnb Bookings, Other Bookings, Expenses, Properties, Settings, Lists
- Quick-Start Guide (PDF)
- A sample host with two rentals, so you can see how everything works before you add your own
Works with
- Microsoft Excel 2010 or newer (Windows and Mac), Excel for the web, and Google Sheets
- Any currency
- Capacity: 10 properties, 3,000 Airbnb CSV rows, 500 other bookings, 1,000 expenses
How it works
- Download the files instantly after purchase
- Add your properties and their Airbnb listing names
- Export your Airbnb earnings CSV, copy it and paste it in. Add other bookings and expenses, and the dashboard updates by itself.
Quick answers
- Who is this for? It is made for Airbnb and short-term rental hosts with one or more properties who want their real profit, occupancy and nightly rate.
- Do I have to enter every booking? No. Paste the earnings CSV that Airbnb already gives you and every booking is read automatically, matched to the right property.
- Can I add Vrbo or direct bookings? Yes. Add Vrbo, Booking.com and direct stays in seconds alongside your Airbnb bookings.
- What does it show? Profit by month and by property, occupancy, average nightly rate (ADR), revenue per available night (RevPAR) and expenses by category.
- Is there a monthly fee? No. It is a one-time purchase and an instant download, with no subscription. It works in Excel and Google Sheets, in any currency.
Please note
- This is a digital download. No physical item will be shipped.
- Revenue and nights count in the month the stay starts.
- This template helps with record keeping. It is not tax, legal or accounting advice.
- For use in your own business. Please don't resell or share the file.
- Not affiliated with or endorsed by Airbnb, Inc.
- Designed by me with the help of AI tools. Every formula was tested in Microsoft Excel and Google Sheets.
Want the complete version? Rental Property Manager Pro (in our shop) runs long-term and short-term rentals in one file and adds mortgages, depreciation, maintenance, tenant screening, owner statements and a deal analyzer for up to 25 properties.
Questions? Send me a message. I'm happy to help you get set up.
Questions people ask
Do I have to enter every booking?
No. Paste the earnings CSV that Airbnb already gives you and every booking is read automatically, matched to the right property.
Can I add Vrbo or direct bookings?
Yes. Add Vrbo, Booking.com and direct stays in seconds alongside your Airbnb bookings.
What does it show?
Profit by month and by property, occupancy, average nightly rate (ADR), revenue per available night (RevPAR) and expenses by category.
Does it work in Excel and Google Sheets?
Yes. It works in Microsoft Excel 2010 or newer (Windows and Mac), Excel for the web and Google Sheets.
Is there a monthly fee?
No. It is a one-time purchase and an instant digital download. There is no subscription.
Does it work in my currency?
Yes. It works with any currency.
What if I find an error?
Message us on Etsy. You can choose another spreadsheet from our shop, free of charge (any except our Pro editions), and we will fix the error for everyone.
Get the Airbnb Host Profit Tracker on Etsy
More spreadsheets like this
Want everything in one file? See Rental Property Manager Pro.