TheIQSuite Issue № 02 · ReconcileIQ
ReconcileIQ — features

Bank against books.
Done in minutes.

Upload a bank statement and your books export. ReconcileIQ matches every line — fuzzy descriptions, date drift, many-to-one splits — and surfaces every exception with a confidence score. CSV, Excel, PDF, OFX, QBO. Any bank, any platform.

Inputs & ingestion

Whatever your bank gives you, we read it.

Most reconciliation tools give up if your bank's CSV doesn't fit a template. ReconcileIQ auto-detects columns, parses 20+ date formats, handles currency symbols, commas and negative-in-parens, and ships its own PDF converter for the banks that still only offer statements as PDF.

CSV, Excel, OFX, QBO

Upload .csv, .xls, .xlsx, .ofx or .qbo. Auto-detection of date, amount and description columns; manual remap if you want to override.

  • Multi-sheet Excel with sheet picker
  • Negative amounts in any format (-50, (50), 50 DR)
  • UK DD/MM/YYYY and US MM/DD/YYYY auto-detected
  • Currency symbols stripped (£, $, €, ¥)

PDF statement converter

Bank-specific PDF parsing for 17+ UK banks plus US and EU formats. No template setup, no manual fields. Drop a PDF in, get a clean CSV out.

  • Lloyds, HSBC, NatWest, Barclays, Santander
  • Monzo, Starling, Halifax, Mettle, Revolut
  • Bulk PDF mode for monthly batches
  • Per-bank instructions inside the tool

Direct platform sync

OAuth into your accounting platform. Pick the account, pick the date range, pull the books data — no exports, no copy-paste.

  • QuickBooks Online, Xero, Sage, Pandle
  • FreeAgent and YNAB also supported
  • Multi-entity / multi-account selection
  • Tokens stored encrypted, revocable any time
UK bank PDF formats supported
Lloyds HSBC NatWest Barclays Santander Monzo Starling Halifax Mettle Revolut Tide Co-op TSB Nationwide Metro Bank First Direct Wise + more
Other supported regions
US bank statements (any CSV) EU SEPA formats Multi-currency support
Two reconciliation modes

Bank versus books, or invoice versus payment.

The same engine runs both. Switch modes from the upload screen. Bank rec compares your statement to your accounting record; invoice rec compares outstanding invoices to incoming payments — perfect for AR/AP cleanups and onboarding new clients.

Mode 1

Bank vs books reconciliation

The default. Two datasets — your bank statement and your accounting platform export — matched line by line. Surface unmatched items, suggest fixes, push corrections back to your platform.

  • Fuzzy description matching with confidence scoring
  • Date tolerance for posting drift (±N days)
  • Many-to-one and one-to-many matching for split entries
  • Tag-and-resolve workflow for unmatched items
  • Save reconciliations to history — pick up later
Mode 2

Invoice vs payment matching

Take your AR list and your bank deposits, and match them. Used for AR clean-ups, large client onboardings, and any time you have a list of expected payments that need linking to actual money in.

  • Match invoices to payments with confidence scores
  • Surface missing payments (chase those clients)
  • Surface payments without invoices (clean up the books)
  • Handles partial payments and overpayments
The matching engine

Eight matching strategies. One transaction at a time.

The engine doesn't just look for exact amounts. It runs every transaction through a sequence of progressively smarter strategies — and surfaces a confidence score so you know whether to trust it or flag it.

Exact match

Same amount, same date, same direction. Confidence 1.0. Most rows are this — they go through silently.

Date-tolerant match

Same amount, ±3 days for posting drift. Configurable tolerance for slow-clearing transactions, ACH delays, or cross-border timing.

Description fuzzy match

Token similarity on descriptions for cases where the amount is suspiciously close but not exact (FX rounding, fees, wire deductions).

Many-to-one

One bank line that splits across multiple book entries — common for batched payouts, payroll runs, daily takings.

One-to-many

Reverse case — multiple bank lines summing to a single book entry. Combined matching with date windows.

Suggestion engine

For unmatched rows, the engine ranks the 5 most likely candidates with a confidence score. One-click accept or filter, search, refine.

"The matching engine is offloaded to a C++ microservice. A 100,000-line statement reconciles in under thirty seconds. Bigger batches just take a bit longer."

Integrations

Direct sync with the books, not just exports.

Skip the CSV download dance. ReconcileIQ connects via OAuth to six accounting platforms. Pick the account, pick the date range, run the rec. Discrepancies can be pushed back as one-click fixes.

QuickBooks
Online · Full sync
Xero
Bank txns · OAuth 2.0
Sage
Business Cloud
Pandle
Deepest integration
FreeAgent
Direct OAuth
YNAB
Personal & small biz

A note on Xero specifically: Xero's API doesn't allow marking transfers or invoice payments as reconciled — that's a Xero limitation, not ours. The rest of standard transactions reconcile cleanly via the IsReconciled flag. We're upfront about it.

Exports & reporting

Auditable output, any format.

Every rec produces three artefacts: a summary report, the matched pairs, and the exceptions. Export any combination as PDF, CSV, or Excel — for clients, for your file, for the audit.

Reconciliation summary PDF

Executive overview: opening balance, total in, total out, matched count, unmatched count, confidence breakdown. Branded.

Matched pairs CSV / Excel

Full audit trail of every match: bank line, book line, match confidence, strategy used, any tolerance applied.

Exception report

Unmatched bank items, unmatched book items, suggestions ranked by likelihood. The to-do list for the close.

History & saved recs

Every reconciliation saved to your account. Resume later, compare period-to-period, restore prior state.

Scope: current view or full

Apply filters and export the visible subset, or always pull the full dataset. Useful for client-specific exports.

Hand off to LedgerIQ

Once the books are reconciled, jump straight into LedgerIQ for ratio analysis, trend reporting and a board-ready PDF.

Performance

Built for the messy real-world file.

A single-month rec for a small business is not interesting. The interesting case is the practice migrating 18 months of data from one platform to another, or the multi-entity finance team with a hundred bank accounts. The engine is built for that.

100K+
transactions per batch
~30s
to reconcile 100K lines
99.9%
accuracy on clean data
C++
match engine offload
Security & compliance

Your data, protected the whole way through.

AES-256 in transit and at rest. GDPR-compliant deletion and consent flows. OAuth tokens stored encrypted, revocable any time. Reconciliation data deleted from temporary processing as soon as the export is generated.

AES-256 encryption

In transit (TLS 1.3) and at rest. All temporary processing files encrypted; deletion auto-runs after export.

GDPR deletion

Data minimisation by default. Account deletion clears all caches, recs, OAuth tokens, contribution history.

OAuth, not credentials

We never see your accounting platform password. OAuth 2.0 tokens scoped to read/write only what we need; revocable any time.

FAQ

The questions we get asked.

Can ReconcileIQ work with US bank statements?

Yes. The CSV importer handles any column format — US date formats (MM/DD/YYYY), USD symbols, parentheses for negatives, and the funny formatting Wells Fargo, Chase, and BofA use. The PDF converter has US bank profiles too. Multi-state sales tax periods, 1099 reconciliation, and multi-entity rec are first-class workflows.

Does it work without a platform integration?

Completely. Upload a CSV from your bank and a CSV from your books, run the rec. No OAuth required. Most one-off recs and migrations work this way. The OAuth integrations are a convenience, not a requirement.

How does the PDF converter compare to other tools?

It's bank-specific, not generic OCR. We've parsed the actual statement layouts of the 17+ UK banks listed above, plus US formats. That means amounts come out as numbers, dates as dates, and the multi-line description columns get reconstructed correctly — not the column-soup you get from generic PDF-to-Excel tools.

What if my bank isn't listed?

Two options: upload the PDF and the generic parser tries first (it works for most layouts), or export the statement as CSV from your bank's portal — which most banks support. If you want us to add a specific format, drop us a line.

How big a batch can it handle?

Tested up to 100,000+ transactions per side in a single rec. The C++ matching engine handles it in under 30 seconds. Bigger jobs run a bit longer; the bottleneck is usually the file upload, not the match.

What about Making Tax Digital / VAT?

VAT-aware reconciliation is built in for UK clients. The engine respects VAT codes when matching, surfaces VAT-on-sales versus VAT-on-purchases, and the LedgerIQ handoff includes a VAT analysis module. MTD compliance for VAT submission lives in your accounting platform — we keep your books rec-clean so the submission goes out without surprises.

Is there a free tier?

Yes. The Starter plan is free to use with 5,000 credits per month — enough for a small business or to run a few practice recs. No card required to sign up. See pricing.

After the reconciliation

The other two products in the suite.

Stop closing the month by hand.

ReconcileIQ pays for itself the first time you avoid an evening on a stuck rec. Free to start, no card required.