Service Charge Budget Excel
Budget, levies, arrears & sinking fund for OMCs
- Budget in the 9 categories of the MUD Act, vs actual
- Levy per unit from the lease share or floor area
- Arrears aged 0–30 / 31–60 / 61–90 / 90+ days
One-off purchase – no subscription
Club Treasurer Accounts Excel
Cashbook, members' subs, bank reconciliation, budget, fundraisers and the AGM accounts for Irish clubs and voluntary groups
€49incl. VAT
The treasurer's whole year in one workbook – from the first lodgement to the AGM
10sheets
600cashbook lines
0macros
- Cashbook for the bank current and deposit accounts, the club app or card reader, the cash box and transfers between them
- Members' subscriptions with family, adult and juvenile rates, discounts, payments and overdue subs flagged
- Monthly bank reconciliation with lodgements in transit, unpresented cheques and a treasurer's checklist
- Budget vs actual by category and month, with the year elapsed as the yardstick
- Net profit of the club lotto, raffles, table quiz, race night, golf classic and camps
- A4 treasurer's report for the AGM: income & expenditure account and statement of assets & liabilities
STARTSETTINGSCASHBOOKMEMBERSPETTY CASHBANK RECONCILIATIONBUDGETFUNDRAISERSAGM REPORTDASHBOARD
Found an error in the template? We'll fix it – or refund you.
Club accounts for the volunteer treasurer – ready for the AGM
Record every lodgement and payment once. The workbook keeps the bank balances, the subs, the budget and the fundraisers up to date and prints the accounts for the AGM.
Taking over as treasurer often means a shoebox of receipts, a bank statement, a list of who paid their subs and a cash box after every home game. At the end of the year the members expect clear accounts at the AGM – and the independent examiner wants to see that the books agree with the bank.
This workbook is built for Irish clubs and voluntary groups – GAA, soccer and rugby clubs, community groups, parents' and residents' associations. Enter each receipt, payment and transfer once in the CASHBOOK: the balances of every account, the budget, the fundraisers and the AGM report update by themselves, and the bank reconciliation shows exactly which lodgements and cheques have not reached the statement yet.
Without a template
- Receipts, subs and lotto money spread over notebooks, apps and envelopes
- Nobody is sure who has paid their subs this year
- The bank statement never quite agrees with the books
- A rushed set of accounts the night before the AGM
With ExcelGrand
- One cashbook for all accounts, with transfers and checks on every line
- A members list with rates, payments and overdue subs flagged
- A monthly bank reconciliation with the items still to clear
- An A4 treasurer's report produced automatically from the year's figures
What's in the file
START
Key figures, quick links and a step-by-step guide.
SETTINGS
Club details, financial year, charity / Revenue status, two-signatory limit, 6 accounts with opening balances, membership rates, 40 categories with AGM headings and the lists used in the dropdowns.
CASHBOOK
600 lines: date, receipt or cheque number, category, account, transfer to, money in or out, event, cleared date, running balance and a check on every line (refunds, outside the year, two signatures…).
MEMBERS
300 memberships – family, adult, juvenile, student, OAP or honorary – with discount, amount paid, date, method, balance, status and reminder date, checked against the subs in the cashbook.
PETTY CASH
Imprest float with vouchers, receipt check, single-payment limit, top-ups from the bank, cash count and the top-up needed.
BANK RECONCILIATION
Account and month end of your choice: book balance, lodgements in transit, unpresented payments, statement balance and difference, the items still to clear, a 12-month grid and the treasurer's checklist.
BUDGET
Last year, budget and actual by category, variance, % used, status against the year elapsed and 12 months side by side.
FUNDRAISERS
Lotto, raffles, bag packs, quiz, race night, golf classic, camps…: income, costs, net profit, margin, target and a permit reminder.
AGM REPORT
A4 treasurer's report: income & expenditure account and statement of assets & liabilities against last year, key figures and signatures.
DASHBOARD
Cash & bank, surplus, subs outstanding and fundraising net, with four charts.
Take a look inside
Specifications
Format.xlsx
RequiresExcel 2016+ / Microsoft 365
Sheets10
Capacity600 cashbook lines · 300 memberships · 150 petty cash vouchers · 25 events · 6 accounts · 40 categories
AGM reportA4 – income & expenditure and assets & liabilities, this year vs last year
MacrosNone
Who is it for?
- GAA, soccer & rugby club treasurers
- Residents' associations
- Parents' associations
- Community groups & committees
- Independent examiners
Frequently asked questions
How do I keep the accounts for a small club?
Keep one cashbook: every lodgement, payment and transfer on its own line, with the date, a receipt or cheque number, a category and the account it went through. Lodge cash promptly, keep a receipt for every payment and reconcile with the bank statement every month. The CASHBOOK sheet does the balances and flags lines that need a second look.
What should a treasurer's report for the AGM include?
At least the income and expenditure for the year by heading, compared with last year, the surplus or deficit, and what the club has in the bank and in cash at the year end – plus anything it owes or is owed. The AGM REPORT sheet prints this on A4, with key figures such as members, subs collected, grants and fundraising, and lines for signatures.
What is the difference between a receipts and payments account and an income and expenditure account?
A receipts and payments account lists the money that came in and went out during the year. An income and expenditure account also takes into account money owed to the club, stock and money the club owes at the year end. The workbook starts from the cashbook and lets you add these year-end items, so you can use either approach.
How do you do a bank reconciliation for a club?
Take the balance on the statement at the month end and compare it with the cashbook: lodgements not yet on the statement and cheques not yet presented explain the difference. Choose the account and month in BANK RECONCILIATION, enter the statement balance and the sheet lists the items still to clear and shows whether it agrees.
Does our club have to register with the Charities Regulator?
It depends on what the club is for. A body set up solely to promote athletic or amateur games or sports is generally an excluded body and not a charity under the Charities Act 2009, while a community group with charitable purposes may need to register. Check charitiesregulator.ie, and ask Revenue or your accountant about tax exemptions such as the sports body exemption or a CHY number.
Do we need a permit for the club lotto or a raffle?
Lotteries, raffles and collections may need a permit or licence, and the rules are changing under the Gambling Regulation Act 2024. Check grai.ie and your local Garda station before you start. The FUNDRAISERS sheet has a column to record that you have checked.
Other templates you may need
Fire Safety Register Excel
Fire safety log book with due-date alerts for Irish buildings
- Weekly fire alarm test log with call point rotation
- Monthly checks of fire doors, escape routes and emergency lighting
- Service due dates for extinguishers, alarm and other equipment
Risk Assessment Template Excel
Hazard register, 5×5 risk matrix, action plan & Safety Statement checklist
- Hazard register by area with who is at risk and existing controls
- 5×5 likelihood × severity scoring with colour-coded ratings
- Action plan with owner, target date from the rating and overdue alerts
Club Treasurer Accounts Excel
Cashbook, members' subs, bank reconciliation, budget, fundraisers and the AGM accounts for Irish clubs and voluntary groups · €49
Club accounts spreadsheet in Excel for treasurers of Irish clubs and associations
A club accounts spreadsheet gives the treasurer one place for the cashbook, the members' subscriptions and the bank reconciliation, and turns them into the income and expenditure account for the AGM. This club treasurer template works for a GAA club, a soccer or rugby club, a community group, a parents' association or a residents' association.
Use it as a treasurer spreadsheet template, a simple cashbook for a voluntary group, a membership subscriptions tracker, a club budget template or a fundraising tracker for the club lotto, raffles and table quiz – with petty cash, an A4 treasurer's report and a dashboard for committee meetings, no macros and no subscription.
Club Treasurer Accounts Excel€49