Club Treasurer Report Excel - Free Template

1. Open the Instructions sheet and read the recommended entry process before changing the example data.
2. Go to Transactions and replace the opening balance with the bank balance held on 01/01/2026. The highlighted input cell is formatted as currency.
3. Enter one row per receipt or payment, including the date, description, category, Type, amount, payment method and a useful note.
4. Put receipts in Income (£) and payments in Expense (£), leaving the other amount column blank. Do not enter the same transaction in both columns.
5. Review the running balance against the club bank statement after each bank reconciliation. Investigate any difference before presenting figures to the committee.
6. Check Budget Summary and Dashboard after adding transactions. Use the resulting totals and charts to explain variances, cash available and unusual spending.
7. Save a dated copy after each month-end and retain invoices, receipts, bank statements and committee approvals with the workbook.

A volunteer treasurer normally needs a usable record before the monthly committee meeting, not a complicated accounts package. A football club may collect membership subscriptions in September, pay pitch hire each week and buy equipment during the season; the Transactions sheet gives you one place to record each movement.

Image 1 shows the Transactions sheet headed Riverside Sports & Social Club — Treasurer's Cash Book 2026. The visible columns run from Date and Description through Category, Type, Income (£), Expense (£), Running Balance (£), Payment Method and Notes. The yellow input area for the opening balance is above the table.

Monthly committee reporting

Suppose a club receives £1,250.00 from 25 members and pays £180.00 for January hall hire plus £340.00 for nets and training equipment. Entering those three items makes the cash movement understandable; the note can preserve the detail that the subscription was a bulk payment and the quiz night produced 42 tickets at £5.

Image 2 shows the Budget Summary sheet, which is the natural place to compare the season's plan with recorded activity. A treasurer can use this before approving another equipment order, rather than discovering at year-end that event income was lower than expected.

Preparing the annual meeting

At the AGM, members usually want a concise explanation of income, expenditure and cash held. Image 3 shows the Dashboard, designed to turn the underlying entries into a visual overview, while image 4 shows the Instructions sheet for anyone taking over the role.

This suits a club treasurer who is comfortable with basic Excel but does not need double-entry bookkeeping. It is also useful for a committee secretary checking whether a proposed £600 purchase is affordable after forthcoming hall hire and affiliation fees are considered.

That same check becomes easier when the committee has a cash record showing the running balance after each receipt and payment.

A spreadsheet is a management record, not a substitute for source documents. Keep the bank statements, invoices, receipts, membership schedules and minutes approving significant spending with the workbook. A club registered as a company must generally retain accounting records for 6 years; a self-employed person keeps records for 5 years after the 31 January Self Assessment deadline, although an unincorporated club should set a written retention policy appropriate to its tax and governance obligations.

For a club registered for VAT, the standard rate is 20%, the reduced rate is 5% and the zero rate is 0% for qualifying supplies. VAT registration is required when taxable turnover exceeds £90,000. The VAT amount should be supported by a valid VAT invoice, and quarterly VAT returns under Making Tax Digital require digital records and compatible software.

Separate club money from personal spending

Use the club bank account for club receipts and payments wherever possible. If a volunteer pays £75.00 personally for first-aid supplies, record the expense and keep the receipt, then record the £75.00 reimbursement clearly; do not hide it in a general cash total.

Image 1's Type, Income (£) and Expense (£) fields help make that distinction visible. A payment must have a date, description and category that another committee member can understand six months later. In practice, “equipment” is more useful than “miscellaneous” when the AGM asks why spending rose.

Tax and governance points

Trading income, room hire, fundraising and membership subscriptions can have different tax treatment. Gift Aid claims require appropriate declarations and records, while an incorporated club files with Companies House and may have Corporation Tax responsibilities. Keep approvals in meeting minutes; a £1,200 grant-funded purchase should show both the grant restriction and the invoice.

Choose cash-book categories that match the club's reporting needs rather than copying a commercial chart of accounts. The £90,000 VAT threshold and 20% rate are practical review triggers, not reasons to add VAT to every receipt automatically.

The most damaging mistake is treating the bank balance as the same thing as the club's complete financial position. A treasurer may see £3,500.00 in the account but still owe £900.00 for a tournament, have £600.00 of restricted grant money and hold £400.00 of cash not yet banked. Reporting £3,500.00 as freely available money can lead to an unaffordable purchase.

Small entry errors with large consequences

Double-entering a £180.00 hall-hire payment reduces the running balance by £360.00. Entering it once as £180.00 in Income (£) and once as £180.00 in Expense (£) can make totals look plausible while reversing the true result. Check the bank statement line by line and investigate any duplicate description, date or amount.

Another frequent problem is recording a batch of 25 subscriptions as one amount without a membership list. The cash book may show £1,250.00, but the treasurer cannot explain which members have paid, who is outstanding or whether a refund is included. Use the Notes field for the batch detail and keep the supporting schedule separately.

Categories and timing

Putting pitch hire, equipment and safeguarding checks into “general expenses” removes the information needed for next season's budget. If equipment spending is £340.00 in February and £460.00 in March, a committee may need to pause purchases even if total cash remains positive.

Cash timing also causes confusion. A £600.00 annual insurance payment made in August affects the bank immediately, while a supplier invoice received in March but unpaid belongs in the list of amounts owed for the year-end review. The workbook is a cash book, so do not present its running balance as an accruals-based profit figure.

Finally, changing formulas, deleting headings or typing over the dashboard can break the report. Keep a clean master copy and save a dated version before making corrections.

Attach the workbook to a fixed event in the club calendar. The simplest routine is to update Transactions on the first Monday after the bank statement arrives, then complete a short review before the monthly committee pack is circulated. A club with 35 payments in a month can usually clear them in 20–30 minutes when receipts are already filed.

A repeatable month-end check

• Download or open the bank statement and tick each recorded receipt and payment.
• Check that the calculated running balance agrees with the statement balance, allowing for uncleared items.
• Review unusual categories, missing notes and any expense without an invoice or receipt.
• Open Budget Summary and Dashboard, then copy the relevant figures into the committee report.

Use consistent descriptions such as “March pitch hire — Juniors” rather than changing the wording every month. That makes searching and reviewing easier. Enter dates as DD/MM/YYYY and amounts as £ figures so totals and charts remain reliable.

Making handover easier

Save one file per financial year and keep the original workbook unchanged as a master. At handover, the outgoing treasurer should explain the opening balance, outstanding payments, restricted funds and any recurring subscriptions; the Instructions sheet gives the incoming volunteer a starting point.

Do not add unnecessary complexity. For a club with 300 orders or transactions a month, multiple bank accounts, stock or several restricted grants, a proper bookkeeping system is safer than a growing manual spreadsheet. Until that point, a disciplined monthly reconciliation and a dated backup will usually provide better control than an elaborate workbook nobody updates.