Collaborate on Hotel Bill Book Format for Management with Ease Using airSlate SignNow

Hotel bill book format for Management

welcome friends to Excel beginners and advanced tips friends hope you are all well and our of coronavirus friends at present we have to follow the guideline of our nation as well as the guideline of the World Health Organization to fight against these virus and hopefully friends we will overcome the situation and we we will conquer so friends today I have tried to develop a software for maintaining hotel rooms so let us start friends at first I want to see I want to show you the software clicking on option enable content the software will start from this menu here friends you can see a menu and within the menu there are some common buttons I have given the name of our company ABC Hotel Company Limited and here and from here we can inquire the rooms and check-in/check-out visitor and courier exit friends at if we click on the room in query just click here if anyone this form will be loaded user from one you can see and friends here you can inquire the rooms inquire for rooms suppose anyone come to the hotel and works a single room bedroom and for a ground floor just like this now search bed you can see friends room number one bed number one and rain one thousand and room number three bed number four and one thousand here friends I have many rooms I have added items in this combo box you can see single bedroom double bedroom and dormitory here friends floor you can see ground floor first floor and second floor and friends now if I want to book room one a bed one of room one then I will select it and go for booking click on the booking here friends another of formulas are from two will be loaded and as soon as I clicked the click the booking here you can see friends floor ground the captions on the above category single room number one bed number one rent already automatically come here under the levels and the date current date if I change I can change the current date here friends I can change the current date or anything say it is 21 to the first March 2020 and here friends I need to give the contact number say the contact number like these [Music] two for and like this and mr. name say the visitor named Robin address say inland here first no need of typing proper in proper case it will be a proper automatically and purpose visit say Tori and and the national ID passports I will service ID other another document can be produced by the visitor so I click on the national ID as for example and national ID number say a X 2 5 8 9 and and if anyone wants to take a worse to wants to read the room for 7 days that will be 7000 for 7 days and give any advance say type thousand advance or say the check in debt as the check in get is 22 fast so today is to the 4th that means it is pretty fast to 24 that means the three days that way so I am 3,000 total old with 3000 and 22,000 advance and if I click on the checking check-in button see our database has been filled with the records there is a records that you see that records taken date visitor ID this is the full number name Robin you can see the proper casing land and purpose to photo document national ID the ID number is X 2 5 8 9 advanced 2004 floor ground category bed number 1 rent already inserted you can see friends other other fields here just closing it for this moment friends other fields the flow don't need to close it there are other fields some other fields and their fields will be will be filled up gradually here friends just closed it and you can see the room one of a room one a bed one row or the bed one of room one has been booked closed again the main menu will be appear and you can you cannot find the single bedroom of room one room one single bedroom in there in the room in the floor you can say flow in the ground floor you can't find now so you can make if you want to make it quietly just go to the enquiry and single bedroom ground here you can see this is the ground column number nine ground floor and you will not find this such bent see friends only bed number four room number three ground floor only dog number room number three and bed number four it is only remained so friends does we can see the how many rooms are remaining unbooked so those friends just going back just I am showing the software checking I have completed a check out here if this if these visitor was to check out he needs to give visitor phone number either bed number so II I am giving the bed number first one and find see friends total three days and then I will check out I am checking out check out see check out done and then bill here you can see the bill generated automatically you can see the total details of the visitor named visitor ID name address room number category bed number check-in checkout and number of days stay read one thousand among three thousand GST if 18 percent GST therefore it will be five hundred forty more so three hundred three thousand five hundred and forty-four to be paid by the by the occupant and friend here you can see advanced 2000 paid and rest amount 1540 total 3540 and here do you need the seal of the authority so friends I'm just going back this report will be generated I am just going back and friends now I will tell you how I created this software and the cover and the codes behind the software so friends for this moment I am closing it to show you my codes here just drilling this all this friends here you can see I have three sheets only only force is one two three and four here you can see friends here this is the bed information or you can say bed bed master database and here I have I have these rooms room number one - I have taken the reference I have taken the example of ten rooms one room one ground floor single bedroom a bed number one and status is blank at present and when we will check in the status will be booked automatically the status will be updated and read this is the bed information much it is the master database friends and then I have another sheet this is the visitor sheet here all the informations of the visitor will be recorded like this here I have taken a nineteen column visitor sheet we can see the columns chicken dead visitor ID name address purpose of the visit photo document photo ID number advance I paid floor category room number bed numbers checkout date total days you can see here rent but the amount GST and just the amount here the net that means the total of amount and GST - advance and transaction already here I have given a column names and transaction ID so that with the ID we can handle the database if needed further here I have a sheet this is the sheet you can see I have created a model report form and here in the cell I want to I want to insert the required fields as well whenever when the checkout will be taken place and now friends here you can see the sheet one another sheet is a blank sheet and it and on this blank sheet our menu will be activated main menu will be activated on this blank sheet whenever the program will be loaded so friends here going to Developer tab and you can see visual basic and you can see friends I have used these user forms one two three four and five these are foreign friends double click it just you can see the bed this is a combo box floor these are other combo box and some common button search bed booking refresh and here you can see some levels room Lombard bed number red and here is another level for displaying the current date and friends here is the list box friends to to add the items in the bed that is single bedroom double bedroom dormitory I have added an floor ground floor first floor second floor etc and for these trails going to initially going to its initialize these are from one dot initialize just you can see for displaying current date in the level 12 here it is the level 12 friends this is the this is the level 12 you can see level level to sorry level to this level here you can see the level 2 dot caption is equal to format dent this format will be displayed DD mm and YY whatever the form will be loaded some other things will be will be loaded automatically that means combo box one dotted atom single bedroom similarly double bedroom and dormitory friends and for adding floor you can see friends combo box 2 here in the user from one ground floor first floor and second floor this is the code friends hope you can understand these codes if you see my last videos you can understand the codes I am sure for initializing for initializing there is a form at the time of initializing there is a form the following things will be loaded automatically into the into the concerned on Hillary related controls okay friends so our you can see here loaded from loaded and these are automatically loaded as I showed you in our initialize event of this form here friends if I select it single ground here Sarge bade here in the Sarge bid option you can see only two rooms room number one but number one and room number three but number four there are all the single bedrooms caracal see our mains database bed information master we can see friends this is single double double single double these are the bed bed numbers bit numbers starting from 1 to 17 only 17 bits within 10 within tenth room within 10 numbers of room I have taken the example of this database I have taken it as an instance so friends if I click on the search button just select any room any room and we search sorry just before that I want to refresh it first single bedroom and ground floor search here only if we require new search then we need to refresh it first so friends single bedroom ground floor search here you can see just I want to select this and going for booking just I also going for booking and friends at the time of clicking the search button you can see our our required data is being displayed ground search so what is written the code in the search button just I want to display so you first Sarge button here you can see friends here friends it will be displayed from sheet to all the records all would have spent here the records will be displayed from sheet - so this is a sheet to friend sweet one and this is it - that is the bed information master you can we have to follow this database first for getting the search item here here we need to go to the we need to go to the total rows we need to calculate the total rows but I did have situate it or look at it and for then I have used a for loop for I is equal to 2 to 0 you can see the difference friends don't forget that this is the sheet reference of - I will take the reports I will take the reports into the list into the list box here in here in the list box I will take the liquid data from to the list box from sheet 2 so I have taken the leaf and a sub C 2 and you can see friends I have 2 combo boxes in these are from 1 so here combo box 1 dot if I have taken another if statement condition if combo box 1 dot value like XI two dot cells I comma 3 that means the category a bit you can see you can see this is 1 2 and 3 number call a column that is category so if it is combo box 1 dot value I will select from the combo box and if it is like the column third of second of the second row of sheet 2 and combo box 2 dot value that means combo box - what is comma box tool we can see the flow here is the you can see the floor you can see the floor both need to be matched both need to be matched then search bar search option Lulu will be will will extract the report so going back floor search and leave the comma box student value like sheet to door sales 1 comma 2 here you can see it's going to sheet 2 here you can see there's the second column that is floor and ground floor first floor second floor etc so friends if this value matches with this value with these values up - and friends another thing if she to door sales I comma 5 that means I cooperate this the status if the status is booked it will not be shown because it is it is booked here if first friends you can see the all our blank at present so the matching record will be seen and the blank room will be shown and if anything any room will be booked the records will not be shown therefore we can tell how many rooms are by floor of the of the required category is found blank ok parents just going back there for friends EEP and and another kind of criteria I can see XI two dot cells are 5 not equal to boot then then friends come released box will be activated that means this box will store three columns will create three columns here pleased walks out column called is equal to 3 and list walls water add item these things will be added that wins the first column here will be added with the data of these of this data that means the first that go is the first column up sheet 2 you can see the first column poor column and for 6th column first column here see - you can see room number and 1st 2nd 3rd 4th bed number or 6th red here therefore this column or list box will be assigned these values this column of the second column that means second column will be assigned this value and the third column of the list box one will be assigned this value and if next I I have concluded the for loop here and the if statement here and if and next time this is the code friends to display the search item you can see friends again just single and ground-floor searched you can see the required items has been entered in our list box one has the inference now we will proceed to our booking and if we want to book room number one or door number three we won't just click click on the list and then going for booking you can see friends all the items all some items already come into a comment are the levels showing above in the red color you can see and there and then I need to type I need to I need to fill the other other fields so here friends how it is automatically coming how it is automatically coming the records under the levels so to I want to clarify this friends so going back to the and here you can see another thing that is the current date is being displayed here so friends just for displaying the current dates and and that and all the data under the levels so I am going back and here you can friends when to booking booking here you can see you can see friends the double the least the the you can see that list box one not least count that means the list box one of these userform the list that that that will be selected that will be selected and when for booking and going for booking here here for X I have taken a for-loop X is equal to list box 1 dot least count minus 1 that means the total list here you use of a 1 dot lvl category these are the names of the levels friends which were which were displayed in the user form you can see here to which are displayed in the user from two at the red color level you can see so friends going back to one gain and booking user from two dot level category level caption will be the will be as I has been assigned the value of this combo box value combo box one dot value that means the combo box one that that means the what is that combo combo box wanted value bed just a single bit double bed single double and dormitory etcetera and then floor like these so friends going to booking here here you can see the levels will be as I has been assigned the value like this this is a value and this will be like this and room number will be the value taken from the list box the first column of Leesburg that is 0 that means list index 0 means the first column list index 1 means the second column of the list box and list index 2 minutes third column of the list box this value will be has been assigned to our captions displaying in a red color ok friends and then I have unloaded user from one another from two dots show again then I need to show again that user from two for further entry for information and other things so going back to the user from one again again friends I am going to signal and ground floor such bed you can see here if I select this number one room number one bed number one and going for booking see friends user from two we can see has been loaded and these levels also loaded here and the data under this levels also loaded automatically here and date of tion will be loaded friends as soon as the user firm will be loaded so you can find this in the initialize event we can see here or visible to debt you can see the initialize event has been loaded and loaded the date and this format is DDM a wire in the first text was okay you can see this and here friends some other items need to be added user from - such as national ID passport service ID other you can see if i click on user from - here just just for this view you can see here these combo box has been added the following items all the initialized event of this user from - so going back to the fray go to the first user for friends again so single and ground-floor and such bait and I want to book this bed and going for booking then this data will be filled automatically and now I want to put the contact number such as 2 4 3 5 any contact number 6 5 8 9 - 0 and visitor name you can say visitor named Robin again take an example address say India and purpose you can say treatment purpose and photo ID here photo ID you can say is pas 5 9 8 7 anything can be or advance if I want to stay if this is visitor or occupant want to say want to stay for 7 days that means it will be it will cost for 7,000 rupees thank me because the rent is 1000 per day so he give if he gives 500 500 500 or sorry 5000 5000 and going to check in see friends room number one but number one rent one here you can see the follow you can follow the bed number one number bed will you booked checking so friends if just close it and going to our bed number you can see the booked option has come automatically here because the bed number one has been booked just a little bit more so this room will not be displayed at the time of search or enquiry okay friends so those friends I am booked I I have booked that first I have a booth the first bed held friends now going to the second home second and again if I want to book another just going back to our bed numbers single bedroom and say first floor search or single bedroom ground floor okay if you click sorry just just to search anything first refresh single ground and search you can see only room bed number four is remaining in the ground floor that is wrong number three and if I want to book it also just going clicking here and if you don't know I don't want to book this let's refresh it I want to book another floor single and first floors so you can see there are two two a bed that is bed number seven and with number 10 pet llama 7 is room number 5 and with number 10 is room number 7 so I want to book this and going for booking so see friends and if I check in here so Peter name a contact number you can say anything can be contact number and Peter by Peter the name of the occupant address or rohban you can see another Robin and he's from England here friends purpose visit or to tourist and here's a piece ID say anything like this like this as you want and adverts if you wants to stay for say five days you can give advance three thousand check in here friends if I close this for the stands just went to bed info you can see this cell has been booked this room this bed number bed number has been booked you can say bed number this bedroom at number seven first floor and bed number one up ground floor has been booked and this will not be seen if the inquiry anyone wants to inquire the rooms so friends going back and going to the affirm to now we have completed chicken and now another thing that is check out here you can see friends the userform here these are from three and to check out friends you need to put the either bed number or the phone number here so here you can see the level and textboxes controls you can see friends I hope you can create this and you will you will be able to create this such form design this design such form friends you can see that here you can entry the visitor phone number and bed number and check in debt will be kept will be will appear automatically and the checkout date will be the current date friends ok and check-in ID here it will be displayed check-in ID and here bed number would be automatically displayed and the difference of the check out - check check in date will be displayed here so friends first you can go just just to run this first if I want to check out for 7 bed number 7 find was find you can see total is zero because that check in get 24th and checkout date 24th if friends for example if I change check-in debt here in the visitor sheet here you can see the first column is a check-in debt here if we you can see it is it has given here the advance how many advance 5,000 so for at least for 5 days so if we change it 19 or 18 [Music] the text type and this is the 24th three thousand to four it is 20 here so I am forcefully changing the chicken yet so that the result should see we can see seven but number seven fine here you can see the total day is four but number seven total days shake our check-in date bit number 7 that means advance given only well what is that what she does okay so friends here you can see that bed number seven and total days for and to get these how it how the find button works just click on just click on back and go to the find you can see the course here it will take the value from the sheet three here so I have taken the reference of sheet three I I calculated the total rows of sheet 3 here you can see and then for X is got the four to Tito and here I have given the condition friends if she treat ourselves X comma to that value like this means X comma two you can see here see three here visitors it the value will be checked with value either whatever either visitor ID or friends you can see the two column two here visit ID or bed number here color bed now bed number that is two column twelve these two columns will be checked either this or this so for these friends I am going back and see treat ourselves X comma 2 dot value like the value of user well that is converted the phone number that is the phone number that is the ID I have taken the phone number phone number as the idea of the visitor so friends this Val or these she receives X comma 2 L that means the bed number like the values are from three dot bed number be Co bed you can see here if it matches then the following records will be filled up automatically here is a form the date will be here you can see the current date automatically chicken there sorry this is the chicken yet indeed you can see c-4 check over out I in debt means check and it will come from the sheet three here first column you can see the chicken dead here here is the chicken dead check in there it will display automatically in the chicken dead text box here check out debt will be automatically displayed the current date and user found three dot and here you can see the check-in ID that is X comma nineteen checking ID you can see friends and he is starting from one to like this the check-in ID will be will be required if we want to if we want to update or delete the records in future this ID will be required so I have taken a field named transaction ID this is our ID number so this is the nineteenth column I have kept it further if you need it then I will use it use this idea so friends going back and this is the ID will be displayed and then the bed number you can see will be displayed from this 12 column of this sheet here you can see say three all informations will but will be taken from this seat from this sheet 2 sheet 3 that is the 12 here you can see but number will be displayed which bed automatically expect again lab again friends then total days total days this is the here you can see the total days here this is the total days here this here in this level the difference of check out that a chicken debt will be displayed that will use the number objects here you can see the number of dates this is total debt equal to the bail function I have used to convert this figure into the value that is check out debt debt to value check out debt - check in debt that is the difference of checkout date and checking debt is equal to total days then I have and if and next I concluded it so friends does the find common button works similarly friends well as you will check out you can see wait well I will check out then what it will be displayed then going back to seven and file for at first I have to find yes then I need to check out this will be the check out that means you can see the bed number seven will be checked out check out just going to click here check out done successfully okay here friends you can see if we check out remember the bed number and just closing it for the first for this moment going to bed number information you can see friends and the final checkout not been done and here check out what is displayed here you can see total it will it will take the information from sheet three so so the check out will be you can see the all that other other calculation all the calculation will be taken place which was not calculated in checking option here here you can see up to column twelve was filled in checking option here here is she checking where when I use user from two but when I use is a from three all the remaining columns all the remaining columns will has been filled up you can see all the remaining columns has been filled up you can see the column lava thirteen check out date total days but end but the amount GST net amount to paint you because because this is an a Timon because this is the total - advance is equal to net amount more amount more 1720 amount twenty rupees need to be paid okay friends this is the check out this is the check out for this is the action of the check out to fill these remaining fields okay friends these remaining fields okay so check out completed friends you can see thus this column this column of the column will be filled up with these values debt check out date at total days LVL total days you can see the caption and this is the amount and this is the GST 18 percent and this is the net that means the total that will 16 that means that means is the it is there is the calculated value 60 of column 16 plus 17 that was GST and - you can see here that Vance so mrs. box check out done and if next this is the check out water banks and here friends in the build but earlier here if I click on the build button these things will be prepared report will be prepared and before that friends you can see total row you can see here when I will click on the blue bill button what happens there just going back and if I go to 7 find then check out ok done if I click on the build button friends see Bill just going to build button here the report will be generated how the report will be generated has been generated just see these friends going back and and these are from sorry user from three here is are from three and Bill Burton bill common button you can see the T dough up sheet to higher I have created III have I have unhooking unhooking the see to cause whenever I click on the build button will generate whenever the bill will be generated the book booking or book or book booked will not will be removed and will be free for text booking so I have already created click on the book button just to see the room bed number seven bed in first second here you can see friends seven booked has been deleted booked has been deleted so this year this will be open for booking again to do these rails just I am going to sheet 2 I'm going to sit - here here you can see and to-220 EEP here you can see bed numbered matches here you can see bed number it matches but number seven has been matched and then it will matches the with these with this value that means XI two dot X comma four that means the fourth column here it was masked it was said here in this column then it was booked if it was matches and matches then XI two dot call up I'm sorry report column in bed number actually this the bed number friend sorry this is the bed number here this is the bed number seven matches then the column pipe that knee column this is the fifth column will be unbooked will be blank for next booking this is this de code this is the code she did our cells x comma v is equal to blank that means booked will be vanished and E and difficult and then friends it is very easy to print the report you can see I want to print the report taking the data from the sheet three taking the required data from the ship three here I want I have created report in sheet for here you can see Bill suite for here this is the she code here friends this is the registry to fall here friends the report has been generated as soon as I click on the bill comment button here I have already designed this and this is automatically this will come the value will come automatically and here you can see the advanced a pair paid and total amount is 4720 an advanced paid three thousand arrests about 1720 total this amount has been paid so friends just see so I have taken only the cell range Oracle say the cell name b2 b3 b4 b5 of for all array all cell name has been taken to be assigned and Al has been assigned the value option of these from sheet 3 or these records of this data from 3 you can say these cells a sheet for has been assigned this is the first column number to exceed 3 what was in the column number 2 option 3 because they go to the visitor sheet sheet 3 : / - I have given the column well for better comprehension this is the name Carano - so this the qur'an / - this is the visitor ID then three rubber name then for columnar for India or England whatever related or masked with this bed number seven this is the color ID it is a Robin inland okay like this all these has been taken in for printing into the respective cells of for you can see the sheet for all the for the names of the cell and the cell has been assigned we these records from the sheet 3 okay gasps friends those friends this is that this is the you can see this is that the f16 that was f-16 another I have taken f-16 go to the bill here here you can see this is the what is the f16 f-16 f6 sorry this is the f6 this is the f6 total this is the f6 everything it this will be the amount plus GST so this is written we can say you can see this is the amount and this is the plasticity from sheet 3 like this rails I have taken these reports taken this data into the sheet 4 into the report sheet and b9 you can see the total amount that means the total amount including GST here including GST you can see in this reference including GST sorry including GST and - b8 that means what was in the b8 this is the advance here you can see the b8 here little c b8 here and advance is taken from the column 8 of the cell 3 this is that Edwards you can see go back and visitorship and 8 you can see here this advance for as well 13,000 the Ospreys I have taken all the data from the sheet 3 to 0 and then I have ENDIF and next and then I have unloaded user from unloaded user from and unloaded user from 3 and unloaded user from - all these are from Hezbollah are loaded and unloaded unloaded from one everything has been unloaded and then she told that print Balu you can so you can see the plain view here and the other one not show again is about 1 will be shown for ready for enquiry - friends I have done this bill command button codes and again friends you can see here a refresh button if we refresh it you can on you replace all that all the items phildee these are from three everything will be will be refreshed so friends just going back to the again I want to replace it for you just seven just if I see refresh anything you can write write write write difference just it will be it will be ready for taking the values this is the code of the flesh just unload this and show these so friend just we have completed user from three and is affirmed for you can see here first ABC what will visitor search if any visitor another visitor comes and want to search the about our occupant we can search it so if anyone if anyone asked me again er as the enquiry counter to search the name of this of this suppose this Robin Robin from India Robin from India okay so going back and double run it name Robin I have to type the name whatever case it may be and for India search see you get a front table can tell him or can ask can tell him that his room number is two one ground floor bed number one just to search if anyone was to come to meet Robin in the hotel and inquire the room number we can search this so to see the commands friends this is the course here friends in the user home for if you know on what come to search any occupant so within this case we will use this form going back and search and it will take the value from sheet three here friends and if application that world should function that and you can say here is the name here this is the name this is the this is the eighth name that means the such name and such address so and here so I have given last name like she cheat ourselves X comma 3 and the address like she T comma 6 comma X comma 4 that is the fourth column well the address is situated in the ship 3 then it will be first then a list box has been taken if a pipe column list box and adding item here like this from taking for the first column cell that is X 3 it will took the value from X 3 here you can see it 1 2 3 this is the name del address then value will be taken to a room number where the room number room now a floor 9 room number 11 9 11 and 12 here you can see friends 3 4 9 11 and 12 these items are required to tell him or to view the occupant last attribute occupant okay so so friends thus I have created this only taking a taking a leader taking a taking some contours text boxes and list box or such command button so name again I am giving say-so say Robin India here this is item I only only deliver the item only the records of Robin from India are being displayed okay friends so friends does we can search any any visitor any other does any visitor can can find find the their friends if he or she wants to come to inquire to the hotel about his about his or her friends okay so that's where you can search it and hear friends I have just created this simple menu and just are from this menu we can operate it like this just this caracals see the unload is are from five that means the menu and this is the first user form to show the first user from and then I want I unloaded the user from and again so there is our form here when the from will you closed I did not use exit button I want to close it like this like this then again whenever when I click this the five will burn loaded that means the menu we are unloaded and this form will be is are from one will be shown and when I cross it the user from one will be unloaded and five that means menu will be shown again like this and here check it don't have you get the forms friends I have created this menu like this to navigate within the forms like this so friends Harley if I click on the exit button the application I will exit from this program ok friends and here friends you can see this workbook here you can see sheet one detective activate and is about five dorsal so whenever the for the file will be loaded sheet one that was a blank sheet will be activated here this chip would we activate it and here on this sheet the menu will be displayed so friends these are the code friends you can see again again you can see these are the these are the forms one two three four these are the form one to two maybe a hotel ABC hotel room check-in and this is the checkout and billing and this is for in Korea by prey by the friends or relatives of the visit of the of the occupant okay that is the menu so these are the codes friends and the course I have written the course here you can see within the forms here this is the codes you can see this everything is written very simply as far as I have understand I have understood so friends this is the course friends and just see friends these are the sheets used for you use for this program use these seats only one two and three only three sheets used for this program so friends if I again you can see the bill a bill has been generated for room number seven bed number seven you can see here it is the bed number seven and if anyone are again come here just going if any one again come here if any one again come to inquire for the single bedroom ground-floor you can't find this you can the first floor oh sorry sorry check in first floor check in a room and query single single first floor search bit yes you can find this again because the the the booked option has been deleted as the bill has been prepared that which as the checkout and billing has been done for this record just little earlier I showed it so you so friends this is the idea and this is the coding sprints if it is just practice this and if you have any question please make comments I will try my level best to answer your question friends and thank you very much friends for staying with me and if it is little helpful friends please subscribe this channel and it will be great it will be great boost for us Thank You friends thank you very much again