It's not random - work the list in order
A reconciliation mismatch feels like it could be anywhere, but in practice it is almost always one of a short list of causes. Checking them in order of likelihood - most common first - finds the answer far faster than re-reading every transaction from the top.
The eight usual suspects, in order
Work through these before you touch a single transaction line
- 1
1. Outstanding checks and deposits in transit
Anything you've recorded but the bank hasn't cleared yet (a check written but not cashed, a deposit made but not credited) will show up as a difference until it clears. This is the single most common cause and is not an error at all.
- 2
2. Bank-initiated items you haven’t recorded
Bank fees, interest earned, card processing charges, and automatic transfers post on the bank’s side first. If your last statement had any of these, check they were also entered in your books.
- 3
3. The opening balance itself
If last period’s reconciliation didn’t actually balance (or someone edited a cleared transaction after the fact), this period inherits the same gap. Compare this period’s opening balance to last period’s closing balance - they must be identical.
- 4
4. Duplicate entries
A transaction imported twice from a bank feed, or entered manually and then imported again, inflates one side only. Search for two entries with the same amount and date.
- 5
5. Wrong amount entered
A mismatch divisible evenly by 9 is a strong signal of a transposed digit (₹45 entered as ₹54, for example - the difference between any two-digit transposition is always a multiple of 9).
- 6
6. A transaction posted to the wrong account
If you operate more than one bank account, confirm the transaction was recorded against the account you are actually reconciling, not a sibling account.
- 7
7. Voided or reversed transactions
A payment that bounced or was reversed needs its own reversing entry (see the customer-credit-refunds-and-reversals guide) - deleting the original instead of reversing it is a common source of silent gaps.
- 8
8. Rounding or currency conversion
If any transaction involved a currency conversion, small rounding differences between how you calculated the converted amount and how the bank calculated it can leave a few cents/paise unmatched.
Narrow the window before you widen the search
Still stuck after the list above? Reconcile a shorter date range first - a single week instead of a full month. A smaller window has fewer transactions to check and will isolate roughly where the mismatch entered.
Worked example: an off-by-45 mismatch
The transposed-digit tell
Your books show a closing balance ₹45 higher than the bank statement. ₹45 is divisible by 9, which points straight at a transposed digit. Sure enough, a ₹1,050 supplier payment had been entered as ₹1,005 - a ₹45 difference. Scanning for any transaction ending near that amount, rather than re-adding every line, finds it in under a minute.
Preventing the next one
Habits that shrink the search next time
- Reconcile weekly, not monthly - fewer transactions per session means a smaller haystack
- Record bank fees and interest the moment a statement arrives, before starting the reconciliation
- Never delete a wrong entry - reverse it, so the audit trail explains the gap instead of hiding it
- Confirm the opening balance matches last period’s closing balance before reconciling a single line
I found the difference but I don’t know which side is wrong - the books or the bank?
The bank statement is definitionally correct for what actually happened in the account; if a transaction is genuinely missing from your books, add it. If the bank shows something you don’t recognize, contact the bank before adjusting your books to match it.
Can I just force the reconciliation to balance with an adjustment entry?
Only as an absolute last resort, and only for an immaterial, unexplainable rounding difference of a few cents. Forcing a balance to close hides a real error and will make next period’s reconciliation start from a wrong opening balance.
The mismatch appeared only after I edited an old, already-reconciled transaction - why?
Editing a transaction that was part of a prior, locked reconciliation retroactively changes that period’s closing balance, which is this period’s opening balance. Once a period is reconciled, corrections should be new reversing entries, never edits to the original.
Resources
Was this guide helpful?