Committee in Excel: a working sheet, and where it stops working
A spreadsheet is a perfectly good committee record for a while. It is worth knowing exactly where "a while" ends.
Short answer. A committee spreadsheet needs one row per member and one column per month, with a total column and a paid-count row. It works well until you need members to see it themselves, need receipts attached to rows, or need it to be certain nobody edited a past month.
The layout
Members down the left, months across the top. One cell per member per month.
| Member | Sep | Oct | Nov | Total paid | Turn |
|---|---|---|---|---|---|
| Ayesha | 5,000 | 5,000 | =SUM(B2:D2) | Nov | |
| Bilal | 5,000 | =SUM(B3:D3) | Sep | ||
| Sana | 5,000 | 5,000 | =SUM(B4:D4) | Oct | |
| Collected | =SUM(B2:B4) | =SUM(C2:C4) | =SUM(D2:D4) | ||
| Paid count | =COUNT(B2:B4) | =COUNT(C2:C4) | =COUNT(D2:D4) |
The three formulas worth having
=SUM(B2:B4)— collected this month.=COUNT(B2:B4)— how many have paid, so you can see 3 of 10 at a glance.=COUNTIF(B2:B4,"")— how many have not, which is the number you actually act on.
Add conditional formatting so an empty cell after the due date turns red. That single rule does most of the work of chasing.
Where it stops working
1. Members cannot see it
Unless it is a shared Google Sheet, the organiser is still the only person who can answer questions — and if it is shared and editable, anybody can change a past month.
2. Receipts live somewhere else
A screenshot of a transfer sits in a chat, and the sheet has a row. The two are only connected in the organiser's memory. Six months later that connection is gone.
3. Nothing records who changed what
A spreadsheet cell that used to say 5,000 and now says 0 looks exactly like a cell that always said 0. For a record whose entire purpose is settling disagreements, that is the weak point.
When to move off it
Roughly: more than eight members, or more than six months, or the first time somebody asks a question you cannot answer without scrolling. Until then a well-kept sheet is genuinely fine, and better than a badly-kept anything else.
Common questions
Is Google Sheets better than Excel for this?
For a committee, yes — it can be shared with everyone, which is the main thing a committee record needs. The limits below still apply.
Can I attach receipts in a spreadsheet?
Only as links to files elsewhere, which is where most committee records start to rot: the sheet survives and the linked images do not.
Read next
- Committee list format: what the record should contain — The columns, and why each one earns its place
- A spreadsheet or a shared record: an honest comparison — When a spreadsheet is enough, and when it is not
- A committee app for keeping the record straight — What an app actually changes about running a committee