How to Create NGO Balance Sheet Format in Excel (4 Easy Steps)

The article will show you how to create an NGO balance sheet format in Excel. The template in this article will be tremendously helpful for any NGO employee. The proper use of this template will also be helpful for keeping track of the expenses. Let’s move on to the description of how to make an NGO balance sheet using Excel.

4 Steps to Create NGO Balance Sheet Format in Excel

In this section, you will have an idea of what a typical NGO balance sheet looks like. You will see variable assets in the following picture.

The process of making this template will be discussed in the later section.

Step-1: Inserting Source of Assets and Formulas for Primary Calculation

First, we need to identify which are the source of assets for an NGO company and put them in the Excel sheet.

Fill up your Excel sheet with the necessary parameters.
After that, write down the following formula in cell C11 to calculate the total Current Assets of the organization.

=SUM(C6:C10)

The formula uses the SUM function to return the value of the Total Current Assets of the company.

Next, we will need more similar formulas to calculate other assets. For example, the formula below in F10 will return the total Fixed (Long-term) Assets of Omega NGO Organization.

=SUM(F6:F9)

Thereafter, we also need a formula to calculate the Overall Total assets of the company which I’ve shown below.

=C11+F10+F15

Thus your Asset Calculation sheet is complete.

Step-2: Calculating Liabilities and Owner’s Equity

The next thing you should do is to identify the Liabilities amount for your organization.

Fill the Excel sheet with necessary Liabilities parameters and type the following formula to determine the Total Current Liabilities.

=SUM(C6:C11)

Next, use the same function for other Liability Calculations
The following formula will return the Total Liabilities and Owner’s Equity.

=C12+F9+F15

By following this approach, you can have an Excel sheet where the liability history is stored.

Step-3: Summarizing NGO Balance Sheet Format in Workbook

After entering all the data, you now need a summary of the sheet so that you can easily understand the expenses of your company. For that purpose, we are going to apply some formulas. Let’s have a look at the following description.

First, we generate a formula to calculate the Debt Ratio. It is the ratio between the Total Liabilities and Total Assets.

=IF(Assets!C14=0,"",(Liabilities!C12+Liabilities!F9)/Assets!C14)

The formula uses the IF function to check whether the Total Asset is 0, if the condition is true it will return nothing. Otherwise, it will return the ratio (Current Liabilities + Long Term Liabilities)/Total Assets which is the Debt Ratio.

Next, we will develop a formula to determine the Current Ratio. It refers to the ratio of Current Assets and Current Liabilities. This ratio also represents the ability of a company to pay its short time dues within a year.

=IF(Liabilities!C12=0,"",Assets!C11/Liabilities!C12)

The following formula will return the Debt to Equity Ratio which is the ratio between Total Liabilities and Owner’s Equity.

=IF(Liabilities!F15=0,"",(Liabilities!C12+Liabilities!F9)/Liabilities!F15)

Thereafter, we will use a formula to calculate the Assets to Equity Ratio. This is the ratio between Total Assets and Owner’s Equity.

=IF(Liabilities!F15=0,"",Assets!C14/Liabilities!F15)

Finally, we calculate the Working Capital which basically represents the company’s gain.

=Assets!C11-Liabilities!C12

Thus our Summary sheet is done for application.

Step-4: Inserting Assets and Liabilities Data

In this step, we just simply insert the data.

First, complete the entries for the Assets.

After that, enter the necessary data for Liabilities and Owner’s Equity

Next, we can see that the Summary of the balance sheet automatically updates according to the formulas.

Thus you can create an NGO balance sheet format in Excel.

Download Practice Workbook

NGO Balance Sheet.xlsx

Conclusion

In the end, we can conclude that you will learn a very efficient way to create an NGO balance sheet format in Excel. If you have any better suggestions, questions, or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles.

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

Get FREE Advanced Excel Exercises with Solutions!