Understanding Bank Reconciliation
Your company's accounting records and bank statement rarely match on any given day. Bank reconciliation is the process of identifying why these figures differ and adjusting both sets of records to agree with each other.
Timing differences are the primary cause. Money you deposited may take several days to appear on the bank statement. Cheques you wrote might not be cashed for weeks. The bank also applies fees and credits without always notifying you immediately. Bank reconciliation isolates these temporary timing issues from genuine errors or fraud.
A complete reconciliation requires two adjusted balances:
- Adjusted cash book balance — your accounting records plus corrections for bank-initiated items you didn't know about
- Adjusted bank balance — the bank statement plus/minus outstanding cheques and deposits in transit
When both adjusted figures match, your records agree with the bank's. If they don't, you've uncovered a genuine discrepancy requiring investigation.
Reconciliation Formulas
Bank reconciliation uses two key calculations to align your records with the bank's statement.
Adjusted Cash Book Balance = Starting Balance + Interest Earned + Direct Deposits − Bank Charges − NSF Cheques − Automatic Payments
Adjusted Bank Balance = Statement Balance + Deposits in Transit − Outstanding Cheques
Unreconciled Difference = |Adjusted Bank Balance − Adjusted Cash Book Balance|
Starting Balance— Opening balance in your cash book at the beginning of the periodInterest Earned— Interest credited by the bank, not yet recorded in your booksDirect Deposits— Customer payments deposited directly to your account by the bankBank Charges— Monthly fees and transaction charges applied by the bankNSF Cheques— Cheques returned unpaid due to insufficient funds in the payer's accountAutomatic Payments— Routine withdrawals debited automatically, such as loan payments or subscriptionsStatement Balance— Closing balance shown on your current bank statementDeposits in Transit— Money you deposited that hasn't yet cleared on the bank statementOutstanding Cheques— Cheques you issued that recipients haven't yet cashed
Step-by-Step Reconciliation Process
1. Gather documents
Collect your cash book (or accounting ledger), the current bank statement, and any recent deposit slips or cheque stubs.
2. Match cleared items
Go through the bank statement line-by-line and mark every transaction that appears in both your records and the statement. Identify items that are listed only in one document.
3. List outstanding cheques
Write down all cheques you issued that don't appear on the bank statement yet. These are outstanding and must be subtracted from the bank balance.
4. List deposits in transit
Identify deposits you recorded but which haven't cleared yet. Add these to the bank balance.
5. Identify adjustments to your records
Look for bank charges, interest earned, or NSF cheques shown on the statement but not in your cash book. These adjust your book balance.
6. Calculate both adjusted balances
Apply the reconciliation formulas above. If the unreconciled difference is zero, reconciliation is complete. If not, recheck all entries for errors.
Common Reconciliation Pitfalls
These mistakes delay reconciliation and mask genuine errors.
- Confusing deposits in transit with deposits recorded late — Deposits in transit were recorded in your books on the deposit date but haven't cleared the bank yet—they adjust the bank balance upward. Don't accidentally record them twice or omit them entirely.
- Forgetting automatic transactions — Standing orders, direct debits, and auto-transfers are often applied by the bank without fanfare. Review your statement carefully for all charges and credits, not just manual transactions you initiated.
- Using the wrong statement period — Ensure your cash book covers the same dates as your bank statement. Starting or ending on different dates creates artificial mismatches that obscure real discrepancies.
- Arithmetic errors in the cash book — Transposition mistakes, missed entries, or incorrect addition in your own records are the most common culprits. Before blaming the bank, verify every number you've recorded.
Why Monthly Reconciliation Matters
Monthly reconciliation is standard practice because banks issue statements monthly, making it easier to spot patterns and discrepancies. Regular reconciliation offers several concrete benefits:
- Fraud detection — Unauthorized transactions stand out quickly when records are fresh. Delays allow fraudsters to create complex cover-ups.
- Error correction — Banks occasionally apply charges incorrectly or credit the wrong account. Prompt notification gives you time to dispute and fix the error.
- Cash flow accuracy — You can't manage working capital or plan payments if you don't know your true available balance. Reconciliation eliminates guesswork.
- Financial statement accuracy — Your balance sheet, profit and loss statement, and tax returns depend on correct cash figures. Unreconciled accounts undermine every downstream report.
- Audit preparedness — Lenders, investors, and auditors expect documented evidence that you control and monitor cash. Monthly reconciliation demonstrates financial discipline.