Airbnb Host Income & Expense Tracker Spreadsheet - Short-Term Rental Bookkeeping Template (Excel & Google Sheets)

Know exactly what each of your rentals earns. This auto-calculating Excel & Google Sheets workbook tracks bookings, expenses and mileage for up to 5 short-term rental properties, then builds your monthly summary and annual dashboard for you.

What's inside

• Start Here - simple setup instructions
• Settings - up to 5 property names, currency symbol, tax year, mileage rate, editable platform and expense category lists
• Bookings log - check-in/out, property and platform dropdowns (Airbnb, VRBO, Booking.com, Direct), guest, nights and net income calculated automatically, platform fee, cleaning fee, taxes
• Expenses log - date, property, category dropdown, vendor, amount, notes
• Monthly Summary - 12 months of revenue, expenses, net profit, nights and occupancy for all properties and each property
• Annual Dashboard - total revenue, expenses, net profit, ADR, occupancy %, revenue per property and 4 native charts
• Mileage log - miles and deduction calculated from your rate

Why you'll love it

• Real formulas, no hardcoded totals - everything updates as you type
• Works in Excel, Google Sheets, Numbers and LibreOffice (no macros, no add-ins)
• Room for 500 bookings, 500 expenses and 300 trips; sample rows included to delete
• Clean pine-and-sage design with frozen headers and dropdown validation

How it works

Instant digital download: a .xlsx file plus a short START-HERE guide. Upload it to Google Drive to use it in Google Sheets, or open it directly in Excel.

This is a bookkeeping aid, not tax or legal advice.

This is a digital product. Nothing will be shipped.

License: for use with your own rental properties. Reselling or sharing the template file is not permitted. Template designed with the help of AI tools.