A recurring reconciliation difference is a gap that appears again each month. If it stays the same size, one old error is being carried forward, often a bad opening entry or a dropped item. If it grows, something repeats, usually an automatic debit or credit the books never record. Trace either kind back to the first month it appeared.
Why does the same reconciliation difference come back every month?
A reconciliation difference comes back every month for one of two reasons. Either an error made once is still in the books and carries forward through every later balance, or the same kind of transaction keeps happening and keeps being missed. The first gives a fixed gap; the second gives a gap that adds up over time.
A carried error lives in the cumulative balance. The book balance at any month-end is the total of every entry ever posted, so a wrong amount from March is still inside the December figure. Fixing December's lines cannot remove it, because no December line caused it. Typical carried errors:
- An opening balance entry set from the wrong figure when the books started.
- A transaction deleted or edited in a period that was already reconciled.
- An outstanding check or deposit in transit that was dropped from the list one month and never restored.
- A balancing entry posted once to force a reconciliation, which now sits in the books.
A repeating error is new each month. The books are missing the same kind of line every period, so the gap grows by roughly that amount each time. Typical repeating errors:
- A monthly bank fee, loan payment or software subscription drawn automatically and never entered.
- Interest credited each month and never booked.
- Card processor deposits recorded gross when the bank receives them net of fees.
- A tax payment drawn by ACH debit that the books record on a different basis.
Telling the two apart is the first job, because the search for each is different. The month-by-month trend does that.
Is the recurring gap constant or growing each month?
Lay out the unexplained difference for each of the last six to twelve months in one table. A constant figure means a carried error. A figure that grows by a steady amount means a repeating omission. A figure that grows irregularly usually means a repeating item whose amount varies, such as a usage fee or a tax payment.
The table is an example for two accounts of the same small company.
| Month | Account A: unexplained difference | Account B: unexplained difference |
|---|---|---|
| January | $1,150.00 | $29.99 |
| February | $1,150.00 | $59.98 |
| March | $1,150.00 | $89.97 |
| April | $1,150.00 | $119.96 |
| May | $1,150.00 | $149.95 |
| June | $1,150.00 | $179.94 |
Account A is out by the same $1,150.00 every month. Something wrong sits in the opening balance or in a period before January, and the January search should start with the prior reconciliation.
Account B grows by $29.99 each month. A monthly charge of that amount is reaching the bank and not the books. A search of each statement for $29.99 will find it in a minute.
If the difference was zero for a while and then turned constant, the error happened in the month it first appeared. If it was always there, look at how the account started.
Sign the figures consistently. Write "books higher than bank" as positive and "bank higher than books" as negative, or the other way, but keep one rule. A gap that switches sign is not the same gap.
Automatic debits missing from the ledger every month
Automatic debits are payments the bank takes from the account on a schedule you or a vendor set up: loan installments, insurance premiums, subscriptions, payroll service fees, merchant fees and tax payments. Because nobody writes a check or approves an invoice each month, they are the transactions books most often miss, month after month.
Look at the statement descriptions for lines with the same payee in every month. Then check each against the ledger. A useful habit is to keep a short list of every recurring debit on the account, with its usual amount and date, and to tick it off at each reconciliation.
Merchant deposits are a related trap. If a card processor deducts its fees before paying out, the bank shows a net deposit. A bookkeeper who records the gross sales as the deposit overstates cash by the fees each month, and the gap grows with sales volume rather than by a fixed amount.
Tax payments drawn by ACH debit are another. If the books record sales tax payments only when the return is prepared, but the tax authority draws the amount on a different date, the reconciliation carries a varying gap until the two line up. The wider job of tying tax collected to tax paid is described in sales tax reconciliation.
The fix for a repeating omission is two entries: one catch-up entry for the months already missed, with a memo listing each month and amount, and a standing process for the future, such as a recurring entry in the accounting system or a line on the month-end checklist.
Tracing a recurring difference back to its first month
Tracing a recurring difference means finding the earliest month in which it appears. Work backwards through saved reconciliations until you reach a month with no unexplained gap. The month after that is where the error happened, and that is the only period worth searching line by line.
Steps that work for most accounts:
- Collect the saved reconciliation reports for each month back to the last one you trust, or to when the books began.
- Note the unexplained difference on each. If a report balances only because of a balancing entry, treat the entry's amount as the difference for that month.
- Find the first month with a difference. That month holds the cause of a carried error, or the first occurrence of a repeating one.
- Compare that month's report with the ledger as it stands now for the same month, line by line.
- Check the prior month's outstanding list against that month's statement, looking for items that cleared but stayed on the list, or items that vanished from the list without clearing.
- Search for the gap amount in the month's statement and ledger.
Outstanding lists are a frequent source. A check recorded under the wrong number may be ticked as cleared against a different check, while the real one stays outstanding forever. The outstanding list then carries a phantom item and the cleared column is wrong by the difference between the two amounts. How to correct the sequence is covered in fixing a wrong check number in the ledger.
If saved reports are missing, rebuild the comparison from statements. For each month, compute what the books should have shown from the statement balance and the outstanding items, and compare it with the ledger's month-end balance. It takes longer, but it gives the same answer.
A bad opening entry behind a recurring difference
An opening entry is the first entry in a new set of books that sets the bank account's starting balance. A bad opening entry is one taken from the wrong figure, often the bank's balance on the start date, without allowing for checks and deposits that had not yet cleared. Every reconciliation after it carries the same gap.
The constant pattern in the table above, $1,150.00 from the very first month, is the typical signature. In this example, the books began on January 1 with an opening entry of $22,400.00, the bank's balance on December 31. Two checks totalling $1,150.00 had been written in December under the old system and had not yet cleared. The correct opening book balance was $21,250.00. When the checks cleared in January, the bank balance fell and the books, which never had the checks, did not. From then on the books ran $1,150.00 above the bank every month.
The same mistake has a variant. If someone entered the two checks in January when they cleared, cash in the books ends up right and the reconciliation balances, but January carries $1,150.00 of December's expenses. A bad opening entry produces a constant cash gap only when the uncleared items were never recorded anywhere. Otherwise the error moves out of cash and into income or expense. Read the first month's ledger to see which happened.
To correct a bad opening entry, compute the right opening balance: the bank balance on the start date, less checks written before that date and cleared after it, plus deposits made before that date and credited after it. Compare that with the entry booked. Post the correction in the current period, usually against opening balance equity or retained earnings, with a memo explaining the calculation. A general method for working through any unbalanced month, in the right order, is in what to check when a bank reconciliation is not balancing.
Mistake: carrying a recurring difference forward as a plug
Carrying a recurring difference forward means listing it as a permanent reconciling item, or posting a balancing entry each month, so every reconciliation shows zero. It feels like housekeeping, but it hides the cause and makes the trail harder to follow with every month that passes.
Three things go wrong. First, a repeating omission keeps growing behind the plug, so the amount that eventually has to be explained is larger than any single month. Second, new errors combine with the carried one, and the net amount no longer matches any line. Third, a reviewer reading a reconciliation with an "unexplained, carried from prior months" line has no way to tell an innocent old error from money that left the account.
If a small constant difference truly cannot be traced after a documented search, write it off once, with approval and a memo, and stop carrying it. A growing difference should never be written off, because something is still happening.
PreciseBankFlow lists every unexplained difference as an exception with its supporting lines rather than adjusting it to zero, so each month's figure stays on record for a trend table like the one above. Firms can ask for early access.