Balance sheet format of charitable trust

This query is : Resolved

Report Abuse Follow Query Ask a Query

D.SRINIVASULU REDDY

D.SRINIVASULU REDDY (Querist)
Follow

18 April 2014 please send me charitable trust balance sheet and profit and loss account format of excel

Asha Kanta Sharma

Asha Kanta Sharma

(Expert)
Follow

18 July 2024 I don't have the capability to send files directly, but I can guide you on how to create a basic format for a charitable trust's balance sheet and profit and loss account in Excel. Here’s a simplified outline you can use:

### Charitable Trust Balance Sheet Format:

| **Assets** | | **Liabilities** | |
|---------------------------|---------------------|------------------------|----------------------|
| Current Assets: | | Current Liabilities: | |
| - Cash and Bank Balances | | - Accounts Payable | |
| - Accounts Receivable | | - Accrued Expenses | |
| - Inventory | | Non-current Liabilities:| |
| Fixed Assets: | | - Long-term Debt | |
| - Land and Buildings | | - Deferred Income | |
| - Equipment | | | |
| Other Assets: | | Equity: | |
| - Investments | | - Opening Balance | |
| | | - Retained Earnings | |
| **Total Assets** | | **Total Liabilities** | |

### Charitable Trust Profit and Loss Account Format:

| **Income** | Amount (INR) | **Expenses** | Amount (INR) |
|---------------------------|---------------------|-------------------------|----------------------|
| Donations | | Salaries and Wages | |
| Grants | | Rent and Utilities | |
| Investment Income | | Program Expenses | |
| Other Income | | Administrative Expenses | |
| | | Fundraising Expenses | |
| **Total Income** | | **Total Expenses** | |
| | | | |
| **Net Surplus/(Deficit)** | | | |

### Notes:

- **Assets and Liabilities:** List all relevant assets, liabilities, and equity accounts specific to your charitable trust. Include both current and non-current items.
- **Income and Expenses:** Customize the income and expense categories based on the activities and sources of income of your charitable trust.
- **Formatting in Excel:** Use Excel's formatting tools to make the tables clear and easy to read. You can apply borders, shading, and fonts to distinguish between different sections.
- **Calculations:** Use Excel formulas to calculate totals automatically based on the data you input into each section.
- **Further Customization:** Depending on your specific requirements and reporting standards, you may need to add additional sections or modify the format accordingly.

To create these formats in Excel, you can start by opening a new Excel workbook and setting up each section as shown above. Enter your data into the appropriate cells and use basic Excel functions (like SUM) to calculate totals where needed. This will help you maintain organized financial records for your charitable trust.