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 :

Tags: booking, hotel, hotel booking, reservation, reservation spreadsheet, room reservation

Comments

15 Responses to “Hotel Reservations”

Booking Calendar | Excel Templates on August 10th, 2009 5:23 pm

[...] can read my previous hotel reservations spreadsheet. And if you are clear enough with above short explanation :-)… you download the file [...]
Crystal Wells on September 3rd, 2009 6:18 pm

is this free to use forever?
Kamal Shah on September 4th, 2009 8:49 pm

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
admin on September 7th, 2009 2:52 pm

@ 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.
Kamal Shah on September 8th, 2009 8:42 pm

Thank you for doing that.Appreicate your help.
Kamal Shah on September 9th, 2009 12:31 pm

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
Restaurant Reservations | Excel Templates on September 12th, 2009 4:29 am

[...] my reservation spreadsheets on hotel, car, and banquet hall which based on day reservations, this reservation spreadsheet is based on [...]
Tony Chaar on September 22nd, 2009 9:14 am

Hi,
Is there any way that i can link an invoice and receipt to the hotel reservation form?

Thank You
John Fisher on September 23rd, 2009 5:58 pm

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
Tony Chaar on September 24th, 2009 1:50 pm

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
Joshua on October 8th, 2009 2:19 pm

Please advice on how to change availability by use of colour.Changing from blue-available to red-not available.
Thank you.
Admin on October 16th, 2009 4:45 am

@ 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
Ion on October 30th, 2009 11:34 pm

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
Lana on November 17th, 2009 4:31 am

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
Skinner on December 11th, 2009 4:18 pm

Great spreadsheets. Is it possible to add the cost for each room and have a different spreadsheet to analyze the income earned etc?