Free tool · OFX, QFX & QBO
OFX & QFX viewer and validator
See what’s inside a bank download file, find out why it won’t import, and convert or repair it. Works with OFX, QFX and QBO files. It’s free, you don’t need an account, and the file never leaves your browser.
Choose an OFX, QFX or QBO file, or drop it here
The bank download that won’t import, or one you want to see inside.
Or
Read in this browser tab. Your file is never uploaded.
Why a bank file won’t import
Most failed imports come down to a handful of problems. The file was cut off while it downloaded. A payee name contains a bare “&”, as in AT&T, which OFX expects written as “&”. Transactions are missing their ID, or two share one, so the importer skips them as duplicates. Dates or amounts are written in a format the importer doesn’t expect, such as a comma for decimals.
For .QBO files there is one more: QuickBooks Desktop uses the INTU.BID field to identify the bank, and a file without one may be refused. The checker looks for each of these and tells you how many transactions are affected.
What the repair does
It writes the transactions back out as a clean OFX 1.0.2 file: special characters escaped, long names moved into the memo, and the statement period set to cover every transaction. Transactions without a readable date or amount are left out, and the page tells you how many.
Original transaction IDs are kept, so software that has already imported the file still recognises those transactions. You can also export the transactions as a plain CSV, or in the layouts QuickBooks Online and Xero import.
Only have PDF statements?
The statement converter reads the PDF, checks every transaction against the closing balance, and exports OFX or CSV for QuickBooks and Xero.
Questions
What is the difference between OFX, QFX and QBO?
OFX is the standard format banks use for account downloads. QFX (for Quicken) and QBO (QuickBooks Web Connect) are OFX with some of Intuit’s own fields added, most importantly INTU.BID, which tells Intuit’s software which bank the file came from. This tool reads all three.
Can it turn my file into a QFX or QBO file?
No. A valid INTU.BID belongs to a bank registered with Intuit and can’t be made up, so repaired files are written as plain OFX. QuickBooks Online’s Upload from file accepts .ofx files, and Xero recommends OFX for manual imports.
Will the repaired file create duplicates if I already imported the original?
It shouldn’t. Original transaction IDs (FITIDs) are kept, and only a missing or repeated one is replaced, so software that matches on FITID still recognises transactions it already has.
Can I open an OFX file in Excel?
Not directly in a useful way. Convert it to CSV here, with one row per transaction, and open that in Excel or Google Sheets.
Is it free, and is my file uploaded?
It is free with no account and no limit. The file is read by this page in your browser tab, and any file you download is created there too. Nothing from it is sent to us.
What if I only have PDF statements?
Use the statement converter on the home page. It reads a PDF bank statement, checks the transactions add up to the closing balance, and exports CSV or OFX.