Convert CSV to IIF
Import transactions into QuickBooks Desktop (IIF).
Drop CSV or Excel here
or click to browse
No Upload
Files stay on your device
Browser Processing
Everything runs locally
Zero Storage
These tools run entirely in your browser. Your sensitive data never leaves your device.
Why Use Our CSV to IIF Converter?
Private & Secure
Files never leave your device. Browser-based processing.
Easy Mapping
Interactive column mapper. Match 'Date', 'Amount', 'Payee' easily.
Instant Conversion
No uploads required. Generate IIF files in milliseconds.
Error Free
Auto-formats dates and numbers to prevent QuickBooks import errors.
Universal Support
Works with CSVs from any bank, PayPal, Stripe, or manual Excel sheets.
No Signup
No email or account needed. Completely free to use.
How to Convert CSV to IIF
Prepare Your CSV
Save your Excel file as CSV. Ensure it has headers like Date, Amount, Description.
Upload & Map
Upload the CSV. Use the dropdowns to match your CSV columns to IIF fields.
Download IIF
Click 'Convert'. We generate a properly formatted .iif file.
Import to QuickBooks
In QuickBooks, go to File > Utilities > Import > IIF Files.
Who Uses This CSV to IIF Converter?
Business Owners
Import bank transactions that don't support direct QuickBooks feeds.
Accountants
Bulk import client data from Excel statements into QuickBooks Desktop.
Payroll Managers
Import payroll data from third-party systems into QuickBooks registers.
Bookkeepers
Clean up historical data in Excel before importing to QuickBooks.
Best Free CSV to IIF Converter
Why choose Statement Extract?
| Feature | Statement Extract | Competitors |
|---|---|---|
| Price | Free forever | $19/mo or $50+ |
| Privacy | entirely browser-based | Cloud Upload (Risky) |
| Mapping | Visual Column Mapper | Strict Templates Only |
| Date Parsing | Auto-Detect Format | Must be exact |
| Speed | Instant | Queue times |
Why Use IIF Files?
While QuickBooks Desktop supports newer formats like QBO (Web Connect), the IIF (Intuit Interchange Format) remains a powerful "backdoor" to import data directly into your company file lists and registers.
It's the file format of choice when:
- You need to import historical data (older than 90 days).
- Your bank doesn't support QuickBooks Web Connect.
- You want to bulk import expenses from a spreadsheet where you've already done the coding.
- You are migrating data from another accounting system.
How It Works
Our tool acts as a bridge. It reads your unstructured CSV data, asks you to identify the key columns (Date, Amount, etc.), and then constructs the rigorous `!TRNS` and `!SPL` blocks that QuickBooks requires.
!TRNS // Transaction Header
DATE ACCNT NAME AMOUNT MEMO
01/15/2024 Checking Staples -45.20 Office Supplies
!SPL // Split Line (The other side of the entry)
DATE ACCNT NAME AMOUNT MEMO
01/15/2024 Office Expense 45.20
!ENDTRNS
Frequently Asked Questions
Do I need to backup my QuickBooks file?
YES. IIF imports write directly to your database and cannot be undone properly. Always create a backup of your company file before importing any IIF.
What Excel date formats are supported?
We support most common formats (MM/DD/YYYY, DD/MM/YYYY, YYYY-MM-DD). If you have issues, try standardizing the date column in Excel before uploading.
Does this work with QuickBooks Online?
No. QuickBooks Online (QBO) uses CSV or QBO files differently. This tool is specifically for QuickBooks Desktop (Pro, Premier, Enterprise) IIF imports.
Need to Extract Data from Bank Statements?
Convert PDF bank statements to Excel/CSV with AI-powered accuracy. Works with any bank format, extracts transactions, balances, and account details automatically.