CSV to QuickBooks Desktop — IIF Converter

🥦

Convert Complete

QuickBooks Desktop IIF Format
valid rows

Import bank statements from CSV or Excel directly into QuickBooks Pro, Premier, or Enterprise. No API required.

Free preview — then from $5. Save with bundles.
Free preview before you pay
Files never leave your browser
No account needed to start

Download Sample CSV Template

Sample CSV file showing the required column format

Download Template

Tool Rating

4.7 / 5 (59 votes)

How to Convert Your File

1

Export from Banking

Log in → Reports → Export → Exported reports → Download CSV

2

Upload and Configure

Upload Bank CSV Transactions CSV and choose IIF File format

3

Preview and Download

Review converted data, download Quickbooks Desktop-ready file

4

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.

Common Conversion Questions

What columns does my CSV need?

At minimum, your file needs 'Date' and 'Amount' columns. Optional columns include 'Payee', 'Account', 'Memo', 'CheckNum', and 'Class'. Column names are case-insensitive.

Which QuickBooks Desktop versions are supported?

IIF import works with QuickBooks Pro, Premier, and Enterprise versions 2000-2025.

What transaction types can I create?

You can create CHECK, DEPOSIT, INVOICE, BILL, or CREDIT CARD transactions. Use 'Auto' to automatically classify based on amount sign.

Why Convert CSV/Excel to IIF?

Bank Statement Import

Many banks provide transaction downloads as CSV files. QuickBooks Desktop can't import CSV files directly for transactions—it requires IIF format for proper account assignments and balanced entries. This tool converts your bank's CSV export into a QuickBooks-ready IIF file.

Required Columns

Your CSV/Excel file needs these columns (case-insensitive): - Date (required): Transaction date - Amount (required): Negative for debits, positive for credits - Payee (optional): Vendor/customer name - Account (optional): Expense/income account - Memo (optional): Transaction description - CheckNum (optional): Check or reference number - Class (optional): QuickBooks class

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.

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

Accepts .csv, .xls, and .xlsx files.

Multiple Transaction Types

CHECK, DEPOSIT, INVOICE, BILL, or CREDIT CARD.

Flexible Column Detection

Auto-detects common column name variations.

Desktop Compatible

Works with QuickBooks Pro, Premier, and Enterprise.

Class Support

Optional QuickBooks class tracking.

Browser-Based Privacy

Files process locally. Your data never leaves your computer.

Data Transformation

Each CSV row becomes a TRNS/SPL/ENDTRNS block

Input CSV/Excel Row

One row per transaction

Key columns: Date, Amount, Payee, Account
1:N — One input row creates multiple output rows
Output IIF Transaction Block 3 rows per input

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

More credits - more savings

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

// PRICING //

Choose the plan that fits your needs

5,381 reviews, Excellent
Pay as you go

Just start processing on any tool page

$1/credit

Tools processing starts from 5 credits. Then 1 credit = 1k rows. No sign-up needed.

OR

Credit Bundles

$ /Credit

One-time purchase

  • No monthly commitment
  • Credits valid for one year
  • Access to all tools
  • Full file downloads
Best value

Monthly Bundles Pro

$ /Credit

Best for professionals and content creators

Annual Discount
Per month, billed annually:
Save 20% more
  • Credits refresh monthly
  • Priority processing

Purchase Credits

  • Full CSV & Excel export
  • Google Sheets export
  • Instant browser download
for credits

Visa Mastercard PayPal Apple Pay Google Pay
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle

Do unused credits expire?

One-time credit bundles are valid for one year. Subscription credits refresh monthly. You can use credits across any tool, anytime.

Is my data secure?

Files process entirely in your browser. We're GDPR compliant with TLS encryption.

Can I get a refund?

Yes! Full refund within 14 days if no credits used. Partial refund for unused credits anytime. Contact sup@spreadsheetbroccoli.com.

Powered by Paddle

Terms of service applies. VAT included where applicable.

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.
At minimum, your file needs 'Date' and 'Amount' columns. Optional columns include 'Payee', 'Account', 'Memo', 'CheckNum', and 'Class'. Column names are case-insensitive.
Use negative numbers for debits/payments and positive for credits/deposits. The Amount column can include currency symbols ($) and commas, which are automatically removed.
IIF import works with QuickBooks Pro, Premier, and Enterprise versions 2000-2025.
You can create CHECK, DEPOSIT, INVOICE, BILL, or CREDIT CARD transactions. Use 'Auto' to automatically classify based on amount sign.
Yes. The Bank Account and expense/income accounts you specify must already exist in your QuickBooks Chart of Accounts.
Yes! Select 'INVOICE' for sales transactions (A/R) or 'BILL' for expense transactions (A/P) in the Transaction Type dropdown.
Yes, QuickBooks Desktop supports both 3-column (Date, Description, Amount) and 4-column (Date, Description, Debit, Credit) CSV formats for importing transactions.
Common causes include incorrect date formatting, blank rows, mismatched column headers, special characters, or the file exceeding size limits. Ensure consistent formatting and remove any special characters.
Use a consistent date format like dd/mm/yyyy or mm/dd/yyyy throughout your CSV file. Inconsistent dates or include day-of-week names will cause import failures.
No, QuickBooks cannot automatically link invoices to payments during IIF import. You'll need to manually reconcile them after importing the data.