Convert OFX to QFX Free for Quicken
Your bank gave you OFX, but Quicken for Windows wants QFX. This OFX to QFX converter adds the Intuit institution ID Quicken checks, so you can import the file as Web Connect.
- Encrypted with AES-256
- Temporary private storage; automatic deletion
- Preview before you download
How to convert OFX to QFX for Quicken
- 01
Upload the OFX file.
Drop in the file your bank or other app exported. Want to test first? Run the sample file.
- 02
Set the two Quicken options.
Under "Bank shown in Quicken", pick your bank. Under "Account type", match the account in Quicken.
- 03
Preview and download the QFX.
Scan the first 10 transactions for the right dates and amounts. Then download the QFX file.
OFX to QFX: transaction data and institution details
Here is a fictional Sample Bank file before and after conversion. Transactions and their IDs don't change; the QFX adds the Intuit bank ID for the bank you choose.
OFX input
<?xml version="1.0" encoding="UTF-8"?> <?OFX OFXHEADER="200" VERSION="211" SECURITY="NONE" OLDFILEUID="NONE" NEWFILEUID="NONE"?> <OFX> <SIGNONMSGSRSV1><SONRS> <STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY></STATUS> <DTSERVER>20260430</DTSERVER> <LANGUAGE>ENG</LANGUAGE> <FI><ORG>Sample Bank</ORG><FID>0000</FID></FI> </SONRS></SIGNONMSGSRSV1> <BANKMSGSRSV1><STMTTRNRS><STMTRS> <CURDEF>USD</CURDEF> <BANKACCTFROM> <BANKID>000000000</BANKID> <ACCTID>000000000000</ACCTID> <ACCTTYPE>CHECKING</ACCTTYPE> </BANKACCTFROM> <BANKTRANLIST><DTSTART>20260403</DTSTART><DTEND>20260415</DTEND> <STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20260403</DTPOSTED><TRNAMT>-62.15</TRNAMT><FITID>20260403001</FITID><NAME>Office Depot</NAME></STMTTRN> <STMTTRN><TRNTYPE>CREDIT</TRNTYPE><DTPOSTED>20260409</DTPOSTED><TRNAMT>1800.00</TRNAMT><FITID>20260409001</FITID><NAME>Client payment – Acme LLC</NAME></STMTTRN> <STMTTRN><TRNTYPE>FEE</TRNTYPE><DTPOSTED>20260415</DTPOSTED><TRNAMT>-12.00</TRNAMT><FITID>20260415001</FITID><NAME>Monthly service fee</NAME></STMTTRN> </BANKTRANLIST> </STMTRS></STMTTRNRS></BANKMSGSRSV1> </OFX>
QFX output
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>20261024231311[0:GMT]</DTSERVER>
<LANGUAGE>ENG</LANGUAGE>
<FI>
<ORG>Sample Bank</ORG>
<FID>0000</FID>
</FI>
<INTU.BID>00000</INTU.BID>
</SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
<STMTTRNRS>
<TRNUID>0</TRNUID>
<STATUS>
<CODE>0</CODE>
<SEVERITY>INFO</SEVERITY>
</STATUS>
<STMTRS>
<CURDEF>USD</CURDEF>
<BANKACCTFROM>
<BANKID>000000000</BANKID>
<ACCTID>000000000000</ACCTID>
<ACCTTYPE>CHECKING</ACCTTYPE>
</BANKACCTFROM>
<BANKTRANLIST>
<DTSTART>20260403000000[0:GMT]</DTSTART>
<DTEND>20260416000000[0:GMT]</DTEND>
<STMTTRN>
<TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20260403120000[0:GMT]</DTPOSTED>
<TRNAMT>-62.15</TRNAMT>
<FITID>20260403001</FITID>
<NAME>Office Depot</NAME>
</STMTTRN>
<STMTTRN>
<TRNTYPE>CREDIT</TRNTYPE>
<DTPOSTED>20260409120000[0:GMT]</DTPOSTED>
<TRNAMT>1800.00</TRNAMT>
<FITID>20260409001</FITID>
<NAME>Client payment – Acme LLC</NAME>
</STMTTRN>
<STMTTRN>
<TRNTYPE>FEE</TRNTYPE>
<DTPOSTED>20260415120000[0:GMT]</DTPOSTED>
<TRNAMT>-12.00</TRNAMT>
<FITID>20260415001</FITID>
<NAME>Monthly service fee</NAME>
</STMTTRN>
</BANKTRANLIST>
<LEDGERBAL>
<BALAMT>0.00</BALAMT>
<DTASOF>20261231235959[0:GMT]</DTASOF>
</LEDGERBAL>
</STMTRS>
</STMTTRNRS>
</BANKMSGSRSV1>
</OFX>OFX to QFX field mapping
The converter writes a new QFX document. Existing transaction IDs and supported values carry across, but institution overrides, account settings and normalization can change the header and date representations.
| OFX field | QFX field | Note |
|---|---|---|
| (not present) | INTU.BID | Added from "Bank shown in Quicken". Quicken checks this ID on import. |
| FI (ORG, FID) | FI (ORG, FID) | Source values carry across unless the selected bank or manual institution settings override them. |
| BANKACCTFROM or CCACCTFROM | BANKACCTFROM or CCACCTFROM | Set by "Account type". Checking and savings use BANKACCTFROM. Credit cards use CCACCTFROM. |
| ACCTID | ACCTID | Unchanged, so Quicken can match the file to the same account each time. |
| DTPOSTED, TRNAMT, TRNTYPE | DTPOSTED, TRNAMT, TRNTYPE | Dates, amounts and types copy across unchanged. |
| NAME, MEMO | NAME, MEMO | Payee and memo text copy across unchanged. |
| FITID | FITID | Existing IDs are kept. Review the destination application's matches before accepting imports. |
| LEDGERBAL | LEDGERBAL | The closing balance carries over. |
| DTSTART / DTEND | DTSTART / DTEND | The header's date range covers the transactions in the file. |
How to import the QFX file into Quicken
Back up your Quicken data file before any import. Then follow the steps for your version of Quicken.
Quicken for Windows
Quicken Classic for Windows · Documentation checked
- Back up your Quicken data file.
- Go to File > File Import > Web Connect (.QFX) File and select the download.
- Link it to the correct existing account or create one when prompted.
- Review dates, amounts and duplicate matches before accepting the transactions. If the institution is rejected, follow Quicken's support guidance.
Quicken for Mac
Quicken Classic for Mac · Documentation checked
- Back up your Quicken data file.
- Go to File › Import › Bank or Brokerage File (OFX, QFX).
- Select the QFX file and choose the account it belongs to.
- Review the imported transactions in the account register.
Quicken for Mac lists OFX and QFX in the same import option. If your original OFX file imports cleanly there, you may not need to convert it.
Where to get the OFX file for Quicken
Show me where to download it
Check your bank's download options first. If it offers a Quicken or QFX download, use that and skip this page.
If OFX is the only choice, sign in to online banking and open the account. Look for "Download", "Export" or "Download transactions" and choose OFX. Some banks call it "Money" or "Microsoft Money". Pick a date range that starts after your last import into Quicken.
Moving from another personal finance app? If it exports OFX, use that export. Convert it here, then import the QFX into Quicken.
What are OFX and QFX files?
What is an OFX file?
An OFX (Open Financial Exchange) file is the standard format banks use to send transactions to finance software. Xero, Sage, MYOB, Moneydance, GnuCash and QuickBooks Online read it. Dates, amounts and a unique ID per transaction are labeled, so there's no column mapping.
What is a QFX file?
A QFX file is Quicken Web Connect, used for bank and credit card downloads. It is based on OFX and adds Intuit institution details. Transaction IDs help identify previously imported entries. Acceptance depends on the institution and your Quicken edition and services.
Convert OFX to QFX when Quicken for Windows won't import the plain OFX file your bank gave you.
OFX and QFX import errors in Quicken
| Error | Cause | Fix |
|---|---|---|
| Quicken won't import the OFX file, or says it can't verify the financial institution | The institution is not accepted, the identifiers do not match, or Web Connect services are unavailable for this edition. | Confirm that the selected bank and institution IDs match your own account, and that your software supports that bank's Web Connect service. Correct the details and reconvert; do not substitute an unrelated bank. |
| You renamed the file from .ofx to .qfx and Quicken still rejects it | Renaming changes the file extension, not the contents. The Intuit fields are still missing. | Convert the original OFX file here instead of renaming it. |
| Transactions show up twice | The account also downloads from your bank, or the same period was imported from a different file. | Review duplicate matches and overlapping date ranges in the account register before accepting entries. If Quicken reports a connection conflict, follow its support guidance before changing online services. |
| Transactions land in the wrong kind of account | "Account type" didn't match the account in Quicken. A credit card file sent to checking is a common case. | Convert again with the matching account type. |
| The QIF import option won't accept your checking account | Quicken for Windows doesn't import QIF into checking, savings or credit card accounts. | Use QFX for bank and credit card accounts. |
OFX and QFX files: your questions
QFX is OFX with extra Intuit fields. The most important is the Intuit institution ID, which tells Quicken which bank sent the file. The transactions inside are the same.
Renaming rarely solves it. The extension changes, but the Intuit institution ID Quicken looks for is still missing. Converting the file adds that ID.
Quicken for Mac has one import option for both OFX and QFX. Quicken for Windows imports QFX through File › File Import › Web Connect (.QFX) File and often rejects plain OFX. That's when you need a QFX file.
Yes. Converting OFX to QFX is free, and no account is needed. Upload your OFX file, preview the transactions and download the QFX.
Choose the bank that holds the account. Quicken checks this ID during a Web Connect import. Picking the right bank keeps the file tied to the right institution in Quicken.
Existing FITIDs are retained. Transaction IDs help your software recognise previously imported transactions. Review duplicate matches and overlapping date ranges; an ID is not a guarantee that every import will be de-duplicated. If Quicken reports a connection conflict, follow its official troubleshooting guidance before changing online services.
For checking, savings and credit card accounts in Quicken for Windows, no. QIF import there only works for cash, asset and liability accounts. QFX is the format to use for bank accounts.
Limitations
Use the details for the bank that holds your account. A directory listing or an Intuit bank ID does not guarantee acceptance by QuickBooks or Quicken; your edition, subscription and the institution's Web Connect support also matter.
File privacy
File-converter uploads and results are temporarily stored in private storage. Uploads are deleted after a successful conversion; abandoned uploads and results are automatically deleted after about an hour. Download links are temporary.