Hotel Reservations
Posted on August 9, 2009
Filed Under Calendar |
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.
Since this is a simple template, you can modify it to suit other type of reservations. You can download the file here.
You can read and download my other templates below :
- Booking Calendar
- Car Rental Reservations
- Restaurant Reservations
- Banquet Halls Reservation
- Weekly Calendar
- Bill Payment Calendar
- Monthly Calendar
- 2010 Calendar
Comments
20 Responses to “Hotel Reservations”
Leave a Reply
[...] can read my previous hotel reservations spreadsheet. And if you are clear enough with above short explanation :-)… you download the file [...]
is this free to use forever?
This is a great template. Is there anyway to have it work so that when you enter check in date and you can add how many nights so you do not have to type in check out date ?
Also when you for example have a 3 nt reservation checking in say jul7 and out on 10 jul, the availibilt calender show the night of 10 jul occupied. So on the availibilty chart it actuall shows four nights blocked off.
If there is a way to do it, it would help me tremdously.
Thanks
@ Crystal : Yes, it is free forever
@ Kamal : Thank you for reminding me about checkout date. I just realized that the checkout date shouldn’t be occupy the room. I have fixed that in the latest version. You can download it again. And I will consider about filling the number of nights instead of checkout dates in the next version. Cheers.
Thank you for doing that.Appreicate your help.
Hello:
I was wondering if I could hire your services to customize this template for my business. Please provide me with an e-mail address or phone no so we may discuss.
You can e-mail me the details.
Thank you
Kamal
[...] my reservation spreadsheets on hotel, car, and banquet hall which based on day reservations, this reservation spreadsheet is based on [...]
Hi,
Is there any way that i can link an invoice and receipt to the hotel reservation form?
Thank You
Is there anyway the name of the room occupant can be shown on the availability page so you can see if it is possible to switch rooms, without having to scroll through the reservation page.
And the idea of linking the invoice (and possibly a booking confirmation letter) would be very useful.
Thanks for a great tool. It works really well
Hi again,
In the hotel booking we have 48 room, i have added another 20, but iam not seeing the added rooms in the combo box in the reservation sheet iam only seeing room numbers till 48, can you help with this.
More, i have modified the formula in the Calendar form to let the added rooms shown in it and it works, exept the above.
Thank You
Please advice on how to change availability by use of colour.Changing from blue-available to red-not available.
Thank you.
@ Kamal : Thank you for your offer, but this time I am just making free templates as my hobby and do it in my leisure time.
@ John : Probably later, or you can try to modify by yourself.
@ Tony : I will consider about linking to invoice and receipt, but later. And about your other question, I have answered it in “Booking Calendar” post.
@ Joshua : Read my answer in “Booking Calendar” post
Regards
It is exist a possibility to make an template who can store the entrance of documents (date of entrance, to whom it is distributed and if it is solved, from who it came an so on?)
Thank you
Hello,
I love the spreadsheet. But can I somehow modify it that you can scroll through the whole year, instead of 3 months ? If yes, how then?
Thank you
Great spreadsheets. Is it possible to add the cost for each room and have a different spreadsheet to analyze the income earned etc?
Template very useful but have a problem when trying to add comment for instances paid etc. When I add comment it stays in the same place and moves along with the date when you scroll along. Is there any way to add a comment without it doing this.
Hi,
Is there a way you can explain how you inserted the scroll bar on the top to navigate the dates?
Thanks,
Vijay
Hi there,
May I request if you are working on Jon’s request about having the names of guests in the color coded sheet? I was trying to do a reverse lookup but I haven’t suceeded in it yet.
Thanks,
Vjay
OMG.. these totally work with our reservation people. They no longer suffer migraines. You’re an angel. Thank you so much ^_^
hello, please help!!! this is great but when I change details it does not work it out for me…how can I keep the formula for the red,blue booking etc but change the names in the columns and add more columns?
Thank you