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.

Video of the Day

Brought to you by Techwalla
Brought to you by Techwalla

About the Author

Catherine Johnson is a freelance writer and designer. Her writings on computer software, electronics, cooking, digital photography, home office productivity, organization, and online technologies have been published by Demand Studios, eHow, Bright Hub, and Associated Content. She has also produced award-winning graphic design, digital images, and websites since 2003.

More Articles

Photo Credits