Bank Reconciler by ReconcileIQ
Bank Reconciler · FeaturesIncluded with every plan

Automated reconciliation software, bank against books.

Upload a bank statement and the books. Bank Reconciler is reconciliation software for accountants and the businesses they look after: it matches every line, allows for dates that drift, settles look-alikes by description, groups batch payments, and puts a confidence score on whatever it cannot settle. The same engine reconciles invoices to payments.

5,000+ lines a second6 accounting platformsAny bank CSV or PDF
Reconciliation · MarchCurrent account
Bank / booksAmountMatch
Bank 03 MarCARD 4521 TESCO STORES−42.18Exact
Books 03 MarTesco · office supplies−42.18
Bank 09 MarFPS ACME LTD INV1042960.002 days apart
Books 07 MarAcme Ltd · INV-1042960.00
Bank 14 MarSTRIPE PAYOUT1,284.40Batch · confirm
Books 14 Mar3 sales receipts1,284.40
Bank 28 MarMONTHLY ACCOUNT FEE−8.50Not in books
Difference after the fee is posted£0.00

01 · Inputs

Whatever the bank gives you, it reads.

A reconciliation tool is only as good as the files it accepts. Bank Reconciler takes CSV exports from any bank or accounting platform, reads PDF statements through its own converter, and can pull the books straight from your accounting platform.

  • CSV from anywhereDate, description and amount columns are detected for you, with a manual remap if a bank labels them oddly. Excel exports are saved as CSV first, and up to 12 CSVs can be merged on each side.
  • Any number format−50, (50) and 50 DR all read as the same outgoing amount. Currency symbols and thousands separators are stripped.
  • 20+ date formatsIncluding UK DD/MM/YYYY and US MM/DD/YYYY, told apart from the file itself.
  • PDF statementsThe bank statement converter turns digital PDFs, scans and phone photos into a clean CSV, with no per-bank template.
  • Bulk PDF modeConvert a stack of monthly PDF statements in one go.
  • Export steps for your bankThe tool shows how to download a CSV from your bank, or from Xero, QuickBooks, Sage and other platforms, step by step.
  • Straight from the booksConnect Xero, QuickBooks, Sage, Pandle, FreeAgent or YNAB, pick the account and the dates, and skip the export.

Field-tested on statements from the banks UK businesses use most. Because the parser needs no template, it also reads formats it has never seen.

LloydsHSBCNatWestBarclaysSantanderMonzoStarlingHalifaxTideRevolutTSBMetro BankRBSWiseChase UKand the rest

02 · Two methods

Bank reconciliation, and invoice and payment reconciliation.

The same engine runs both, chosen on the upload screen. The first ties the bank to the books. The second is payment reconciliation: it pairs each invoice with the money that settled it.

Method 1

Bank against books

The statement on one side, the bank account in your books on the other, matched line by line. Unmatched items are listed with suggestions, and missing lines can be pushed back to the platform in one click.

The same two-file upload ticks off a credit card statement against the card account, or a supplier statement against the purchase ledger.

Unmatched · to clear4 items
Cheque 000417 not yet presented−1,200.00Extra in books
Lodgement 31 Mar in transit2,450.00Extra in books
Bank interest3.12Missing from books
Duplicate entry, books−96.00Extra in books
Method 2

Invoices against payments

Upload the invoice list and the payment list as CSV files. Each invoice is paired with payments of the same amount, then scored on amount (60%), description (35%) and date (5%), looking up to 150 days after the invoice. Use it for invoice reconciliation, a debtor reconciliation before a credit control run, or taking on a new client's sales ledger.

Invoices · paymentsThree results
INV-1042 ↔ FPS ACME LTD960.000.97
INV-1051 no payment found2,400.00No payment
BACS NORTHFIELD no invoice318.00No invoice

03 · The matching engine

How a match is found, line by line.

This is where automated reconciliation earns its keep. Every line must agree on amount; dates may drift a few days, and where several entries share an amount the closest description wins. Batch payments are matched as groups. Settled matches show whether they were exact or how many days apart; anything left unsettled carries a confidence score against its likeliest match.

CaseBank lineBook entryShown as
iExactSame amount, same date, same direction.03 Mar −42.1803 Mar −42.18Exact
iiDate-tolerantSame amount, posted a few days apart.09 Mar 960.0007 Mar 960.002 days
iiiDescription tiebreakSeveral entries with the same amount, settled by the closest description.AMZNMKTPLACE*2K4 24.99Amazon · 24.99Exact
ivMany to oneOne bank line, several book entries on the same day: payouts, payroll, takings.STRIPE PAYOUT 1,284.403 receipts = 1,284.40Batch
vOne to manySeveral bank lines on the same day that add up to one entry.2 card lines = 610.001 bill 610.00Batch
viPotential matchFor anything left, the likeliest match, with its confidence.BACS NORTHFIELD 318.00best match shown86%

Line-by-line matching runs at more than 5,000 lines a second, so a year of transactions clears in minutes rather than an afternoon.

04 · Integrations

Connected to the books, not just their exports.

Connect by OAuth, choose the account and the dates, and the books come in without a download. Missing lines go back as bank transactions in one click, and extra entries can be deleted on every platform except Sage.

PlatformWhat it does
XeroPulls bank transactions. Missing lines post to Xero as reconciled bank transactions, and extra entries can be deleted, in one click.
QuickBooks OnlineFull sync of the account you choose, fixes pushed back.
SageSage Business Cloud accounts; missing lines pushed back (extra entries are removed in Sage itself).
PandleThe deepest integration: pull, reconcile and push back.
FreeAgentPull, reconcile and push fixes back.
YNABPull, reconcile and push fixes back, for personal and very small business budgets.

Fixes post to a default account and are meant to be reviewed and recoded in the platform; CodeIQ does the coding. Reconciling inside Xero itself? See Xero bank reconciliation.

05 · Reports

An answer you can put on the file.

Every reconciliation ends in two outputs: a PDF report, of the view you have filtered or of the full reconciliation, and a CSV of every item missing from or extra in the books, ready to clear.

Reconciliation reportPDF
Confirmed matches412
Missing from books3
Extra in books1
Net difference0.00

The summary cards and the detail behind them, for the current view or the whole reconciliation.

Missing & extraCSV
MONTHLY ACCOUNT FEE−8.50Missing
Duplicate, books−96.00Extra

What did not match, on each side: the to-do list for the month end.

Saved historyIn your browser

Reconciliations are kept in your browser, so you can come back to one, compare it with last month or start again from it.

  • Then LedgerIQOnce the bank is clean, LedgerIQ turns the general ledger into management accounts, ratio analysis and a board pack.

06 · Scope

Account reconciliation software, within its lane.

Accounting reconciliation software, and automated account reconciliation software in particular, covers a lot of ground. Here is exactly what Bank Reconciler does and does not reconcile, so you can judge the fit before you start.

It reconciles

  • Bank accounts against the cash book, in any currency the files carry.
  • Credit cards and payment processors: a card, Stripe or PayPal statement against its account in the books, so it doubles as credit card reconciliation software.
  • Invoices against payments: automated invoice reconciliation for accounts receivable and accounts payable, including customer and debtor reconciliation.
  • Supplier statements against the purchase ledger, as two transaction lists: supplier statement reconciliation without the ticking.
  • Platform moves: an old system's export against the new one after a migration.

Best done elsewhere

  • Balance sheet reconciliation of accruals, prepayments and control accounts: your accounting software, or PrepIQ at the year end.
  • Intercompany eliminations and group consolidation.
  • Coding the transactions themselves: that is CodeIQ.
  • A paper or spreadsheet bank reconciliation statement: use the free bank reconciliation template.

07 · Performance and security

Built for the messy file, and kept private.

A single month for a small business is the easy case. The engine is built for the hard ones: a practice moving eighteen months of books between platforms, or a finance team with dozens of accounts.

5,000+lines matched a second
C++compiled matching engine
1credit a statement line; 2 a line to convert a PDF
0passwords shared: OAuth tokens, revocable any time
  • Encrypted throughoutAES-256 encryption for data in transit and at rest; files are processed in isolation and deleted once the job is done.
  • OAuth, not credentialsWe never see your accounting platform password. Tokens are stored encrypted, scoped to what the reconciliation needs, and you can revoke them at any time.
  • GDPRData minimisation by default. Deleting your account clears its tokens and server-side data; saved history lives in your browser and can be cleared there. Security details.
Questions

Reconciliation software, answered.

The questions people search for most about reconciliation tools, plus the ones we hear about Bank Reconciler. More in the full FAQ.

What is the best accounting software for reconciliation?

It depends on where the books live. Xero, QuickBooks and Sage reconcile their own bank feeds well, one statement line at a time. Dedicated reconciliation software earns its place when the data is not already inside one platform: a PDF statement, a bank the feed does not cover, a migration, or hundreds of lines to clear at once. Bank Reconciler takes the statement in whatever form the bank gives it, matches it against the books from Xero, QuickBooks, Sage, Pandle, FreeAgent or YNAB, scores every exception and pushes fixes back.

What is the best reconciliation tool for a small practice?

One that copes with the files clients actually send. For a small practice that usually means CSV exports from any bank, PDF statements, and books held on several platforms. Bank Reconciler handles all three, runs the bank-to-books and invoice-to-payment reconciliations from the same upload screen, and has a permanent free tier, so it can be tried on a real client file before anyone pays.

What does payment reconciliation mean?

Payment reconciliation is checking that every payment you expected to receive or make actually went through the bank, for the right amount, and is recorded against the right invoice. In practice it means matching a list of invoices to the money that settled them, then chasing what is unpaid and clearing what was paid but never recorded. Bank Reconciler's invoice and payment mode does that matching and gives each pair a confidence score.

What is invoice reconciliation, and how do you reconcile an invoice?

Invoice reconciliation pairs each invoice with the payment that settled it. To reconcile one, find the payment on the bank statement, check the amount agrees (or that any difference is explained, such as a discount or a bank charge), then mark the invoice paid against that payment. Billing reconciliation is the same check run from the sales side: every bill raised against the money received. Across hundreds of invoices it is a matching job: upload the invoice list and the payment list as CSV files and Bank Reconciler returns the matched pairs, the invoices with no payment and the payments with no invoice.

What are the three types of reconciliation?

Accountants usually group them as bank reconciliation (the statement against the cash book), customer and supplier reconciliation (the sales and purchase ledgers against statements and payments) and balance sheet or general ledger reconciliation (each balance against its supporting evidence). Bank Reconciler covers the first two: bank against books, and invoices against payments. (If someone says there are two types, they usually mean the first two.) Balance sheet reconciliation of accruals, prepayments and other control accounts happens in your accounting software or year-end working papers.

Can Xero reconcile bank transactions automatically?

Xero automatic reconciliation is partial: Xero suggests matches and applies bank rules, but each line still needs an OK. Bank Reconciler reconciles the statement against the Xero books outside Xero, lists every difference, and posts missing lines back to Xero as reconciled bank transactions. Reconciling inside Xero instead? See Xero bank reconciliation.

Can ChatGPT do a bank reconciliation?

It can explain one and tick a short list, but a general chatbot is not built for a full statement: it can lose or invent lines in long tables and leaves no audit trail. Bank Reconciler matches every line on a compiled engine, shows a confidence score behind each suggestion, and exports a PDF report and a CSV of everything missing from or extra in the books.

Does it work without connecting my accounting software?

Yes. Upload a CSV from the bank and one from the books and run the reconciliation. No connection is needed. The integrations save the export step and let you push fixes back, but they are a convenience, not a requirement.

What if my bank only gives me a PDF statement?

Drop the PDF into the converter. The universal parser reads digital PDFs, scanned statements and phone photos without a per-bank template and returns a clean CSV with dates, descriptions and amounts, ready to reconcile. Converting uses two credits a line.

How big a file can it reconcile?

The matching runs at over 5,000 lines a second, so a year of transactions for a busy business clears in minutes. Each uploaded file can be up to 10MB; split larger exports into batches.

Is there a free version?

Yes. The free tier is permanent, not a trial: no card, and 1,000 one-off credits, enough to reconcile 1,000 statement lines at one credit a line. Starter, at £5 a month, adds 5,000 credits every month.

Stop closing the month by hand.

Bank Reconciler is free to start: no card, 1,000 credits, and one credit a statement line. Bring a real statement and see what it finds.