How to Reconcile a Bank Statement
Reconciling is one question asked carefully: does what the bank says happened match what your books say happened. Everything else is bookkeeping around that question: the ticking, the screens, the little running difference in the corner.
Published 10 August 2026 · 7 min read
The short answer
Take the closing balance from your statement, take the opening balance from the last time you reconciled, and tick off every transaction in your books that also appears on the statement. When the ticked transactions plus the opening balance equal the closing balance, the account is reconciled. When they do not, the gap is the size of what is missing, duplicated or wrong, and that figure is the most useful thing you have.
Write the difference down before you start hunting. People adjust three things, lose track of the original gap, and can no longer tell whether they are closer than when they began.
What reconciling actually proves
Your books are a claim about what happened to the money. The bank statement is a second, independent record of the same events, produced by somebody with no interest in agreeing with you. Reconciling puts the two side by side and asks whether they tell the same story.
That is a narrow question and it is worth being precise about what it does not answer. A reconciled account is not a correct account. Every transaction can be present, in the right amount, on the right date, and every one of them booked to the wrong category: the reconciliation will pass without complaint. It proves completeness, not correctness.
What it catches is the class of error nobody notices by reading: a payment entered twice, a transfer recorded on one side only, a figure typed as 1,240 when the bank says 1,420, a page of a statement that was never imported. These are invisible in a list of transactions and obvious the moment two totals refuse to meet.
What you need in front of you
- The statement itself, covering a period that starts where your last reconciliation ended. Gaps between periods are the most common reason a reconciliation cannot be made to work at all.
- The opening balance, the closing balance of the previous statement, not a figure your books calculated.
- The closing balance, read off the statement rather than derived.
- Every transaction for that period already entered in your books. Reconciling is a check, not a data-entry session, and mixing the two is how the difference stops being meaningful.
Some banks print three, so if you are not sure which figure on the page is the closing balance, how to read a bank statement covers the anatomy of the page and what each total is for.
The manual method, in order
- Write down the opening balance and the closing balance from the statement, and leave room between them.
- Go down the statement line by line. For each line, find the matching entry in your books and tick both.
- Anything on the statement with no match in your books is something you have not recorded: bank charges and interest are the usual suspects, along with direct debits nobody told you about.
- Anything in your books with no match on the statement is either timing or an error. A cheque written on the 29th that clears on the 3rd is timing and is fine. A payment entered twice is not.
- Total the ticked transactions. Add that to the opening balance.
- Compare the result with the closing balance. Equal means reconciled. Not equal means the difference is your next task.
It is worth doing this by hand once even if software will do it forever afterwards, because the arithmetic is the entire concept and it takes about ten minutes on a short statement. Everything below is that same sum with a nicer interface.
Reconciling in QuickBooks Online
QuickBooks calls this screen Reconcile and it asks for exactly the three things above: the account, the closing balance from the statement, and the statement's end date. It then shows the transactions it holds for that period with a running difference in the corner.
- Open Transactions → Reconcile and choose the account.
- Enter the ending balance and ending date from the statement. Take both from the paper or the PDF, not from what the software suggests.
- Tick each transaction that appears on the statement. The difference figure updates as you go.
- When the difference reaches zero, finish. If it will not, leave the reconciliation and read the next section rather than forcing it.
Resist the reconciliation adjustment. QuickBooks will offer to post the difference to an expense account so the screen can close, and it does close, with the original error still in the books and a second entry now hiding it.
When the difference will not go away
The size and shape of the gap usually names the cause before you have looked for it. Four patterns cover most of them.
| The difference is | Look for |
|---|---|
| Exactly one transaction on the statement | A row that was never imported, or a page missing from the export |
| Exactly twice a transaction | The same entry recorded on both sides of a transfer, or entered twice |
| Divisible by 9 | Two digits swapped, 1,240 typed as 1,420. A transposition is always a multiple of 9 |
| A round number you do not recognise | An opening balance that was wrong before this period started |
The transposition rule is the one worth memorising. If the difference divides cleanly by nine, stop searching for a missing transaction and start comparing digits, because you are almost certainly looking at a typing error rather than an absence.
An opening balance that was already wrong
This is the one that wastes afternoons. If the opening balance is wrong, no amount of ticking will close the gap, because the difference was there before the first transaction of the period.
The test is quick: reconcile the previous period again. If it no longer balances, something was edited or deleted after it was closed, and that is where the work is. Fixing the current month on top of a broken prior month buries the problem one period deeper each time it happens.
Reconciling when there is no bank feed
A feed is a convenience, not a requirement, and plenty of accounts do not have one: closed accounts, a client's historic year, a bank that never offered the connection, or a feed that has stopped. A stalled feed has its own fixes, but the month still has to close while they are pending.
In that situation the statement itself is the source, and the work is getting it into a shape the software will read. Most banks offer a CSV or a spreadsheet on the same screen as the PDF, and those are worth taking when they exist.
If what you have is the statement rather than an export, converting it here produces a clean transaction list and totals every row against the closing balance first, so you find out whether anything was dropped before it reaches your books rather than during a reconciliation. It does not categorise anything, and it does not know what your accounts are called: that part stays yours.
Turn a statement into a clean fileHow often, and how long it should take
Monthly, on the statement period, and it should be dull. A reconciliation that regularly takes an afternoon is usually telling you about something upstream: a feed importing duplicates, an account nobody categorises until quarter end, transfers being entered from both directions.
The one thing not to do is skip a period. Reconciliations chain: each one starts from the last one's closing figure, so a month left undone does not stay a single month's problem. It becomes the thing every subsequent month is measured against.
Frequently asked questions
What is the difference between reconciling and just checking my balance? Checking the balance compares one number to one number. Reconciling compares every transaction that produced it. The balance can be right by coincidence, since a missing payment and a duplicated receipt of the same size cancel out perfectly, and only the transaction-level check finds that.
Do I need the bank statement, or is the feed enough? You need the statement. A feed is a copy of the bank's data delivered through a third party, and reconciling a copy against itself proves nothing. The statement is the independent record, which is the entire reason the exercise works.
My difference divides by 9. What does that mean? You have almost certainly transposed two digits somewhere: 1,240 entered as 1,420, or 87.65 as 87.56. The difference between a number and the same number with two digits swapped is always a multiple of 9, which makes it one of the few arithmetic tells in bookkeeping worth remembering.
Can I reconcile a closed account? Yes, and it is usually a historic clean-up rather than a monthly task. What makes it harder is getting the statements at all, since access often ends with the account. The bank is still obliged to provide them in most jurisdictions, and the request is worth making in writing.
Should I use the reconciliation adjustment if I cannot find the difference? Only as a last resort, and never before checking the prior period's opening balance. The adjustment does not fix anything: it posts the unexplained difference to an expense account so the screen will close. The original error remains, now with a second entry making it harder to find.
Does a reconciled account mean my books are correct? No. It means they are complete. Every transaction can be present and correct in amount and date while being booked to entirely the wrong category, and the reconciliation will still balance. Completeness and correctness are separate checks, and this is the first one.