HotelSoft Files

Hotel Soft 1.2 is a free open source software for the purpose of all common functions of operations of a hotel
day to day activities.As requested by the users working worksheets are now unlocked with the unlock option in
main menu right side below File Unlock View And Unprotect Sheets. Click it to unlock working sheets. Now you
can easily view those sheets, edit easily. First unzip HotelSoft1.2Acs.zip to any folder, preferably c drive HotelSoft1.2Acs folder. Please keep all the room pictures and the small company logo image file in the same 
folder with HotgelSoft1.2Acs.xlsm. Now simply you can change the room picture with your but the size should be
306 x 193 pixels.

This software Permited for free of charge, to any person obtaining a copy of this software and associated documentation files
HotelSoft1.2 zip software as much as they want. But they can not modify it and publish it under their own name. 
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT  LIMITED TO 
THE WARRANTIES OF MERCHANTABILITY,FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT,
TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE 
SOFTWARE.

This Workbook Contains VBA Macro for each sub menu. It is made for Windows 64 bit o.s. MS Excel. Open this book and
go to file menu and then excel option. In excel option go to trust centre setting then macro settings and tick for enable 
all macros and in developer tab tick on trust access to vba model.

Create Profile option is for creating and updating company or organisation profile with all basic data. You change it accordingly
and change and then click on submit.
In RoomMaster data option 
After Typing  The  Above  Data  Field  Values  Click On Add To Add New Record. After Selecting Data Values Of Room No Above 
Click The List Of Rooms.  Submit  Before Correction,  Then Correct  The Data  Values If  Any And Click On Edit To Make Correction. 
After Every Action Click On Reset To Reset The Form. Select From Above Data Fields And The Click On View To View The Record.
To Delete  Click On View Then Select Record From The Room List And Then Click On Delete To Delete Of Any Record . 
In RoomAvailibility option you have to pick or choice data from data and to date (in dd-mm-yyyy) format from date picker and 
then click on check availibility. 
In RoomBook option you have to input from data and to data (in dd-mm-yyyy) format from date picker and then click on check 
availibility. This will display the available rooms and then input customer or client detail and click on submit button. This is the 
primilary booking option. In Change Cancel Book option you can change details of the booking by clicking the primary  booking 
 check record  in the book history box.Here you can input payment details and check in or out data and time. The Same check in 
and in check out option is also given in and check out form.
Accodomation billing option is for absolute billing for room charges for staying in hotel with taxes. Here also you can change or
 correct by click correction oiption. After every operation click on reset button.

Booking Register will direct you to BookReg worksheets, here you will get a detail register of booking with total amount paid 
and due.

By Clicking Tour Booking button you will be directed to a form of choice car, tour route, date and time slot.  Here you have to
you can view and  choice those and submit for book car for tour. Like room accomodation you can opt for tour billing, tour cancel
 and print of tour register with amount part there on.

Food Master is for maintaining master records of food available in the hotel.Its name,code,price,stock,order,order for preparation 
is incorporated here.
Food order is for customer order for food and after ordering food when the food bill will be prepared atomatically  the  order  
list  will appear in the "Consume" worksheet against the client's order. In "FoodOrder" and "Comsume" worksheets there are add 
new,correct, delete and print options each separately.
You can check food stock by clicking Food Stock button and you can display and print of Food Bill Register.


This is for the revised version more revision will be available shortly.
  
Asis Kumar Goswami
Internationally Awareded Free Opensource Software Developer
akgbest77@yahoo.com
2023