A club treasurer report takes the period's bank statement and turns it into four numbers members care about: the opening balance, money in by category, money out by category and the closing balance. Add a short check showing the closing figure matches the bank, and fit the whole club report on one page.
What goes in a club treasurer report?
A club treasurer report answers three questions for members: how much money the club has, where it came from, and where it went. The bank statement for the period holds almost everything you need. Your job is to group its lines into a few categories that make sense to people who never see the statement.
The standard parts, in order:
- Period covered, such as "September 1 to September 30".
- Opening balance, taken from the statement.
- Income by category: dues, event tickets, donations, sales, interest.
- Spending by category: venue hire, supplies, insurance, refreshments, bank fees.
- Closing balance, which should equal the opening balance plus income minus spending.
- Reconciliation note, explaining any difference from the bank's figure.
- Notes for the meeting: big payments coming up, unpaid dues, a decision members need to make.
Keep the categories steady from one report to the next. If "refreshments" becomes "food and drink" in March, members lose the ability to compare months. A list of eight or fewer categories covers most clubs.
Some clubs also want a budget column beside the actuals. If the members approved a budget at the start of the year, add it. Otherwise leave it out. A report with an empty column looks unfinished.
Sorting club bank statement lines into treasurer categories
Sorting club bank statement lines is the main work of the report. Each line on the statement gets one category, and the totals per category become the report's middle section. A spreadsheet with four columns does it: date, description, amount and category.
Start by getting the lines into the sheet. Many banks let you export recent transactions to CSV from online banking, which is free. If you only have the PDF statement, you can type the lines, which is fine for a quiet month of twenty rows. For a busy month after an event, converting the PDF saves an evening: CheapBankConvert, once it opens, will turn one statement into a spreadsheet for a single payment, and a statement of two pages or fewer will convert free.
Then tag each line:
- Deposits from members, often labelled with a name or a payment app reference, go to dues.
- Deposits around an event date go to event income, even if some are card payouts from a ticketing service.
- Payments to the hall, school or park go to venue hire.
- Small fees from the bank or a payment processor go to bank fees. Do not fold processor fees into event income, or the event looks less profitable than it was.
- Anything you cannot place goes to "to be checked", never to "other".
A pivot table, or a simple SUMIF per category, gives the totals. Check that the category totals add up to the statement's total deposits and total withdrawals. If they do not, a line is untagged or tagged twice.
Payment app payouts need care. A ticketing service may send one deposit that bundles thirty ticket sales minus its fees. Use the service's own report to split the gross sales from the fees, so the report shows both.
The balance check behind a club treasurer report
The balance check is what lets members trust a club treasurer report. Start with the bank's closing balance, adjust it for anything the bank has not processed yet, and the result should equal the closing balance in your report. Treasurers call this a bank reconciliation, and it takes a few minutes once the lines are sorted.
The usual adjustments:
- Checks written but not yet cashed. Subtract them from the bank balance.
- Deposits made but not yet on the statement, such as cash dropped at the branch on the last day. Add them.
- Bank errors, which are rare. Note them and call the bank.
Here is an example with made-up figures:
| Item | Amount |
|---|---|
| Closing balance on the bank statement | $2,846.10 |
| Less: check 312 to Hall Rentals, not yet cashed | -$180.00 |
| Plus: cash deposit of September 30, not yet shown | +$95.00 |
| Adjusted balance | $2,761.10 |
| Closing balance in the treasurer report | $2,761.10 |
When the two figures match, write "Reconciled to the bank statement of September 30" on the report. When they do not, the gap usually equals one transaction: a missed line, a line counted twice, or a sign entered the wrong way. A gap of exactly double one amount usually means a sign error.
A one-page club treasurer report for members
A one-page club treasurer report gives members the totals and the reconciliation, and nothing they have to decode. Leave the transaction list out of the report itself. Keep it ready for anyone who asks, but most members only want the summary.
The report below is an example for a fictional hiking club, with example values.
Ridgeline Hiking Club, treasurer report for September 2026
| Amount | |
|---|---|
| Opening balance, September 1 | $2,412.75 |
| Income | |
| Member dues | $640.00 |
| Autumn trail day tickets | $1,150.00 |
| Donations | $75.00 |
| Bank interest | $0.62 |
| Total income | $1,865.62 |
| Spending | |
| Park shelter hire | $180.00 |
| Trail day supplies and food | $864.30 |
| Insurance, annual premium | $425.00 |
| Ticketing and bank fees | $47.97 |
| Total spending | $1,517.27 |
| Closing balance, September 30 | $2,761.10 |
Reconciled to the bank statement dated September 30, with one uncashed check of $180.00 and one deposit in transit of $95.00.
Notes for the meeting:
- The trail day brought in $1,150.00 in tickets against $864.30 of supplies and food, leaving $285.70 before ticketing fees and the shelter hire.
- Six members have not yet paid this year's dues.
- The van hire deposit of $300 for November is due next month.
Arithmetic check: $2,412.75 plus $1,865.62, minus $1,517.27, is $2,761.10. Do this sum on every report before you send it. The ticketing fees in this example are part of the $47.97 line. The note on profit would be clearer still if you split them out, which is one reason to keep fees in their own category.
Some readers outside the club may ask for evidence of its funds, such as a grant body or a venue that wants a deposit guarantee. The report is not that evidence. Send the bank statement itself, and the post on what a proof of funds bank statement must show explains what such readers check.
Which club treasurer records should you keep, and who sees them?
A club treasurer should keep each period's bank statement, the spreadsheet of tagged lines, receipts for spending, and the report as presented. Members usually see the report. The committee or an appointed reviewer sees the detail. Your club's rules or bylaws may say how long to keep records and who reviews them.
If the club is a tax-exempt organization, there may be a federal filing too. The IRS page on the Form 990-N e-Postcard for small exempt organizations says small tax-exempt organizations whose annual gross receipts are normally $50,000 or less are generally eligible to file it. It also warns that organizations failing to file a required return for three consecutive years automatically lose tax-exempt status. Not every club is a tax-exempt organization, so check your club's status before assuming a form applies.
Gross receipts, in that IRS sense, are the total amounts received from all sources without subtracting costs. Your income section is close to that figure, as long as you record ticket sales gross and put fees under spending. That is another reason not to net fees off event income.
Think about where the files live. Statements carry the club's account number and members' names in deposit descriptions. Keep them in a shared folder only the committee can open, and be careful what online tools you upload them to. The post on what happens in a converter data breach explains the risks and the questions to ask a site before you trust it with a statement.
Cash, personal cards and other club treasurer report problems
Cash and personal cards cause most club treasurer report problems, because neither shows up cleanly on the club's bank statement. Cash collected at an event may never reach the bank in one piece, and a purchase on a member's own card appears on their statement, not the club's. Both need a paper trail the treasurer creates.
Cash at events. Count it with a second person, write the total on a slip that both of you sign, and deposit the whole amount. Do not pay expenses from the cash box. If you do, the bank deposit no longer matches the takings and the report cannot be checked.
A member pays with a personal card. Reimburse them from the club account with a transfer or check, against a receipt. The club statement then shows the expense, labelled with the member's name. Note what it was for in the category column.
The treasurer pays from their own account. Avoid it. Besides blurring the club's records, it leaves club spending in your personal statements, which you may later need for something else, such as bank statements for an apartment application, where a landlord would see the club's costs as yours.
Missing receipts. Write a short note with the date, the amount, the payee and the purpose, and have a second committee member initial it.
The previous treasurer left gaps. Rebuild the missing months from bank statements first, then ask for receipts. A statement is the one record the bank can always supply again.