A thermometer on the wall and a spreadsheet nobody trusts
The roof needs replacing, or the extension for classes has planning permission, or the prayer hall needs a new heating system. The committee launches an appeal. At the launch event people fill in pledge cards: some promise a single gift, some promise monthly amounts over three years, some promise to match whatever the youth group raises. The thermometer poster goes up by the entrance.
Two years in, the appeal coordinator keeps a spreadsheet of pledges. The treasurer keeps a separate record of what has arrived in the appeal fund. Some pledgers pay by standing order, some by card, some in cash at the collection, and one gave a lump sum from a family member's estate. Nobody can say with confidence how much of the pledged total has been received, who has fallen behind, or how much is left to raise. The thermometer has not been updated since the spring.
Why appeals outgrow their spreadsheet
An appeal is a long project run by volunteers who also have other roles, and the money arrives in pieces over a long time.
| Pledge type | Why it is hard to track |
|---|---|
| Single promised gift | May arrive months later through any channel |
| Monthly or yearly instalments | Payments start late, pause or stop quietly |
| Matched or conditional pledge | Depends on another figure being reached |
| Gift in memory of someone | Needs to be recorded sensitively and correctly |
| Event income | Dinners, sponsored walks and sales feed the same total |
Payments rarely say which pledge they belong to. A standing order labelled with a surname, a card gift through the online page and an envelope in the collection all need to be tied back to the right promise.
Grants and larger donations from outside the congregation are often handled by a different volunteer, adding another list.
What a fuzzy appeal total costs
The main cost is planning. The committee has to decide when it can sign a contract with the builder, and that depends on knowing what has been received and what can reasonably be expected. Guessing either delays the work or commits to spending money that has not yet arrived.
Relationships matter too. Thanking people properly, and noticing when a regular pledger has stopped paying because they lost their job or became unwell, needs accurate records. A reminder sent to someone who has already paid, or who has recently been bereaved, does real harm.
Momentum is the last cost. Appeals rely on people seeing progress. A thermometer that stays still for months makes the appeal look stalled even when money is coming in.
A pledge tracker linked to real payments
What we build is an appeal record that treats a pledge and a payment as different things, and links them.
- Each pledge is recorded with the giver, the amount, the schedule and any conditions, from paper cards or an online pledge form.
- Payments to the appeal fund come in from the bank feed, card and online giving, and the collection counting record, each tagged to the appeal.
- Payments are matched to pledges by giver and amount, with uncertain matches listed for the appeal coordinator to confirm.
- Each pledge shows how much has been paid and what is due next. A pledge that has missed two expected instalments appears on a short list for a personal conversation, not an automatic reminder.
- Event income and grants are recorded as their own lines, so the appeal total includes everything without mixing it up.
- An appeal summary, with total pledged, total received and total still to raise, updates automatically and can feed a progress figure on your website or a screen in the foyer.
Gifts made in memory of someone carry that dedication, so it is used correctly in thank-yous and on any list of dedications your trustees decide to publish.
A committee meeting with real numbers
The building subcommittee meets to decide whether to sign the contract for phase one. The coordinator shares the summary: received so far, pledges on schedule, pledges behind, and events planned. The treasurer confirms the received figure matches the appeal fund in the accounts. The decision is made on facts.
Two pledgers have fallen behind. The system does not email them. It puts their names in front of the coordinator, who knows one has had a hard year and suggests someone visits rather than writes.
Does your appeal need this?
- Pledges and payments are recorded in different places by different people.
- You cannot quickly say how much of the pledged total has arrived.
- Instalment pledges have stopped without anyone noticing.
- The progress figure on the wall or website is out of date.
- Thank-you letters for appeal gifts are behind.