GAA · soccer · rugby · golf · community groups

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
Add to basket
Club Treasurer's Cashbook – Dashboard

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

  1. Choose the account and the month end
  2. Compare the book balance with the statement
  3. List lodgements in transit and unpresented cheques
  4. Tick off the treasurer's checklist

Inside the workbook

Common questions

Receipts and payments or income and expenditure?
A receipts and payments account lists money in and out. An income and expenditure account also takes in amounts owed. The AGM report uses income and expenditure.
Does our club have to register as a charity?
It depends on the club's purposes. SETTINGS records whether the club is a registered charity and its Revenue status.
Can the next treasurer take over?
Yes. Everything is in one file with categories and checks, so a handover is straightforward.

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.

Hand the AGM a report everyone understands

Add the cashbook to your basket and continue to payment.

Add to basket