What Bank export file format does this tool accept?

This tool accepts Bank CSV File files. Export from Bank and upload the File file directly.

Can I convert Bank CSV to QuickBooks Desktop?

Yes, this tool converts Bank CSV File exports directly to QuickBooks Desktop IIF format compatible with QuickBooks Desktop.

How do I import Bank csv to QuickBooks Desktop?

Export your csv from Bank, upload the CSV file to this converter, then import the converted file to QuickBooks Desktop.

CSV to IIF Converter — QuickBooks Desktop Import Tool

🥦

QuickBooks Desktop IIF Format

valid rows

Transform bank CSV files into IIF format for direct import into QuickBooks Pro, Premier, or Enterprise.

Free preview — then from $5. Save with bundles.

Free preview before you pay

Files never leave your browser

No account needed to start

Download CSV Template

Sample CSV showing required column format

CSV Template

Tool Rating

4.7 / 5 (78 votes)

How to Convert Your File

Export from Banking

Upload and Configure

Upload Bank CSV Transactions CSV and choose IIF File format

Preview and Download

Review converted data, download Quickbooks Desktop-ready file

Import to QuickBooks Desktop

File → Utilities → Import → IIF Files → Select File

Output is in QuickBooks Desktop IIF format — ready to import directly, no manual reformatting needed.

How People Use This

I download bank CSV files from three different client accounts each month and convert them to IIF for QuickBooks Desktop import. The auto-detection of CHECK and DEPOSIT types saves me from manually categorizing every line. What used to take an afternoon now takes minutes.

My bank only exports CSV but my accountant needs everything in QuickBooks Desktop. I converted my weekly bank CSV to IIF format and imported directly without any third-party software subscription. The balanced double-entry structure was exactly what QuickBooks expected.

We run QuickBooks Premier for job costing and needed to convert CSV bank statements to IIF with custom expense accounts per transaction. Adding an Account column to our CSV let us map each payment to the correct nominal code during conversion.

Several of my clients are on QuickBooks Enterprise and refuse to switch to Online. I converted their bank CSV exports to IIF format in bulk, specifying the correct bank account name for each client. The TRNS/SPL/ENDTRNS structure imports cleanly every time.

Our company credit card provider only gives us CSV downloads. I set the transaction type to CREDIT CARD and converted the entire statement to IIF for QuickBooks Desktop. The tool handled negative amounts for returns and positive amounts for charges without any manual edits.

During tax season I receive bank CSV files in every format imaginable. The flexible column detection recognizes different date and amount formats from various banks, and the csv to iif conversion handles them all consistently. I just specify the default expense account and go.

Common Conversion Questions

What QuickBooks Desktop versions support IIF?

IIF import works with QuickBooks Pro, Premier, and Enterprise versions from 2000-2025. All editions support this format.

Do my QuickBooks accounts need to exist first?

Yes! The bank account and any expense/income accounts you specify must already exist in your QuickBooks Chart of Accounts. Create them first if needed.

How should amounts be formatted in my CSV?

Use negative numbers for payments/debits (like -50.00) and positive for deposits/credits (like 100.00). Currency symbols ($) and commas are automatically removed.

Why Convert CSV to IIF Format?

QuickBooks Desktop Can't Import CSV

QuickBooks Desktop cannot import CSV for bank transactions. It requires IIF (Intuit Interchange Format) - a tab-delimited format with balanced double-entry accounting structure. Without conversion, you'd manually enter transactions or pay $139-169 for third-party software. This converter does it instantly in your browser with proper IIF structure (TRNS/SPL/ENDTRNS).

Required CSV Columns

Your CSV needs (case-insensitive, tool auto-detects): - Date: Transaction date - Amount: Transaction amount (negative=payment, positive=deposit) Optional columns: - Payee or Description: Transaction description - Account: Expense/income account (uses defaults if missing) - Memo: Additional notes - CheckNum: Check or reference number

Your Conversion is Secure

Browser-Only Processing

All conversion runs in your browser. Files are never uploaded to any server.

No Data Retention

Nothing is stored after conversion. Close the tab and your data is gone.

GDPR Compliant

Full EU data protection compliance. Your privacy rights are fully protected.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Field Mapping

How Banking Csv fields map to Quickbooks Desktop Iif

Banking Csv	Source Value		Quickbooks Desktop Iif	Target Value	Note
`Date`	`01/15/2025`	→	`DATE`	`01/15/2025`	Transaction date
`Amount`	`-50.00`	→	`AMOUNT`	`-50.00`	Transaction amount (negative=debit, positive=credit)
`Payee`	`AMAZON PURCHASE`	→	`NAME`	`AMAZON PURCHASE`	Payee or vendor name
`Account`	`Checking`	→	`ACCNT`	`Checking`	Expense/income account for split line
`Memo`	`AMAZON PURCHASE`	→	`MEMO`	`AMAZON PURCHASE`	Transaction memo or description
`CheckNum`	`REF123456`	→	`DOCNUM`	`REF123456`	Check number or reference
`Class`	`Sales`	→	`CLASS`	`Sales`	QuickBooks class for tracking

Why Use This Converter?

CSV & Excel Support

Converts .csv, .xls, and .xlsx files to IIF format.

Multiple Transaction Types

Support for CHECK, DEPOSIT, and CREDIT CARD transactions.

Flexible Column Detection

Recognizes various column name conventions from different banks.

Automatic Balancing

Creates properly balanced double-entry transactions automatically.

Account Customization

Specify bank account and default income/expense accounts.

Browser-Based Privacy

Files convert locally. Your data never leaves your computer.

Data Transformation

Each CSV row becomes a TRNS/SPL/ENDTRNS block

One row per transaction

Key columns: Date, Amount, Payee, Account

1:N — One input row creates multiple output rows

Hierarchical structure for QuickBooks Desktop import

Common IIF File Import Errors

Issues you might encounter when importing Bank CSV Transactions data to IIF File - and how we solve them

Missing Date Column

CSV/Excel file must have a 'Date' column

File has 'Transaction Date' instead of 'Date'

Rename column to 'Date' (case-insensitive)

Ensure your file has Date, Amount columns (required)

Download our sample template for correct format

Missing Amount Column

CSV/Excel file must have an 'Amount' column

File has 'Debit' and 'Credit' columns

Combine into single 'Amount' column (negative for debits)

Use negative values for payments, positive for deposits

Edit your spreadsheet before uploading

Account Not Found

QuickBooks can't find the specified account name

Account 'Bank Account' not in Chart of Accounts

Create the account first or use exact name

Verify account names match your Chart of Accounts exactly

Edit account names in the tool options before converting

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.

No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.

IIF import works with QuickBooks Pro, Premier, and Enterprise versions from 2000-2025. All editions support this format.

Yes! The bank account and any expense/income accounts you specify must already exist in your QuickBooks Chart of Accounts. Create them first if needed.

The tool automatically combines them into a single signed amount (positive for credits, negative for debits). You don't need to reformat.

Use negative numbers for payments/debits (like -50.00) and positive for deposits/credits (like 100.00). Currency symbols ($) and commas are automatically removed.

Yes! Add an 'Account' column to your CSV with the QuickBooks account name for each transaction. If missing, the default expense/income account is used.

The tool accepts many date formats: MM/DD/YYYY, DD/MM/YYYY, YYYY-MM-DD, and more. All dates are converted to MM/DD/YYYY for IIF.

This tool is optimized for bank transactions (CHECK, DEPOSIT). For invoices or bills, you'd need specialized IIF structure. Consider using QuickBooks' native invoice/bill entry.

Open the IIF file in Notepad or Excel. You'll see tab-delimited rows starting with !TRNS, TRNS, !SPL, SPL, and ENDTRNS. Check that amounts balance and dates are correct.

IIF (Intuit Interchange Format) is a proprietary text file format used by QuickBooks to import and export financial data like transactions, accounts, and customer information.

No, IIF files are not meant to be edited manually. Convert to CSV format if you need to make changes, then re-convert to IIF.