When the reconciliation difference is not zero
A non-zero difference means something on one side has no partner on the other. Start with the likeliest causes and work toward the rare ones. Don't fix the figure with an invented entry.
One accounting manual says plainly not to force the difference into the reconciliation date without identifying it.1 A reference on reconciliation says such items typically need to be investigated before any adjustment is made.2
The usual causes
The same reference lists where discrepancies come from: timing differences, missing or duplicate transactions, fees, interest or errors.2 The checks below follow that list, plus a few set-up problems that cause the same symptoms.
Check in this order
The dates. Is the statement end date the one printed on the statement? A date one day off can add or drop a whole day of lines. Also confirm the start date matches where the last reconciliation ended.
The opening balance. An entry dated on the start day may sit outside the opening balance, depending on the program.1 Does the opening balance differ from where last period closed? Then an older entry may have been changed, added or removed, or the start date may not match where the last reconciliation ended. Find the cause before going on, because it can carry into every later line.
Duplicate lines. A feed or file import can bring in the same line twice. The transaction manual points to the ID, reference, date, amount and original file as clues to a repeat.3 If the difference equals one transaction exactly, look for its twin. Remove the extra copy using your software's normal method.
Items on the bank side only. These are fees, interest and direct debits that the bank recorded and you didn't. The reference counts these as a main cause of a gap.2 One manual says to look for entries in the statement that aren't in your books, with bank charges, interest and direct debits as examples, and post them.1
Wrong amount or direction. A deposit recorded as a payment makes a difference of double the amount. The transaction manual says incoming money belongs in deposits and outgoing money in withdrawals, so correct any mapping error before importing more.3 Also look for a typing slip, such as two digits swapped in an amount.
Combined, split or reduced payments. The manual lists fees, deductions, combined payments, split vouchers and rounding as things to review when an amount is only partly matched.3
Timing items. Cheques or payments you've recorded that the bank hasn't processed yet. The manual lists uncleared cheques among the items to confirm.1 These gaps are real. Note them. Leave them open.
A quick way to narrow it
Write down the difference, then look for a single transaction with that exact amount, or exactly half. A match with the full amount points to a missing or duplicate line. A match with half points to a wrong direction.
Nothing fits? Then go line by line through the period and list what stays unmatched.2 It's slow. It works anyway.
After you find it
Correct the record at its source, then reconcile again. If the item is a genuine bank item, such as a fee, enter it and categorize it, perhaps with a rule. If a line didn't match when you expected it to, how matching works explains why.
Some problems aren't yours to fix. If the bank shows a charge you don't recognize, contact the bank. For accounting treatment of an odd item, ask your accountant.
Notes and sources
- Bank Reconciliation, ERPNext Documentation
- Reconciliation (accounting), Wikipedia
- Bank Transaction, ERPNext Documentation