Quarter-end bank reconciliation checklist for small businesses
Close July–September with an account inventory, statement checks, outstanding-item list and a clear handover to your bookkeeper.
A quarter-end bank reconciliation compares the bank's records with your books and explains every difference. Start with every account, finish each month's checks, then carry only genuine outstanding items into the next quarter. A converter checks extracted statement arithmetic; it does not reconcile the accounting ledger for you.
For the quarter ending 30 September 2026, gather July, August and September statements as they become available. You can prepare July and August now; do not sign off September using a partial transaction export as though it were the final statement.
Download the quarter-end checklist (.csv) and use the free reconciliation workbook for statement arithmetic.
1. Make the account list
Include current/checking accounts, savings, business cards, payment processors and any closed account used during the period. Record the account, currency, month, statement received, opening balance, closing balance and reviewer. Keep separate rows for separate currencies.
For each account, confirm June's closing balance agrees with July's opening balance. An unexplained opening difference should not be buried in September as a balancing adjustment.
2. Establish one transaction source per period
A bank feed may already cover part of July. Before importing PDFs, identify the first and last dates already present in the books. Fill the missing range rather than importing a full quarter over an active feed.
The bank-feed guide explains where statement conversion helps. If duplicates have already appeared, use the duplicate-import help guide and compare original records before removing anything.
3. Check each statement's extraction
Use the bank's CSV export when it covers the required period. Otherwise convert the PDFs, review flagged results and save the untouched export. Check that opening balance plus signed transactions equals closing balance, where the statement supplies both balances.
Also inspect dates, payees and page boundaries. Matching totals cannot detect a wrong description or two mistakes that cancel each other out. The PDFs remain the source evidence.
4. Match the statement to the ledger
Match receipts and payments to existing entries before creating new ones. Check customer deposits against invoices, supplier payments against bills, and card repayments against the card account. Investigate bank fees and interest that have not yet been recorded.
Here is a synthetic quarter-end example, in one currency:
| Reconciliation item | Amount |
|---|---|
| Bank statement closing balance | 8,420.00 |
| Add: genuine deposit in transit | 600.00 |
| Less: payment recorded but not yet cleared | 250.00 |
| Adjusted bank balance | 8,770.00 |
| Ledger balance before bank fee | 8,790.00 |
| Less: bank fee not yet recorded | 20.00 |
| Adjusted ledger balance | 8,770.00 |
The £20 fee needs a supported ledger entry. The £600 and £250 are timing differences requiring evidence and later clearance. These are different jobs; do not enter all three as expenses to force the accounts to agree.
5. Review outstanding items
For every unmatched item, record its date, amount, explanation, supporting document, owner and next action. Check October's activity for clearance after quarter-end. Investigate old outstanding payments rather than carrying them forward indefinitely.
A payment that never clears may require correction or cancellation, but the treatment depends on what happened. Ask the responsible bookkeeper before changing a closed period.
6. Keep tax review separate
A reconciled bank account is useful evidence, not a completed tax calculation. Invoices, credit notes, payroll, cash transactions and non-cash adjustments may also be needed. For MTD, VAT or BAS work, use the correct reporting basis and period in the relevant software.
7. Sign off the pack
Save the source statements, exports, ledger reconciliation, outstanding-item list and review date. Record who reviewed it and unresolved questions. Keep the working file separate from the original export so later category changes do not destroy your evidence trail.
Repeat the same checklist next quarter. Combining statements into Excel can shorten preparation, but account-by-account checks are still what make the close explainable.
Statements in, clean books out.
NoRekey converts bank statement PDFs to CSV, Excel, OFX and QFX — every conversion balance-checked. Free to try.
Convert a statement free →Free bank reconciliation template for Excel (and how to use it)
A clean Excel reconciliation template with the formulas already wired — opening balance, running balance, and an automatic reconciled/not-reconciled verdict. Free download, no email wall.
How to combine multiple bank statements into one Excel file
Merge monthly statement PDFs into one spreadsheet, retain the source of every row, and check accounts, currencies and overlaps before importing.
Bank feeds vs statement conversion: when you need each
Feeds are the present tense of bookkeeping; statements are its past and its proof. A practical guide to which tool fits which job — and why most practices quietly need both.