QFX to QBO converter (plus OFX, QBO to QFX, and CSV)
Quick answer
Drop a .qfx, .ofx, or .qbo file below and download it as QBO (QuickBooks), QFX (Quicken), OFX, or CSV. All three formats share the OFX structure, so the conversion keeps every transaction, its unique ID, date, amount, and payee exactly as your bank wrote them - only the labels QuickBooks and Quicken look for change. The file is read and converted in your browser and never uploaded.
Drop a QFX, OFX, or QBO file
Converted in your browser · nothing is uploaded
Choose a fileYour file is read and converted on this device. It never leaves your browser.
What the converter changes - and what it doesn't
- Kept as-is: every transaction, its FITID (so duplicate detection still works), dates, amounts, payee and memo, check numbers, the account number, and the ending balance.
- Kept when present: your bank's identifier (INTU.BID) and FI details, which QuickBooks and Quicken use to recognise the bank.
- Rewritten: the file is output as OFX 1.02, the version QuickBooks and Quicken Web Connect imports expect - so OFX 2.x (XML) files are converted too.
- Shortened: payee names longer than 32 characters (the OFX 1.x limit) are trimmed, with the full text kept in the memo.
QFX to QBO for QuickBooks
QuickBooks Online also accepts QFX uploads directly, so you mostly need QBO for QuickBooks Desktop.
- Download the QFX (or OFX) file from your bank.
- Drop it above and click Download QBO.
- QuickBooks Online: Bank transactions > Link account dropdown > Upload from file. QuickBooks Desktop: File > Utilities > Import > Web Connect Files.
- Pick the account and review the imported transactions.
QBO or OFX to QFX for Quicken
Quicken imports Web Connect (QFX) files through File > File Import > Web Connect File. Quicken checks the bank identifier (INTU.BID) inside the file. If your source file has one it's kept; plain OFX files often don't, and you can paste the number from any QFX your bank has given you into the Bank ID box before downloading.
Open a QFX, OFX, or QBO file in Excel
Excel can't read these formats as a table. Choose CSV instead: you get one row per transaction with date, description, memo, amount, type, check number, and transaction ID, ready for Excel or Google Sheets.
Only have a PDF statement?
If your bank only gives you PDFs, use the PDF statement converter instead - it produces QBO, QFX, QIF, CSV, and Excel directly from a digital PDF, reconciled against the statement's balances.
Related
Converted in your browser - your statement never leaves your device.
Doing this monthly or across clients?
Batch multi-file conversion and direct QuickBooks/Xero sync — join the early-access list. We only collect your email, never your statement.
Frequently asked questions
How do I convert QFX to QBO?
Drop the .qfx file on the converter on this page and click Download QBO. It runs in your browser, keeps every transaction and its ID, and the result imports into QuickBooks Online or Desktop as a Web Connect file.
Can I convert OFX to QBO?
Yes - OFX 1.x (SGML) and OFX 2.x (XML) files both work. The output is OFX 1.02 labelled for QuickBooks.
Can I convert QBO to QFX for Quicken?
Yes. Drop the .qbo file and click QFX. If Quicken asks which bank the file is from or rejects it, add your bank's INTU.BID in the Bank ID box and download again.
Will converting create duplicate transactions?
It shouldn't. Each transaction keeps its original FITID, which QuickBooks and Quicken use to recognise transactions already imported into the same account.
Is my file uploaded?
No. It's read and converted on your device; nothing is sent to a server.
Does it work for credit card files?
Yes. Credit card statements are written in the OFX credit card format, so they import into credit card accounts.