Airbnb Host Spreadsheet, Short Term Rental Profit Tracker, Vrbo Income & Expense, Occupancy Tracker, STR Bookkeeping, Google Sheets Excel

Know what each rental actually earns. Log bookings and bills, and the workbook works out nights, occupancy, ADR, RevPAR, platform fees, lodging tax and profit for every listing and month, then groups the year under Schedule E line labels for tax time.
WHO IT'S FOR
Short-term rental hosts and co-hosts with 1 to 10 listings on Airbnb, Vrbo, Booking.com or direct bookings who want real numbers without paying for host software.
WHAT IT DOES
• Booking log (500 rows): check-in and check-out, platform, status, accommodation, cleaning and guest fees, platform fee and lodging tax, with checks for overlapping dates and missing info
• Nights are split across months exactly; owner stays and blocked nights are tracked but never count as rented
• Occupancy, ADR, RevPAR and average stay by listing and month
• Expense log (1,000 rows) by listing, or 'shared' and split evenly across listings
• Monthly P&L for one listing or all listings, with cumulative net
• Year-end summary by Schedule E line labels for each listing, with capital improvements, lodging tax and owner-stay nights as memo rows
• Host-collected lodging tax vs what you've remitted, with a remittance log
• Personal-use review flag and average-stay figure to discuss with your preparer
• Dashboard with 8 KPIs, by-month, by-platform and by-listing tables, alerts and charts
TABS
Start Here · Dashboard · Settings · Listings (up to 10) · Bookings (500 rows) · Expenses (1,000 rows) · Occupancy · Monthly P&L · Tax Summary · Lodging Tax
WHAT YOU GET
• Instant digital download — no physical item is shipped.
• Excel workbook (.xlsx) plus a Buyer Access PDF with your Google Sheets copy link.
• Works in Microsoft Excel 2010 or later (Windows and Mac), Excel for the web, and Google Sheets (free Google account). No macros, add-ins or subscriptions.
• Fictional sample data is included so you can see how it works. Clear it when you're ready to start.
GOOD TO KNOW
• Formula cells are protected so they can't be overwritten by accident (no password). Light-tinted cells are for your entries, and dropdowns keep entries consistent.
• The Tax Summary organizes your records under Schedule E line labels. Whether a short-term rental belongs on Schedule E or Schedule C, and how depreciation is handled (not calculated here), is for your tax preparer.
• Lodging tax rules vary by city, county and platform. Enter your own rates in Settings.
• Because this is a digital download, returns aren't accepted. If something doesn't work, message the shop and we'll help.
AI disclosure: This listing was made with the help of AI tools. AI helped draft the spreadsheet formulas, the listing text and the layout of the preview images. Every formula was then recalculated and checked for errors before listing, and the preview images show the real workbook's sample numbers.
Please note: This is a record-keeping template. It is not financial, tax, accounting, legal or HR advice, and it does not guarantee compliance with any law, regulation or rule. Check important results with a qualified professional.
Original design by SystemSheets. For personal or internal business use; please don't resell or share the file.