4 posts tagged with "nonprofits"

Every booster club treasurer has a ritual for the last week of the fiscal year. It looks a little different from org to org, but the shape is always the same: copy the master spreadsheet into a new file named something like FY26_FINAL_v3_ACTUAL_FINAL.xlsx, carefully type the ending balance of every account into the opening row of a new blank tab, change the year in the header, and pray that nobody needs to add a late transaction to the prior year for the next six weeks.

Then someone asks if the board fund ending balance is correct. You open three versions of the file to compare. Two of them agree. The third is off by $47. Nobody knows which version the board meeting minutes referenced.

This is the ritual we built ledger periods to retire.

Central Valley Youth Athletic Association is a mid-sized booster club supporting four varsity sports programs at a public high school. They have 94 family accounts, run 24 concession events per year, manage a scholarship fund, and have annual 990 filing obligations as a registered 501(c)(3).

They were managing all of it with spreadsheets.

The booster club treasurer is usually the most organized person in the room. They volunteered for the role knowing it would be work. What they didn't anticipate was how much of that work would be spent compensating for systems that weren't built for this job.

Here are the five things every treasurer privately wishes they had — and what those things actually look like in practice.

Every fall, booster club coordinators across the country open the same spreadsheet they've been using for three years. It has 70-something tabs. The filename ends in _FINAL_v3_USE-THIS-ONE.xlsx. And somewhere between columns AQ and BW, last year's settlement math stopped adding up.

This is not a technology problem. It's a coordination problem that technology made worse.