7 Common Bank Reconciliation Errors and How to Fix Them

A controller once spent three hours hunting a ten-cent difference in a bank reconciliation. Ten cents. She checked every transaction. Twice. The culprit was a transposition error. Someone typed $1,280 as $1,820 on a single deposit. The difference was $540, which is divisible by nine, which is the universal signature of a transposition error. She knew the trick. She just forgot to check for it first.

Bank reconciliations are the most fundamental control in accounting. And they are also the place where small, stupid errors compound into hours of wasted time. Here are the seven most common reconciliation mistakes, how to spot them, and how to fix them.

Error 1: Outstanding checks from prior periods

A check was written in March. It never cleared. Now it's August and the check is still sitting in the outstanding items list, creating a permanent difference between the bank balance and the GL cash balance.

A check becomes stale after six months, sometimes less depending on the bank's policy. After that, it should be voided and reissued if the payee still needs to be paid. Leaving it outstanding forever means your cash balance is wrong. You think you have less cash than you actually do because you're reserving for a check that will never clear.

The fix is simple. Review the outstanding check list every month. Any check older than 90 days gets investigated. Was it cashed but not recorded? Was it lost in the mail? Has the vendor gone out of business? Take action or void it.

Error 2: Deposits in transit counted twice

A deposit is made on the last business day of the month. It appears on the bank statement dated the 1st of the next month. The accountant correctly lists it as a deposit in transit in the month-end reconciliation. So far, so good.

But the next month, that same accountant sees the deposit on the bank statement and enters it again as a new deposit. Now the same cash is on the books twice. The reconciliation difference will exactly equal the amount of the duplicated deposit, which is the clue that tells you where to look.

The fix is a clearing account or a systematic process. Every deposit in transit from the prior month must be the first thing you check off when the new bank statement arrives. Mark it cleared, not re-entered.

Error 3: Bank fees and interest not recorded in the GL

The bank deducts $45 in monthly service fees on the 28th. The statement shows it. The GL does not. You reconcile and find a $45 difference. You start checking every transaction for a $45 error that doesn't exist. The real error is that the $45 fee was never entered.

Bank fees, interest income, wire transfer charges, and returned deposit fees all hit the bank account without a corresponding GL entry unless someone creates one. These are small amounts individually, but they add up and they always create reconciliation differences at month-end.

The fix is to enter bank fees and interest as soon as the statement is available, before starting the reconciliation. If your bank provides a daily feed, enter them daily.

Error 4: Transposition errors

You type $2,470. You meant to type $2,740. The difference is $270. $270 divided by 9 equals 30. That divisibility by nine is the mathematical signature of a transposition error. It works every time. If your reconciliation difference is divisible by nine, you almost certainly transposed two digits somewhere. Stop searching transaction by transaction and start scanning for transpositions in the amounts you entered.

The fix is prevention. Import bank transactions electronically whenever possible instead of manually keying them. When manual entry is unavoidable, double-check every amount before saving.

Error 5: Cleared items still marked as outstanding

Last month, a check cleared. You reconciled it. But you forgot to change its status from outstanding to cleared in your reconciliation tool or spreadsheet. This month, you look at the outstanding items and it is still there, creating a false difference.

This is a process error, not a data error. The amounts are correct. The status flag is wrong.

The fix is to always start each month's reconciliation by clearing all items that appear on the bank statement. Before you hunt for differences, make sure everything that should be cleared actually is cleared in your system.

Error 6: NSF checks and returned deposits

A customer pays a $5,000 invoice. You record the cash receipt and reduce AR. Two weeks later, the customer's check bounces. The bank deducts $5,000 from your account and charges a $35 returned item fee. If nobody records the reversal, your cash is overstated by $5,035 and AR is understated because the customer still owes you the money.

This is an easy one to miss because the bank deducts it silently. You are not expecting a deduction, so you do not look for one. The difference appears in the reconciliation and you have to trace it back to a check that cleared and then un-cleared.

The fix is a bank alert. Most banks can notify you when a deposit is returned. Set up the alert, and when it fires, reverse the cash receipt and reinstate the receivable immediately.

Error 7: Timing differences in credit card batches

A retail business swipes credit cards on the 31st. The point of sale records the sales immediately. The credit card processor batches and deposits the funds on the 2nd. The bank statement shows the deposit on the 2nd of the new month. The GL shows revenue and cash on the 31st of the old month.

This is a legitimate timing difference, not an error. But it must be tracked. The GL cash balance will be higher than the bank balance by the amount of the unsettled batch, and that difference needs to be explained in the reconciliation, not corrected.

The fix is to always know your credit card processor's settlement schedule and maintain a schedule of unsettled batches at month-end.

A systematic reconciliation workflow

Here is a checklist you can follow every month. Start with the bank's ending balance from the statement. Add deposits in transit that you know are legitimate and were submitted before month-end. Subtract outstanding checks that you have verified are still valid and not stale. Add or subtract any bank errors you have identified and confirmed with the bank. The result should equal your GL cash balance. If it does not, divide the difference by nine to check for a transposition. Then check for unrecorded bank fees. Then check for deposits counted twice. Then check for cleared items still marked as outstanding. Then check for NSF returns. Then check for timing differences.

Reconciliations are not about finding fraud. They are about catching the small human errors that, left unchecked, compound into financial statement misstatements. A clean reconciliation means you can trust your cash number. And if you cannot trust your cash number, you cannot trust anything else on your financial statements either.