# Charity accounts by fund Excel (free) + online

> Free Excel sheet for charity accounts by fund: donations and expenses per project, general and restricted funds, balance per fund and an overspend alert.

Source: https://softwiro.com/blog/charity-funds-accounts-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Charity accounts by fund in Excel (free): restricted and general funds, balance per project

Tie every donation and expense to a fund and see each fund's balance, with an alert when a fund is overspent.

12 November 2026 5 min read

## In short

- Every donation and expense is tied to a fund (a programme or project).
- Each fund shows opening balance, donations, expenses and closing balance.
- General and restricted funds are told apart, with an alert when a fund is overspent.
- Donor codes only, no names in the sheet.

A charity treasurer knows that donations cannot all sit in one balance: some are general, some are restricted to orphan sponsorship, treatment or a water well, and must not be spent on anything else. The free [charity accounts by fund sheet](https://softwiro.com/templates/charity-funds-accounts) works out each fund's balance on its own: what came in, what went out and what is left.

## The problem it solves

When every donation and expense goes into one statement you only know the total balance. You cannot tell whether what is left for the water well is enough, or whether more was spent from the treatment money than was donated for it. Here every donation and expense is tied to its fund, and one page answers.

## Steps

1. Settings: the charity name, year and report month, then up to 8 funds: name, type (general or restricted) and the balance before the first record.
2. Donations: one row per donation: date, donor code (blank for anonymous), fund from the list, amount and payment method.
3. Disbursements: one row per payment out: date, fund, item and amount.
4. Open Funds report for each fund's opening balance, donations, expenses, closing balance and status.

## Worked example (sample data, October 2026)

The names and figures are sample data, not a real charity. There are five funds:

- General fund: opening 10,550, donations 2,500, expenses 500, closing 12,550.
- Orphan sponsorship (restricted): opening 1,800, donations 500, expenses 700, closing 1,600.
- Treatment (restricted): opening 0, donations 3,500, expenses 3,800, closing −300, flagged "spent more than the balance" in red.
- Water well project (restricted): opening 10,000, donations 3,500, expenses 6,000, closing 7,500.
- Iftar and food baskets (restricted): donations 300, expenses 500, closing −200, flagged the same way.
- Total: opening 22,350, donations 10,300, expenses 11,500, closing 21,150: 12,550 in general funds and 8,600 in restricted funds.
- Unclassified: a 400 donation and a 200 expense entered under a fund that is not on the list. They are not lost from the total; they show on the "unclassified" row so you can correct the fund name.

## How the numbers are worked out

- Fund balance = opening balance + all its donations − all its expenses up to the end of the period.
- Opening balance of the month = opening balance + earlier donations − earlier expenses.
- Closing balance of the month = opening of the month + month donations − month expenses.

## Tips

- Pick the fund from the list instead of typing it; one wrong letter takes the entry out of its fund.
- Do not delete a fund that has entries; rename it in Settings.
- The red status does not block spending, but it tells you to review the decision and document any transfer from another fund.
- Do not type donor names into the sheet; keep them in your own register.

## Try it

[Open the sheet and try it online, or download it for Excel](https://softwiro.com/templates/charity-funds-accounts). It holds 2000 donations, 2000 disbursements and eight funds. If you want something made for your charity, [ask for it here](https://softwiro.com/request-sheet).

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: charity fund accounting (1/3)](https://softwiro.com/uploads/cheatsheets/charity-funds-accounts/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/charity-funds-accounts/en-1.jpg)[![Cheat sheet: charity fund accounting (2/3)](https://softwiro.com/uploads/cheatsheets/charity-funds-accounts/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/charity-funds-accounts/en-2.jpg)[![Cheat sheet: charity fund accounting (3/3)](https://softwiro.com/uploads/cheatsheets/charity-funds-accounts/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/charity-funds-accounts/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### What is the difference between a general and a restricted fund?

A general fund can be spent on any of the charity's purposes. A restricted fund is set aside for a project or purpose the donor named, so it is spent only on that. Set each fund's type in Settings.

### How do I know the balance of each project?

Tie each donation and expense to its fund, then open the Funds report: fund balance = opening balance + donations − expenses.

### What if a fund is spent beyond its balance?

The Funds report shows the status "spent more than the balance" in red, so you review the spending or document a transfer from another fund.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
