Bank reconciliation checklist
The bank reconciliation checklist
This is a step-by-step bank reconciliation checklist — gather the statement, match cleared items, investigate the difference, resolve it to zero, then document — grouped so you can work one account at a time. Tick items as you go; your progress saves in your browser, so you can close the tab and come back.
The checklist, phase by phase
0 of 21 — start anywhere.
Gather the statements
Match the cleared items
Investigate the difference
Resolve to zero
Document
The list is print-friendly — to keep a copy, use your browser's print option and choose Save as PDF.
How to use this checklist
Reconcile one account for one statement period at a time, top to bottom. The phases build on each other: you gather the statement so you have a fixed target, match everything that has already cleared, then investigate only the difference that's left. That last part is the whole job — a reconciliation that won't hit zero is telling you a transaction is missing, doubled, mistyped, or sitting in the wrong month, and the Investigate phase walks those in the order they usually turn up.
The one rule that saves you later: never force the difference to zero with an adjustment you can't explain. A forced reconciliation looks finished but buries the real error, and it resurfaces the next month sitting on top of a balance that was never right. Tick items as you finish them — your progress saves in your browser on this device, so you can stop and come back. When the difference traces back past the current statement, that's the moment to hand the file over rather than keep chasing it.
Questions about bank reconciliation
Do I have to do the phases in order?
Yes — the order is the method. You gather the statement first so you have a fixed target, match what has cleared, then investigate whatever difference is left. Skip to investigating before you have matched the easy items and you waste time chasing transactions that were only unmatched.
What does it mean when the difference won't go to zero?
A non-zero difference means the cleared transactions in QuickBooks don't add up to the statement's ending balance. It is almost always a missing transaction, a duplicate, an amount typed wrong, or something cleared in the wrong month — not a mystery. The Investigate phase walks the usual suspects in order.
Does my progress save?
Yes. Each item you tick is stored in your browser on this device, so you can close the tab and pick up where you left off. It is not sent anywhere; clearing your browser data or switching devices starts the list fresh.
What if the account still won't reconcile?
Some files carry an older discrepancy that predates the month you're working on, or a prior reconciliation that was forced. When the difference traces back beyond the current statement, that is the point people hand it off. A free QuickBooks review will tell you where the break started before you spend more hours on it.