Registration of Rooms and Guests
The first feature of the spreadsheet is a tab where will register up to 100 rooms and how many guests as you need.
Afterwards, you will be able to create reservations by simply selecting the guest from a menu, the desired period and also the desired room. In addition, you will also have, on this screen ,the daily amount and the total amount, this data will be used to generate a simple cash flow in your hotel.
The main feature of the worksheet is the possibility to see all bookings by period and see which days that rooms are available.
Then the worksheet automatically compiles all data completed and provide a complete room occupation report month-to-month.
In addition to the expenses related to the reservation that must be registered in the reservation tab, you will also have a specific tab for your hotel’s general expenses such as purchases, maintenance, staff, property, etc. It will be accounted with your income to form the cash flow.
Finally, the worksheet allows you to issue receipts that are automatically filled in and ready for printing for your guests. And you can choose to post this receipt on behalf of the company you are paying.