Airbnb Host Spreadsheet: Short-Term Rental Income and Expense Tracker for VRBO Hosts, Excel Google Sheets

★ SAVE: this is 1 of 20 spreadsheets in the Complete Landlord Bundle, US edition etsy.com/listing/4599085170 or Canadian edition etsy.com/listing/4599064233

Know what every listing really earns – a short-term rental tracker for Airbnb, VRBO, Booking.com and direct-booking hosts that works in Microsoft Excel AND Google Sheets. For hosts in the US, Canada or anywhere else (the currency is just a label).

Built for hosts with 1 to 5 listings or units.

★ WHAT YOU GET
• BOOKINGS LOG – 1,000 stays: check-in, check-out, listing, platform, guest, gross payout, cleaning fee charged and platform fee. Nights, net payout and ADR are calculated for you. Mark a row Cancelled (a payout you kept), Owner stay or Blocked, and those nights are handled correctly.
• STAYS ACROSS TWO MONTHS, SPLIT CORRECTLY – every night is counted in the month it falls in (Jan 30 to Feb 2 = 2 nights in January, 1 in February), and a stay that crosses Dec 31 only counts its nights in your tax year. Money follows the nights, so occupancy is never overstated.
• EXPENSES LOG – 1,000 rows with 18 editable categories made for hosts: cleaning & laundry, supplies & consumables, utilities & internet, furnishings & linens, repairs, platform fees, insurance, property tax, mortgage interest, software, local occupancy taxes, and more. Assign each cost to a listing or to "Shared (all listings)".
• MONTHLY DASHBOARD – pick Full year or any month: occupancy rate, nights booked, ADR, RevPAR, gross and net payout, expenses and profit, per listing and in total, plus your platform mix (bookings, nights, gross, fee % and ADR per platform) and 3 charts
• MONTHLY DETAIL – every metric for every listing and every month, plus platform mix by month
• ANNUAL SUMMARY FOR YOUR ACCOUNTANT – gross payouts, cleaning fees, platform fees, expenses by category and net income per listing, nights rented, owner-stay and blocked nights, and a cash-basis cross-check by check-in date
• CHECK COLUMNS that flag missing dates, check-out before check-in, typos, fees larger than the payout and overlapping stays (a possible double booking)
• START HERE guide with plain-English definitions (ADR and RevPAR use room revenue, so cleaning fees don't inflate your nightly rate) – set up in about 10 minutes

★ HOW IT WORKS
1. Download the .xlsx file instantly after purchase (Etsy › Purchases › Download Files).
2. Open in Excel – or upload to Google Drive and choose File › Save as Google Sheets.
3. Add your listings and platforms, delete the clearly marked SAMPLE data, and log each booking and expense.

★ DETAILS
• Digital download – nothing will be shipped
• File: 1 × .xlsx (Excel 2010+ / Google Sheets; no macros, no add-ons, no subscription)
• Up to 5 listings and 6 platforms; works with any currency
• Tested formula-by-formula with sample data, empty data, zero-booking months, stays across months and years, and edge cases
• Not affiliated with Airbnb, VRBO, Booking.com or any platform

★ AI DISCLOSURE
This template was designed by me with the help of AI tools (for drafting formulas, layout and text), then reviewed and tested before listing.

★ IMPORTANT
This is a record-keeping tool, not tax, legal or accounting advice. The Annual Summary includes general notes only: US hosts usually report on Schedule E, or on Schedule C if they provide substantial services such as regular cleaning or linen changes during stays (IRS Publication 527); Canadian hosts usually report on Form T776, or on Form T2125 if the services they provide mean they are carrying on a business (CRA guide T4036). Which form applies, what you can deduct and how owner stays are treated depend on your situation, and short-term rental and occupancy-tax rules differ by state, province and city. Please check the current IRS or CRA guidance, or ask a tax professional, before you file.

Personal-use licence: for your own listings. Please don't resell or share the file. Digital items can't be returned – but if anything doesn't work, message me and I'll fix it.