Loading converter...
Loading converter...
A step-by-step guide to converting your bank statement CSV files into IIF format for QuickBooks® Desktop.
Most banks allow you to download your transaction history as a CSV (Comma Separated Values) file. Here's how to get it from popular banks:
Log in → Accounts → Download Account Activity → Choose CSV format
Log in → Accounts → Download → Select CSV
Log in → Account Activity → Download → Spreadsheet (CSV)
Log in → Account Details → Download Transactions → CSV
Tip: Select a date range that matches your accounting period. Most banks allow exports of up to 2 years of transactions.
Our converter needs to know which columns in your CSV correspond to the required IIF fields. Here are the essential mappings:
| IIF Field | Required? | Common CSV Headers |
|---|---|---|
| Date | Yes | Date, Transaction Date, Posting Date |
| Amount | Yes | Amount, Debit, Credit, Transaction Amount |
| Description | Yes | Description, Memo, Details, Narrative |
| Check Number | No | Check #, Check Number, Reference |
Drag and drop your CSV file or click to browse. Our tool automatically detects most bank formats.
Review the auto-detected mappings. Adjust if needed by selecting the correct column from the dropdown.
Review your transactions, skip any you don't want to import, and assign specific accounts if needed.
Set your default bank account name and expense account as they appear in QuickBooks®.
Click download to get your IIF file. It's ready to import into QuickBooks® Desktop!
Before generating your IIF file, you'll need to configure a few settings:
Enter the exact name of your bank account as it appears in your QuickBooks® Chart of Accounts. For example: "Chase Checking" or "Business Checking".
This is where expenses will be categorized if not assigned individually. Common choices: "Expense", "Uncategorized Expense", or "Ask My Accountant".
Choose "General Journal Entry" for maximum flexibility, or select specific types like "Check" or "Deposit" if your transactions are all of one type.
Ensure dates are in MM/DD/YYYY format. Our tool attempts to parse various formats automatically.
Each IIF transaction must have equal debits and credits. Check that amounts are correctly assigned.
QuickBooks® will create new accounts if they don't exist. Use exact account names to avoid duplicates.
Some special characters may cause issues. Our tool automatically sanitizes text for compatibility.
Try our free converter tool now. Just create a quick free account to get started.
Start Converting Free