OFX · QFX · no OCR · no upload
OFX / QFX to CSV and Excel
If your bank can export your transactions as OFX or QFX, start there. The data is already structured, the dates are unambiguous, and there is nothing to recognise. Drop the file in and take a spreadsheet out.
Drop your bank statement here
PDF from online banking, or an OFX / QFX export. Click to choose, or paste with Ctrl/⌘+V.
Text-based PDF up to 60 MB / 200 pages, or .ofx / .qfx
Why OFX is the easier input
Every difficulty in reading a bank statement PDF comes from the fact that a PDF has no table — only text at coordinates. An OFX file has no such problem. Each transaction is already labelled:
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20250106000000
<TRNAMT>-806.84
<NAME>INSURANCE PREMIUM AUTO
<MEMO>ANNUAL POLICY
</STMTTRN>No columns to find, no signs to infer, and 20250106 cannot be misread as the 1st of June.
The running balance, derived
OFX gives you a closing ledger balance and a list of amounts, but not the balance after each row. The converter reconstructs it: start from the closing balance and walk backwards through the amounts, then verify forward.
Two things come out of that. You get a Balance column you can reconcile in a spreadsheet, and you get the same self-check the PDF path uses — if the arithmetic does not close, you are told rather than handed a silently wrong column.
Also handled
- OFX 1.x (SGML, unclosed tags) and OFX 2.x (XML)
- QFX, Quicken's dialect
- Files named
.txtor with the wrong extension — the format is detected from the contents - HTML entities such as
&in merchant names - Memo and cheque number folded into the description
Where to find your OFX export
Wording varies by bank, but it is usually one of: Download transactions, Export, Money in Excel, or a file-type dropdown offering OFX, QFX, QIF or CSV next to the date range. Three notes from experience:
- Pick the widest date range your bank allows. Many cap an export at 90 days, which means several exports for a year — each one converts separately.
- Prefer OFX or QFX over CSV when both are offered. Bank-produced CSVs often have inconsistent date or amount formatting between exports; OFX is a fixed specification.
- Treat the file as sensitive. Unlike an encrypted statement PDF, an OFX file is plain text and usually contains your full account number. It is not uploaded here, but be careful where you email or store it.
Which output should you take?
- Excel workbook — to look at it, sort it, or hand it to an accountant. Typed dates and numbers, plus a Summary of the balance check and a Raw sheet.
- Generic CSV — to feed a script, a database, or a spreadsheet import wizard.
- QuickBooks Online CSV — Date, Description, Amount with outflows negative.
- Xero CSV — the required
*Dateand*Amountheader set. Xero also imports OFX directly, which may be simpler still.
Questions people actually ask
What is the difference between OFX and QFX?
QFX is Quicken's dialect of OFX. The structure is the same — a list of transactions with dates, amounts and descriptions — with a Quicken-specific header. Both are read the same way here, and the converter detects the format from the file contents rather than the extension, because banks frequently mislabel exports.
Why is OFX better than a PDF?
The data is already structured. There is no layout to infer, no right-aligned numbers to cluster, no risk of a scan, and the dates are unambiguous — an OFX timestamp is YYYYMMDD, so there is no day/month versus month/day question at all. If your bank offers it, it is the better input.
Where does the balance column come from?
OFX files contain a ledger balance and each transaction amount, but not a running balance per row. The converter derives one by working backwards from the ledger balance, then checks the arithmetic forward. That is the same verification the PDF path uses, applied to structured data.
Does it work on QIF or QBO files?
No. QIF and the QuickBooks QBO backup format are different structures. OFX 1.x (the SGML-style flavour with unclosed tags) and OFX 2.x (proper XML) are both supported, which covers what banks actually export.
Is the file uploaded anywhere?
No. The OFX text is read in your browser and never leaves it. That matters more than usual here, because an OFX file has no password protection at all — many PDF statements do, but OFX exports are plain text with your account number in them.
Can I get Excel out of it instead of CSV?
Yes. The same output presets apply: a three-sheet Excel workbook with typed dates and numbers, a generic CSV with separate debit and credit columns, and import-ready files for QuickBooks Online and Xero.