QFX to QBO Converter — Quicken file to QuickBooks

Your bank's download menu offers Quicken (QFX) but not QuickBooks (QBO)? This rewrites the QFX as a QuickBooks Web Connect file, keeping your bank's INTU.BID, each transaction's FITID, cheque numbers, payees and the closing balance. Both are Intuit formats and they are not interchangeable: Quicken wants QFX and QuickBooks wants QBO.

Not the file you need?

From the Quicken file to the QuickBooks one.

The bank id carried over

Where your QFX names its issuing bank, that code is kept rather than replaced with a generic one.

Your bank's transaction ids kept

Each transaction keeps the FITID your bank gave it, so QuickBooks recognises one it has already imported from the bank itself. Only an id the file repeats is replaced.

Card statements handled

Credit card exports use a different wrapper. It is read as readily as a current account, and written out as a bank-account file.

What the QBO file contains

Field by field, where each part of the download comes from.

In your QFXIn the QBOHow
<INTU.BID><INTU.BID>Your bank's id, kept rather than replaced with a generic one.
<FITID><FITID>Your bank's transaction id, kept. One the file repeats gets a new id, since QuickBooks would drop the second.
<DTPOSTED>, <TRNAMT><DTPOSTED>, <TRNAMT>The same date, YYYYMMDD, and the same signed amount.
<NAME>, <MEMO><NAME>, <MEMO>Kept apart as the bank split them. A name longer than 32 characters, the most <NAME> holds, is cut there and written whole at the start of <MEMO>.
<CHECKNUM><CHECKNUM>Kept; a transaction the bank typed CHECK stays a CHECK.
<LEDGERBAL><LEDGERBAL>The closing balance and its date, as the QFX states them.
<CCSTMTRS><STMTRS>A credit card QFX is written as a bank-account (CHECKING) statement.

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 carrying a bank id (12345, invented) in <INTU.BID>, the way a bank's own Quicken download does.

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>20260314120000<LANGUAGE>ENG<INTU.BID>12345</SONRS></SIGNONMSGSRSV1>
<BANKMSGSRSV1><STMTTRNRS><TRNUID>1<STATUS><CODE>0<SEVERITY>INFO</STATUS>
<STMTRS><CURDEF>USD
<BANKACCTFROM><BANKID>000000000<ACCTID>987654321<ACCTTYPE>CHECKING</BANKACCTFROM>
<BANKTRANLIST><DTSTART>20260303<DTEND>20260314
<STMTTRN><TRNTYPE>CREDIT<DTPOSTED>20260303<TRNAMT>2200.00<FITID>7Q2603030001<NAME>EXAMPLE CO PAYROLL</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260307<TRNAMT>-54.18<FITID>7Q2603070001<NAME>SAMPLE PHARMACY #22</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260314<TRNAMT>-129.00<FITID>7Q2603140001<NAME>FICTIONAL FITNESS CLUB MONTHLY MEMBERSHIP</STMTTRN>
</BANKTRANLIST>
<LEDGERBAL><BALAMT>2516.82<DTASOF>20260314</LEDGERBAL>
</STMTRS></STMTTRNRS></BANKMSGSRSV1>
</OFX>

The output: QBO

The whole file. The writer puts everything after the header on one line; line breaks are added here before each transaction so it can be read.

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY></STATUS><DTSERVER>20260314120000</DTSERVER><LANGUAGE>ENG</LANGUAGE><INTU.BID>12345</INTU.BID></SONRS></SIGNONMSGSRSV1>
<BANKMSGSRSV1><STMTTRNRS><TRNUID>1</TRNUID><STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY></STATUS>
<STMTRS><CURDEF>USD</CURDEF><BANKACCTFROM><BANKID>000000000</BANKID><ACCTID>987654321</ACCTID><ACCTTYPE>CHECKING</ACCTTYPE></BANKACCTFROM>
<BANKTRANLIST><DTSTART>20260303</DTSTART><DTEND>20260314</DTEND>
<STMTTRN><TRNTYPE>CREDIT</TRNTYPE><DTPOSTED>20260303</DTPOSTED><TRNAMT>2200.00</TRNAMT><FITID>7Q2603030001</FITID><NAME>EXAMPLE CO PAYROLL</NAME></STMTTRN>
<STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20260307</DTPOSTED><TRNAMT>-54.18</TRNAMT><FITID>7Q2603070001</FITID><NAME>SAMPLE PHARMACY #22</NAME></STMTTRN>
<STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20260314</DTPOSTED><TRNAMT>-129.00</TRNAMT><FITID>7Q2603140001</FITID><NAME>FICTIONAL FITNESS CLUB MONTHLY M</NAME><MEMO>FICTIONAL FITNESS CLUB MONTHLY MEMBERSHIP</MEMO></STMTTRN>
</BANKTRANLIST><LEDGERBAL><BALAMT>2516.82</BALAMT><DTASOF>20260314</DTASOF></LEDGERBAL>
</STMTRS></STMTTRNRS></BANKMSGSRSV1></OFX>

Questions about converting QFX to QBO

What is the difference between a QFX and a QBO?

Both are OFX with Intuit's <INTU.BID> tag: QFX is the file Quicken opens and QBO the one QuickBooks opens. This keeps everything your QFX states - the bank id, each FITID, cheque numbers, payees, memos and the closing balance - and writes it as a QBO.

Will importing it duplicate transactions from my bank feed?

Not the ones that carry the same ids. The FITIDs are your bank's own, and QuickBooks does not add a transaction whose FITID it has already imported into that account.

Can I convert a credit card QFX?

Yes. It is read, and written as a bank-account statement, because this QBO is always a checking-account file. Import it into a bank register; QuickBooks may not link a checking-account file to a credit card account.

Do my Quicken categories come across?

No, because a QFX has none to give. The categories you see in Quicken are assigned in Quicken after a download; the QFX itself has no category field. What comes across is each transaction's date, amount, payee, memo, FITID and cheque number. Assign categories in QuickBooks after the import.

Related guides