What to Do When an OFX File Won't Open
An error on an OFX, QFX or QBO file rarely means your data is lost. Most of the time the download stopped early, the date range had no activity, or the file is a different format with a familiar extension. A few quick checks usually find the cause.
Your file is never uploaded. The OFX, QFX and QBO converter runs in your browser and makes no network requests while it works. Always review the rows before you use them.
Steps
- Open the file in a plain text editor. A real OFX file starts with OFXHEADER or an XML line and contains an OFX tag near the top.
- Scroll to the end and confirm the file finishes with a closing OFX tag. If it stops mid-line, the download was cut off.
- Search for STMTTRN. If there are none, the period you chose had no transactions.
- Download the file again for a wider date range and try the OFX to CSV tool once more.
- If the status line reports skipped rows, check those transactions in online banking.
Good to know
Messages you may see
If the tool says that file doesn't look like an OFX, QFX or QBO statement, the content is probably something else, for example a web page saved by mistake. If it says no activity, the period you picked had no transactions. If it says the file looks cut off, it keeps the complete transactions and leaves out the incomplete one at the end, so download the file again to get every row.
Password protected or zipped files
Encrypted downloads and archives can't be read directly. Unzip the archive first, and request an unprotected export if your bank offers one.
Leave the contents alone
Editing tags by hand to force a file open often breaks it further. A fresh download is quicker and keeps the original values intact.
Questions
Does the browser matter?
Any current desktop or mobile browser works. If the page seems to do nothing, reload it and choose the file again.
My file ends in .xml or .txt. Will it work?
It can, as long as the content inside is OFX. The file picker accepts those extensions too.
Can a broken file be repaired here?
No. The tool reads files as they are and does not alter them, so a re-download is the reliable fix.
Have bank statements as PDFs instead? RowSmith converts text-based PDF statements to CSV or Excel in your browser.
This guide was written with AI assistance and reviewed against the tool's behaviour. Always review your output before using it.
RowSmith is an independent tool and is not affiliated with any bank or software company.