To find a reconciliation difference, first prove the totals are right, then search for one line equal to the gap, half the gap, or a digit swap of it. If none fits, split the month in half and reconcile each part, or compare the bank's daily balances with your own until you reach the day the difference begins.
Before the hunt: footing the statement and the ledger detail
Footing means adding a column and checking the total against the printed or reported one. Before searching for a reconciliation difference, foot the bank statement and the ledger detail for the month. If either one does not foot, the difference is in the data you are comparing, not in any single transaction, and line searching will not find it.
For the statement, take the opening balance, add the total of deposits and credits, subtract the total of withdrawals and debits, and compare the result with the printed closing balance. A mismatch means a page is missing, a line was read wrong, or a credit was counted as a debit when the statement was keyed or converted.
For the ledger, run the account detail for the exact statement period and confirm it moves from the opening to the closing book balance. Watch for entries dated outside the period that a filter pulled in, and for a second bank account posted to the same ledger account.
Then write the difference down with its direction: "books higher than bank by $482.00" or "bank higher than books by $482.00". The direction halves the search, because it tells you whether to look for a missing debit or a missing credit.
Matching the reconciliation difference to a single line
The quickest search treats the difference as a clue to one transaction. Look for a line whose amount equals the gap, then for one equal to half the gap, then test the gap for divisibility by 9. Each test points to a different kind of mistake, and together they solve most single-error months.
Run them in this order:
- The exact amount. Search the statement and the ledger for the gap itself. A match means an item is on one side only, such as a fee not booked or a check entered twice.
- Half the amount. A match means a line went in with the wrong sign, which doubles its effect.
- Divisible by 9. A gap that divides by 9 suggests two swapped digits or a misplaced decimal in a hand-keyed amount.
- The amount in a different form. Try the gap as a combination of two lines you would expect to see together: a deposit and its fee, a payment and its reversal.
Reversals deserve a moment. A bank may post a transaction and take it back days later, sometimes in the next month. If you booked the original but not the reversal, or the other way round, the gap equals the transaction. How to pair the two halves is covered in handling a reversed bank transaction on a reconciliation.
Search by amount in both directions and with the cents, because $482.00 and $48.20 are different searches. If your system's search only matches whole amounts, export both sides to a spreadsheet and sort by amount instead.
When one line looks oddly large
Sometimes no line matches the gap, but one line looks too big for its payee. A utility bill that is usually around $300.00 shows $3,000.00. Comparing each line with the usual size of that payee's transactions is a quick screen, and fraud examiners formalise it as the relative size factor test. On a reconciliation it is useful for keying errors as much as for fraud.
Halving the period to corner a reconciliation difference
Halving the period means reconciling only the first half of the month, using the bank's balance on the middle day, and then the half where the difference appears. Each split halves the number of transactions to check, so even a busy account narrows to a few days within three or four rounds.
You need a running balance on the statement, which most banks print after each day's activity. If yours does not, compute one from the opening balance and the day's lines.
The method:
- Pick the middle date of the period, such as the 15th.
- Take the bank's balance at the end of that day.
- Take your ledger balance to the same date, and list items in your books by then that the bank had not cleared by then.
- Reconcile. If it balances, the difference lies in the second half. If not, it lies in the first.
- Split the failing half again and repeat until you are down to a day or two.
Two cautions. Make sure the outstanding items you list at the midpoint are correct for that date, not for month-end, or the split will mislead you. And remember that the difference may sit in more than one half if there are two errors; the halving still works, but you will find one and then need to repeat for the other.
Comparing daily balances to find the day the difference starts
A daily balance comparison puts the bank's closing balance for each day beside your books' balance of cleared items for the same day. The two columns should move together. The first day they part is the day the difference was created, and the amount by which they part is the size of the error.
To build it, list your ledger entries by the date each one cleared the bank, not the date you entered it. Then keep a running total from the opening balance. On each date, compare the running total with the bank's printed balance.
A worked example: a $482.00 gap appears
The figures are an example. A company is out by $482.00 at May 31, with the bank higher than the books. The comparison for one week:
| Date | Bank balance | Books, cleared items | Difference |
|---|---|---|---|
| May 12 | $14,220.00 | $14,220.00 | $0.00 |
| May 13 | $13,905.50 | $13,905.50 | $0.00 |
| May 14 | $15,640.50 | $15,158.50 | $482.00 |
| May 15 | $15,020.50 | $14,538.50 | $482.00 |
| May 16 | $16,110.25 | $15,628.25 | $482.00 |
The difference appears on May 14 and holds steady after it. On that day the bank credited a deposit of $1,735.00. The ledger shows a deposit of $1,253.00. The deposit slip lists two customer checks, $1,253.00 and $482.00. Whoever recorded it entered only the first. Recording the second check closes the gap.
Notice that $482.00 is not divisible by 9 and does not equal twice any reconciling item, so the quick tests would not have found it. It did not equal a whole statement line either, because the bank combined two checks into one deposit. The daily comparison found it because it does not depend on the shape of the error.
A difference that changes size on later days points to a second error. Read each change as a separate event and work on them one at a time.
Why recheck items reconciled last month?
Items reconciled last month are the transactions you marked cleared in the prior reconciliation. Recheck them because a change to any of them moves this month's starting point. An edited amount, a deleted line or a cleared mark added by mistake all carry into the new month as a gap no current line explains.
Compare last month's ending balance on the saved report with this month's beginning balance on the new reconciliation. If they differ, the gap is in the prior period and every search of the current month will fail. Run the comparison before you start matching lines, not after.
Also look at last month's outstanding list. A check listed as outstanding that actually cleared in the prior month, and was missed then, will not appear on the current statement. It stays on your list and the gap is its amount. A deposit in transit that the bank never received behaves the same way.
When the same amount shows as a gap month after month, the cause is usually a single old error that was never fixed, or something that repeats each month, such as an automatic debit nobody records. That kind of gap needs a different approach, described in tracing a recurring reconciliation difference.
What if the difference is several errors combined?
A combined difference is the net of two or more separate errors, and its amount usually matches none of them. The single-line tests fail, the divide-by-9 test gives false hints, and fixing one error can make the remaining gap larger. The method changes from searching for an amount to isolating where each error happened.
Signs that you are dealing with more than one error:
- No single test matches, though the account has many hand-keyed lines.
- A fix you are sure of moves the gap but does not close it.
- The daily comparison shows the difference changing on two or more dates.
Work from the daily comparison or the halving method, because they locate errors by date rather than by amount. Fix each error as you find it and recompute the gap, so you always know how much is left. Keep a short list of each correction, with the amount and direction, so the total of corrections ties to the original difference when you finish.
Two errors can also cancel each other, leaving no gap at all. A $75.00 overstatement on one line and a $75.00 understatement on another produce a reconciliation that balances while two lines are wrong. Only line-by-line matching of amounts catches that, which is a reason to compare each matched pair even when the totals agree.
PreciseBankFlow reads each statement line with its date and amount, checks that the statement foots, and lists unmatched lines and differences as exceptions, which gives you the first two steps of this method without retyping anything. Firms can request a spot in early access.