QuickBooks does not match your bank. Finding the difference

Your accounting file says one thing. The bank statement says another. They are supposed to be identical and they are off by some maddening amount like $1,247.83.

There are only about six reasons this happens. Working through them in order finds it faster than scrolling and hoping.

Before anything else: do not force it

Every accounting package offers, in one form or another, to make the difference go away by posting an adjusting entry. It is the most tempting button in small business accounting and it is almost always the wrong one.

Forcing a reconciliation does not fix anything. It hides a real difference — a duplicated transaction, a missing deposit, a payment that never went out — inside a plug figure, and it does it in a way that makes the original problem much harder to find later. A year of forced reconciliations produces a file where every balance is wrong by an unknown amount and nobody can say which.

If you take one thing from this page: an unexplained difference is information. Find it.

Check the obvious two first

Are you comparing the same date? The single most common cause. The bank statement runs to the 28th, the reconciliation is set to the 31st, and four days of transactions are the difference. Match the dates exactly.

Is the opening balance right? If the starting figure does not match last period's closing figure, the problem is not in this month at all — it is that a prior period was changed after it was reconciled. Fix the earliest broken month first; there is no point reconciling January onward from a February that is already wrong.

Then the six real causes

1. Duplicates. Something entered manually and also imported from the bank feed. Sort by amount and look for pairs. This is the leading cause by a distance in files that use a bank feed alongside manual entry.

2. A transposition. $1,247.83 entered as $1,472.83. There is an old trick worth knowing: if the difference divides evenly by 9, a transposition is very likely. $225 difference, divided by 9, is 25 — go looking for two digits swapped.

3. Timing. A cheque written in March that cleared in April. Genuinely outstanding items are fine and should simply appear as uncleared — that is what the outstanding list is for. The problem is uncleared items that are old. A cheque outstanding for eight months either never got cashed or never got sent, and either way it is not a timing difference any more.

4. Bank charges and interest. Fees, wire charges, merchant processing deductions and interest that the bank applied and nobody entered. Common on merchant accounts, where the processor deposits net of fees and the books record the gross.

5. Something in the wrong account. A transfer between two of your own accounts recorded once instead of twice, or recorded against the wrong side. Transfers cause more reconciliation grief than any other transaction type.

6. Voided or deleted transactions in a closed period. Someone voided a cheque from a reconciled month. The reconciliation was correct when it was done and is not any more. This is why closing periods with a lock date matters.

A method that works

If the obvious checks did not find it:

1. Take the difference and search for that exact amount. Both as a positive and a negative. It finds it more often than it has any right to.
2. Halve the difference and search for that. A transaction entered with the wrong sign — a deposit recorded as a payment — shows up as exactly twice its value.
3. Divide by 9. If it comes out even, hunt for a transposition.
4. Compare counts, not just totals. Number of transactions on the statement against number cleared in the file. If the counts match and the totals do not, it is a wrong amount. If the counts differ, something is missing or duplicated.
5. Split the month in half and reconcile the first two weeks only. Then split the half that is wrong. Four or five rounds of this narrows any month to a handful of transactions.

That last one feels slow and is by far the fastest method for a difference that will not surrender to the search.

When the file has been wrong for a long time

Sometimes the honest answer is that the file has not been reconciled properly for a year or more and the differences have compounded. At that point, hunting each month individually is not the efficient path.

The usual approach is to establish a clean starting point: reconcile from the most recent statement backwards until you find the last month that genuinely tied, then work forward from there correcting each period. It is more work than one month, but it produces a file you can trust afterwards — which chasing individual differences forever does not.

This is normal work and it is most of what a catch-up engagement actually consists of.

What good looks like afterwards

• Every account reconciled monthly, within a couple of weeks of month end
• The reconciliation report kept, not just the tick
• Uncleared items reviewed, with anything over ninety days investigated
• A closing date lock so reconciled periods cannot be silently edited
• Someone other than the person who does the entry looking at the result

If your current arrangement produces a P&L every month but never a reconciliation report, you do not actually know whether any of it is right. That is one of the checks worth running on any bookkeeper.

Related

• Nine ways to tell whether your bookkeeper is doing a good job
• QuickBooks setup mistakes contractors make
• How far behind is too far behind? Catch-up bookkeeping explained