QuickBooks Desktop cluster

Convert CSV to IIF for QuickBooks Desktop batch import

Turn any bank CSV into a validated .iif file — with account mappings, splits and journal entries — that QuickBooks Desktop Pro, Premier and Enterprise import without errors.

Convert CSV to IIF — free See pricing

Step 1

Upload your CSV bank export or transaction log.

Step 2

(Optional) Map categories to your QuickBooks chart of accounts and set the target bank account.

Step 3

Download the .iif and import via File → Utilities → Import → IIF Files.

About CSV → IIF

IIF (Intuit Interchange Format) is QuickBooks Desktop's tab-delimited batch format. Unlike QBO, IIF supports full journal entries, splits and chart-of-accounts mappings — but its header validation is strict and one wrong tab breaks the whole file. Our converter parses your CSV, maps categories to your CoA, and emits an IIF with the exact !TRNS / !SPL / !ENDTRNS header structure QuickBooks Desktop expects.

Sample input & output templates

Download a small working example on both sides so you can match your source file's format before uploading — the #1 cause of failed conversions is a source file with the wrong column order or delimiter.

CSV · Input template

Sample CSV input

Date,Description,Debit,Credit,Balance
2026-01-02,Opening balance,,,10000.00
2026-01-03,UPI/PAYTM/Coffee shop,120.00,,9880.00
2026-01-05,NEFT-SALARY-ACME LTD,,75000.00,84880.00
2026-01-08,IMPS/Rent payment,25000.00,,59880.00
2026-01-15,POS/Amazon.in,1899.00,,57981.00

IIF · Expected output

Expected IIF output

!TRNS	TRNSID	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	MEMO
!SPL	SPLID	TRNSTYPE	DATE	ACCNT	AMOUNT	MEMO
!ENDTRNS
TRNS	1	GENERAL JOURNAL	01/05/2026	HDFC Current	Acme Ltd	75000.00	Salary Jan
SPL	2	GENERAL JOURNAL	01/05/2026	Salary Income	-75000.00	Salary Jan
ENDTRNS
TRNS	3	GENERAL JOURNAL	01/08/2026	HDFC Current	Landlord	-25000.00	Rent Jan
SPL	4	GENERAL JOURNAL	01/08/2026	Rent Expense	25000.00	Rent Jan
ENDTRNS

Try it now — mapping wizard

Upload a small CSV sample and walk through column mapping, validation and preview before downloading — everything runs locally in your browser.

Mapping wizard

Preview, map columns, validate, then download.

1. Upload your CSV file

All parsing runs in your browser. Nothing is uploaded.

Need a different output format?

Every CSV conversion can also be exported directly to CSV, Excel (.xlsx), QuickBooks (.qbo) or OFX from the upload screen.

Export to CSV Export to EXCEL Export to QBO Export to OFX All QuickBooks/Quicken formats →

Why bookkeepers pick BankToBooks

Every transaction validated — dates, amounts, running balance reconciled before export.
Zero setup: no templates, no bank IDs, no fees — upload CSV, download IIF.
OCR handles scanned inputs when the source is a PDF, not just structured files.
Free tier: 3 conversions per day, 200 transactions per file. Paid plans: unlimited.