QBO to IIF Converter
Convert QBO bank statement files to IIF format for QuickBooks Desktop — Pro, Premier, and Enterprise. Free, browser-based, no upload.
Drop your QBO file here
or click to browse
How to convert QBO to IIF
Get your QBO file
Download a QBO/OFX file from your bank or export from QuickBooks Online.
Upload QBO
Drop the file into the converter above — transactions are parsed automatically.
Import IIF
In QuickBooks Desktop: File > Utilities > Import > IIF Files.
QuickBooks Online to QuickBooks Desktop
QuickBooks Online and QuickBooks Desktop use completely different file formats for importing transactions. Online uses QBO (OFX/SGML), while Desktop uses IIF (tab-delimited text). There is no direct way to import a QBO file into QuickBooks Desktop.
This converter bridges the gap by parsing the OFX transaction data from your QBO file — dates, amounts, descriptions — and generating a properly structured IIF file with TRNS, SPL, and ENDTRNS records that QuickBooks Desktop expects.
This is especially useful when your bank only offers QBO downloads but you run QuickBooks Desktop, or when migrating transaction history from QuickBooks Online to a Desktop installation.
Frequently asked questions
When would I need QBO to IIF conversion?
When you have bank statements in QBO (OFX) format but use QuickBooks Desktop instead of QuickBooks Online. QuickBooks Desktop imports transactions via IIF files, not QBO.
What is the difference between QBO and IIF?
QBO (OFX format) is used by QuickBooks Online and bank feeds. IIF (Intuit Interchange Format) is a tab-delimited format used by QuickBooks Desktop (Pro, Premier, Enterprise). They serve different QuickBooks products.
How do I import the IIF file into QuickBooks Desktop?
In QuickBooks Desktop, go to File > Utilities > Import > IIF Files. Select your downloaded IIF file and click Open. Transactions appear in your register immediately.
Can I use this to migrate from QuickBooks Online to Desktop?
Yes — if you can export your QuickBooks Online data as QBO/OFX files, this converter transforms them into IIF format that QuickBooks Desktop can import.
What account names does the IIF file use?
Transactions default to 'Checking' as the primary account with 'Income' or 'Expense' as offset accounts. You can rename these in QuickBooks Desktop after import.
Is my data safe?
Your data never leaves your browser. The conversion happens entirely in JavaScript on your device — no server upload.