CSV to IIF Converter
Convert CSV bank statements to IIF format for QuickBooks Desktop — Pro, Premier, and Enterprise. Free, browser-based, no upload.
Drop your CSV file here
or click to browse
How to convert CSV to IIF
Export CSV
Download transactions from your bank as a CSV or Excel file.
Upload CSV
Drop your file into the converter above.
Map columns
Select which columns are Date, Description, and Amount.
Import IIF
In QuickBooks Desktop: File > Utilities > Import > IIF Files.
About IIF format
IIF (Intuit Interchange Format) is a tab-delimited text format created by Intuit for QuickBooks Desktop. Unlike QBO files (which work with QuickBooks Online), IIF is specifically for the desktop-installed versions: QuickBooks Pro, Premier, and Enterprise.
An IIF file for bank transactions contains TRNS records (one per transaction) and SPL records (split lines). Each transaction must end with an ENDTRNS marker. Our converter generates a valid IIF structure automatically from your CSV data.
After importing, check your QuickBooks register to verify the transactions appear correctly. Account names in the IIF default to "Checking" and "Income/Expense" — rename these in QuickBooks after import if needed.
Frequently asked questions
What is an IIF file?
IIF (Intuit Interchange Format) is a tab-delimited text format used by QuickBooks Desktop to import transactions and lists. It's the standard import format for QuickBooks Pro, Premier, and Enterprise.
How is IIF different from QBO?
IIF is for QuickBooks Desktop (the installed software). QBO is for QuickBooks Online (the web version). They are not interchangeable — use IIF if you run QuickBooks on your computer.
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.
What columns do I need in my CSV?
You need at minimum: a Date column, a Description/Memo column, and an Amount column. Debit/Credit split columns also work — select them separately during column mapping.
Will QuickBooks detect duplicate transactions?
QuickBooks Desktop does not automatically detect duplicates on IIF import the way it does with bank feeds. Always check your register after importing and filter by date to spot any doubles.