A good import starts with the right file.
QFXtoQBO creates Web Connect transaction files for posted USD bank and credit card activity. It does not connect to your bank or write directly to your books.
Supported in this release
- One checking, savings or credit card account per file.
- QFX / OFX 1.x SGML and standard OFX 2.x XML bank statement structures.
- CSV with comma, semicolon or tab separators; with or without column headers.
- USD with no more than two decimal places, up to 2 MB and 10,000 transactions.
- UTF-8, Windows-1252 and UTF-16 input decoding. QBO export uses Windows-1252 bytes, including supported accented Latin letters and punctuation. Characters outside this character set (such as Chinese text and emoji) block export with an error; they are not silently replaced.
Outside the current scope
PDFs, scanned statements, Excel workbooks, investment accounts, multiple accounts in one file, pending transactions, correction records, currencies other than USD, payroll posting and automatic categorization are not supported. Save Excel data as CSV first. Do not simply rename a PDF or XLSX extension.
Where to find the institution details
If you already have a recent QuickBooks (.qbo) Web Connect file from the same bank and account, use “Copy details from a working QBO file” inside the converter. It reads the file locally, copies institution fields and fills an empty account identifier. It does not copy transactions or replace your closing balance and date.
The fields are ORG (institution organization), FID (institution ID), INTU.BID (Intuit Bank ID), and BANKID (routing identifier for bank accounts). A credit card uses a different account structure and does not require BANKID. Keep your account identifier consistent between imports.
These details identify the institution in the file. They are not a bank password, API key or login. If your bank only provides QFX, its identifiers may not be valid for QuickBooks Web Connect. Ask the bank for its current QuickBooks download details. We do not supply a generic bank ID or claim approval by Intuit.
Only have a CSV?
A transaction CSV usually has dates, descriptions and amounts, but no QuickBooks institution identifiers or statement closing balance. You can inspect and map that CSV here before obtaining the missing details. A preview alone does not mean the file is ready for Desktop import.
- Check your bank’s transaction-download options for QuickBooks / Web Connect (.qbo). If it offers the date range you need, you may not need a converter.
- If only CSV or QFX is available, ask the bank to confirm whether your account supports QuickBooks Desktop Web Connect and provide its current identifiers. A routing number alone is not enough.
- Use the actual closing balance and period-end date from your statement. Keep account identifiers consistent when importing into the same account.
Message you can copy when asking your bank
I need to import this account’s posted transactions into QuickBooks Desktop using Web Connect. Does this account currently support it? If so, where can I obtain a QuickBooks .qbo download, or the current institution ORG, FID, Intuit Bank ID (INTU.BID), and routing identifier for that account type? I do not need to share my password.
If your bank cannot provide supported identifiers, this converter cannot guarantee a valid Desktop import. Do not use another bank’s ID. For QuickBooks Online, first try its direct CSV or QFX upload; the Desktop identifier requirements are different.
QuickBooks Desktop
Desktop Web Connect imports .qbo files, subject to your edition, service status, bank support and account setup. Discontinued banking services cannot be restored by file conversion. QuickBooks Desktop 2023 banking services ended May 31, 2026.
Desktop test results: on September 23, 2026, we imported QFX-derived and CSV-derived QBO files with eight transactions each, plus a three-transaction credit card file, into QuickBooks Enterprise Solutions 24.0 Trial on Windows 11. Dates, amounts, accented text and distinct transactions were checked. Re-importing the same files added no new transactions; one credit card charge was also added to the register.
These tests used a synthetic company and a simulated Wells Fargo institution profile. They establish results for that test setup, not approval by the bank or Intuit. Your edition, institution identifiers and account setup still determine acceptance. Try a free export in a backup copy of your company file before buying Pro.
QuickBooks Online
Online accepts CSV, QFX and QBO uploads. Try its native upload when that meets your need. Our Desktop test results do not establish compatibility with your Online account.