CSV to IIFconverter

Upload your bank statement PDF and download an IIF file ready to import into QuickBooks Desktop — Pro, Premier, or Enterprise.

Instant IIF downloadQuickBooks DesktopAny bank worldwide

📄

Drop your CSV file here

or click to browse · .csv files only · 100% private

No data leaves your browser — conversion happens 100% client-side

See the difference

From CSV to clean IIF

Before

Date,Description,Amount
01/15/2025,WHOLEFDS MKT #10247,-67.42
01/15/2025,STARBUCKS #8291,-4.75
01/14/2025,ZELLE TO LANDLORD,-1850.00
01/14/2025,PAYROLL - ACME CORP,2847.63

transactions.csv

After

!TRNS	TRNSID	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	MEMO
!SPL	SPLID	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	MEMO
!ENDTRNS
TRNS		CHECK	01/15/2025	Checking	WHOLEFDS MKT #10247	-67.42	Groceries
SPL		CHECK	01/15/2025	Groceries	WHOLEFDS MKT #10247	67.42	Groceries
ENDTRNS
TRNS		CHECK	01/15/2025	Checking	STARBUCKS #8291	-4.75	Dining Out
SPL		CHECK	01/15/2025	Dining Out	STARBUCKS #8291	4.75	Dining Out
ENDTRNS
TRNS		DEPOSIT	01/14/2025	Checking	PAYROLL - ACME CORP	2847.63	Income
SPL		DEPOSIT	01/14/2025	Income	PAYROLL - ACME CORP	-2847.63	Income
ENDTRNS

transactions.iif

Works withChaseBank of AmericaWells FargoCitibankCapital OnePNCUS BankTD BankBarclaysHSBC& 10,000+ more

How it works

Three steps to a clean IIF file

Step 1

Upload your bank statement

Drag and drop your bank statement PDF — downloaded from your bank or scanned from paper. JPG and PNG images work too.

Step 2

AI extracts every transaction

Our AI reads each transaction and structures it: date, payee, amount, and spending category — ready for IIF formatting.

Step 3

Download IIF & import

Download the .iif file and import it into QuickBooks Desktop via File > Utilities > Import > IIF Files.

1.Upload your bank statement

Drag and drop your bank statement PDF — downloaded from your bank or scanned from paper. JPG and PNG images work too.

2.AI extracts every transaction

Our AI reads each transaction and structures it: date, payee, amount, and spending category — ready for IIF formatting.

3.Download IIF & import

Download the .iif file and import it into QuickBooks Desktop via File > Utilities > Import > IIF Files.

Why IIF

CSV vs IIF for QuickBooks Desktop

Feature	CSV	IIF
QuickBooks Desktop import	Requires column mapping each time	Native — one-click import
Double-entry format	Single line per transaction	TRNS + SPL lines — proper double-entry
Account mapping	Must map manually	Account names built into file
Vendor names	Plain text column	NAME field — auto-matches QB vendors
Batch import speed	Slow with large files	Fast — QuickBooks native format
Category / account split	Not supported	SPL line assigns category account

Preview

What the IIF export looks like

A tab-delimited .iif file that QuickBooks Desktop imports natively via File > Utilities > Import.

transactions.iif

!TRNS	TRNSID	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	MEMO
!SPL	SPLID	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	MEMO
!ENDTRNS
TRNS		CHECK	01/15/2025	Checking	WHOLEFDS MKT #10247	-67.42	Groceries
SPL		CHECK	01/15/2025	Groceries	WHOLEFDS MKT #10247	67.42	Groceries
ENDTRNS
TRNS		CHECK	01/15/2025	Checking	STARBUCKS #8291	-4.75	Dining Out
SPL		CHECK	01/15/2025	Dining Out	STARBUCKS #8291	4.75	Dining Out
ENDTRNS
TRNS		DEPOSIT	01/14/2025	Checking	PAYROLL - ACME CORP	2847.63	Income
SPL		DEPOSIT	01/14/2025	Income	PAYROLL - ACME CORP	-2847.63	Income
ENDTRNS

Each transaction has a TRNS line (the bank side) and a SPL line (the category/offset side), creating a proper double-entry record. The header lines starting with ! define the column structure.

IIF field reference

IIF Field

Example

Notes

TRNSTYPE

CHECK

Transaction type. CHECK for expenses/withdrawals, DEPOSIT for income. QuickBooks uses this to determine the register entry type.

DATE

01/15/2025

Transaction date in MM/DD/YYYY format — the standard date format for QuickBooks Desktop IIF imports.

ACCNT

Checking

Account name in QuickBooks. Uses 'Checking' by default. You can remap during import to match your Chart of Accounts.

NAME

WHOLEFDS MKT #10247

Vendor or payee name as it appears on your statement. QuickBooks matches this to existing vendors automatically.

AMOUNT

-67.42

Transaction amount. Negative for expenses, positive for deposits. The SPL (split) line carries the opposite sign to balance the entry.

MEMO

Groceries

AI-assigned spending category. Appears in the Memo field in QuickBooks so you can filter and report by category.

Pricing

Simple, transparent pricing

Free

Try it out

3 PDF pages / month
AI transaction categorization
Sankey money-flow chart
AI insights & savings tips
Financial health score
Spending calendar
CSV export

Start Free

CSV to IIF converter FAQ

What is an IIF file?+−

IIF (Intuit Interchange Format) is a tab-delimited text file format created by Intuit for importing data into QuickBooks Desktop. Each transaction has a TRNS line (the main entry) and a SPL line (the split/offset entry), creating a proper double-entry bookkeeping record. IIF has been the standard QuickBooks Desktop import format since the 1990s.

Is this converter really free?+−

Yes. You can convert up to 3 pages per month completely free — no account required, no credit card. Most single-month bank statements fit in 1-3 pages. For longer statements or bulk processing, paid plans start at $9/month.

Does this work with QuickBooks Online?+−

No — QuickBooks Online does not support IIF imports. IIF is exclusively for QuickBooks Desktop (Pro, Premier, Enterprise). For QuickBooks Online, use our CSV or QBO export instead.

Which banks are supported?+−

Any bank worldwide that provides PDF statements — Chase, Bank of America, Wells Fargo, Barclays, HSBC, HDFC Bank, and thousands more. Scanned paper statements and photographed statements work too.

Do I need to create accounts in QuickBooks first?+−

No. When importing an IIF file, QuickBooks will automatically create any accounts referenced in the file that don't already exist. The default account is 'Checking' for the bank side, and category names (Groceries, Dining Out, etc.) for the split side.

Will duplicate transactions be created if I import the same period twice?+−

Yes — QuickBooks Desktop does not have automatic duplicate detection for IIF imports. Only import each date range once, or delete the duplicate entries manually after import.

How do I import an IIF file into QuickBooks Desktop?+−

Open QuickBooks Desktop, go to File > Utilities > Import > IIF Files, select your .iif file, and click Open. QuickBooks will import all transactions and create any new accounts automatically. Review the imported transactions in your bank register.

Is my bank statement data kept private?+−

Your PDF is processed in memory and immediately discarded — never stored on disk, never shared. Only the structured transaction data is saved temporarily to generate your download.

Convert your CSV to IIF — free

No account required. Get a clean IIF file ready for QuickBooks Desktop in under 30 seconds.

Upload & Convert to IIF