Product guides

When reconciliation shows a difference

A gap between your computed balance and the statement has a short list of usual causes. Work through them in order and find the culprit quickly.

Editorial illustration for When reconciliation shows a difference

The reconcile screen sometimes ends with a difference line that is not zero. It feels like a failure, but it is the whole point of the exercise: the check has found something. The screen itself offers a hint, saying that a missing, duplicated or mis-dated transaction is the usual cause. With that in mind, the search can be systematic.

Work out the direction and the size

First, note whether your computed closing balance is higher or lower than the statement, and by how much. If your figure is higher, you may have recorded too much money in or too little out. If lower, the opposite. The size is a clue too: a difference equal to a round or familiar amount often points directly at one transaction.

Suspect one: a missing transaction

If your balance is higher than the statement, a payment may be missing. Compare the statement line by line with your transactions, or import the statement and see which rows are new. Pay attention to small recurring charges and fees, which are easy to overlook.

Suspect two: a duplicate

If your balance is lower than the statement, a duplicate may be inflating your debits. The screen suggests reviewing flagged items on the transactions tab, and notes that a duplicate left in place shifts the computed closing. The duplicates view compares pairs with matching amount, date and account.

Suspect three: a date problem

A transaction dated outside the period will be missing from this period and present in another. If the difference disappears when you widen the range, a date is the cause. Card payments are common offenders, because the purchase date and the posting date can fall in different months.

Suspect four: a wrong amount or type

A digit transposed, or a refund recorded as an expense, creates a difference. Look at the largest transactions first, then at any that you edited manually. If the difference is exactly twice a transaction amount, that entry probably has the wrong direction.

ClueProbable cause
Computed higher than statementMissing payment, or an extra credit
Computed lower than statementDuplicate, or a missing credit
Difference equals one known amountThat transaction is missing or duplicated
Difference equals twice an amountA transaction has the wrong direction
Difference vanishes with a wider rangeA date falls outside the period

Check the opening balance too

If the period before this one was not reconciled, an old error may be carried forward. Reconcile in order, earliest first. Each period's opening balance depends on the previous period, so fixing the earliest difference often clears the rest.

Using search to hunt

Once you suspect an amount, search for it. The filter for minimum and maximum amount, set to the same figure, lists every transaction of that size in the period. Seeing zero results when the statement has one, or two where it has one, solves the case in seconds. This is far quicker than reading every line.

Fix, then re-run

After correcting an entry, return to the reconcile screen and run it again. The difference should shrink or vanish. If it shrinks without vanishing, there is a second error. Repeat the process, treating each difference as a fresh puzzle, until the figures agree or only a small, explained gap remains.

When you cannot find it

If an hour of searching turns up nothing, leave the difference visible and note it. Some differences are small bank adjustments or timing items that clear next month. A noted, small difference is more honest than forcing the figures to agree with a made-up entry.

Resist the temptation to add a balancing transaction without understanding it. An unexplained adjustment hides the error rather than fixing it, and a future reconciliation will trip over it again.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports