How to convert a CSV file to IIF
Export your CSV from your bank or app
Download transaction history as a .csv file from your bank, accounting software, payment processor, or bookkeeping app.
Upload and map your CSV columns
The converter detects Date, Amount, Debit, Credit, Payee, Memo, and Category columns. Review the mapping and enter your QuickBooks account names.
Download your IIF file
Click Download .iif, then import it in QuickBooks Desktop through File -> Utilities -> Import -> IIF Files.
What is an IIF file, and why does QuickBooks use it?
IIF stands for Intuit Interchange Format. Intuit built this format for QuickBooks so businesses can import transactions, accounts, customer lists, vendor lists, and journal entries without retyping the data.
Many banks export transactions as CSV, but QuickBooks Desktop does not accept plain CSV for several import workflows. A CSV to IIF converter bridges that gap and prepares the file QuickBooks expects.
| Feature | CSV file | IIF file |
|---|---|---|
| Full name | Comma-Separated Values | Intuit Interchange Format |
| Opens in | Excel, Google Sheets, any text editor | QuickBooks Desktop mainly |
| Used for | Bank, app, and spreadsheet exports | Importing transactions into QuickBooks |
| Structure | Rows and columns separated by commas | Tab-delimited rows such as TRNS, SPL, and ENDTRNS |
| Human-readable | Yes, easy to edit | Yes, but the format must stay exact |
Why use the CSVall.com converter
This converter is built for privacy, speed, and practical QuickBooks Desktop imports. It avoids uploads, account creation, and the common row limits that slow bookkeeping work down.
Processes in your browser
Your financial data is read and converted on your device. It is not sent to CSVall servers.
Fast with large files
Thousands of transaction rows can be mapped, checked, and exported quickly in the browser.
Smart column mapping
Common bank headers such as Date, Amount, Debit, Credit, Payee, Memo, and Category are detected automatically.
Free to use
No trial lock, no watermark, and no account form before you can download the file.
Works on any device
Runs in modern browsers on Windows, Mac, Linux, iPad, and most mobile browsers.
Tips for a clean QuickBooks IIF import
Check the date format
QuickBooks Desktop commonly expects M/D/YY dates. The converter writes IIF dates in that style and lets you choose how to read the source CSV.
Use exact account names
The ACCNT field must match your QuickBooks chart of accounts. A small spelling difference can create a new account instead of posting to the existing one.
Review debit and credit signs
Use one signed amount column or separate debit and credit columns. If the direction looks wrong, turn on the sign flip before export.
Test a small file first
Import a few rows into a backup company file before loading months of transactions.
Frequently asked questions
These are the questions people ask most often about converting CSV, IIF, and QBO files for QuickBooks Desktop.