Convert a Quicken QFX download to a plain OFX statement for FreeAgent, Sage, Xero or GnuCash. Intuit tags removed, account number cut to the last 4, balance kept. Free up to 100 transactions.
Only have a PDF statement? Use the PDF statement converter.
A QFX is OFX with Intuit's Web Connect tags added. Most programs read it as it is, but some importers only take .ofx files, and a QFX carries your bank's routing number and full account number. Utilly reads each transaction and writes a clean OFX 1.02 statement with stable transaction IDs. Going to QuickBooks Desktop? Use QFX to QBO or QFX to IIF instead.
.qbo or an OFX 2 (XML) file works the same way.The transactions are the same. The difference is the wrapper Quicken adds and the account details your bank puts in it. The top of our sample QFX:
<FI><ORG>Example Community Bank<FID>3000</FI><INTU.BID>3000
becomes this in the OFX:
<FI><ORG>Utilly</FI>
| In the QFX | In the OFX |
|---|---|
| INTU.BID, INTU.USERID and the bank's FID (Intuit's Web Connect tags) | Removed. These are what Quicken checks before importing; other programs don't need them. |
| BANKID (usually your bank's routing number) | The placeholder 999999999. |
| ACCTID (the full account number) | Only the last 4 digits, or the nickname you type. A QFX with ACCTID 123456780427 comes out as 0427. |
| LEDGERBAL (ending balance) | The same balance and date, when it's dated on or after the last transaction and you haven't flipped the signs. Otherwise 0.00. |
| Bank (STMTRS) or credit card (CCSTMTRS) statement | The same kind of statement. Import a card file into a credit card account. |
| OFX 2 (XML) or OFX 1 (SGML) body | Always OFX 1.02 SGML, the version importers handle most widely. |
Because a QFX is OFX underneath, changing the extension from .qfx to .ofx is often enough, and it's free. Convert instead when:
& codes, or you want one file per account from a download that holds several.The first transaction of our sample QFX, as it comes out of the converter:
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260901120000<TRNAMT>-6420.18<FITID>20260901E26D1A27070800<NAME>ACH DEBIT GUSTO PAYROLL 0912<MEMO>ACH DEBIT GUSTO PAYROLL 0912</STMTTRN>
| QFX tag | OFX tag |
|---|---|
| DTPOSTED | Same date, written at noon. The time and time zone are dropped. |
| TRNAMT | Same signed amount, two decimals. TRNTYPE is CREDIT for money in and DEBIT for money out. |
| NAME (or MEMO when NAME is empty) | NAME cut to 32 characters, with the full text in MEMO. A separate bank memo isn't kept. & becomes "and". |
| FITID (the bank's transaction ID) | A new ID from the account, date, amount and description, identical every time you convert the same file. |
| CHECKNUM, SIC, categories | Not written. |
| Program | Reads QFX? | What to upload |
|---|---|---|
| FreeAgent | No. It lists OFX, QIF and CSV. | This OFX: Banking → Bank Accounts → the account → Upload Statement. |
| Sage Accounting | Sage's help talks about OFX files, which upload without editing; only the first bank account in a file is imported. | This OFX, one account per file. |
| Xero | Yes, Xero lists QFX with OFX, QBO, QIF and CSV. | The QFX as it is, or this OFX without your full account number. |
| Wave | Yes (OFX, QBO, QFX and ASO). | Either. |
| QuickBooks Online | Yes. Upload from file lists QBO, QFX, OFX, CSV and TXT. | Either; QFX to QBO is the QuickBooks-first choice. |
| QuickBooks Desktop | No, Web Connect reads only .qbo. | QFX to QBO, or QFX to IIF without Web Connect. Not OFX. |
| GnuCash | Yes (File → Import → Import OFX/QFX). | Either. |
| Quicken | Yes, from your bank. | The bank's own QFX. Quicken says it doesn't support files from conversion software, so an OFX from here isn't promised to open there. |
We don't write QFX. Quicken checks a QFX's Intuit bank ID with its online service before importing, and files made by converters usually fail that check. If the data is going into Quicken for Windows, convert to QIF with the OFX / QFX to QIF converter; if it's going to QuickBooks, use QFX to QBO.
.qfx downloads, plain OFX 1.x/2.x files and QuickBooks .qbo Web Connect files.| Problem | Fix |
|---|---|
| "No transactions found in that OFX/QFX/QBO file" | The download has no transactions for that date range, or it's an investment file. Download the account again with a wider date range. |
| Transactions imported twice | The new IDs don't match the bank's own, so a program that already has these dates from a bank feed won't spot the repeats. Import only dates that aren't there yet. |
| Card payments show as charges | Choose Credit card as the account type in the preview, check the signs and tick Flip signs if they're backwards. |
| Balance in the program is off | Check the ending balance in the OFX. If it's 0.00, the QFX had no usable ledger balance; enter the opening balance in your program. |
| QuickBooks Desktop won't open the .ofx | Desktop only imports .qbo Web Connect files. Use QFX to QBO or QFX to IIF. |
Free for files up to 100 transactions, which covers a typical month of activity. Larger files (a year of catch-up, a client's full history) use 1 credit from the same $9 pack of 5 as our PDF statement converter, or unlimited on Pro at $19/month. The preview is always free.
Yes for files up to 100 transactions: no sign-up, no watermark. Bigger files (multi-month catch-up work) use 1 credit from the same $9 / 5-credit pack as our PDF converter, and the preview is always free.
Xero: Accounting → Bank accounts → the account's menu icon (⋮) → Import a Statement. Sage Accounting: its bank statement import under Banking (Sage says OFX files upload without editing). FreeAgent: Banking → Bank Accounts → the account → Upload Statement. GnuCash: File → Import → Import OFX/QFX. QuickBooks Online also takes an OFX under Upload from file, but for QuickBooks pick the .QBO output instead.
No. Files are processed in memory and deleted after 1 hour. We never use your data for AI training.
Yes. Click a sample button under the upload box. It opens a made-up export from a fictional bank in the same preview your own file gets, and every format is free to download, so you can test an import in a test or backup company file first. Don't import a sample into your real books.
Almost. QFX is Quicken's Web Connect version of OFX: the same statement and transactions, plus Intuit tags such as INTU.BID (the bank's Intuit ID) that Quicken checks before importing. Take those out and you have a plain OFX statement.
Often, yes, and it costs nothing to try first. Renaming keeps the Intuit tags, your bank's routing number and the full account number, though. Convert when the importer still rejects the renamed file, or when you're sending the file to someone and want only the last 4 digits in it.
FreeAgent lists OFX, QIF and CSV, and Sage says OFX files upload without editing. Xero, Wave, QuickBooks Online's Upload from file and GnuCash already read QFX, so try the original there first.
Not here: we don't write QFX. Quicken validates Web Connect files with its online service and says it doesn't support files from conversion software, so a converted QFX usually won't open in Quicken anyway. For Quicken for Windows, convert to QIF instead.
Yes, when the QFX has a ledger balance dated on or after its last transaction and you haven't flipped the signs. Otherwise the OFX says 0.00 and your program works the balance out from the transactions.
No. Each transaction gets a new FITID made from the account, date, amount and description, the same every time you convert the same file. If you already imported some of these dates from the bank's own download, import only the dates that aren't in your program yet.
Yes. A credit card statement (CCSTMTRS) in the QFX is written as an OFX credit card statement, with charges negative and payments positive. Import it into a credit card account.
Yes. Each account gets its own tab in the preview and its own OFX, named with the account type and last 4 digits. One credit covers the whole file.
Free converter →
Free converter →
Free converter →
Free converter →
Free converter →
Free converter →