Convert a Quicken QIF export or bank QIF download to an OFX statement for QuickBooks Online, Wave, Xero or GnuCash. Stable transaction IDs added. Free up to 100 transactions.
Only have a PDF statement? Use the PDF statement converter.
Plenty of importers take OFX but not QIF: QuickBooks Online's Upload from file and Wave among them. Utilly reads each Quicken row and writes an OFX 1.02 statement with a stable FITID per transaction, which a QIF never had. Going to QuickBooks Desktop? Use QIF to QBO or QIF to IIF. Want the reverse? Use OFX to QIF.
!Type:CCard register opens as a credit card account.QIF is older than OFX and many importers dropped it. Check what your program reads before converting, because several still open a QIF as it is:
| Program | Reads QIF? | What to upload |
|---|---|---|
| QuickBooks Online | No. Upload from file lists QBO, QFX, OFX, CSV and TXT. | This OFX works; the QIF to QBO download is the QuickBooks-first choice. |
| QuickBooks Desktop | No, and Web Connect reads only .qbo. | QIF to QBO, or QIF to IIF without Web Connect. Not OFX. |
| Wave | No. Its statement upload takes OFX, QBO, QFX and ASO. | This OFX. |
| Xero, FreeAgent | Yes, both list QIF. | The QIF as it is, or this OFX if you'd rather have transaction IDs. |
| GnuCash | Yes (File → Import → Import QIF). | Either. The OFX importer remembers the account for the next file. |
| Quicken | Quicken for Windows, yes. | The QIF. Quicken rejects Web Connect files made by converters, so an OFX/QFX from here isn't promised to open. |
The first record of our sample Quicken export:
D9/ 1'26
U-6,420.18
T-6,420.18
PACH DEBIT GUSTO PAYROLL 0912
LPayroll
^
comes out of the converter as this OFX transaction:
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260901120000<TRNAMT>-6420.18<FITID>202609015DCA91C8B0BC00<NAME>ACH DEBIT GUSTO PAYROLL 0912<MEMO>ACH DEBIT GUSTO PAYROLL 0912</STMTTRN>
| QIF line | OFX tag |
|---|---|
D, Quicken's 9/ 1'26 style included | DTPOSTED as YYYYMMDD at noon; the file's DTSTART and DTEND are the first and last dates. |
| T, or U if there's no T | TRNAMT with two decimals and no thousands commas. Negative is TRNTYPE DEBIT, positive is CREDIT. |
| P, or M when the payee is empty | NAME (first 32 characters) and MEMO (the whole text), plain ASCII. |
| Nothing in the QIF | FITID: an ID from the account, date, amount and description, identical every time you convert the same QIF. |
!Type:Bank / !Type:CCard | A BANKACCTFROM checking statement, or a CCACCTFROM credit card statement. |
| !Account name | Names the tab and the download, and seeds ACCTID so next month's file from the same account gets the same ID. Bank ID is the placeholder 999999999. |
| Opening Balance record | Skipped; it isn't a bank transaction. |
| L, S/E/$ splits, N, C, A | Not written. OFX statements have no category or split field. Keep them with QIF to CSV or QIF to Excel. |
| No balances in a QIF | LEDGERBAL 0.00. Set the opening balance in your program and reconcile from there. |
A QFX is an OFX file with Intuit's bank ID tags, made for Quicken's Web Connect. Quicken checks that ID with its online service before importing and says it doesn't support files from conversion software, so we don't write QFX. If Quicken is where the data is going, Quicken for Windows imports the QIF itself; if it's QuickBooks, convert to QBO.
| Program | Menu |
|---|---|
| QuickBooks Online | Bank transactions → Link account ▾ → Upload from file, then pick the account. At most 1,000 transactions and 350 KB per file. |
| Wave | Accounting → Transactions → More → Upload transactions, then the payment account. |
| Xero | Bank accounts → ⋮ on the account → Import a Statement. |
| FreeAgent | Banking → Bank Accounts → the account → Upload Statement. |
| GnuCash | File → Import → Import OFX/QFX, and match the account the first time. |
!Type:Bank, Cash, CCard, Oth A, Oth L).!Type:Invst) aren't converted. Category, class and memorized payee lists are ignored.| Problem | Fix |
|---|---|
| "No transactions found in that QIF file" | The export held lists only. Export again with Transactions ticked. |
| Some accounts are missing from the preview | They're on other tabs at the top of the preview. Download each account's OFX from its tab. |
| Dates a month or more off | Pick %d/%m/%Y or %d/%m/%y as the date format; the file is day-first. |
| Deposits imported as spending | Tick Flip signs in the preview and download again. On a card account, check the account type is Credit card. |
| Balance in the program is wrong after import | The OFX ending balance is 0.00 because the QIF had none. Enter the opening balance in your program for the day before the first transaction. |
| QuickBooks Desktop won't open the .ofx | Desktop only imports .qbo Web Connect files. Use QIF to QBO or QIF to IIF. |
| Quicken says the file can't be imported | Expected for converted OFX/QFX. Import the original QIF under File → File Import → QIF File instead. |
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.
Because the program you're moving to doesn't read QIF. QuickBooks Online's Upload from file and Wave take OFX but not QIF, and many other bank-statement importers are the same. The OFX also gives every transaction an ID (FITID), which a QIF doesn't have.
Not here: we don't write QFX. A QFX is OFX with Intuit's bank ID added, and Quicken checks that ID against its list of participating banks, so a converted QFX usually won't open in Quicken anyway. Quicken for Windows reads QIF directly under File → File Import → QIF File.
No. An OFX bank statement has no category field, so L (category) and split lines are dropped and a split comes through as one line for its total. QIF to CSV and QIF to Excel keep the Category column.
0.00. A QIF holds transactions only, no statement balances, so there's nothing honest to write as LEDGERBAL. Your accounting program works the balance out from the transactions; check the opening balance there.
Each transaction's FITID is built from the account, date, amount and description, so converting the same QIF again gives the same IDs. Programs that check FITIDs skip the repeats; check your program's own duplicate handling before importing overlapping dates.
Yes. A !Type:CCard register is written as an OFX credit card statement (CCSTMTRS), 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 after the account. Import each into its matching account. One credit covers the whole file.
Yes, with the OFX / QFX to QIF converter. For QuickBooks Desktop, convert the QIF to QBO or IIF instead of OFX.
Free converter →
Free converter →
Free converter →
Free converter →
Free converter →
Free converter →