Club accounts spreadsheet for the treasurer – from cashbook to AGM report
Club treasurers inherit shoeboxes of receipts and a bank statement that never quite matches. The cashbook keeps every lodgement and payment across the bank, the club app or card reader and the cash box, reconciles them monthly and produces the treasurer's report for the AGM.
- 600 cashbook lines across 6 accounts
- 300 memberships with family and juvenile rates
- 150 petty cash vouchers
- Net result for 25 fundraisers and events

Subs and fundraising
MEMBERS records family, adult, juvenile, student and senior memberships with discounts and payments, and flags overdue subs. FUNDRAISERS shows what each fundraiser really made after costs – the weekly lotto, raffles, a table quiz, race night, golf classic or summer camps.
Workbook facts
- START
- SETTINGS
- CASHBOOK
- MEMBERS
- PETTY CASH
- BANK RECONCILIATION
- BUDGET
- FUNDRAISERS
- AGM REPORT
- DASHBOARD
- File format
- .xlsx
- Tabs
- 10
- Capacity
- 600 cashbook lines · 300 memberships · 150 petty cash vouchers · 25 events · 6 accounts · 40 categories
- Requires
- Excel 2016+ / Microsoft 365
- Macros
- None
Monthly bank reconciliation
- Choose the account and the month end
- Compare the book balance with the statement
- List lodgements in transit and unpresented cheques
- Tick off the treasurer's checklist
Inside the workbook




Common questions
Receipts and payments or income and expenditure?
Does our club have to register as a charity?
Can the next treasurer take over?
Ready for the AGM
BUDGET compares last year, this year's budget and the actual figures by category, using the share of the year gone as a yardstick. AGM REPORT fits on one A4 page: an income and expenditure account and the club's assets and liabilities, this year against last.