How to Do Bank Reconciliation for a Sports Club (Volunteer Treasurer Guide)
Club Ledger Editorial Team | Last updated: June 2026
Bank reconciliation is the process of confirming that your transaction records match your bank statement. For a volunteer treasurer, a monthly reconciliation takes 20-30 minutes and catches errors before they compound. Here is how to do it step by step.
Table of Contents
- What Is Bank Reconciliation?
- Step 1: Download Your Bank Statement
- Step 2: Open Your Transaction Log
- Step 3: Match Each Transaction
- Step 4: Investigate Discrepancies
- Step 5: Record the Closing Balance
- Step 6: File the Reconciliation
- Common Discrepancy Causes
- FAQ
What Is Bank Reconciliation?
Bank reconciliation compares two records of the same money:
- Your transaction log - what you recorded as income and expenses
- Your bank statement - what the bank recorded flowing in and out of your account
If both records show the same closing balance, you are reconciled. If they don't match, there's an error somewhere - either in your log or (rarely) at the bank.
For a volunteer treasurer, reconciliation is your primary control against mistakes. It catches duplicate entries, forgotten transactions, and bank fees before they cause problems at year end.
Step 1: Download Your Bank Statement
At the end of each calendar month, download your full bank statement for that month. Most online banking portals offer PDF and CSV formats - both work.
If your bank sends paper statements, scan or photograph them so you have a digital copy for your records.
Step 2: Open Your Transaction Log
Open Club Ledger or your spreadsheet and filter to the same month as the bank statement. You should see all transactions you recorded during that period.
Note your log's current running balance before you start. This is what you are trying to confirm against the statement's closing balance.
Step 3: Match Each Transaction
Work through the bank statement from top to bottom. For each line:
- Find the matching entry in your transaction log
- Confirm the amount matches exactly
- Confirm the date is close (within 1-2 business days for some transactions)
- Mark it as matched
In Club Ledger, the Reconciliation section lets you mark transactions as cleared and tracks the matched running balance automatically.
Step 4: Investigate Discrepancies
Any transaction that appears in one place but not the other needs to be resolved.
| Scenario | What to do |
|---|---|
| In bank, not in log | Add the missing entry to your log with the correct date and amount |
| In log, not in bank | Check if the transaction is still pending - it may clear in the next statement |
| Amount doesn't match | Correct the amount in your log and note the adjustment |
| Duplicate entry in log | Delete the duplicate |
| Bank fee not in log | Add the fee as a new transaction |
Step 5: Record the Closing Balance
Once all transactions are matched, your log's closing balance should equal the bank statement's closing balance.
If they match: you are done. Record the verified closing balance and note the reconciliation date.
If they still don't match: the remaining difference is your reconciling gap. Add a note explaining the gap and its amount. Do not adjust figures to force a match - find the source first.
Step 6: File the Reconciliation
- Mark the month as reconciled in Club Ledger
- Save a copy of the bank statement (PDF is fine)
- The verified closing balance rolls forward as your opening balance for next month
Keeping a reconciliation record for each month means that if you're ever questioned about a transaction, you can trace it back directly to a verified statement.
Common Discrepancy Causes
| Cause | Prevention |
|---|---|
| Bank fees not recorded | Add a recurring entry for monthly fees on the same date each month |
| NSF or returned payments | Log immediately when notified by the bank |
| Cash expenses not logged | Log on the day of purchase, not later |
| E-transfer timing gap | Note as pending; matches the following statement |
| Duplicate entry | Check before adding any transaction that looks familiar |
| Wrong amount (typo) | Double-check dollar amounts at entry time |
FAQ
What is bank reconciliation for a volunteer club or team?
Bank reconciliation is the process of comparing your transaction records to your bank statement to confirm they match. It verifies that nothing has been missed or recorded incorrectly, and produces a verified closing balance that rolls into the next month.
How often should a volunteer club reconcile its bank account?
Monthly. Reconciling once a month keeps the process quick - usually 20-30 minutes for an active club or team - and ensures errors are caught while the details are still fresh.
What causes reconciliation discrepancies in clubs and teams?
The most common causes are transactions recorded on the wrong date, missing entries for small cash purchases, duplicate entries, and bank fees that weren't logged. NSF fees and timing differences on e-transfers are also common.
Does my club or team need to do bank reconciliation?
Yes, if your group holds a bank account and handles money on behalf of members and families. Reconciliation is the minimum standard of financial accountability that members and associations expect from a volunteer treasurer.
What should I do if I can't get the reconciliation to balance?
Add a reconciling note describing the gap and its amount. Do not adjust your records to force a match without finding the source. Flag it for the following month - the root cause usually surfaces when the next statement arrives.