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.

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.

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 B column.
Then, input all the data in the F column.
After that, select the F10 cell.

Copy the following formula in the selected cell.

=SUM(F6:F9)

After pressing enter, you will find the following result.

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

Enter the following formula in the F14 cell.

=SUM(F12:F13)

Then press the enter button.

Enter the following formula in the F15

=F10+F14

After that, press enter.

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

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 F column.

Then, copy the following formula in the F20

=SUM(F18:F19)

After that press Enter and get the total current liabilities.

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

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 B column.
Then, enter the values in the F 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

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.

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.

Hotel Balance Sheet Format.xlsx

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.

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

Get FREE Advanced Excel Exercises with Solutions!