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

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.
• Similarly, merge the B3 to F3 and B4 to F4 cells and add the subheading 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 column.
• Then, input all the data in the 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 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 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 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` ### 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.

## 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

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 Advanced Excel Exercises with Solutions PDF  