Bank Reconciliation: Why Your Books and Your Bank Disagree
The bank says $19,875. The books say $18,240. Neither is necessarily wrong. Somewhere in the $1,635 between them are cheques that have not cleared, a fee nobody recorded, and one payment that was entered twice. Finding which is which is the whole job.
What a bank reconciliation is
A bank reconciliation compares the cash balance in your books with the balance on the bank statement at the same date, and explains every difference between them. It is finished when the two agree after adjustments, and each adjustment has a reason.
The two numbers are rarely equal, and that is normal. They are two records of the same money, kept by different parties on different timing.
Why the two balances disagree
| Cause | Example | Which side is wrong for now |
|---|---|---|
| Timing | A cheque you wrote that has not cleared, or a deposit made on the last day | Neither. The bank will catch up |
| Bank-only items | Service fees, interest, a returned payment | Your books. Record them |
| Errors in the books | A payment entered twice, or $540 typed as $450 | Your books. Correct them |
| Missing entries | A card charge or transfer nobody recorded | Your books. Find out what it was |
| Something else | A payment you do not recognise | Unknown. Investigate before anything else |
Timing differences resolve without anyone acting. Everything else needs an entry or an answer. The purpose of the exercise is to sort the differences into those groups.
A worked example
The figures are an illustration. At month end the bank statement shows $19,875 and the books show $18,240, a gap of $1,635.
| Amount | |
|---|---|
| Bank statement balance | $19,875 |
| Add deposit not yet credited | $900 |
| Less cheques not yet cleared | $2,300 |
| Adjusted bank balance | $18,475 |
| Balance in the books | $18,240 |
| Less bank fee not recorded | $35 |
| Add back supplier payment entered twice | $270 |
| Adjusted book balance | $18,475 |
Both sides now read $18,475. The cheques and the deposit need no action. The fee needs recording. The duplicate needs reversing, and it also means the supplier account showed $270 less owing than was true.
A gap of $1,635 had four causes, one of which was a real mistake. A business that does not reconcile carries that mistake forward and adds to it.
Where AI earns its place
Matching that rules miss. Accounting software already matches a bank line to an entry when the amount and date agree. The stubborn cases are one deposit covering three invoices, a payee name on the statement that differs from the supplier name in the books, or a payment net of a fee. Proposing candidates for those is pattern work.
Sorting the exceptions. OpenAI's guidance for its new accounting plugin suggests asking for proposed matches to be listed separately from possible duplicates, missing transactions and differences in fees or currency, with the source row and amount on each side. That is a good instruction for any tool, and the launch is covered in what ChatGPT can read and change in your books.
Drafting the questions. Six unidentified card charges become six short messages to the people who made them. A missing receipt is one cause, as in expense reports.
Spotting repeats. The same supplier name entered three ways, or the same fee missed every month, points to a fix upstream, which is the subject of cleaning the data you already have.
What stays with a person
Accepting a match. A proposed match is a suggestion. Two payments of the same amount to the same supplier in one month may be a duplicate or may be two invoices, and the software cannot know which.
The unexplained item. Do not close a reconciliation by posting a small difference to a miscellaneous account. A difference that will not explain itself is the one finding the process exists to produce.
Separation. Where staffing allows, the person who reconciles the account should not be the only person who makes payments from it. Reconciliation is one of the ways a business notices money leaving that should not have. In a very small firm, the owner reading the finished reconciliation serves the same purpose.
The judgment calls. How to treat an old uncleared cheque, or a deposit the bank reversed, is a question for your bookkeeper or accountant.
How often
Monthly at a minimum, when the statement arrives. Weekly if there are many transactions. A difference from last week can be traced in minutes because somebody remembers it. The same difference found at year end is an afternoon. Reconciled accounts are also what make the cash flow statement and every report built on the ledger worth reading.
Frequently Asked Questions
What is a bank reconciliation?
The process of comparing the cash balance in your accounting records with the balance on the bank statement for the same date, and explaining each difference. It is complete when the adjusted balances agree and every adjustment has a reason.
Why do the book balance and the bank balance differ?
Because of timing differences such as cheques that have not cleared and deposits not yet credited, items only the bank has recorded such as fees and interest, errors in the books such as duplicated or mistyped entries, and transactions that were never recorded.
How do you do a bank reconciliation?
Start with the bank statement balance, add deposits not yet credited and subtract cheques not yet cleared. Then take the balance in the books and adjust it for bank fees, interest and any errors found. The two adjusted balances should match. Investigate anything left over.
How often should a business reconcile its bank account?
At least monthly, when the statement arrives. A business with many transactions may prefer weekly. Differences are much easier to trace while the people involved still remember them.
How can AI help with bank reconciliation?
It can propose matches that simple rules miss, such as one deposit covering several invoices or a payee name that differs from the supplier name. It can separate proposed matches from possible duplicates and missing transactions, and draft queries about unidentified items. A person should approve each match.
What should you do with a difference you cannot explain?
Investigate it before closing the reconciliation. Do not post it to a miscellaneous account to make the balances agree. An unexplained item can indicate an error, a missing record or an unauthorised payment.
Only look at what needs a decision
We set up matching and exception reports around your accounting software so reconciliation takes minutes and nothing is forced to fit.
Related Articles
Cash Flow Statement: Why Profit Is Not in Your Bank
Claude Can Read Your Bank Account. Read the Fine Print
AI Can Be Fooled by Tiny Changes: Why Robustness Matters
Ajan leads the ChatGPT.ca team: 200+ custom GPT builds and automation projects for 50+ businesses across 20+ industries. Based in Markham, Ontario. PIPEDA-compliant solutions.