What an OFX file is
OFX (Open Financial Exchange) is a standard that Intuit, Microsoft and CheckFree created in 1997 so banks could send statements straight into personal finance and accounting software. An OFX file holds the account details, the statement's date range and every transaction with its date, amount, payee, memo and a unique ID.
This converter writes OFX version 1.02, the plain-text format most bank downloads still use. Older and current programs both read it, which makes it the safest choice when you are not sure what your software wants.
OFX, QBO or QFX: which file do you need?
All three share the same structure. QBO and QFX add a few Intuit fields that QuickBooks and Quicken look for.
| Software | Best file |
|---|---|
| QuickBooks Desktop | QBO |
| QuickBooks Online | QBO or OFX |
| Quicken for Windows or Mac | QFX |
| Xero | OFX |
| Sage Accounting | OFX |
| GnuCash | OFX |
| Microsoft Money (Sunset edition) | OFX |
How to convert a CSV to OFX
- Download your transactions from online banking as CSV, or use an Excel (.xlsx) file.
- Drop the file into step 1. Bank exports with a few lines of account details before the column names are handled automatically.
- Check that the date, description and amount columns are right in step 2. For separate debit and credit columns, choose Separate money out and money in columns.
- Compare the preview with your statement. Money out should be negative and money in positive.
- Choose the account type, enter the last digits of the account number, pick the currency and download the .ofx file.
Import the OFX file
Xero
Go to Accounting › Bank accounts, find the account, choose Manage Account › Import a Statement and pick the OFX file. Xero then shows the lines ready to reconcile.
GnuCash
Choose File › Import › Import OFX/QFX, select the file and match it to the GnuCash account the first time. GnuCash remembers the match for later imports from the same account number.
QuickBooks Online
In Transactions › Bank transactions, open Link account › Upload from file and choose the .ofx file.
Other programs
Look for an option named "import statement", "import bank file" or "OFX import" in the banking area. Most programs that accept QIF or CSV also accept OFX.
Credit card accounts
Choose Credit card as the account type and the file is written as a credit card statement, which is how card providers send their own OFX downloads. Purchases should be negative and payments to the card positive. Many card CSVs list purchases as positive numbers; tick Reverse signs in step 2 and check the preview.
What the converter does with your data
- Long descriptions. OFX limits the payee name to 32 characters. Longer descriptions are shortened in the name field and kept in full in the memo, so nothing is lost.
- Special characters. Characters such as &, < and > are encoded so the file stays valid.
- Transaction IDs. Each line gets a stable ID from its date, amount and description. Re-importing the same file lets your software recognise duplicates.
- Ending balance. If your CSV has a balance column, the most recent balance is written to the file. Otherwise it is set to 0.00. Some import screens display that figure, but it does not change any transaction.
Questions
Is my file uploaded?
No. Everything happens in your browser. The page does not send your file or its contents anywhere, and it keeps working if you go offline after it loads.
What is the difference between OFX and QFX?
A QFX file is an OFX file with extra Intuit fields that Quicken checks. Quicken for Windows usually refuses a plain OFX file, so use the CSV to QFX converter for Quicken.
Which currencies are supported?
The currency list covers the most common ones. The currency code is written into the file; amounts are not converted.
Can I open an OFX file to check it?
Yes. An OFX file is plain text, so any text editor opens it. To see it as a table, use the OFX to CSV converter.
Does it work with European bank exports?
Yes. Semicolon-separated files, day-first dates such as 31.10.2026 and decimal commas such as 1.234,56 are detected. You can change the date format and decimal separator in step 2 if needed.
Check for yourself that nothing is uploaded
- Open this page, then turn off Wi-Fi or switch on airplane mode.
- Drop your file into the tool and convert it. It still works, because the conversion runs in your browser, not on a server.
- For a closer look, open your browser's developer tools and watch the Network tab while you choose a file. No request carries your file anywhere.
The tools work in current versions of Chrome, Edge, Safari and Firefox, on computers and phones.
Last reviewed November 11, 2026. Found a bank export this tool reads wrongly? Tell us about the layout and we will look at it.