How to Make Hotel Balance Sheet Format in Excel

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.


Download Practice Workbook

Please download the workbook to practice yourself.


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 skill more.


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 subheading like the date and Assets.

Heading of Hotel Balance sheet in Excel

Read More: Balance Sheet Format in Excel with Formulas (Create with Easy Steps)


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: Balance Sheet Format in Excel for Proprietorship Business


Similar Readings


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: How to Create a Balance Sheet for Small Business in Excel


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: How to Make Automatic Balance Sheet in Excel


Things to Remember

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

Conclusion

In this article, I have tried to explain how to make 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. You will find such interesting blogs on our website Exceldemy.com. 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

Souptik Roy

Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo