ReconcileIQ VOL. I · BANK MATCH

Bank reconciliation software · Included with every plan

Bank Reconciler

Match your bank to your books in seconds, not hours.

For when the bookkeeping is done but the bank and the books don't agree. It finds the discrepancies.

Bank Reconciler drops a statement against the books from Xero, QuickBooks, Sage or Pandle, finds every discrepancy and pushes the fix back in one click.

Start free No card · Free tier
5,000/s
Match throughput
Any
Bank · format · file
6
Connected platforms
150d
Invoice match window
Plate I · The matching screen

Drop in a statement.
Watch the month close.

Bank on the left, books on the right. Green lines are done. Amber gets fixed and pushed back, in one click.

Recreated to scale · the real thing is faster

§ 00 · Demonstration

Watch it work.

Drop in your bank statement, pull your books straight from Xero, QuickBooks, Sage or Pandle, match thousands of lines in seconds, then push every fix straight back. The whole flow, start to finish.

Fig. 01 How Bank Reconciler works · connect, pull, match, push back. Or view the real product demo →
The story · two minutes

Zipped together, to the penny.

An animated short. The bank says one number, the books say another, and the gap is somewhere in 1,240 lines. Bank Reconciler zips the two sides together, stops exactly where they don’t meet, and RiQ fixes each snag until the difference reads £0.00.

The Zip▶ Watch the storyTwo minutes. Best with your phone turned sideways.

Watch it full screen

§ 01 · The engine

Two methods.
Both included.

Two workflows, one platform. Close the month on the bank, settle the AR ledger, or both, then hand off to CodeIQ or LedgerIQ.

Method I № 01

Bank statement matching

Close the month on the bank in minutes. Match bank transactions against your accounting ledger at 5,000+ per second, handling batch payments, date variances and differing descriptions.

  • 5,000+ transactions per second throughput
  • Fuzzy matching for messy descriptions
  • Universal format support: CSV, Excel, PDF, API
  • Any bank, any format: PDFs, scans, phone photos, CSV

Best for · month-end reconciliation, general ledger matching

Try method I Any bank · any platform
Method II № 02

Invoice ↔ payment

AR and AP reconciliation, automated. Match outstanding invoices to incoming payments using a weighted algorithm that reads company names, invoice numbers and references out of the description.

  • Weighted match: 60% amount, 35% description, 5% date
  • Reads company names, invoice numbers and refs from the description
  • 150-day window finds late payments automatically
  • Outputs: matched pairs, unmatched invoices, unmatched payments

Best for · accounts receivable, payment allocation, AR aging cleanup

Try method II 60 / 35 / 5 · 150-day window

Both methods included in every plan · switch instantly inside the tool

Try both methods free
§ 02 · The typical month

From statement to closed month.

Three ways in, one engine to match, one click to push fixes back. The same data flows on to CodeIQ and LedgerIQ. No re-entry.

Step 00 · Input
Choose your source
Drop a PDF, scan, photo or CSV from any bank, or sync live from QuickBooks, Xero, Sage, Pandle, FreeAgent or YNAB. Columns auto-detected, remap if needed.
Formats3
Elapsed~00:10
Step 01 · Prepare
Parse & normalise
Columns detected, PDFs converted, amounts and dates standardised. Variants like STRIPE GBP and STRIPE PAYOUT are normalised so they line up.
Mapped100%
Elapsed~00:05
Step 02 · Match
Automated matching
5,000+ transactions a second. Batch payments, date variances and fuzzy descriptions all handled, by a C++ engine that keeps the UI snappy.
Matched96%
Elapsed~00:30
Step 03 · Close
Review & export
Review, push corrections back to your software, or export PDF and CSV. Then hand off to CodeIQ and LedgerIQ.
OutputPDF · CSV · API
Elapsed~00:10
§ 03 · Field notes

Everything you need
to reconcile faster.

Tools built to save 50+ hours a month. PDF converter, matching engine and API connectors.

Feature · 01

Any bank. Any format.

PDFs, scans, photos, CSV or Excel from any bank worldwide. No template needed, we clean and format it for instant reconciliation, then feed it straight to CodeIQ.

Formats readPDF · scan · photo · CSV
CSV compatibleAny bank, worldwide
New banks added< 48h on request
Feature · 02 · Throughput

Transactions per second

Process an entire month of trading in under a minute. The heavy lifting runs in a C++ micro-service; the browser stays snappy.

5,000+ /s
Feature · 03

Direct API sync

Push matches directly to QuickBooks, Xero, Sage and Pandle with one click. No copy-paste, no middleman.

Feature · 04

Bank-grade security

AES-256 encryption. Files processed in isolated environments and deleted automatically. GDPR compliant. ICO registered.

Feature · 05

Learning matching engine

More than exact amounts: pattern recognition, date tolerance, batch-payment splitting and fuzzy text matching, learning from your history.

§ 04 · Integrations

Works with your existing tools

Connect once. The same OAuth connection powers Bank Reconciler, CodeIQ and LedgerIQ across the entire ReconcileIQ suite.

§ 05 · Universal parser

PDF bank statement to CSV.
Any bank. Any format.

Digital PDFs. Scans. Blurry phone photos. Spreadsheet exports. If it shows dates, descriptions and amounts, the parser reads it. No templates, no per-bank maintenance. Converting a single file? Use the bank statement converter.

Field-tested with
ChaseBank of AmericaWells FargoCitiHSBCLloydsNatWestBarclaysSantanderMonzoStarlingRevolutWiseTDRBCWestpacCommonwealthDeutsche BankBNP ParibasINGworks with any bank, any country · upload a CSV

Run into a format that trips us up? Send the file. We will fix it, usually inside 48 hours.

§ 06 · Before & after

From spreadsheet to signed off.

Same data, two endings. The reconciliation you do now in a tab of unmatched rows and red text, finished on the right in under a minute.

§ Today · the Excel pass unsaved.xlsx
ABCDE
115/01SHELL ?? PAYMNT-47?
216/01AMAZON UK MK-128.40
317/01ACME INC PMT1250DUP?
417/01ACME INC INV-44011250.00DUP?
518/01BT GROUP DDR-39
620/01STRIPE PAYOUT2,840.12no match
7?WISE TRF 38291420date?
822/01OFFICE STAPLES-67.50
  • Manual eyeball matching · a few hundred lines an hour
  • Date formats break: 15/01 vs 01/15 vs 2024-01-15
  • No audit trail · no undo · no comment history
  • Duplicates, missing rows, partial payments all hidden
§ Today · with Bank Reconciler example session · 1.4s
0lines
0matched
0flagged
0duplicates
BANKBOOK
15/01 · SHELL OIL UK · −£47.23
✓
SHELL OIL UK · −£47.23
16/01 · AMAZON UK · −£128.40
✓
AMAZON UK MKT · −£128.40
17/01 · ACME INC · +£1,250.00
⚠
INV-4401 · +£1,250.00 (dupe of row 3)
18/01 · BT GROUP · −£78.00
✓
BT DDR · −£78.00
20/01 · STRIPE PAYOUT · +£2,840.12
◌
missing from book · suggested: Sales · Stripe
  • 5,000 lines/second · full year reconciled in moments
  • Fuzzy match catches partial & late payments
  • Push fixes back to Xero / QuickBooks / Sage / Pandle
  • Audit trail, undo, comments · ready to sign off
§ 07 · Calculator

Calculate your ROI.

See what manual reconciliation is costing you. Most users save 50+ hours a month from month two.

10hrs
£50/ hr
Manual 10 hrs
With Bank Reconciler 0.5 hrs

95% time saved

Monthly savings
£475
Annual
£5,700

Time recovered · 9.5 hrs / month. CodeIQ and LedgerIQ included at no extra cost.

§ 08 · Native in IQ Books · one ledger

Bank Reconciler has three siblings. They're all native in IQ Books.

Each tool takes over at a different point. Start where your books are.

§ Why we say it, why we mean it

Five thousand a second.
That's the difference.

By hand in a spreadsheet you match a few hundred lines an hour and call it a day. Bank Reconciler runs five thousand transactions a second on a compiled C++ matcher: a full year of books finishes before your tea is cold. One practitioner, thirty clients, one morning.

“If we can't reconcile a year of your books in under ten minutes, you don't owe us anything.”
C++ MATCHER

The match engine is a compiled C++ service, not a JavaScript loop. Thousands of times faster than matching by hand in a spreadsheet.

ANY BANK

Universal parser reads PDFs, scans, phone photos and CSV. No template library, no per-bank maintenance, no waiting on integrations.

PUSH-BACK

Fixes go back to Xero, QuickBooks, Sage or Pandle as proper journals. You verify and sign off in the platform you already use.

Reconcile a year · free No card · full pipeline · ten-minute test
§ 09 · Common questions

Frequently asked.

Everything you need to know about Bank Reconciler. Anything missing, email [email protected].

What is bank reconciliation software and why do I need it?
Bank reconciliation software automates the matching of bank statement transactions with your accounting records. It is the bank end of account reconciliation software, and Bank Reconciler is the reconciliation tool for it: 5,000+ transactions a second, with discrepancies identified at a 96%+ auto-match rate. You need it to save 50+ hours a month, remove manual errors and keep your books in line with accounting standards. With ReconcileIQ, Bank Reconciler is just the beginning. CodeIQ automates the coding, LedgerIQ adds 44 financial analysis modules, and PrepIQ prepares year-end working papers. Doing one by hand? Our free bank reconciliation template sets out the statement.
Which banks does Bank Reconciler's PDF converter support?
Bank Reconciler works with any bank worldwide. The universal parser reads digital PDFs, scanned statements, phone photos and CSV/Excel exports. No bank-specific template required. It is field-tested with Lloyds, HSBC, NatWest, Monzo, Metro Bank, RBS, Wise, Starling, Tide, Barclays, Santander, Halifax, TSB, Revolut, Chase UK and many others, and it reads formats it has never seen before.
How does automated bank reconciliation work with Bank Reconciler?
Bank Reconciler accepts every common input: CSV and Excel files from any bank, digital PDFs, scanned statements, even phone photos of paper statements. Or connect via OAuth to QuickBooks, Xero, Sage, Pandle, FreeAgent or YNAB for direct pulls. The automated bank statement reconciliation engine processes transactions at 5,000+ per second, handling batch payments, date variances and fuzzy description differences. After reconciliation, CodeIQ codes the transactions, LedgerIQ turns the GL into 44 analysis modules, and PrepIQ can prepare the year-end set.
Can AI do bank reconciliation?
Yes, most of it. A reconciliation is mainly matching, and software does that faster and more consistently than a person: Bank Reconciler pairs exact and near matches first, allowing for dates a few days apart, batch payments and descriptions that differ between the bank and the books. What is left is ranked by likelihood with a confidence score, so you accept the suggestions you agree with in one click and spend your time only on the true exceptions. You approve every match.
What are the steps in a bank reconciliation?
There are five. Get the bank statement and the bank account in your books for the same period. Match each statement line to its entry in the books. List what is left: payments not yet cleared, deposits in transit, and bank charges, interest or direct debits not yet recorded. Correct the books for the items that belong in them and note the timing differences. Then check that the adjusted bank balance equals the adjusted book balance and sign it off. Bank Reconciler does the matching and the listing for you, so the last step is a check rather than a hunt.
Can you automate bank reconciliation in Excel?
Partly. Formulas such as XLOOKUP or SUMIFS can tick off lines where the amount and date agree exactly, but they struggle with batch payments, dates a few days apart and descriptions that differ between the bank and the books, and every month starts with pasting the data in again. Bank Reconciler takes the same CSV or Excel files, handles those cases and exports what is left as a list to clear.
Is there free bank reconciliation software?
Yes. Bank Reconciler has a permanent free tier rather than a time-limited trial: no card, and 1,000 one-off credits, enough to reconcile 1,000 statement lines at one credit a line (converting a PDF statement uses two a line). Starter at £5 a month adds 5,000 credits every month. Prefer to work in a spreadsheet? Our free bank reconciliation template is laid out for it.
How secure is my financial data with Bank Reconciler?
Bank Reconciler uses bank-level AES-256 encryption for all data. Files are processed in isolated environments and automatically deleted within minutes. We never store transaction data permanently. We're GDPR compliant, ICO registered, and working towards SOC 2 Type II certification.
What's the ROI of using Bank Reconciler?
Average users save 50+ hours monthly. At £50 / hour that's £2,500+ monthly value. Our users report: 40% more client capacity, 95% reduction in reconciliation errors, 3-day month-ends reduced to 30 minutes, and ability to take on higher-value advisory work. Most users cover the £5 subscription on their first reconciliation.
How does Bank Reconciler compare to manual bank reconciliation?
By hand in a spreadsheet you match a few hundred lines an hour, and errors slip through. Bank Reconciler matches 5,000 transactions a second on a compiled C++ engine, flags every discrepancy, duplicate and missing entry, and keeps a full audit trail. A year of books that takes a day by hand finishes in minutes.
How is Bank Reconciler different from the reconciliation built into Xero or QuickBooks?
Xero and QuickBooks only reconcile the data already inside them. Bank Reconciler works across platforms and off-platform. Upload a statement in any format, whether CSV, PDF, scan or phone photo, match it, then push the fixes back to Xero, QuickBooks, Sage or Pandle as proper journals. It reconciles banks and formats your accounting software cannot import. Reconciling inside the platform instead? See our guides to Xero bank reconciliation and QuickBooks bank reconciliation.
Can Bank Reconciler convert a PDF bank statement to CSV?
Yes. The universal parser turns any bank statement, whether a digital PDF, a scan or a phone photo, into clean, structured CSV with dates, descriptions and amounts. No per-bank template is needed, so it handles statements it has never seen before.
Can Bank Reconciler reconcile invoices to payments?
Yes. Invoice and payment reconciliation is the second method, included with the first. Upload your invoices and your payments, and it matches each invoice to the payment that settled it, weighing amount, description and date. You get the matched pairs, the invoices missing from your books and the payments to remove, each with a confidence score.
§ 10 · Pricing

From £5/mo.
Four core products, included.

Start with Starter or scale up to Accountant, Practice or Enterprise. Every tier includes Bank Reconciler, CodeIQ, LedgerIQ and PrepIQ. Credits refresh each month and unused credits do not carry over.

Need more?
Accountant · Practice · Enterprise
£ 15 → £398 /mo
25,000 → 500,000 credits
  • Accountant · £15 / mo · 25,000 credits
  • Practice Essential · £78 / mo · 50,000 credits
  • Practice Pro · £158 / mo · 150,000 credits
  • Enterprise · £398 / mo · 500,000 credits
  • Connected client workspaces with their own login, full IQ Books organisation and one-off starter credits
  • Same five-product access across every tier

Ready to reclaim your time?

One subscription unlocks the whole ReconcileIQ suite: Bank Reconciler to match, CodeIQ to keep the books, LedgerIQ for 40+ analytics, PrepIQ for year-end working papers. All four are native in IQ Books, or standalone on the software you run now. Setup takes 30 seconds.
Start for free See pricing No card required · GDPR compliant

The platform behind Bank Reconciler

Reconciliation is one job. IQ Books does them all.

Bank Reconciler ties out the bank on whatever platform you run. Inside IQ Books it's simply native — alongside the coding, the analysis and the year-end, in one double-entry ledger that keeps itself reconciled as it goes.

Bring a client's books over from the connection you already have, and the bank ties out from day one — your history migrates with you.

Start with the records you have