Why Don't My Transactions Reconcile?

Your transactions don't reconcile because the balance in your books doesn't match the balance on the bank statement, and something between the two is unaccounted for. The usual culprits are timing differences (a cheque you've written that hasn't cleared yet), bank charges or interest you haven't recorded, a missing or duplicated entry, or a wrong opening balance carried forward from last period. Reconciliation simply proves that every difference between your records and the bank is explainable. When it won't balance, one of those differences hasn't been explained yet.

The five reasons a reconciliation usually fails

Most non-reconciling periods come down to one of these. They're listed roughly in the order we see them cause trouble.

1. Timing differences. You've recorded a payment or receipt that the bank hasn't processed yet. An uncleared cheque, a deposit in transit, or a card payment that you posted on the 31st but the bank settled on the 1st. The money is real and your entry is correct — it just hasn't landed on the statement. These aren't errors. They're legitimate reconciling items, and you list them rather than delete them.
2. Bank-only items you haven't recorded. The opposite case. Bank charges, account fees, interest, and the occasional direct debit hit the statement before they ever reach your books. Your side is short by the exact amount of the fee until you post it.
3. A missing transaction. A payment or receipt that simply never made it into your records. It's the hardest gap to spot, because there's nothing on the page to catch your eye — the ledger looks complete. The balance is the only check that reliably flags an entry you never saw.
4. A duplicated transaction. The same payment entered twice — often when a batch is keyed once by hand and once from an import. Two identical £140 direct debits where there should be one will throw your closing balance out by exactly £140.
5. A wrong opening balance. Your opening figure must equal last period's closing figure. If a prior period was never closed properly, or someone re-keyed the brought-forward balance, every total after it is off by the same constant amount — even when the new period balances internally.

A couple of quieter ones are worth naming too: transposed digits (£54 entered as £45, which leaves a difference divisible by 9) and miscategorised entries, which usually still tie to the closing balance but quietly distort your reports and VAT.

How to find which one it is

Don't re-check the whole period. Work the running balance forward from your opening figure, applying each transaction in date order, and compare it to the balance the bank prints after every line. The first row where your figure stops agreeing with the bank's is where the difference begins. That single row, not sixty rows, is where to look.

The *shape* of the gap usually tells you the cause before you've found the exact line:

• A difference equal to one transaction amount points to a missing or duplicated entry.
• A difference divisible by 9 points to a transposition.
• A difference equal to your opening figure points to a wrong brought-forward balance.
• A small, round, recurring amount is often a bank charge you haven't posted.

Where converting the statement fits in

If your statement starts life as a PDF, a scan, or a phone photo, getting it into a form you can reconcile is its own small chore — and copy-paste introduces missing and duplicated lines of its own. This is where the tool earns its place. Export Bank Statement converts the PDF, including scanned and photographed statements via OCR, into clean Excel or CSV. The part that matters here is what it does next: it runs the running-balance check for you, recomputing opening balance plus transactions against the printed closing balance and flagging any statement that doesn't reconcile. So a gap shows up before you've posted a month of entries on top of it.

To get the data into your accounting software the path is convert, then import the CSV. The export uses the native bank-import format for Xero, QuickBooks, and Zoho Books, so the lines arrive as reconcilable statement lines. It doesn't push transactions through a live bank-feed API — that's a separate, certified integration — so think of it as producing a verified import file you bring in yourself, not a one-click sync.

Frequently asked questions

Why won't my bank reconciliation balance?

Because at least one difference between your books and the bank statement hasn't been accounted for. Recompute the running balance from your opening figure forward and find the first row where it stops matching the bank's printed balance. That difference is usually a timing item (an uncleared cheque or deposit in transit), an unrecorded bank charge, a missing or duplicated entry, or a wrong opening balance.

Are timing differences actually errors?

No. Outstanding cheques, deposits in transit, and payments that cleared the bank in a different period are legitimate reconciling items. You list them and explain the difference they create — you don't "correct" them away, or you'll introduce a real error while removing an imaginary one. They clear themselves on the next statement.

Why is my reconciliation out by the amount of a bank charge?

Because the bank has taken a fee or paid interest that you haven't recorded yet. Banks apply these directly, so they appear on the statement before they're in your books. Post the charge or interest as a new entry and re-run the balance — the difference disappears.

What if my difference is divisible by 9?

That almost always means a transposition — two digits swapped, like £54 entered as £45 or £1,209 for £1,290. The difference between a number and its transposition is always a multiple of 9, so a gap of 9, 90, or 900 is a strong hint to check for swapped digits at the mismatch row.

Can a converter make my transactions reconcile?

It can't post your correcting entries, but it removes the extraction errors that copy-paste introduces and then checks the maths for you. Export Bank Statement converts the PDF or scan, recomputes opening plus transactions against the closing balance, and flags any statement that doesn't reconcile — so missing, duplicated, or misread lines surface before you trust them. For the full method, see how to reconcile bank statements and the rundown of common reconciliation errors.

CTA: Upload a PDF or scanned statement and let the running-balance check show you exactly where it stops reconciling — start a conversion.