Airbnb & Short-Term Rentals
Airbnb Income & Expense Tracker
Log every booking payout and expense as they happen, with automatic monthly income and expense totals.
- Delivery
- Instant download
- Purchase
- One-time payment
- Format
- Google Sheets
- Excel
- Updated
- August 2026
YTD net income
$21,340
- June$3,420
- July$4,110
- August$3,890
Sample data preview of the Airbnb Income & Expense Tracker spreadsheet, shown for illustration only.
What this spreadsheet does
Payout amounts, cleaning fees and maintenance costs land in different places, so actual monthly performance is hard to see without logging it in one place.
What you can do with it
- Keep a running record of actual bookings and payouts
- See which months are most profitable
- Prepare year-end numbers for taxes
What's included
Sheet tabs
- Booking Log
- Expense Log
- Monthly Summary
Features
- Booking log with payout, dates and guest count
- Expense log by category (cleaning, supplies, maintenance, fees)
- Automatic monthly income, expense and net totals
- Year-to-date summary
How it works
- 1Log each booking payout as it's received
- 2Log expenses by category as they occur
- 3Check the Monthly Summary tab for totals
Who it's for
Active hosts who want an ongoing record of income and expenses, not just an estimate.
Frequently asked questions
Is this useful for tax time?
The Monthly Summary and year-to-date totals give you organized income and expense figures, though you should confirm final numbers with a tax professional.
Can I track more than one property?
Add a property column to the Booking Log and Expense Log tabs to separate totals by property.
You might also need
Airbnb Profit Calculator
See revenue, operating costs and monthly profit in one sheet.
- Google Sheets
- Excel
Airbnb Cleaning Cost Tracker
Track cleaning fees charged versus cleaner costs paid per stay.
- Google Sheets
- Excel
Airbnb Furnishing Budget
Plan and track furnishing costs room by room before you open.
- Google Sheets
- Excel