An Excel workbook (XLSX) for hosts, B&B and guesthouse owners and small property managers with 2 to 6 properties. Type each booking once (property, guest label, check-in, check-out) and pick a month: the Calendar sheet draws every property night by night, marks turnover days when one guest leaves and another arrives the same day, and flags free gaps of 1 or 2 nights between two bookings (you can set the limit from 1 to 7). It also shows occupied nights, occupancy and overlap warnings. A BLANK workbook and a DEMO workbook with fictional data come in English, Italian, Spanish, French and German. It is not a channel sync: nothing is imported from booking sites.

The problem it solves

Bookings sit in separate calendars and notes. It is hard to see at a glance which property is free, where two stays touch on the same day, and which 1 or 2 night holes are too short to sell.

Who it is for

Hosts, B&B and guesthouse owners and small property managers with 2 to 6 properties who keep bookings in desktop Excel and want one monthly picture.

What you get

• One monthly grid with up to 6 properties side by side, night by night, for any month and year you pick
• Turnover days marked automatically when a check-out and a check-in fall on the same day, so you can plan cleaning and handovers
• Short gaps of 1 to 2 free nights between two bookings flagged (limit adjustable from 1 to 7 nights), to help you decide on a minimum stay or a discount
• Overlaps, missing or reversed dates and unknown properties flagged in a Status column and counted on the Calendar
• Per property and in total: occupied nights, occupancy for the month, turnover days and free nights in short gaps
• Simple input: one list of up to 300 bookings with a property list, date checks and locked formulas
• All files in English, Italian, Spanish, French and German; start from the BLANK workbook or learn first with the DEMO

How you use it

1. Download and unzip, open the folder of your language and try the DEMO workbook first.
2. Open the BLANK workbook in desktop Microsoft Excel and save a working copy. In Properties type your property names; in Setup choose how many free nights count as a short gap.
3. In Bookings add one row per booking: property from the list, a guest label, check-in and check-out dates.
4. Open Calendar, pick the month and the year, and read the grid, the totals and the number of bookings needing attention.

Questions