QBO vs IIF: What’s the Difference and When to Use Each
QBO files are Web Connect format — they require an active Intuit connection to import. IIF files are QuickBooks’ legacy import format that works offline with any QB Desktop version. If you’re seeing an OL-222 error or “Web Connect import no longer supported,” your QBO connection has been cut off. Converting to IIF is the standard workaround.
Quick Summary
QBO = requires Intuit Web Connect (discontinued for QB 2020/2021/2022) IIF = offline file import (works with ALL QB Desktop versions) Solution: Convert .qbo → .iif → File → Utilities → Import → IIF Files
What Is a QBO File?
A QBO file is a bank transaction file formatted using the Open Financial Exchange (OFX) standard, wrapped in Intuit’s proprietary Web Connect protocol. When you download transactions from your bank for QuickBooks, you typically receive a .qbo file.
The key thing to understand about QBO files is that they don’t just contain data — they rely on an active connection between QuickBooks and Intuit’s servers. When you double-click a .qbo file or use File → Import → Web Connect, QuickBooks contacts Intuit’s servers to verify the financial institution data before allowing the import.
This verification step is where things break. When Intuit discontinues Web Connect support for a version of QuickBooks Desktop, that verification call fails. The .qbo file itself is perfectly valid XML/SGML data containing your transaction dates, amounts, and payee names. But QuickBooks refuses to process it because the server-side handshake no longer works.
QBO files were the standard import method for QuickBooks Desktop from the early 2000s until Intuit began phasing out Web Connect. The format worked well when the service was active — it was reliable, handled duplicate detection, and matched transactions to accounts automatically. The problem is entirely that Intuit chose to shut down the server-side infrastructure.
What Is an IIF File?
- IIF stands for Intuit Interchange Format. It is a tab-delimited plain text file format that QuickBooks Desktop has supported since its very first version in the 1990s.
- Unlike QBO, IIF files require no internet connection, no server verification, and no active Intuit service. They are imported directly via File → Utilities → Import → IIF Files. QuickBooks reads the tab-separated values and creates transactions in your company file.
- An IIF file is structured with header rows (prefixed with !) that define the columns, followed by data rows. A typical bank transaction IIF file looks like: !TRNS, DATE, ACCNT, NAME, AMOUNT, MEMO on the header line, followed by one TRNS row per transaction and a corresponding SPL (split) row for the offset account.
- The IIF format is older and simpler than QBO. It doesn’t do automatic duplicate detection or account matching. But it has one critical advantage: it has never been discontinued. Every version of QuickBooks Desktop — from the earliest releases through 2020, 2021, 2022, 2023, and beyond — supports IIF import. This makes it the most reliable way to get bank transactions into QuickBooks Desktop when Web Connect is no longer available.
- Banks stopped providing IIF downloads years ago in favor of QBO/OFX. But you can easily convert a .qbo or .ofx file to .iif using a converter tool, which is exactly what QBOConverter does.
QBO vs IIF: Side-by-Side Comparison
| Feature | QBO (Web Connect) | IIF (Legacy Import) |
|---|---|---|
| Requires Intuit connection | ✅ Yes | ❌ No |
| Works offline | ❌ No | ✅ Yes |
| QB Desktop 2020–2022 support | ❌ Discontinued | ✅ Yes |
| QB Desktop 2023+ support | ✅ Yes | ✅ Yes |
| QuickBooks Online support | ✅ Yes | ❌ No |
| Human-readable format | ❌ SGML/XML | ✅ Tab-delimited text |
| Import path in QB Desktop | Web Connect | File > Utilities > Import > IIF Files |
| Can be converted | ✅ To IIF | ✅ From QBO/OFX |
Frequently Asked Questions
Can I convert QBO to IIF without installing software?
Yes. QBOConverter is a free online tool. Upload your .qbo or .ofx file in your browser and download the converted .iif file instantly. No software installation required.
When does QBO stop working for QuickBooks Desktop?
Intuit discontinued Web Connect (QBO import) for QB Desktop 2020 in May 2023, QB Desktop 2021 in May 2024, and QB Desktop 2022 in May 2025. QB Desktop 2023 and later still support QBO import.
Does IIF preserve all transaction data from QBO?
Yes. All transaction dates, amounts, payee names, and memos are preserved during the conversion. The only difference is the file format — the data itself is identical.
Which format should I use if my QB Desktop version still supports Web Connect?
If your version still supports QBO import (QB Desktop 2023+), you can continue using .qbo files directly. IIF conversion is only needed when Web Connect has been discontinued for your version.
Software Developer & AI Engineer based in Japan
Kenta built QBOConverter after encountering this exact QuickBooks error while supporting a client. He writes about practical fixes for accounting software edge cases.