Most bank reconciliation errors fall into a few families: a transposed or slid figure, an entry recorded twice or not at all, an item posted with the wrong sign, or a beginning balance that no longer matches last month. The size of the difference usually points to the family, so read the amount before you search line by line.
Transposition and slide errors in a bank reconciliation
A transposition error swaps two digits, and a slide error moves the decimal point. Both leave a reconciliation difference that divides evenly by nine. When the gap between the adjusted bank balance and the adjusted book balance is a multiple of nine, check the amounts typed by hand before anything else.
The arithmetic is easy to test with example figures. Suppose a deposit of $1,264.00 was keyed into the books as $1,624.00. The books are now $360.00 higher than the bank, and 360 divided by 9 is 40, a whole number. A slide works the same way. A $45.00 bank fee entered as $450.00 leaves a $405.00 gap, and 405 divided by 9 is 45.
The rule has a limit. Many differences divide by nine by coincidence, and a $90.00 gap could be a single missing $90.00 check. Treat the test as a reason to look at hand-keyed amounts first, not as proof.
To find the line, take the difference, divide by nine, and look at the result. In the first example the result is 40, which says the swapped digits differ by four in the hundreds place (6 and 2). Scan for book entries whose hundreds and thousands digits could be swapped to produce the bank figure. Sorting both lists by amount makes this quick, because the bank's $1,264.00 and the books' $1,624.00 sit near each other with no partner.
Transpositions cluster where people type. Manual journal entries, hand-entered deposits and check amounts copied from a stub are common sources. Imported bank lines rarely transpose, because nobody keyed them. That is a useful shortcut: filter for entries a person typed and compare those first.
Duplicate and missing entries behind reconciliation differences
A duplicate entry is one transaction recorded twice, and a missing entry is a transaction that appears on one side only. Each leaves a difference equal to the amount of that one transaction. If the gap matches a single deposit, check or fee exactly, look for that amount appearing twice in the books or not at all.
Duplicates come from predictable places. A deposit is entered by hand and then imported from the bank feed. A vendor bill is paid twice, once by check and once online. A client forwards the same statement twice and both copies are keyed. The tell is two book entries with the same amount and similar dates, matched to a single bank line.
Missing entries are more often on the book side. Bank service charges, interest credits, returned deposits and automatic debits appear on the statement before anyone records them. The example reconciliation in IRS Publication 583 shows this: a $10.00 bank service charge on the statement is subtracted from the checkbook balance, and the publication notes it is the only book adjustment that example needs.
A wrong-sign entry is a cousin of these. A $312.50 deposit recorded as a $312.50 withdrawal moves the book balance by $625.00, twice the item. When the difference is exactly double a transaction, look for one posted in the wrong direction.
Fixing duplicates and missing items has an order. Confirm the bank line first, because the statement is the outside record. Then correct the books: void or delete the extra entry, or record the missing one with the statement date. Do not delete a book entry only because it lacks a bank match this month. An outstanding check or a deposit in transit has no match yet and is still correct.
Which reconciliation error does the difference amount point to?
The difference amount is the gap left after outstanding checks and deposits in transit are applied. Its size is the best clue to the kind of error. A gap equal to one item, double one item, divisible by nine, or a round number each point to a different family and a different place to look.
The table below maps example amounts to the likely error. The figures are illustrations, not from any real client.
| Difference (example) | What it suggests | Where to look first |
|---|---|---|
| $312.50, equal to one transaction | An item recorded on one side only, or recorded twice | Unmatched lines of exactly $312.50 on both sides; duplicate book entries |
| $625.00, double one transaction | One item posted with the wrong sign | A deposit entered as a payment, or the reverse, of $312.50 |
| $360.00, divisible by 9 | A transposition or a slide in a hand-keyed amount | Manual entries whose digits could be swapped or shifted |
| $1,000.00 or $100.00, a round number | An addition or carry error, or a beginning balance that changed | Column totals, the prior month's ending balance, edited old entries |
| Small and odd, such as $0.03 | Rounding in an import, or a mistyped cents figure | Imported lines with split amounts; cents on hand-entered items |
Read the table from the top down. A gap can match more than one row. A $90.00 difference both divides by nine and could equal a single $90.00 check, so check the single-item row before the transposition row, because it is quicker to rule out.
Errors also combine. Two mistakes can partly cancel and leave an amount that matches no row. When nothing fits, split the month in half by date, reconcile the first half, and see which half carries the gap. Repeating that narrows a month to a few days.
A round-number gap deserves extra suspicion of the opening figure. If the beginning balance on this month's work does not equal last month's reconciled ending balance, every later step inherits the break. The month-to-month tie-out post covers why a beginning balance stops matching the prior statement, and it is worth checking before you hunt through current transactions.
Cleaning up unreconciled transactions from prior months
Unreconciled transactions from prior months are book entries that never matched a bank line and were carried forward month after month. Clean them up by tracing each item to its source, oldest first, then deciding whether it is a genuine timing item, a duplicate or an error. Never clear old items in bulk.
This work usually lands on whoever inherits a file. A list of thirty uncleared checks and deposits from a former bookkeeper looks like a reconciling schedule, but some of it may be noise. The Washington State Auditor's Best Practices for Bank Reconciliations advises tracking each reconciling item to its source evidence or to the original bank statement. It also advises isolating an item that cannot be identified and watching it in the next reconciliation.
A practical order for the cleanup:
- Get the statements. Collect every bank statement for the months the items cover. Without them, you cannot tell a stale check from a duplicate.
- Sort the old items by age. Start with the oldest, because later errors are often built on earlier ones.
- Search later statements for each item. An "outstanding" check may have cleared months later and never been ticked off.
- Look for a twin. An old deposit with no bank match often has an identical entry that did match. That pair is a duplicate.
- Note what is left. Checks that truly never cleared are timing items that have gone stale. Deposits that never reached the bank need an answer from the client.
Write down what each item turned out to be and what was done. A reviewer should be able to follow every change.
Old outstanding checks that never clear raise their own questions for the client and the reviewer, and those questions sit apart from the error hunt; the section on stale outstanding checks and deposits that never clear covers them. The reconciliation cadence post explains why long gaps between reconciliations make this cleanup larger.
The forced-balance adjustment and why reviewers reject it
A forced-balance adjustment, often called a plug, is an entry made for the unexplained difference so the reconciliation shows zero. Reviewers reject it because it hides the error instead of finding it. The real mistake stays in the books, and the next month starts from a balance nobody can explain.
Accounting software makes a plug easy. The QuickBooks Online help article on reconciling an account says that if you cannot find the error, you can finish and accept the difference, and QuickBooks then creates a journal entry for that amount. The same article advises talking to your accountant first and resolving differences inside the reconciliation where possible. QuickBooks Desktop offers the same shortcut as an Enter Adjustment button, and the walkthrough on QuickBooks Desktop Leave versus Reconcile Now explains how to save a month with the difference still open instead.
A plug causes three problems. It posts to some account, so an expense or equity balance absorbs an amount with no source. It masks the original error, which may repeat next month. And it breaks the audit trail, because the entry has no document behind it.
There are narrow cases where a small adjustment is a deliberate, documented decision by whoever signs off, such as an immaterial difference in a dormant account after the search has been exhausted. That is a judgement for the reviewer, not a shortcut for the preparer. If one is made, the workpaper should record the amount, the search done, and who approved it.
The better habit is to leave the reconciliation open with the difference showing, write down what was checked, and pass it to the reviewer. An open item with notes is easier to finish than a closed one built on a plug.
Is the error in the books or in the bank statement?
Most reconciliation differences are bookkeeping errors, but banks do make mistakes. Tell them apart by going to the source document. If the check image, deposit slip or transfer confirmation agrees with the books, the bank may be wrong. If it agrees with the statement, the books need correcting.
Start with the document, not the screen. A cleared check shows the amount the bank paid, and a deposit receipt shows what was handed over. The sample reconciliation in IRS Publication 583 includes a book-side error: a $600.40 deposit was written in the checkbook as $594.40, a $6.00 difference that was the owner's own transcription mistake. The source document settled it.
Signs that point to the bank include a deposit credited for less than the deposit slip shows, a check paid for an amount different from its face, a charge for a service the client never set up, or a transaction that belongs to another account.
Timing matters when the bank is at fault. The Washington State Auditor's guide notes that many banks limit error resolution to 60 days after the transaction date. That is a reason to reconcile soon after each statement arrives, and the client should check the terms of their own account agreement.
Bank-side errors are corrected by the bank, not by an entry in the books. Record the item as a reconciling item on the bank side, note the date the bank was contacted, and clear it when the correction posts. Recording the bank's error in the books would make the books wrong once the bank fixes it.
Before the reconciliation starts
Many errors are easier to prevent than to find. A missing month of statements, or a statement whose beginning balance does not match the prior ending balance, will break every reconciliation after it. Schema CPA reads each client's bank statements, ties their balances out from one month to the next, and calls out a gap in the run before anyone opens the reconciliation. The workflow section of the homepage shows where that check sits.
For a worksheet to reconcile on, the bank reconciliation template in Excel post builds one cell by cell. The QuickBooks, Xero and Excel category covers reconciling inside accounting software.