A spreadsheet or a shared record: an honest comparison
Spreadsheets are underrated for this. It is worth being precise about where they stop working rather than pretending they never did.
Short answer. A spreadsheet is fine for a small, short, single-organiser fund. It stops being enough when members need to see it themselves, when receipts must attach to rows, or when it matters that a past entry cannot be changed unnoticed.
Side by side
| Spreadsheet | Shared record | |
|---|---|---|
| Cost | Free | Free |
| Set-up | Minutes, if you know the formulas | Minutes |
| Members can see it | Only if shared — and then editable | Yes, read-only |
| Receipts | Links to files elsewhere | Attached to the payment |
| Who changed what | Version history, rarely checked | Approvals attributed by name and date |
| Reminders | Manual | Status visible to the member |
| Survives a handover | Only if the file is passed on | Belongs to the community |
| Flexibility | Total — any layout you like | Fixed to how funds work |
That last row is a genuine advantage of the spreadsheet, and worth admitting.
When to stay on a spreadsheet
- Fewer than about eight members.
- One organiser, no handover in sight.
- Nobody has ever asked to see it.
- Your record-keeping is unusual and needs a layout of its own.
When to move
- Members are asking questions you have to look up.
- Receipts are scattered across chats and galleries.
- A handover is coming.
- Somebody has disputed an entry — once is enough.
Common questions
Can we use both?
Many do during a move — the record in the app, a spreadsheet export for the annual report. What does not work is maintaining two live records, because they will disagree within a month.
Read next
- Committee in Excel: a working sheet, and where it stops working — A spreadsheet you can build today, and its ceiling
- WhatsApp or a shared record for group money — Keep the group; move the record
- Community fund management, done so people can check it — The general case: money a group collects and spends together