How to Create a Balance Sheet in Microsoft Excel

By Catherine Johnson

Updated September 28, 2017

There are multiple financial factors and considerations that need to be managed in a business. A balance sheet helps you to have an overall picture of where your business stands. By clearly presenting both your company's assets and liabilities, a balance sheet allows you to make appropriate and responsible financial decisions. Create a balance sheet in Microsoft Excel so that you have a powerful tool for maintaining control over the financial health of your company.

Go online to the official Microsoft Office Template Download Center. In the left column of the page, under the subheading "Collections," click "Finance and accounting."

Select "Balance Sheets" under the "Accounting" section in the middle of the page.

Browse through the available balance sheet styles and choose the one that best suits the needs of your business.

Click the title of your chosen template and click the "Download" button. Accept the Microsoft service agreement to begin downloading.

Open the template in Microsoft Excel. Customize the layout for your business by adjusting the colors, font size and type and text.

Enter all of the data about your current and fixed business assets. Enter all of your current and long term business liabilities. Enter any equity or capital your business may have.


Balance sheets should contain the most accurate data you have. This will allow you to have a clear overview of your company's financial solvency. Explore all of the tools available in Microsoft Excel. There are many convenient sorting, filtering and calculating functions that can help you to manage the data in your balance sheet.