STR Booking Calendar & Occupancy Tracker — Excel Template
See every booking, every platform, every property — all in one Excel calendar.Managing bookings across multiple platforms and properties gets messy fast — juggling Airbnb, VRBO, Direct, and Booking.com calendars separately means double-bookings, missed check-ins, and no clear view of how your properties are actually performing.This template solves that. Log every reservation in one place, and instantly get a color-coded visual calendar showing exactly which properties are booked, on which platform, and when — plus a live dashboard tracking your revenue, occupancy rate, and upcoming check-ins.What's included: Booking Log — track guest name, platform, check-in/check-out, nightly rate, and automatic payout calculations. Status updates itself (Upcoming, Active, Completed). Visual Calendar View — a month-by-month grid showing occupancy across all your properties at a glance, color-coded by booking platform. Dashboard — automatic KPIs including monthly revenue, occupancy rate, average nightly rate, per-property performance, and a 7-day lookahead of upcoming check-ins/check-outs. Instructions tab — a clear walkthrough so you're set up in minutes. Why hosts love this template: No more switching between platform calendars to check availability. See at a glance which properties are underperforming. Fully automatic — enter a booking once, everything updates. Works in Excel (no subscriptions, no plugins, no login required). Simple enough for one property, powerful enough for a growing portfolio. Whether you manage one listing or a dozen, this template gives you the same command-center view professional property managers use — without the monthly software fee.
Get it → strhosttools.gumroad.com