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 and endlessly flexible, which is 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. The burn-down answers it →
- It's one person's file. The file lives on one laptop, behind one login, full 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.