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.

**Table of Contents**hide

## Download Practice Workbook

## 4 Steps to Create NGO Balance Sheet Format in Excel

In this section, you will have an idea of how 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.

**Read More: ****Balance Sheet Format of a Company in Excel (Download Free Template)**

**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.

**Read More: ****How to Make Balance Sheet in Excel (2 Useful Examples)**

**Similar Readings**

**Balance Sheet Format in Excel for Proprietorship Business****How to Make Projected Balance Sheet in Excel (with Quick Steps)****Net Worth Formula Balance Sheet in Excel (2 Suitable Examples)****Create a Balance Sheet Format for Trading Company in Excel****How to Make a Forecasting Balance Sheet in Excel (With 3 Steps)**

**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.

**Read More: ****Balance Sheet Format in Excel with Formulas (Create with Easy Steps)**

**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.

**Read More: ****How to Create Vertical Balance Sheet Format in Excel**

## 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 or questions or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles. For more queries, kindly visit our website **ExcelDemy**.

## Related Articles

**Create Projected Balance Sheet Format for Bank Loan in Excel****How to Create Common Size Balance Sheet in Excel****Create a Balance Sheet for Small Business in Excel****Revised Schedule 3 Balance Sheet Format in Excel with Formula****How to Make Balance Sheet Format in Excel for Individual****Debit Credit Balance Sheet with Excel Formula (3 Suitable Examples)****Schedule 6 Balance Sheet Format in Excel**