Free converter · QIF → OFX

Convert QIF to OFX

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.

Free up to 100 rowsColumns detected automaticallyFiles deleted after 1 hour
Processed in memory, never stored
No file handy? See the result on a fictional one first:

Only have a PDF statement? Use the PDF statement converter.

Why OFX?

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.

How to convert QIF to OFX

  1. Get the QIF. Quicken for Windows: File → File Export → QIF File, choose the account, the date range and Transactions under Include in Export (Quicken's help). An older bank download saved as .qif is fine too.
  2. Drop it in the converter above. Date, signed amount and payee are read from every record, and a !Type:CCard register opens as a credit card account.
  3. Look over the preview. Spending should show as negative. Day-first files (01/09/2026 meaning 1 September) need the day-first date format picked in the preview.
  4. Optionally type the last 4 digits of the account. They become the OFX account ID; leave it empty and a stable ID is made from the QIF's account name.
  5. Download the .OFX and import it into the matching bank or card account (where to import it).

When you need OFX instead of QIF

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:

ProgramReads QIF?What to upload
QuickBooks OnlineNo. Upload from file lists QBO, QFX, OFX, CSV and TXT.This OFX works; the QIF to QBO download is the QuickBooks-first choice.
QuickBooks DesktopNo, and Web Connect reads only .qbo.QIF to QBO, or QIF to IIF without Web Connect. Not OFX.
WaveNo. Its statement upload takes OFX, QBO, QFX and ASO.This OFX.
Xero, FreeAgentYes, both list QIF.The QIF as it is, or this OFX if you'd rather have transaction IDs.
GnuCashYes (File → Import → Import QIF).Either. The OFX importer remembers the account for the next file.
QuickenQuicken for Windows, yes.The QIF. Quicken rejects Web Connect files made by converters, so an OFX/QFX from here isn't promised to open.

What carries over from the QIF

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 lineOFX tag
D, Quicken's 9/ 1'26 style includedDTPOSTED as YYYYMMDD at noon; the file's DTSTART and DTEND are the first and last dates.
T, or U if there's no TTRNAMT with two decimals and no thousands commas. Negative is TRNTYPE DEBIT, positive is CREDIT.
P, or M when the payee is emptyNAME (first 32 characters) and MEMO (the whole text), plain ASCII.
Nothing in the QIFFITID: an ID from the account, date, amount and description, identical every time you convert the same QIF.
!Type:Bank / !Type:CCardA BANKACCTFROM checking statement, or a CCACCTFROM credit card statement.
!Account nameNames 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 recordSkipped; it isn't a bank transaction.
L, S/E/$ splits, N, C, ANot written. OFX statements have no category or split field. Keep them with QIF to CSV or QIF to Excel.
No balances in a QIFLEDGERBAL 0.00. Set the opening balance in your program and reconcile from there.

QIF to QFX?

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.

Where to import the OFX

ProgramMenu
QuickBooks OnlineBank transactions → Link account ▾ → Upload from file, then pick the account. At most 1,000 transactions and 350 KB per file.
WaveAccounting → Transactions → More → Upload transactions, then the payment account.
XeroBank accounts → ⋮ on the account → Import a Statement.
FreeAgentBanking → Bank Accounts → the account → Upload Statement.
GnuCashFile → Import → Import OFX/QFX, and match the account the first time.

Which QIF files work

  • Bank, cash, credit card and other asset or liability registers (!Type:Bank, Cash, CCard, Oth A, Oth L).
  • Multi-account exports. Each account is read separately into its own preview tab and its own .ofx, named after the account. One credit covers the whole file.
  • Investment registers (!Type:Invst) aren't converted. Category, class and memorized payee lists are ignored.
  • Month-first or day-first dates with two- or four-digit years.
  • Free up to 100 transactions, and up to 20,000 per file.

Common problems

ProblemFix
"No transactions found in that QIF file"The export held lists only. Export again with Transactions ticked.
Some accounts are missing from the previewThey're on other tabs at the top of the preview. Download each account's OFX from its tab.
Dates a month or more offPick %d/%m/%Y or %d/%m/%y as the date format; the file is day-first.
Deposits imported as spendingTick 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 importThe 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 .ofxDesktop only imports .qbo Web Connect files. Use QIF to QBO or QIF to IIF.
Quicken says the file can't be importedExpected for converted OFX/QFX. Import the original QIF under File → File Import → QIF File instead.

Other conversions

Pricing

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.

FAQ

Questions

Is it 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.

How do I import the OFX file?

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.

Is my file stored?

No. Files are processed in memory and deleted after 1 hour. We never use your data for AI training.

Can I try it without uploading my own file?

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.

Why convert QIF to OFX?

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.

Can I convert QIF to QFX?

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.

Are my Quicken categories and splits kept?

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.

What ending balance does the OFX show?

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.

Will importing the same QIF twice create duplicates?

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.

Can I convert a credit card QIF to OFX?

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.

My QIF file has several accounts. Will that work?

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.

Can I convert OFX back to QIF?

Yes, with the OFX / QFX to QIF converter. For QuickBooks Desktop, convert the QIF to QBO or IIF instead of OFX.

Other converters

More bookkeeping tools