Excel for hotel managers: occupancy by night
A hotel workbook for this page is the list you open before the morning meeting. One row is one night and one room type: how many rooms you could sell, how many were occupied, and the rate of the second divided by the first. This file is not a restaurant cover count, a guest folio, or a staff rota. Those are other lists. Here the question is only: against the capacity you typed, how full was the night. The guide below builds that list. Elyx writes the rate and the flag in the workbook you already keep. You still type the rooms. The trial lasts 7 days, with no card.
Frequently asked questions
What goes on a hotel occupancy list?
One row per date and room type: capacity, rooms occupied, the rate, and a flag. The rate is occupied divided by capacity.
Should I delete last month when the sheet gets long?
No. Filter the date. Copy the sheet and name the copy with the month if you need an archive. Deleting rows removes the check on yesterday's rate.
Does this sheet plan breakfast or housekeeping?
No. It divides two room counts. Covers, guest names, and cleaning tasks belong on their own lists.