Who wants to spend forty dollars a month on accounting software just to track pizza nights and club dues?
Club budgets boil down to three chores. You collect annual dues, pay for the meeting space, and pay back whoever bought supplies on a personal card. A shared spreadsheet in Google Sheets handles all of that without subscription fees. You can also export a clean, printable PDF copy for monthly business meetings or the audit binder.
Setup takes fifteen minutes.
Core Columns for Your Club Ledger
Most booster clubs, hobby groups, and sports teams only need a single ledger tab to capture cash flow. Consistent column headers across row 1 keep your entries tidy and make automated summaries possible.
| Column | Header | Purpose | Example Entry |
|---|---|---|---|
| A | Date | Transaction date | 10/12/2026 |
| B | Description | What was purchased or received | Annual membership dues |
| C | Payer | Person or account funding the line | Jordan M. |
| D | Category | Budget bucket for sorting | Dues Income |
| E | Amount | Cash value (positive for income, negative for expenses) | 50.00 |
| F | Split Type | How costs divide among attendees | Equal Split |
| G | Settled? | Payment or reimbursement completion status | Yes |
| H | Running Balance | Cumulative cash balance after this row | =SUM($E$2:E2) |
Thing is, clubs stumble when they mix up inflows and outflows. Pick one sign rule early and never bend it.
In this setup, club revenue goes in as a positive number and expenses go in as negative, which makes the running balance formula effortless. Jordan's fifty dollars of dues gets entered as 50. The twelve-dollar pack of markers gets entered as -12.00.
Formulas That Do the Math for You
Don't total categories by hand at month end. The spreadsheet calculates instantly, and your treasurer report leaves less room for arithmetic slip-ups.
Create a second tab in the workbook and name it Summary. It pulls straight from your Transactions tab.
For a single category total, like travel or venue rentals, SUMIFS is the tool. With categories in column D and amounts in column E, paste this into the summary sheet:
=SUMIFS(Transactions!E:E, Transactions!D:D, "Travel")
One formula per category gets old fast. The Google Sheets QUERY function pulls unique categories and totals them in two clean columns, no separate formula for each one:
=QUERY(Transactions!D:E, "SELECT D, SUM(E) WHERE D IS NOT NULL GROUP BY D LABEL SUM(E) 'Total Amount'", 1)
Officers reviewing purchases over a certain dollar threshold can isolate those entries without touching the master sheet. FILTER pulls every transaction over one hundred dollars into an audit box:
=FILTER(Transactions!A:E, Transactions!E < -100)
Notice the negative sign in there. Expenses live in the sheet as negative values, so searching for numbers less than -100 catches purchases larger than one hundred dollars. One check, and the big outlays get flagged before monthly meetings. Treasurers love this shortcut. It saves twenty minutes of manual scanning.
Protecting Formulas and Sharing Access
Turns out, nothing wrecks a shared spreadsheet faster than an eager club member typing a phone number over your running balance formula. Google Sheets lets you share a single file with your entire roster while restricting who can touch the formulas.
Click the green Share button in the top right corner. Three access levels exist:
- Viewer: members inspect the numbers and download copies, but they can't change cell values or alter formulas.
- Commenter: officers or committee chairs leave notes on specific rows without altering ledger math.
- Editor: co-treasurers or designated leads input new receipts, mark reimbursements paid, and add members.
Lock down sensitive cells before handing out editor access. Highlight your summary tab, head to Data, and open protected sheets and ranges. You can lock the entire Summary tab, then set the header row of the Transactions tab to show a warning whenever someone attempts an edit. Members keep entering reimbursements on fresh rows. Your balance formulas stay intact.
How to Export a Clean Printable PDF
Board members ask for paper copies at general meetings. Handing someone a physical sheet keeps the conversation focused, especially when older members or school sponsors prefer paper records over shared links.
The export path is quick. Click File, choose Download, and select PDF document (.pdf). On the print setup screen, switch page orientation to Landscape. Under the Scale dropdown, select Fit to width, which squeezes all eight columns onto a single page width instead of chopping your running balance onto an awkward second sheet.
Gridlines matter more on paper than on screen. Check the box for Show gridlines under the Formatting menu and the ledger gets far easier to read across a crowded table. If your club requires officer signatures on reimbursements, leave the last column blank or add a small signature line at the bottom margin before you export. The downloaded file drops straight into the club binder as an archive-ready record.
When a Spreadsheet Works and When You Need Dedicated Software
A custom Google Sheet is free, easy to adapt, and asks nothing of your members. No software sign-ups, no logins. For a neighborhood run club, book group, or local hobby league with ten to thirty members, a simple sheet is almost always the right answer.
To be honest, spreadsheets hit real limits once budgets grow. Keep the simple sheet while the group processes fewer than twenty or thirty transactions each month, while dues still arrive as cash, checks, or direct peer payments instead of automated recurring subscriptions, and while one or two elected treasurers can handle all the data entry and reconcile totals against bank statements once a month.
Move to dedicated club management software or small-business accounting tools when membership expands past fifty active members, when you need automated recurring dues billing, or when filing official IRS Form 990 schedules requires strict double-entry audit trails. Software costs money every month. It still prevents painful errors once club budgets cross thousands of dollars.
Frequently Asked Questions
How do I handle an expense split unevenly between two club members?
Split it into two rows. A sixty-dollar venue deposit where one person pays forty and the other pays twenty becomes two separate entries with the same date and description. Clean arithmetic, and your running balance formula never breaks.
Should club treasurers attach receipts inside Google Sheets?
Don't paste high-resolution image files directly into sheet cells. Large images drag down spreadsheet performance. Create a shared Google Drive folder titled Receipts 2026, upload the receipt photos there, and paste the shareable link into a Notes column on the transaction row. That keeps the file fast.
Can members without a Google account view or download the tracker?
Yes. Open the Share menu, change general access to Anyone with the link, and set the role to Viewer. Non-Google users can open the link in any web browser, inspect the columns, and download a PDF or Excel copy without signing in.
Open a blank sheet, plug in your eight column headers, and enter last month's ending bank balance as your first row. When the running balance matches the actual statement, share view access with the rest of the board. Your next meeting just got a lot simpler.