Bank reconciliation means proving why the balance in your books differs from the balance on the bank statement, then adjusting the books until both describe the same cash at the same date.
The balances often differ for legitimate timing reasons. A customer payment can be in your books before the bank clears it. A supplier payment can be recorded before it leaves the account. The bank can also know about a fee or interest payment that has not reached your books yet.
The seven-step reconciliation
- Choose one account and one closing date. Use the exact statement period. Do not mix a current bank screen with books closed three days earlier.
- Confirm the opening balance. It should equal the previous reconciliation’s closing balance. If it does not, find the change before continuing.
- Match deposits. Tick each receipt that appears in both places. Leave genuine deposits in transit unmatched.
- Match withdrawals. Tick card payments, transfers, direct debits and cleared cheques. Leave payments that have not reached the bank as outstanding.
- Record bank-only items. Enter fees, interest, chargebacks and direct debits that the bank knows about but the books do not.
- Investigate differences. Look for duplicates, transposed digits, wrong dates, wrong accounts and missing entries. Never create a mystery adjustment just to make the number zero.
- Lock the result. Save the reconciliation, its closing date and the list of outstanding items. That list becomes the opening evidence next time.
A worked example
Your bank statement closes at 12,480. Your cash account in the books closes at 12,315.
| Adjustment | Bank side | Book side |
|---|---|---|
| Deposit recorded but not yet banked | +650 | |
| Supplier payment not yet cleared | -420 | |
| Monthly bank fee not in books | -25 | |
| Interest received not in books | +10 | |
| Adjusted balance | 12,710 | 12,300 |
The result still differs by 410, so the reconciliation is not finished. Looking at the unmatched rows reveals that a 410 customer receipt was entered twice in the books. Reverse the duplicate and the adjusted book balance becomes 11,890, which is still wrong. That tells you to stop and recheck the signs, not force another entry.
Rebuild the bank side carefully: 12,480 + 650 – 420 = 12,710. The books start at 12,315 – 25 + 10 = 12,300. The missing difference is 410 in the books. If the duplicate inflated the book balance, reversing it produces 11,890, not 12,710. Therefore the unmatched item was not a duplicate receipt. It was a 410 payment entered twice. Reversing the duplicate payment raises the books to 12,710. Both sides now agree.
A worked reconciliation is not just arithmetic. The direction of the difference tells you whether the suspected entry can actually explain it.
What to do with common unmatched items
| Item | Action now | What happens next month |
|---|---|---|
| Deposit in transit | Leave the book receipt unchanged | Match when it reaches the bank |
| Outstanding payment | Leave the book payment unchanged | Match when it clears |
| Bank fee | Record an expense | It is already matched |
| Interest received | Record income | It is already matched |
| Duplicate book entry | Reverse the duplicate with an audit trail | Nothing carries forward |
| Unknown bank transaction | Investigate before classifying | Do not bury it in miscellaneous |
How often to reconcile
Monthly is the minimum for an active business. Weekly is better when transaction volume is high, cash is tight, or several people can spend. Daily matching is useful, but it is not a substitute for a dated close that proves the whole account.
Reconcile payment gateways and clearing accounts too. A card processor can show a 1,000 sale, deduct a 30 fee, and deposit 970. Matching only the deposit to sales hides both the gross revenue and the fee.
Doing it in Invoice Crowd
The bank reconciliation workspace keeps the statement side and book side together so matched rows, differences and the final balance remain visible. Use the general ledger when a cash-account total needs to be traced back to its source entries.
Finish only when the difference is zero and every unmatched row has a name you can defend. Zero achieved through an unexplained journal is not reconciliation. It is concealment.
Frequently asked questions
What is the purpose of bank reconciliation?
To prove that the cash balance in the books and the bank statement describe the same money at the same date. It identifies timing differences, missing fees, duplicate entries, wrong amounts and transactions that need investigation.
Why do my bank and book balances differ?
Usually because of deposits in transit, payments that have not cleared, bank fees, interest, direct debits, duplicated entries or transactions recorded in the wrong amount or account. A difference is normal until it is explained.
How often should a small business reconcile?
At least monthly. Weekly is safer when there are many transactions, cash is tight, or several people can spend. High-volume clearing and payment-gateway accounts may benefit from daily matching plus a formal month-end close.
Should I delete an incorrect transaction?
Usually no. Correct it with a reversal or traceable edit according to your accounting policy so the audit trail shows what happened. Deleting a posted transaction can make an earlier report impossible to reproduce.
What does a zero difference prove?
It proves the arithmetic agrees only if every item was matched or explained correctly. A journal posted to a miscellaneous account can manufacture zero while hiding the real error, so the supporting list matters as much as the final number.
Do payment gateways need reconciliation?
Yes. Reconcile gross sales, processor fees, refunds, chargebacks and the net bank deposit. Matching only the deposit to revenue understates both sales and fees and makes refunds harder to trace.
