What is included
- Reservation records and a monthly room calendar support up to 30 rooms and 2,000 bookings.
- The dashboard summarizes arrivals, departures, occupancy, guest balances and recorded room revenue.
- Dated rate history preserves applicable nightly rates, room types and tax settings for earlier stays.
- Includes Google Sheets and Excel; the reservation form and Front Desk actions are Sheets-only, with direct table entry in Excel.
Based on the Etsy listing reviewed October 28, 2026. Check the current listing for any later changes.
What to prepare
For the workflow this product is designed around, gather:
- Room identifiers and confirmed reservations
- Check-in and check-out dates
- Reservation references for subsequent changes
A practical way to use your records
Set up consistent room names before recording stays. Enter confirmed dates and review availability against the original reservation records whenever a booking changes. Decide who is responsible for keeping the spreadsheet current if several people handle reservations.
A worked example
Fictional example: a three-room guest house checks availability for one evening before confirming a new reservation.
- Rooms available to sell
- Rooms 101, 102 and 103
- Existing reservations
- Rooms 101 and 103 occupied on 18 July
- New inquiry
- One room requested for the night of 18 July
- Confirm that the reservation dates use the same arrival-and-departure convention in every row.
- Check the room-level calendar, including any rooms taken out of service, before changing the inquiry into a confirmed booking.
Result: With no room out of service, Room 102 is the single remaining option for that night. The spreadsheet supports the availability review; this example does not assume automatic channel-manager synchronization or online reservation acceptance.
Fictional figures explain the workflow; they do not represent customer results or guarantee particular template fields. See the included features above and the current Etsy listing.
A closer look at Hotel Reservation Tracker & Room Availability Calendar for Google Sheets and Excel
Additional previews from this product's Etsy listing. Open any image for a larger view.
Questions about this product
Can this be used for a guest house or B&B?
Yes. The booking calendar is intended for hotels, guest houses and B&Bs.
Is this an online booking engine?
This is a reservation and room-availability spreadsheet. If you need live booking acceptance or channel-manager connections, confirm those requirements before buying.
Which spreadsheet formats are listed?
This product is described for Google Sheets and Excel. Confirm the included files, software requirements and delivery instructions on its current Etsy listing.
