Skip to content
← TemplatesGroups & property

Free Harambee & Fundraiser Contribution Tracker (Excel)

A harambee lives on trust, and trust needs clean records. This free tracker keeps them: record what each person pledged and what they've actually paid, and it works out every balance, marks who has fulfilled their pledge, and shows exactly how far you are from the target.

Download free — Excel (.xlsx) ↓Opens in Excel or Google Sheets · no sign-up

What's inside

  • Balance and status (Fulfilled / Partial / Pledged) per contributor
  • Target set once; progress bar and % collected on the Dashboard
  • Fulfilled turns green, unpaid pledges red
  • Channel column (M-Pesa, Cash, Bank, Cheque)
  • Formulas locked; safe to share with the committee

The tabs

  • Start Here (guide)
  • Pledges
  • Dashboard

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

Set the fundraiser name and target on the Dashboard. On the Pledges tab, add each contributor with what they pledged and what they've paid — the balance, a status (Fulfilled, Partial, Pledged or Gift) and the channel fill in automatically. Fulfilled pledges turn green; those still unpaid show red, so your follow-up list is obvious.

The Dashboard totals the number of contributors, total pledged, total collected and what's still outstanding, with a progress bar to the target. The formulas are locked and only the yellow cells accept typing, so you can share the sheet with the committee without anyone breaking the totals.

For a group that keeps money together over time — a chama, welfare or investment group — the free Chama / SACCO Ledger tracks contributions, loans and interest month after month.

Do it online instead

Keep a group's books free with Biashara Yangu

Open the free tool →

Frequently asked questions

What's the difference between a pledge and a payment?

A pledge is what someone promised; a payment is what they've actually given. The tracker keeps both, so the balance (pledged minus paid) tells you who still owes and the total collected tells you what's truly in hand — not just promised.

Can I use it for a wedding, funeral or school project?

Yes — it works for any one-off fundraiser: medical harambees, weddings, funerals, church and school projects. Set the target, add contributors, and track collection to the shilling.

Does it work in Google Sheets?

Yes — upload the .xlsx to Google Drive and open it with Google Sheets; share it with your committee so everyone sees the same figures.