OFX → QFX · FREE ONLINE TOOL

OFX to QFX converter

OFX to QFX converter: wrap OFX bank downloads as QFX files that Quicken accepts through Web Connect.

Click here to upload OFX filesor drag and drop here · browse your files · up to 20 files, 25 MB each
Account and export details

Only details required for the selected export are used. Account IDs and bank identifiers are included in bank-feed files.

Convert an OFX to QFX when Quicken refuses your bank's generic download: the file comes back with the Quicken header elements it looks for, and not a single transaction changed.

Supported input and export details

Bank and credit-card transactions are supported. Investment downloads and unsupported statement structures are rejected.

This export requires an account ID, currency, actual closing balance and date; bank feeds also require a valid numeric institution ID and a routing ID for checking or savings accounts. These values are not guessed, and destination compatibility is not guaranteed.

Set required export details in “Account and export details” before converting. The preview shows up to ten transactions and totals by account and currency. Opening or running balances are not inferred, and previewed transactions cannot be edited here. Download links expire after 24 hours.

Why convert OFX files to QFX

Quicken imports only its own Web Connect flavour of OFX. A bank's generic OFX download contains the same transactions but lacks the INTU elements Quicken looks for. Adding them, and writing the header in the form all Quicken releases accept, makes the download importable without touching the data.

Data preserved

Transactions, identifiers, dates, amounts and balances are copied without change.

Quicken elements added

INTU.BID and, where needed, INTU.USERID are inserted.

SGML header with CRLF

The header and line endings are written in the form every Quicken release accepts, even from OFX 2 XML input.

Account type checked

Types Quicken supports are confirmed on the review screen.

Duplicates still detected

Unchanged FITIDs mean Quicken recognises anything already in the register.

File removed after the job

Nothing is kept: the OFX is checked, hashed for the job and deleted immediately after.

Who converts OFX to QFX

Quicken users

Banks that provide OFX but not QFX downloads can still be imported through Web Connect.

Users of banks abroad

Non-US banks rarely offer QFX; the wrapper makes their OFX usable in Quicken.

Household bookkeeping

All accounts import the same way regardless of what the bank offers.

Financial planners

Client downloads are converted to the form Quicken tracks.

OFX to QFX: how each field is mapped

Every transaction element is identical in both formats. The table shows what is copied and what the Quicken header adds.

FieldIn OFXIn QFX
DateDTPOSTED in YYYYMMDD formDTPOSTED timestamp, date part used
DescriptionNAME and MEMO elementsNAME holds the payee, MEMO the longer text
AmountSigned TRNAMTSigned TRNAMT value
BalanceLEDGERBAL block at statement closeLEDGERBAL as of the download date
ReferenceFITID unique ID plus CHECKNUMFITID from the bank, CHECKNUM for checks
AccountBANKACCTFROM with routing and account IDsAccount block with Quicken's INTU.BID institution ID
CurrencyCURDEF elementCURDEF code
OFX to QFX conversion diagram showing date, description, amount, balance, reference, account and currency fields carried from OFX to QFX
OFX content is preserved exactly; the Quicken header elements are the only addition.

Converting OFX to QFX in practice

Turning a generic OFX into Quicken's Web Connect flavour

QFX is Quicken's branded OFX. The transaction data is identical; what Quicken checks for is the INTU.BID institution identifier and, for some versions, an INTU.USERID. The converter leaves the STMTTRN blocks untouched, inserts those elements, and writes the file with the header Quicken expects, so the import behaves like a Web Connect download from a supported bank.

Quicken can be picky about the OFX version declared in the header and about line endings. The output uses the SGML-style header with CRLF line endings that all Quicken releases accept, even when the source was OFX 2 XML.

After converting, check that:

  • Quicken imported without an 'unsupported financial institution' message
  • Every transaction from the OFX appears in the register
  • Amounts and dates are unchanged from the source

How to convert OFX to QFX in three steps

  1. 1Upload the OFXAdd the generic download Quicken would not accept.
  2. 2Confirm the account typeCheck that the type is one Quicken supports.
  3. 3Download and import into QuickenOpen the QFX in Quicken and link it to the account when prompted.

About OFX and QFX

OFX is the standard behind bank downloads. Banks produce it in SGML or XML form, with account and transaction blocks that Quicken can read once the header satisfies it.

QFX is that same content with Quicken's institution elements. Quicken uses them to accept the file and the transaction identifiers to prevent duplicates.

Specifications and vendor help for OFX and QFX: Financial Data Exchange, maintainer of the OFX standard · Quicken support

Questions about QFX conversion

Why does Quicken reject my bank's OFX?

It looks for INTU elements in the header. Once they are present the transactions import normally.

Will anything about the transactions change?

No. Identifiers, dates, amounts and memos are byte-for-byte the same.

Which Quicken versions accept the output?

All Web Connect capable releases, on Windows and Mac.

Can I convert investment OFX files?

Only banking and credit card statements are supported.

Is the ofx to qfx converter free?

Yes. Converting the OFX and downloading the QFX for Quicken is free.