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

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

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.

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

Advanced Excel Exercises with Solutions PDF