Airbnb Host Income and Expense Tracker Spreadsheet

Airbnb, Vrbo, Booking.com and direct bookings all pay you in different places, at different times, minus different fees. This tracker pulls every payout and every cost into one workbook, so you always know what each property actually makes.

The Property Performance tab shows occupancy, average nightly rate and revenue per available night for each property — the numbers that tell you which listing earns its keep. The Dashboard rolls the whole year up month by month, and the Annual Summary sorts your costs into tax-time categories.

WHAT'S INCLUDED

• Income Log — payouts from every platform, per property, with nights booked

• Expense Log — cleaning, supplies & linens, utilities, repairs, platform fees, insurance

• Money Dashboard — the whole year on one screen, updates automatically

• Property Performance — occupancy, nightly rate, revenue per available night, net per property

• Annual Summary — tax-time totals by category

• Settings — your properties and categories

• Quick-Start PDF guide

FAQ

- I have 3 properties — will it cope? Yes. Add a row per property on Property Performance and tag every log entry by property.

- Do I enter gross or net payouts? Net — what actually hit your account. There are category rows for the fees you pay separately.

- Sheets or Excel? Both. No macros anywhere.