QFX to QIF Converter — For MYOB and older Quicken
QIF is older and plainer than QFX, and a great deal of software reads it and nothing else. It carries less around each transaction — a date, an amount, a payee and a cheque number where there is one — and those are what this writes.
Not the file you need?
- Starting from a bank CSV: CSV to QIF Converter
- QuickBooks Desktop rather than MYOB or Quicken: QFX to IIF Converter
For MYOB, older Quicken, and anything that predates the OFX family.
Payee and memo both kept
Where the QFX splits a payee across NAME and MEMO, both halves go into the QIF payee rather than one being dropped.
Dates written month first
The QIF is written MM/DD/YYYY, the order the format's own specification uses, from QFX dates that cannot be read two ways. Choose month first when your software asks.
No categories guessed
A category invented from a payee name is a wrong entry that looks deliberate. None are added.
What the QIF file contains
Field by field, where each part of the download comes from.
| In your QFX | In the QIF | How |
|---|---|---|
| <DTPOSTED> | D line | Written MM/DD/YYYY, month first. |
| <TRNAMT> | T line | The same signed amount, money out negative. |
| <NAME>, <MEMO> | P line | The payee: the two joined as "NAME - MEMO", or the memo alone where it already contains the name. Up to 96 characters. |
| Nothing | !Type:Bank | The first line, marking the file as a bank account, for a credit card QFX too. |
| <CHECKNUM> | N line | The cheque number, where the QFX gives one, on its own line before the payee. |
| <FITID>, <INTU.BID> | Not written | QIF has no field for either, so nothing in the file identifies a transaction to the software reading it. |
| <LEDGERBAL>, <CURDEF> | Not written | This QIF carries no balance and no currency. The preview states the QFX's closing balance. |
| Nothing | No L line | No category is written, because a QFX has none. |
Sample output
Made by this converter's own code from the made-up file shown. The output is the file it writes, not retyped.
The input: QFX
A made-up QFX with a cheque and a payee the bank split across NAME and MEMO.
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
<SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO</STATUS><DTSERVER>20260519120000<LANGUAGE>ENG<INTU.BID>12345</SONRS></SIGNONMSGSRSV1>
<BANKMSGSRSV1><STMTTRNRS><TRNUID>1<STATUS><CODE>0<SEVERITY>INFO</STATUS>
<STMTRS><CURDEF>USD
<BANKACCTFROM><BANKID>000000000<ACCTID>135792468<ACCTTYPE>CHECKING</BANKACCTFROM>
<BANKTRANLIST><DTSTART>20260501<DTEND>20260519
<STMTTRN><TRNTYPE>CREDIT<DTPOSTED>20260501<TRNAMT>2650.00<FITID>7Q2605010001<NAME>EXAMPLE CO PAYROLL</STMTTRN>
<STMTTRN><TRNTYPE>CHECK<DTPOSTED>20260504<TRNAMT>-1200.00<FITID>7Q2605040001<CHECKNUM>512<NAME>CHECK 512</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260512<TRNAMT>-86.25<FITID>7Q2605120001<NAME>SAMPLE GROCERY & DELI<MEMO>DEBIT CARD PURCHASE 0000</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260519<TRNAMT>-45.00<FITID>7Q2605190001<NAME>MADE-UP WATER UTILITY</STMTTRN>
</BANKTRANLIST>
<LEDGERBAL><BALAMT>3105.32<DTASOF>20260519</LEDGERBAL>
</STMTRS></STMTTRNRS></BANKMSGSRSV1>
</OFX>The output: QIF
The whole file.
!Type:Bank
D05/01/2026
T2650.00
PEXAMPLE CO PAYROLL
^
D05/04/2026
T-1200.00
N512
PCHECK 512
^
D05/12/2026
T-86.25
PSAMPLE GROCERY & DELI - DEBIT CARD PURCHASE 0000
^
D05/19/2026
T-45.00
PMADE-UP WATER UTILITY
^Questions about converting QFX to QIF
Which date format should I choose when importing the QIF?
Month first, MM/DD/YYYY. Every date in the file is written that way. The QFX's own dates are YYYYMMDD and cannot be misread, but a QIF does not record which way round its dates are, so the software reading it asks.
Is the cheque number kept?
Yes. The QFX's <CHECKNUM> goes on the N line, QIF's field for a cheque number, as N512 in the sample. Where the bank also wrote the number into the payee, as CHECK 512, the P line keeps that too.
Will importing the QIF twice duplicate transactions?
It can. A QIF carries no transaction id - the QFX's FITID has nowhere to go - so your software has nothing exact to match a second import against. Import each file once.
Does the QIF carry the currency or the closing balance?
No. QIF has no field for either. The amounts take the currency of the account you import them into, and the preview states the QFX's closing balance so you can check that account against it afterwards.