How to Make Hotel Balance Sheet Format in Excel

Get FREE Advanced Excel Exercises with Solutions!

You can do different and versatile work with an Excel worksheet. In this article, I will show you how to make a hotel balance sheet format in Excel. It is a very simple way. Hopefully, you will enjoy the whole procedure. I have added the necessary images with the steps of the procedure. Let’s follow the procedure step by step.


Introduction to Hotel Balance Sheet

A balance sheet summarizes the financial situation of an organization. It illustrates the success of a business plan at a particular point in time. This is accomplished by using a balance sheet, which lists a company’s numerous assets, liabilities, and equity in order to assess an organization’s value and determine whether it is making a profit or incurring losses. Similarly, a hotel balance sheet shows all the assets and liabilities together to show whether the hotel is running in profit or loss.


Step-by-Step Procedures to Make Hotel Balance Sheet Format in Excel

Here, I am going to show the steps to create a hotel balance sheet format in Excel. With the steps, I have added the necessary images for your better understanding. I hope this will increase your Excel skills.

Step 1: Add a Heading

This is the first step of this article. In this step, I will add a heading for the balance sheet as well as two sub-headings. Look at the following steps.

  • First, select cells B2 to F2 and merge them.
  • Select the cell and add the heading.
  • Similarly, merge the B3 to F3 and B4 to F4 cells and add the subheadings like the date and Assets.

Heading of Hotel Balance sheet in Excel

Read More: How to Create Tally Debit Note Format in Excel


Step 2: Input Asset Data

This is the second and most important step of this article. Here I will input the asset data. The first asset is the current asset. Follow the following steps.

  • First, write down all the types of assets in the column.
  • Then, input all the data in the column.
  • After that, select the F10 cell.

Input assets of Hotel Balance sheet in Excel

  • Copy the following formula in the selected cell.
=SUM(F6:F9)

Input assets of Hotel Balance sheet in Excel

  • After pressing enter, you will find the following result.

Input assets of Hotel Balance sheet in Excel

  • Now, enter the fixed asset names in the B12 cell.
  • Then, enter the values in the column.

Input assets of Hotel Balance sheet in Excel

  • Enter the following formula in the F14 cell.
=SUM(F12:F13)
  • Then press the enter button.

Input assets of Hotel Balance sheet in Excel

  • Enter the following formula in the F15
=F10+F14
  • After that, press enter.

Input assets of Hotel Balance sheet in Excel

  • As a result, you will find the total asset in the F15 cell.

Input assets of Hotel Balance sheet in Excel

Read More: Revised Schedule 3 Balance Sheet Format in Excel with Formula


Step 3: Input Liabilities and Owner’s Equity Data

This is the third step of this article. This portion is as important as the second step of this article. I will input liabilities and owner’s equity data here. Follow the procedure step by step. You can have a look at the images attached with the steps.

  • In the B18 cell, input the types of Liabilities.
  • After that, input the values in the column.

Input liabilities of Hotel Balance sheet in Excel

  • Then, copy the following formula in the F20
=SUM(F18:F19)

Input liabilities of Hotel Balance sheet in Excel

  • After that press Enter and get the total current liabilities.

Input liabilities of Hotel Balance sheet in Excel

  • Additionally, input the long-term liabilities in the B22 cell.
  • Select the F24 cell then.

Input liabilities of Hotel Balance sheet in Excel

  • After that, write down the following formula in the selected cell.
=SUM(F22:F23)

  • Then press the enter button and get the result just like the picture given below.

  • After that, enter the types of owner’s equity in the column.
  • Then, enter the values in the column.

  • Then, enter the following formula in the F28
=SUM(F26:F27)

  • Meanwhile, press Enter and get the result.

  • After that, in the F29 cell, enter the following formula.
=F20+F24+F28

Read More: Balance Sheet Format in Excel with Formulas


Step 4: Final Result

This is the last step of this article. You will find the final result in this portion of the article. Follow the procedures step-by-step.

  • Press the Enter button.
  • As a consequence, you will get the final output of a hotel balance sheet, just like the picture given below.

Read More: Schedule 6 Balance Sheet Format in Excel


Things to Remember

  • You can make other balance sheets by using the same formatting and steps.

Download Practice Workbook

Please download the workbook to practice yourself.


Conclusion

In this article, I have tried to explain how to make a hotel balance sheet format in Excel. I hope you have learned something new from this article. Now, extend your skill by following the steps of these methods. I hope you have enjoyed the whole tutorial. If you have any queries, feel free to ask me in the comment section. Don’t forget to give us your feedback.


Related Articles


<< Go Back to Balance Sheet | Finance Template | Excel Templates

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Souptik Roy
Souptik Roy

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo