If you have downloaded one from your bank and wondered what is an OFX file, the short answer is that it is a standard way to move bank transactions between your bank and your accounting software. OFX stands for Open Financial Exchange, and it is the open format that QBO and QFX are both built on. This guide explains what an OFX file contains, what software reads it, how to open one, and how to convert an OFX into a readable spreadsheet when you need to.
What an OFX file is
OFX is an open standard for exchanging financial data, originally created so that banks and accounting software could speak the same language. An OFX file holds a set of transactions along with account and institution details, each transaction carrying a date, an amount, a type, a description, and a unique identifier. The file extension is .ofx.
Like QBO and QFX, an OFX file is written in SGML, a tag-based markup. It is not a comma-separated table, so it is built for software to parse, not for a person to read at a glance. The advantage of OFX is that, being an open standard rather than a vendor format, it is read by a wide range of tools.
What OFX is used for
OFX shows up in a few common situations:
- Downloading transactions from online banking to import into accounting software.
- Moving data into tools like Xero, GnuCash, and many budgeting apps.
- Acting as the base format that bank-specific QBO and QFX files extend.
OFX compared with QFX and QBO
The three formats are close relatives. The difference is who they are aimed at:
| Format | Vendor tie | Read by |
|---|---|---|
| OFX | None (open standard) | Xero, GnuCash, many tools |
| QFX | Quicken | Quicken |
| QBO | QuickBooks | QuickBooks |
Because OFX is not locked to one vendor, it is usually the safest target when you are not sure what your software wants. For a full breakdown, see OFX vs QFX vs QBO.
How to open an OFX file
An OFX file is meant to be imported into financial software, not opened and read directly:
- In Xero, use the bank account's Import a Statement option and select the OFX.
- In GnuCash and similar tools, use the import menu and choose the OFX file.
If you open the .ofx in a text editor you will see raw SGML tags rather than a readable table. When you actually want to read or analyze the transactions, the practical move is to convert the OFX to a spreadsheet. You can convert an OFX file to CSV and open it in Excel as plain date, description, amount, and balance columns.
How to create or convert an OFX file
Sometimes you need an OFX rather than have one. If your bank only gives you a PDF, you can convert a PDF statement to OFX for tools that prefer the open format. If you have an OFX but your software wants QuickBooks specifically, you can convert the OFX to QBO. BankConvert reads the source, extracts the transactions, and writes a valid file with stable transaction IDs so the import goes through without duplicate warnings.
Common OFX issues
A few things trip up OFX imports:
- The wrong financial institution identifier, which some strict importers reject.
- Date or currency assumptions that do not match your locale.
- Software that simply does not accept OFX and needs a CSV or vendor format instead.
Converting through a tool that normalizes these fields removes most of the friction.
Security and scope
An OFX file holds real account activity, so treat it like any sensitive financial document. BankConvert encrypts files, processes them only to convert, then discards them, and never stores or sells your data, as explained on the security page. And note that BankConvert is a conversion tool, not accounting or tax advice, so always review the converted transactions before relying on them.
Bottom line
An OFX file is the open Financial Exchange standard for moving bank transactions into accounting software. It is SGML under the hood, built to be imported rather than read, and broadly compatible because it is vendor-neutral. When you need to read it, convert it to CSV; when your software wants something else, convert it to that. Either way the data stays clean and the import stays simple.
Open or convert an OFX file in seconds
Turn an OFX file into a readable CSV, or build an OFX from a PDF statement, with clean, reviewable transaction data.
See how the converter works step by step on the how it works page.
BankConvert // Get started
Convert your statements
Upload any statement in any format, pick your output, and download a clean file ready for QuickBooks, Xero, or Excel. Files are encrypted and never stored or sold.