# How to Create School Balance Sheet Format in Excel: 4 Methods

### Method 1 – Entering Balance Sheet’s Components

Finalize the components you want to display on the balance sheet. After finalizing the components, enter them into the Excel cells as shown in the following image.

### Method 2 – Organizing the Components in a Desired Layout

• Place the School Logo and Name at the top of the components.
• Make the title of the components as ‘Balance Sheet’.
• Below the title, serially enter the finalized components, as shown in the following image.

• Format the amount cells in the Accounting Number Format (Click Font Settings Icon or CTRL+1).

• The total cells in Total Cell Style (Home > Cell Style > Titles and Headings).

### Method 3 – Entering or Referring Amounts to Populate the Balance Sheet

After formatting all the cells, you need to enter all the data to complete the format. Some of the components may require additional sheets to refer to their values. The Account Receivable entry may require a school grade-wise accumulated amount to refer to.

• Refer to the D13 cell of Account Receivable Monthly Sheet for Account Receivable amount in the Balance Sheet.

• Each grade may have individual Payments and Outstanding Excel Worksheet to transparent the balance sheet calculations.

### Method 4 – A Working Example of a School Balance Sheet in Excel

Use the SUM function to populate the Total Formatted Cells to find out Assets, Liability and Shareholder totals. The highlighted cells are the results of the sum formula.

⧭ Note: In the template, we use only 5 grades for simplified demonstration. You can use as many grades as possible to refer to them in the Summary Worksheet. Individual worksheets for other components can be used.

We create the school balance sheet in a way to be used as a Template. Download it to better understand the steps.

## Things to Remember

• The total Assets, Total Liabilities, and Owner’s Equity must be equal.

## Related Articles

<< Go Back to Balance Sheet | Finance Template | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF