'%3e%3c/rect%3e%3crect%20x='0.5'%20y='0.5'%20width='31'%20height='31'%20rx='7.5'%20stroke='oklch(1%200%200%20/%200.08)'%3e%3c/rect%3e%3crect%20x='9'%20y='9'%20width='14'%20height='2.4'%20rx='1.2'%20fill='oklch(0.995%200.003%2095%20/%200.85)'%3e%3c/rect%3e%3crect%20x='13'%20y='14.8'%20width='10'%20height='2.4'%20rx='1.2'%20fill='oklch(0.995%200.003%2095%20/%200.55)'%3e%3c/rect%3e%3crect%20x='6'%20y='20.6'%20width='17'%20height='2.4'%20rx='1.2'%20fill='oklch(0.52%200.120%20250)'%3e%3c/rect%3e%3c/svg%3e){kind=small}
How to convert PDF bank statements to Excel or CSV
Drop in the PDF. Get a clean, reconciled spreadsheet back. On the one line we’re not sure of, we tell you.
Convert digital bank statement PDFs to Excel, CSV, XLSX, QuickBooks, Xero and Sage files. No account, no email, no payment to try.
Three steps. No retyping, no guessing.
- Step 1 of 3
Upload your bank statement PDF
Drop in one digital bank statement PDF. No account, no email, no payment to try. The only limits are stated up front: 10 MiB, up to 20 pages.
Northbank Business Current Account - Step 2 of 3
We convert every line, and flag anything we are unsure of
Every transaction is read from the PDF and checked against the statement’s own opening and closing balances. On the rare line we cannot read with confidence, we highlight it in plain language so you can glance and confirm. Everything else just converts.
Northbank Business Current Account · page 22026-05-14 CARD PURCHASE SCREWFIX TRA…£2,130.302026-05-14 CARD PURCHASE SCREWFIX TRA…£2,040.312026-05-15 BACS CLIENT PAYMENT PELHAM…£6,760.31Date Description Amount Source page 14 May 2026 CARD PURCHASE SCREWFIX TRADE COUNTERPossible duplicate (£89.99) 2 - Step 3 of 3
Export to Excel, CSV or your accounting tool
Download the workbook as Excel or CSV, or as a QuickBooks, Xero or Sage ready file. The columns come out clean: date, description, money in, money out, balance. Delete the job when you are done.
Sample workbookstatementstudio-sample.xlsx · synthetic dataDate Description Debit Credit Balance 1 May 2026 BACS CLIENT PAYMENT HARWOOD DEVELOPMENTS INV 2041 £8,400.00 £12,580.22 6 May 2026 HMRC VAT REF 475992103 £4,682.10 £3,521.72 12 May 2026 PAYROLL BACS MAY SALARIES £6,120.00 £2,220.29 30 May 2026 GROSS INTEREST PAID £3.71 £5,983.40 +15 more rows · opening 4180.22 · closing 5983.40
Because it isn’t always perfect, we show you where to look.
Opening balance plus every converted row has to equal the statement’s own printed closing balance. When it doesn’t, the export waits and the exact line is flagged. That’s how a £4,213.89 misread gets caught instead of shipped.
- Opening
- £4,180.22
- Transaction sum
- £1,803.18
- Calculated closing
- £5,983.40
- Statement closing
- £5,983.40
- Residual
- £0.00
The balance check is a strong consistency check across the whole month. It does not prove every field on its own, so anything it cannot confirm is shown to you rather than shipped. Sample data.
It’s the same check a bookkeeper runs by hand: opening balance, every transaction, the running balance and the closing balance, reconciled against the statement itself. You get it automatically on every conversion. How the balance check works
One statement in. The file your tools actually want, out.
Excel and CSV for spreadsheets. QuickBooks, Xero and Sage ready files for your books. OFX and QIF when your software asks for them.
- Excel.xlsxA formatted workbook with clean columns: date, description, money in, money out, running balance.
- CSV.csvPlain comma-separated rows that open in any spreadsheet or import into almost any tool.
- QuickBooksCSVA 3-column CSV QuickBooks Online accepts directly, ready to categorise.
- XeroCSVThe date, amount, payee and description layout Xero expects on import.
- SageCSVSeparate money-in and money-out columns, the way Sage reads a statement.
- OFX.ofxThe Open Financial Exchange format older accounting software asks for.
- QIF.qifQuicken Interchange Format, still used by many desktop finance tools.
A QuickBooks-ready CSV imports straight into QuickBooks, OFX is the Open Financial Exchange format many accounting tools accept, and QIF is the older Quicken format still used by desktop finance software. CSV and XLSX open anywhere. Every file is built from the same reviewed rows, so the numbers match whichever format you pick.
Quick answers
How accurate is the conversion?
We aim to convert every line exactly. Because no converter is right 100% of the time, on the rare line we cannot read with confidence we flag it for you instead of shipping a wrong number. Nothing is ever invented to fill a gap.
What happens when a line can’t be read with confidence?
It is shown to you with the source page beside it, so a glance confirms it. Everything we are confident about just converts, and nothing is guessed to fill a gap.
Is this just an AI guessing at my statement?
No. Layout reading may be model-assisted, but the balance and amount checks are arithmetic against the statement’s own printed balances, and anything low-confidence is shown to you rather than silently guessed.
Can it read a scanned PDF or a photo?
Not yet. StatementStudio reads digital bank statement PDFs. If your PDF is a scan, we tell you rather than guess. Direct photos are not supported, only PDF files.
What is an OFX or QIF file?
They are files that accounting tools import. OFX is the Open Financial Exchange format many tools accept, and QIF is the older Quicken Interchange Format. StatementStudio can export your statement as either, alongside Excel, CSV and QuickBooks, Xero and Sage ready files.
Can I import it into QuickBooks, Xero or Sage?
Yes. Alongside Excel and CSV, StatementStudio builds QuickBooks, Xero and Sage ready files with the columns each tool expects on import.
Do you support my bank?
Most UK current-account statements convert cleanly, from banks like Barclays, HSBC, Lloyds, NatWest, Santander, Monzo and Starling, along with many others. Because layouts vary, the balance check tells you if anything did not read cleanly on your statement.
Is my statement safe, and what happens to my file?
Your file is used only to build your export. It is not sold, and it is not used to train models. When you delete a job, its uploaded file, source preview and exports are removed and cannot be recovered.
Can I edit a flagged row?
Yes. If you want to correct a flagged line against the source you can, and the balance check re-runs after each change. Most statements need no edits at all.
Do you change my PDF?
Never. The source file is read, not altered.
Your next statement takes minutes, not an afternoon.
No account to start. Nothing is stored. There’s no hidden gate: the free run is the whole run.