Banking · Guide 34 of 53
Reconciling a bank account to your statement
Use the Reconcile tab to check your bank statement against your ledger line by line, then fix any drift, duplicates or missing entries without ever breaking your double-entry.
Reconciling means proving that what your bank statement says actually matches what’s in your books — line by line — so you can trust your figures and catch anything missing, duplicated or mistyped. IQ Books does this on the Reconcile tab of each bank account: you upload the CSV your bank gave you, and IQ Books compares it against your ledger and shows you exactly where the two disagree.
What Reconciling Does And Doesn’t Do
The Reconcile tab is a comparison tool. It reads your statement CSV and holds it up against the transactions already in your ledger; it never adds those statement rows to your books on its own. Every fix it offers keeps your double-entry balanced — nothing is edited in place, so the original entry and its correction both stay visible as an audit trail.
Get Your Transactions In First
Reconcile only counts transactions that are actually posted to the ledger. Anything still sitting as a draft — freshly imported CSV rows, CodeIQ suggestions you haven’t accepted, captured receipts — is inert until you confirm it. So before you reconcile, bring your bank transactions in, code them and confirm them under Review drafts.
Run A Reconciliation
- Open the account. Go to
Banking → [your bank account] → Reconcile. - Upload the statement CSV. Choose the CSV your bank gave you (or drop it in). A preview of money in, money out and net movement appears alongside.
- Check the column mapping. IQ Books auto-matches the date, description and amount columns — whether your bank uses one signed amount column or separate money-in and money-out columns — and shows how many rows it can read. Approve or adjust the mapping and the date format before continuing.
- Set the date tolerance. Pick anything from ±0 to ±7 days. This lets IQ Books treat a line as matched even when the statement date and your booking date differ slightly — common with cheques and card settlement.
- Reconcile. Click Reconcile N lines. IQ Books compares the statement against every posted ledger line across the whole months your statement spans.
Read The Verdict
The result opens with a headline and a match-percentage dial. If everything ties, it reads “Statement and ledger agree — fully reconciled”; otherwise it tells you how many items need your attention. Below that, a strip shows the statement net, the ledger net, the difference between them (zero means agreement), and counts of what’s in books only and on statement only. Work the difference down to zero by clearing the panels underneath.
Work Through The Panels
- Probable matches, dates drifted. Same money, dates a few days apart. Click Accept match to confirm the pairing — this changes nothing in your books, it just records that the two are the same transaction.
- Same transaction, different amount. The narrative and date line up but the figure differs. For a plain bank line, Replace with statement amount reverses the books line and stages a fresh draft at the statement figure for you to confirm. For a receipt, payment or transfer, use View entry and correct it at its source instead.
- In your books, not on the statement. A ledger line the statement doesn’t show. Removing it posts a reversal (the original stays on record). IQ Books highlights likely duplicates. A plain bank line can be removed here; a customer receipt is voided (the invoice becomes unpaid again); a supplier payment is voided; a transfer or manual journal opens for you to review.
- On the statement, missing from your books. Real money your ledger hasn’t captured. Click Add as draft (or Add all) — the line is staged, then you code and confirm it under
Review drafts. Until confirmed it shows as “Draft staged”. - Matched. A collapsible list of everything that already agrees, so you can spot-check if you want to.
Mark Lines As Reconciled
When you’re happy, click Mark N matched as reconciled. This stamps the matched bank lines in your cashbook so you can see at a glance what’s been checked. It doesn’t change any figures — it’s a tick, not a posting.
Worked Example
Your March statement nets to £4,210 but the ledger nets to £4,150, a £60 difference. The books-only panel shows a £60 supplier payment the bank never took, flagged as a likely duplicate of one you already matched. You void the duplicate; the difference drops to £0 and the verdict flips to fully reconciled.
Common Questions
- Why won’t it import my statement? By design — the tab compares only. To get lines into the ledger, import them under Banking or use the Add as draft buttons, then confirm.
- Can I reconcile a foreign-currency account? Yes. It reconciles in that bank’s own currency, matching the statement against your bank-native amounts.
- A line I need to remove is in a locked or closed period. Removing it posts a reversal into that period, so you’ll need to lift the lock first under
Settings → Organisation, fix it, then re-lock. - Does reconciling cost credits? Comparing a statement is a metered action at 1 credit per statement line. The free plan’s 1,000 one-time credits cover about 1,000 statement lines.