Skip to main content

Hotel Reservations - Free Excel Template



As an extension of my reservation spreadsheets, I made this hotel reservations spreadsheet with the same template of my car rental reservation spreadsheet. You can use this if you manage a small hotel or rooms and you don’t want to use any complicated software to manage your reservation.
The guidance on using this spreadsheet is about the same with car rental reservation spreadsheet, where I re-type it as follows :
1. Go to availability worksheet and put your room type and number in the corresponding column. There are samples there that you can modify. You can continue the number by putting your room information and the reservation column will be revealed automatically.
2. Put your start date reference. This start date is used for the scroll bar as its scroll start date.
3. There are two dates next to the Hotel Availability Table title to help you monitor the reservation window.
4. All reservation information in that window will be differentiated by the color. The blue color means that the room is available on that date, red color means that the room is reserved, and yellow color means the room is double booked, so you have to adjust the reservation.
5. Once you see that the room is available on customer requested date, go to Room Reservation worksheet to fill your customer information.
From: exceltemplate.net
  Download   Demo  

Comments

Popular posts from this blog

inove - Free Concrete5 Theme

inove is one of the most popular themes that are available on wordpress website. It has thousands of downloads and most users rate this as excellent skin for their wordpress blog. The theme is universal - it can work for many websites, not only for blogs or personal homepages.

Wedding Checklist (2) - Free Excel Template

From: weddingguidance.com

Dark 'n Bokeh - Free Blogger/Blogspot Template

Dark 'n Bokeh its a cool Blogger template with a nice colorful bokeh background and transparent post content which make this template to look awesome.