How to Create a Balance Sheet in Microsoft Excel

1. 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.'
2. Select 'Balance Sheets' under the 'Accounting' section in the middle of the page.
3. Browse through the available balance sheet styles and choose the one that best suits the needs of your business.
4. Click the title of your chosen template and click the 'Download' button. Accept the Microsoft service agreement to begin downloading.
5. Open the template in Microsoft Excel. Customize the layout for your business by adjusting the colors, font size and type and text.
6. 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.