Closing the Books Without the Spreadsheet Ritual
· 6 min read
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.