Last updated 2026-07-25
TL;DR
A booster club treasurer spreadsheet should have at minimum five tabs: income log, expense log, monthly bank reconciliation, budget vs. actual, and a 990 prep summary. It replaces a shoebox of receipts with a record any board member, auditor, or successor can read in five minutes. Free templates work fine; the discipline of using them consistently is what actually matters.
What does a treasurer do, and why does a spreadsheet matter?
A treasurer tracks the money coming in and going out, keeps records that match the bank statement, and reports the club's financial position to the board and members. That's the job in one sentence. Everything else, including the spreadsheet, exists to make that job possible without a headache. Most booster clubs, PTOs, and youth sports organizations run on volunteer labor and a shared drive. Nobody hands you a finance department. What you actually get is a checkbook, maybe a login to a bank account, and a folder of last year's receipts if you're lucky. A spreadsheet is the cheapest, most portable tool for turning that mess into something you can hand to a board, an auditor, or the IRS if it ever asks. The deeper reason a spreadsheet matters: your organization almost certainly has to report its finances somewhere. If you're a 501(c)(3) or 501(c)(4), you file some version of Form 990 with the IRS every year, even if your budget is tiny [1]. If you fall behind on that filing for three consecutive years, the IRS automatically revokes your tax-exempt status, no warning letter required beyond the annual notice reminders it sends [2]. A spreadsheet that tracks income and expense categories all year makes that filing a two-hour job instead of a two-week archaeology project. So the honest answer to "what does a treasurer do" is: keeps a paper trail good enough that someone else could reconstruct the year from it. A spreadsheet is how you do that without accounting software you don't need.
What do treasurers do day to day, and how does that map to spreadsheet tabs?
Treasurers do four things repeatedly through the year: record deposits, record payments, reconcile the bank account monthly, and report a budget-to-actual snapshot to the board. Each of those maps directly to a spreadsheet tab. Tab 1: Income log. Every deposit, dated, with source (concession sales, spirit wear, membership dues, a specific fundraiser), payment method, and who counted it. If you ran a raffle or other regulated fundraiser, note that here too, since some states require you to report gross receipts and prize payouts separately. Tab 2: Expense log. Every payment out, dated, with vendor, category (uniforms, equipment, concessions supplies, tournament fees), payment method, and receipt reference number. Categories should match whatever your budget uses, and ideally match the functional expense categories the 990 asks about (program services, management, fundraising) so year-end mapping isn't a guessing game [1]. Tab 3: Monthly bank reconciliation. Bank statement balance, minus outstanding checks, plus deposits in transit, equals your book balance. Do this every month, not once a year. A reconciliation that's six months stale is the number one reason handoffs between treasurers go badly. Tab 4: Budget vs. actual. Your approved budget line by line, next to what's actually happened so far, with a variance column. This is what the board actually wants to see at meetings, not the raw transaction list. Tab 5: 990 prep summary. A running total of gross receipts, program expenses, and management expenses, updated monthly, so that whichever 990 variant you owe (990-N, 990-EZ, or full 990) takes an afternoon instead of a month of digging through bank statements [3]. See [990](/articles/treasurer-basics/990) for how the thresholds work.
What is a club treasurer's spreadsheet actually supposed to include, line by line?
| Date | Deposit date | Payment date | |
|---|---|---|---|
| Description | Event/source name | Vendor/payee | |
| Category | Fundraiser, dues, sponsorship, concessions | Uniforms, equipment, supplies, fees, refunds | |
| Amount | Gross amount received | Amount paid | |
| Payment method | Cash, check, card, Venmo/Zelle | Check number, card, transfer | |
| Counted/approved by | Second counter's initials | Approver's initials | |
| Receipt/reference | Deposit slip number | Receipt or invoice number | |
| Running balance | Optional, useful for spot checks | Optional | Two columns matter more than people think: "counted by" and "approved by." A spreadsheet with two sets of initials on cash transactions is a control, more than a record. It's the cheapest fraud deterrent a volunteer organization has, and it costs nothing but a habit. See financial-controls for more on why two-person counting matters for cash-heavy fundraisers like concessions and gate admissions. One more thing worth a dedicated column on the expense tab: whether the expense was pre-approved in the budget or required a board vote as an exception. That single column saves enormous arguments at year-end audit time. |
Here's a practical field list for the two workhorse tabs, since "track income and expenses" is vague enough to be useless. | Field | Income tab | Expense tab |
What is Form 990, and how does the spreadsheet feed into it?
| Form 990-N | Gross receipts normally ≤ $50,000 | Postcard, 8 basic questions online [4] | |
|---|---|---|---|
| Form 990-EZ | Gross receipts < $200,000 and total assets < $500,000 | Short form [3] | |
| Form 990 (full) | Gross receipts ≥ $200,000 or total assets ≥ $500,000 | Full form with schedules [3] | The IRS states that organizations "whose gross receipts are normally $50,000 or less" may file the 990-N electronic notice instead of a full return [4]. Most small booster clubs and PTOs fall into this bucket. If your income log's annual total sits comfortably under $50,000, your 990 prep tab is basically already your filing worksheet; you're plugging summary numbers into eight web form fields. If you're closer to or over the $200,000 mark, the 990-EZ or full 990 wants your expenses split by functional category (program, management, fundraising), which is exactly why the expense tab's category column should mirror those buckets from day one rather than get reclassified in a scramble every March. See form-990 and 990-tax-form for the filing mechanics, and irs-form-990 for a walkthrough of which schedules typically apply to booster clubs. |
Form 990 is the annual information return that tax-exempt organizations file with the IRS to report income, expenses, and activities for the year [1]. It's not an income tax return in the usual sense, since exempt organizations generally don't pay income tax on mission-related revenue, but it's how the IRS and the public (via Candid/GuideStar and the IRS's own database) see what a nonprofit actually did with its money. There are three main versions a small booster club might file, based on gross receipts and total assets: | Filing | Who files it | Threshold |
What is the 990 tax form's filing deadline, and what happens if the spreadsheet isn't ready?
The 990, in any version, is due on the 15th day of the 5th month after your organization's accounting period ends [5]. For a calendar-year club (most booster clubs and PTOs), that's May 15. For a club running on a school-year fiscal calendar ending June 30, the deadline is November 15. Miss it three years running and the IRS automatically revokes your tax-exempt status by operation of law under Internal Revenue Code section 6033(j); no appeal process exists for the revocation itself, only for reinstatement afterward [2]. The IRS publishes the list of automatically revoked organizations, and reinstatement means refiling for exemption, sometimes with retroactive relief available under Revenue Procedure 2014-11 if you qualify and act within the window it specifies [6]. Confirm current retroactive relief eligibility and procedure with the IRS directly, since the rules and any updated revenue procedures can shift. A spreadsheet doesn't prevent auto-revocation by itself. Filing on time does. But a spreadsheet that's current all year is the difference between a treasurer who files on May 10 in twenty minutes and one who's still reconstructing March's concession stand receipts on May 14 at 11 p.m.
What does a treasurer do in a club that isn't a big nonprofit?
Smaller clubs (think a single team's booster group, or a PTO chapter with a $15,000 annual budget) often assume the rules don't apply to them because they're informal. They do apply. The IRS's 990-N filing requirement applies to any organization recognized as tax-exempt regardless of size, with the $50,000 gross receipts threshold determining which form, not whether to file at all [4]. In practice, a small club treasurer's job looks like this: collect dues and fundraiser proceeds, pay vendors for uniforms and tournament fees, keep the checkbook balanced, report a simple income/expense summary at monthly or quarterly meetings, and file the 990-N by the deadline. The spreadsheet for this scale doesn't need to be complicated. Two tabs (income, expense) plus a bank reconciliation tab covers 90% of what a small club needs. Where small clubs get into trouble is turnover. A treasurer serves one or two years, hands off a shoebox or a login nobody documented, and the next person starts from zero. A spreadsheet with clear tabs and a simple written handoff note solves this better than any accounting software subscription would, because the next volunteer can open it in Excel or Google Sheets with zero training. See handoff-and-audits for a full handoff checklist.
What does a club treasurer do about cash handling specifically?
Cash is where booster club finances go wrong most often, not because volunteers are dishonest, but because cash is easy to lose track of and hard to reconstruct after the fact. Concession stands, gate admissions, raffle ticket sales, and car washes all generate cash that needs a documented count before it ever gets deposited. The spreadsheet's job here is to have a dedicated cash-count log, separate from the general income tab: event name, date, two counters' names, total counted, deposit slip number, and date deposited. That log should tie to a deposit within a few days, not weeks. If cash sits in someone's car for three weeks before hitting the bank, your books are wrong for three weeks and nobody can prove where the money was. A basic but effective rule: no single person counts cash alone and no single person both counts and deposits. Two signatures on the count sheet, one deposit slip, one line in the income log. This isn't about distrust. It's about making sure an honest mistake (or an accusation of one) is provable one way or the other in thirty seconds by looking at a spreadsheet row instead of by memory.
How does a budget vs. actual tab actually get used at board meetings?
The budget vs. actual tab is the report the board actually reads, not the raw transaction logs. It should have one row per budget line (uniforms, tournament travel, concessions revenue, membership dues), with columns for budgeted amount, actual year-to-date, remaining balance, and percent used. Boards care about two things from this tab: are we tracking to plan, and are there surprises. A line that's 140% spent in month four of a twelve-month budget is a surprise worth a five-minute conversation. A line that's 30% spent by month ten might mean a planned expense never happened, or it might mean the club is sitting on money that should've gone somewhere useful. Update this tab monthly, even if meetings happen quarterly. A stale budget report handed to a board is worse than no report, because it creates false confidence. The five minutes it takes to update four formulas after reconciling the bank account is cheaper than the meeting-derailing question of 'wait, is this number current?'
Free template or paid kit: what actually matters for a treasurer spreadsheet?
The honest answer is that the spreadsheet itself is not the hard part. Google Sheets, Excel, and free nonprofit templates from university extension offices and state PTA associations all cover the basic income/expense/reconciliation structure adequately. What's hard is the discipline of updating it weekly, reconciling it monthly, and mapping its categories correctly to whatever your state and the IRS actually require. That's the gap a state-specific setup closes rather than a generic template. BoosterLedger's $99 one-time State-Personalized Treasurer Kit builds the spreadsheet tabs, category mappings, and a state-specific checklist (raffle license requirements, charitable registration thresholds, sales tax exemption paperwork) around your specific state's rules, so you're not guessing whether your category structure will match your state's charity office filing or your 990 threshold. It's not a substitute for an accountant on anything complicated, and it doesn't guarantee any filing outcome or tax-exempt status; think of it as a much better starting template with the state homework already done. If your club's budget is under a few thousand dollars and turnover is low, a free template plus twenty minutes of setup is genuinely fine. If you're inheriting a mess, facing auto-revocation, or setting up a raffle license for the first time, paying to skip the research is a reasonable trade.
What's the difference between a treasurer's spreadsheet and real accounting software?
A spreadsheet is a ledger you build yourself; accounting software (QuickBooks, Aplos, Wave) automates bank feeds, generates financial statements, and enforces double-entry bookkeeping structure. For a booster club or PTO under roughly $250,000 in annual revenue, a well-built spreadsheet usually does the job at zero or near-zero cost. Where software starts to pay for itself: multiple bank accounts, restricted vs. unrestricted fund tracking across several programs, or a treasurer who genuinely doesn't trust manual formulas. Below that complexity level, software often adds a learning curve and a subscription fee for features a small club never uses. The real risk with either tool is the same: garbage in, garbage out. A $40/month accounting subscription updated sporadically produces the same mess as a free spreadsheet updated sporadically. The tool matters less than the habit of touching it every week.
Frequently asked questions
What does a treasurer do?
A treasurer tracks all money coming into and going out of an organization, keeps records that reconcile to the bank statement, reports financial status to the board regularly, and ensures required filings (like Form 990) happen on time. In a booster club or PTO, this is almost always a volunteer role with no formal accounting training required.
What is a treasurer, exactly, in a volunteer organization?
A treasurer is the elected or appointed officer responsible for an organization's finances: cash handling, bookkeeping, banking, budgeting, and financial reporting to the board and members. In booster clubs and PTOs, the role is typically unpaid, term-limited (often one to two years), and defined by the group's own bylaws rather than by law.
What do treasurers do on a weekly or monthly basis?
Weekly: record deposits and payments, file receipts, note cash counts from events. Monthly: reconcile the bank statement against the books, update the budget-vs-actual report, and report to the board. Annually: prepare and file the appropriate Form 990 variant and support the officer transition or external audit if one's scheduled.
What is Form 990?
Form 990 is the annual information return tax-exempt organizations file with the IRS reporting income, expenses, and activities [1]. It's public record, viewable through the IRS's own tools and services like Candid/GuideStar, and it's how the IRS confirms an organization is still active and complying with exempt-status requirements.
What is a 990 tax form used for if nonprofits don't pay income tax?
It's an information return, not an income tax return. It reports what the organization earned, spent, and did during the year so the IRS and the public can verify the organization still qualifies for tax-exempt status and isn't misusing funds. Some 990 variants also trigger state charity registration renewal requirements.
What is the 990-N, and does a small booster club need to file it?
The 990-N (e-Postcard) is the electronic filing available to tax-exempt organizations with gross receipts normally $50,000 or less [4]. Most small booster clubs and PTOs qualify. It's an 8-question online form with no attachments, but skipping it for three straight years triggers automatic revocation of tax-exempt status [2].
What does a club treasurer do differently from a corporate accountant?
A club treasurer usually handles the entire cycle personally: collecting cash at events, making deposits, paying vendors, reconciling the bank account, and reporting to the board, often with zero staff support. A corporate accountant typically works within established software, segregated duties, and a finance department. Volunteer treasurers need simpler, more manual-friendly tools like spreadsheets.
What does a treasurer of a club do if the books are already a mess when they take over?
Start with the most recent bank statement and reconcile backward as far as records allow, flag any gaps to the board in writing, and rebuild an income/expense spreadsheet from bank records even if old receipts are missing. Don't sign or certify a prior year's numbers you can't verify. Check whether required 990 filings were missed, since that affects deadlines and status.
How many tabs should a booster club treasurer spreadsheet have?
Five tabs cover most needs: income log, expense log, monthly bank reconciliation, budget vs. actual, and a 990 prep summary. Smaller clubs with simple finances can often merge this into three tabs (income, expense, reconciliation) and still be fine, as long as reconciliation happens monthly, not annually.
Do I need accounting software, or is a spreadsheet enough?
For most booster clubs and PTOs under roughly $250,000 in annual revenue, a well-maintained spreadsheet is enough. Accounting software starts paying for itself with multiple bank accounts, restricted fund tracking, or a treasurer who wants automated bank feeds. The tool matters less than updating it weekly and reconciling monthly.
What happens if a booster club misses its Form 990 filing deadline?
One missed deadline usually just means a late filing, sometimes with a penalty depending on the form and circumstances; confirm current penalty amounts with the IRS. Three consecutive missed years triggers automatic revocation of tax-exempt status under IRC 6033(j) [2], after which the organization must reapply for exemption, sometimes with retroactive relief available.
Should cash from concessions or raffles go in the same spreadsheet tab as other income?
Use a separate cash-count log for event cash (concessions, gate, raffle ticket sales) that records two counters' names, the total, and the deposit slip number, then roll that total into the main income log once deposited. This creates a documented trail from count to bank, which is the biggest cash-handling control a small club can implement for free.
Sources
- IRS, About Form 990: Form 990 is the annual information return tax-exempt organizations file to report income, expenses, and activities
- IRS, Automatic Revocation of Exemption: Failure to file required returns for three consecutive years results in automatic revocation of tax-exempt status
- IRS, Form 990-EZ, Short Form Return of Organization Exempt From Income Tax: Gross receipts and asset thresholds determine whether an organization files 990-EZ or full Form 990
- IRS, Annual Electronic Filing Requirement for Small Exempt Organizations (Form 990-N): Organizations with gross receipts normally $50,000 or less may file Form 990-N instead of a full return
- IRS, Instructions for Form 990 Return of Organization Exempt From Income Tax: Form 990 is due on the 15th day of the 5th month after the end of the organization's accounting period
- IRS, Revenue Procedure 2014-11: Revenue Procedure 2014-11 sets out procedures for retroactive reinstatement of tax-exempt status after automatic revocation