Bank feeds vs statement conversion: when you need each
Feeds are the present tense of bookkeeping; statements are its past and its proof. A practical guide to which tool fits which job — and why most practices quietly need both.
Bank feeds and statement conversion get framed as rivals. They aren't — they solve different halves of the same problem, and most working bookkeepers need both in the drawer.
What feeds do brilliantly
A connected feed delivers yesterday's transactions into QuickBooks or Xero every morning, no handling at all. For live, ongoing bookkeeping on a healthy account, the feed is the right default: always on, no files, no imports.
Where feeds stop
- History. Feeds start when connected and backfill 90 days at best. January's data doesn't exist to a feed connected in July — that's a backfill job.
- Coverage. Smaller institutions, some credit cards, foreign banks and certain business accounts simply don't offer feeds.
- Continuity. Feeds break — expired consents, bank-side changes — and the gap they leave is invisible until reconciliation fails.
- Closed accounts and old years. Catch-up work, a predecessor's mess, an audit request: the feed can't reach the past. Statements can, even for closed accounts.
- Proof. A feed is a data stream with no document behind it. A statement is the bank's own signed record — the thing an auditor, a lender or HMRC actually accepts.
What statement conversion does
Statement conversion turns the bank's own PDFs — native or scanned paper — into importable data. It's the tool for history, for coverage gaps, for feed outages, and for any situation where the numbers need a document behind them. With NoRekey the conversion is verified against the statement's declared opening and closing balances, which gives converted data something feeds never have: an arithmetic proof that the period is complete and correct. Feeds occasionally drop or duplicate transactions and nothing tells you; a converted statement that reconciles can't have done either.
The practical rule
Feeds for the present, statements for the past — and statements as the referee whenever the present looks wrong. If a feed-fed account won't reconcile, convert that month's statement and compare: the statement is the record, the feed is the convenience. Practices that internalise this stop treating feed breakage as a crisis; it's just a temporary switch to the other tool.
| Situation | Use |
|---|---|
| Ongoing bookkeeping, feed available | Bank feed |
| Months before the feed existed | Statement conversion |
| Account with no feed support | Statement conversion |
| Feed broke mid-quarter | Conversion for the gap |
| Catch-up / clean-up engagement | Statement conversion |
| Audit, loan or tax evidence | Statements, always |
Statements in, clean books out.
NoRekey converts bank statement PDFs to CSV, Excel, OFX and QFX — every conversion balance-checked. Free to try.
Convert a statement free →Free bank reconciliation template for Excel (and how to use it)
A clean Excel reconciliation template with the formulas already wired — opening balance, running balance, and an automatic reconciled/not-reconciled verdict. Free download, no email wall.
UK bookkeeping in numbers: the statistics that matter in 2026
How many businesses keep books, how many tax returns actually get filed, and the Making Tax Digital wave arriving in April — the verified numbers, each linked to its primary source.