Accounting software has made matching bank transactions fast, and that has made it easy to confuse matching with reconciling. A bank reconciliation proves that the cash balance in your ledger agrees to the bank’s record at a fixed date, and that every difference between the two has a known cause, an owner and an expected clearing date. It also gives someone other than the preparer a regular chance to look at every payment that left the account. This free bank reconciliation checklist gives controllers, finance managers and bookkeepers a repeatable process for every account they hold. It covers gathering statements, matching, investigating reconciling items, posting adjustments, preparing the reconciliation and getting an independent review. A conditional escalation phase appears only when there is an unexplained difference or a transaction nobody recognises, and the whole checklist can be scheduled to start itself each month.
Every bank reconciliation produces a list of differences between the bank statement and the general ledger. The skill is in sorting that list quickly into two groups. Timing differences are transactions both sides know about but have recorded on different dates. They clear on their own, usually within days. Items that need action are differences only one side knows about, or that one side has recorded wrongly. They never clear on their own, and every month they are left alone makes them harder to explain.
The most common failure is not a reconciliation that doesn’t balance. It is one that balances by carrying the same unexplained items forward month after month, until a small difference from last spring has become part of the furniture. A good checklist makes the age of every item visible and sets a point at which old items must be escalated rather than rolled forward again.
Examples: deposits in transit, outstanding cheques and payments, card settlements that land a day or two after the sale.
What to do: list them with dates, confirm they clear early in the next period, and question anything that doesn’t.
Warning sign: a “deposit in transit” that is still in transit at the next month end.
Examples: bank fees and interest, returned customer payments, direct debits not yet in the ledger, duplicate postings, transposed amounts and debits nobody recognises.
What to do: post a correcting entry with support, or escalate the same day if the transaction can’t be explained.
Warning sign: a round-sum adjustment to a suspense account to “make it balance”.
Six phases take each account from statement to signed-off reconciliation. A seventh phase appears only when there is a difference or a transaction nobody can explain.
An account that isn’t on the list doesn’t get reconciled. Start from the bank account register, not from memory.
Assign this phase to someone who did not prepare the reconciliation and who cannot initiate or approve payments from the account.
Shown only when Phase 5 records an unexplained difference or a transaction nobody recognises. In a normal month this phase stays empty.
Most businesses hold more accounts than the main operating account, and each type produces its own kind of reconciling item. Use the table to build your account list in Phase 1 and to brief whoever prepares each reconciliation. The frequency column is a starting point; businesses with high volumes or a history of errors reconcile their busiest accounts weekly or even daily.
| Account | Typical frequency | Common reconciling items | Watch for |
|---|---|---|---|
| Main operating account | Monthly; weekly or daily at high volume | Deposits in transit, outstanding payments, bank fees | Debits nobody recognises; duplicate supplier payments |
| Payroll account | Every pay run, and monthly | Uncashed payroll cheques, returned payments | Payments to people who aren’t on the payroll register |
| Payment processor clearing (Stripe, PayPal, Square, card acquirers) | Weekly | Processor fees, refunds, chargebacks, reserves, settlement timing | Sales recorded net of fees, which understates revenue and expenses |
| Business credit cards | Monthly, to the card statement | Unposted transactions, statement cut-off dates | Personal spend and missing receipts |
| Foreign currency accounts | Monthly | Revaluation at the closing exchange rate | Exchange differences being written off as “errors” |
| Loans and credit lines | Monthly, to the lender statement | Interest charged, drawdowns, repayments | Balances that feed covenant calculations |
| Petty cash | Monthly, with a physical count | Vouchers not yet posted | Top-ups without receipts |
Why reconciling promptly matters. The time you have to dispute a transaction with your bank is limited. In the US, the Uniform Commercial Code requires a customer to examine statements with reasonable promptness (UCC §4-406(c)), and a customer who doesn’t report an unauthorised signature or alteration within one year of the statement being made available can’t assert it against the bank (§4-406(f)). Your deposit agreement may set a shorter period, so check it. In the UK, the Payment Services Regulations 2017 require an unauthorised or incorrectly executed payment to be reported without undue delay, and no later than 13 months after the debit date. In both cases the practical window is shorter than the legal one: the sooner a fraudulent payment is reported, the better the chance of recalling it.
Old, uncashed cheques. A cheque that has not been presented after six months is generally treated as stale. In the US a bank has no obligation to pay one (UCC §4-404), although it may still do so in good faith. In the UK most banks treat cheques as out of date after six months, but that is banking practice rather than law, and the only sure way to cancel a cheque is to stop it. Don’t simply write an old cheque back to income. In the US, uncashed payroll and supplier cheques usually become unclaimed property that must be reported to the state after a dormancy period set by that state, often one year for wages and three to five years for supplier payments. Some states exempt business-to-business payments, so check the rules in each state before you reverse one.
A recurring schedule creates the reconciliation on the first working day of the month, one checklist per account or per entity, and assigns it to the preparer. A reconciliation that hasn’t been started shows as overdue, so a missed account is visible the same week rather than at the year-end audit.
The review phase is assigned to a named reviewer and ends in an approval, so the person who matched the transactions cannot sign off their own work. Each task records who completed it and when, and the statement and reconciliation are attached to the task they support.
When the preparer records an unexplained difference, the escalation phase appears with its own owner and due dates. Auditors can see every month’s reconciliation, the reviewer’s sign-off and how each exception was resolved, without anyone rebuilding the file.
The bank reconciliation is one step in the wider close. The Month-End Close Checklist puts it in sequence with the other balance sheet reconciliations, and our guide to the month-end close explains how bank, subledger and intercompany reconciliations fit together.
If you run reconciliations for several entities or clients, CheckFlow’s recurring checklist software shows how one template can generate a separate checklist for each account on its own schedule, with a single view of which are complete, in review or overdue.
It is a step-by-step list for proving that the cash balance in your accounting records agrees to the bank statement at a given date. It covers collecting the statements, matching transactions, investigating and clearing the differences, posting adjustments, preparing the reconciliation and having it reviewed by someone independent. A checklist makes sure the same steps happen for every account, every month, whoever is preparing it.
At least monthly, as part of the month-end close. Accounts with high volumes, such as a main operating account or a payment processor clearing account, are often reconciled weekly or daily. Frequent reconciliation keeps each exercise small and means unauthorised transactions are spotted well inside the time your bank allows for reporting them.
Deposits in transit and outstanding cheques or payments are the most common, and both are timing differences that clear on their own. Bank fees, interest, returned customer payments and direct debits not yet recorded are items the bank knows about before you do. Errors, such as transposed figures or duplicate postings, can occur on either side. Anything that doesn’t fit one of those categories should be investigated straight away.
Someone who did not prepare it, and ideally someone who cannot initiate or approve payments from the account. That separation is what makes the reconciliation a control rather than a formality. In a small business the reviewer is often the owner or an external accountant; in a larger finance team it is usually the financial controller or a senior accountant.
Don’t post it to suspense and move on. Check the obvious causes first: an opening balance that doesn’t agree to last month, a transaction posted to the wrong bank account, a duplicated bank-feed import or a transposed figure. If the difference still can’t be explained, or a debit on the statement isn’t recognised, escalate it the same day and contact the bank. The conditional phase in this template exists for exactly that case.
It does the matching, which is Phase 2 of this checklist. It doesn’t confirm that the feed is complete, investigate old reconciling items, get adjustments approved or give an independent reviewer a reason to look at the statement. Clicking “reconcile” on a bank feed and reviewing a reconciliation are different things. Use the software for the matching and the checklist for everything around it.
14-day free trial, no card required. The Business plan is $10 per user per month after the trial. Full details at checkflow.io/pricing.
