Bookkeeping · Cleanups & Fixes · Brief · Working level
The forced reconciliation: finding the plug and unwinding it
A reconciliation that wouldn't balance got 'fixed' with an adjustment entry, and now the books agree with the bank for the wrong reasons. Here is how to find forced adjustments and unwind them properly.
A reconciliation plug is a confession written as a journal entry: the difference couldn't be found, so someone posted an adjustment to make the screen say "reconciled". The bank and the books now agree — but only because an error in one place is offset by a fabrication in another. Left alone, plugs compound: next month's difference gets plugged too, and the discrepancy account becomes a landfill.
Symptom
A Reconciliation discrepancies, Adjustments, or Miscellaneous account carries a balance nobody can explain. Reconciliation reports show "adjustment" lines. Cash reconciles every month, yet the over-time pattern makes no sense — or a new bookkeeper inherits books where every rec closed suspiciously smoothly.
Why it happens
Deadline pressure plus a difference that won't yield: an unfound duplicate, a missing check, a transposed amount, or an uncleared transaction from years past. Some software even offers the plug as a button — "post an adjustment" — which turns a research task into a click. Occasionally the cause is darker: a plug is also how a shortage gets hidden, which is why unexplained cash adjustments are an internal-controls red flag, not just a tidiness issue.
The fix
- Inventory the plugs. Pull the activity in every discrepancy/adjustment account, plus journal entries hitting Cash directly with no source document. Note the date and amount of each — the amount is a fingerprint of the original error.
- Reverse one plug at a time, dated in the current open period:
| Account | Debit | Credit |
|---|---|---|
| Cash — checking | 512 | |
| Reconciliation discrepancies | 512 |
Reverse whichever direction the plug went. The reconciliation difference reopens — that is the point.
- Find the real error. With the difference live again, work the statement line-by-line against the ledger, per the complete bank reconciliation. A difference divisible by 9 suggests a transposition; a difference equal to one transaction suggests a duplicate or omission.
- Post the true correction — remove the duplicate, record the missing item, fix the amount — and re-reconcile. The adjustment line should now read zero.
- Repeat for each plug, oldest first. If a closed, filed year is involved, correct in the current period and flag it for the tax preparer rather than reopening the year.
How to prevent it
- Ban the plug by policy. An unreconciled difference is reported, not absorbed; small persistent differences get a documented memo, not a silent entry.
- Zero-balance rule: any discrepancy-type account must read zero at every close — put it on the month-end close checklist.
- Separate hands: whoever reconciles shouldn't also post unreviewed journal entries to cash — the standard separation in internal controls for small businesses.
What to do next
- Search your ledger for discrepancy accounts and direct-to-cash journal entries; list every plug.
- Reverse the oldest, find the real error, correct it, re-reconcile — then repeat.
- Add "discrepancy accounts = zero" to the close checklist so the landfill never reopens.
Frequently asked questions
- What is a forced or plugged bank reconciliation?
- A forced reconciliation is one where the preparer couldn't find the difference between the ledger and the bank statement, so they posted a balancing adjustment — often to Reconciliation discrepancies, Miscellaneous, or Opening balance equity — to make the reconciliation close. The account now shows as reconciled, but the underlying error is still in the books, buried.
- How do I find forced reconciliation adjustments in my books?
- Search the ledger for accounts named Reconciliation discrepancy, adjustment, or similar; filter journal entries posted on or near reconciliation dates; and look for round or oddly precise amounts booked straight to expense or equity with no source document. Each reconciliation report's adjustment line also discloses forced amounts.
- How do I fix a plugged reconciliation?
- Reverse the plug entry, which reopens the original difference, then work the reconciliation properly: compare cleared items one by one against the statement to find the real cause — a duplicate, a missing transaction, a transposition. Post the real correction. Never delete the plug; reverse it so the trail survives.