The spreadsheet holds the numbers. It can’t answer “can we afford it?”
Nobody chose the spreadsheet-and-checkbook system — every club inherits it. It works right up until the questions that matter: will the money last, who hasn’t paid, and what happens when the person who built it leaves.
Credit where due
The spreadsheet is free, familiar, and infinitely flexible — that's why every club has one. For a small club with a stable, diligent treasurer, it can carry a season. The problems aren't with the spreadsheet's math; they're with everything around it.
Where the system breaks
- It can't forecast. The sheet holds what happened; the board needs what's next. "Can we afford the pump repair?" becomes an argument instead of a lookup. The burn-down answers it →
- It's one person's file. One laptop, one login, one set of formulas only the author trusts. The club's operating memory has a single point of failure. The handoff problem →
- It doesn't collect anything. Dues arrive by check and memory; the sheet gets updated when someone remembers. "Who hasn't paid?" is a reconciliation project.
- It's disconnected. The schedule, the website, the roster, and the money live in four places that only agree when a volunteer makes them agree.
What replaces it — honestly
Hydive replaces the spreadsheet with records, the checkbook scramble with a live season budget, and the four disconnected tools with one system the whole board can see. It's free to start, so the honest test is simple: import last year's roster, set this season's numbers, and run both side by side until the spreadsheet stops getting opened.