Bank Statement PDF to IIF for QuickBooks Desktop

IIF is QuickBooks Desktop’s own tab-delimited import format — the way to push a whole statement’s transactions in at once. This turns your bank or credit card PDF into a valid .iif Desktop will accept, scanned or digital.

No signup to tryQuickBooks DesktopBulk importFree to start

Click to upload or drag and drop

Supported formats:

PDF

PNG

JPEG

TIFF

Up to 25MB · PDF → IIF

Secure & Encrypted Conversion

All uploads are encrypted for your security

Trouble converting a file? Tell us — we fix issues fast. Report it

How it works

How to convert a bank statement PDF to IIF

Upload the statement

Add a bank or credit card PDF — exported from online banking or scanned from paper. Runs in the browser.

AI reads each transaction

Every line — date, payee, amount — is pulled out and written into the !TRNS / SPL structure QuickBooks Desktop expects.

Download a .iif

A tab-delimited Intuit Interchange file, ready to bring into Desktop through File → Utilities → Import.

The output

What a .iif file looks like

IIF is tab-delimited, not a spreadsheet — each transaction is a TRNS / SPL pair closed by ENDTRNS, with the headers QuickBooks Desktop needs. Toggle from the raw statement to the file.

statement.iif

Messy PDFClean .iif

!TRNS	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT
!SPL	TRNSTYPE	DATE	ACCNT	AMOUNT
!ENDTRNS
TRNS	DEPOSIT	03/07/2024	Checking	Square Payout	2150.00
SPL	DEPOSIT	03/07/2024	Uncategorized Income	-2150.00
ENDTRNS
TRNS	CHECK	03/10/2024	Checking	Home Depot	-318.40
SPL	CHECK	03/10/2024	Uncategorized Expense	318.40
ENDTRNS

Why IIF

What the IIF format does for QuickBooks Desktop

It's the format Desktop trusts for a file-based batch import — when you want transactions in without a live feed.

Made for QuickBooks Desktop

IIF is Intuit's own desktop format — the way Desktop takes a batch of transactions from a file.

Correct tab-delimited structure

Proper !TRNS / SPL / ENDTRNS rows and headers — not a plain CSV that Desktop's IIF importer will reject.

Bulk import in one pass

Bring a whole statement's worth of transactions in at once instead of typing them into the register.

When Web Connect isn't an option

A reliable route into Desktop on setups where the QBO bank-feed import isn't available to you.

Reads scans too

A photographed or scanned statement is OCR'd before extraction, so image-only PDFs still produce a usable .iif.

Dates & amounts Desktop accepts

Dates in the format Desktop expects and amounts signed correctly, so the import doesn't stall on a bad field.

Set up before you import

Two things save headaches. First, create the account first — the bank or credit-card account in the .iif must already exist in your Chart of Accounts, or QuickBooks will quietly make a new one. Second, back up your company file(or import into a test copy): IIF doesn’t check for duplicates and an import can’t be undone in bulk, so bring in one clean range at a time.

IIF or QBO for QuickBooks Desktop?

A QBO file is the bank-feed-style import that matches transactions for you; IIFis a direct, controlled bulk import. On Desktop setups where the Web Connect import isn’t available, IIF is the dependable way to get a batch of statement transactions in.

Importing

Import the .iif into QuickBooks Desktop

One menu path — just back up first.

QuickBooks Desktop

File → Utilities → Import → IIF Files → choose the .iif; the 2019+ importer reviews it and flags any rows to fix before posting.

First time?

Restore a backup to a temporary copy and import there once to confirm the accounts map correctly, then repeat on your live file.

Private by default. Uploads are encrypted, the .iif is built only from the transactions we extract, and the file isn’t kept once you’ve downloaded it — no account needed to try one.

Any bank

A .iif from any bank's statement

Reading each statement's own layout rather than a fixed template means any institution — US or international, checking or credit — converts to a valid IIF.

ChaseBank of AmericaWells FargoCitiCapital OneUS BankPNCHSBCBarclaysNatWestLloydsRBCTD BankHDFCICICISBIAxis BankANZCommonwealth BankDBS+ any bank worldwide

IIF FAQ

Converting to IIF — common questions

QHow do I import the .iif into QuickBooks Desktop?

In QuickBooks Desktop, go to File → Utilities → Import → IIF Files, select the .iif, and let the newer importer review and post it. Always run it against a backup or a test copy of your company file first.

QIIF or QBO — which should I use for QuickBooks Desktop?

QBO (Web Connect) is the bank-feed-style import that matches transactions; IIF is a direct bulk import you control. Where Web Connect import isn't available to your Desktop setup, IIF is the dependable way to get a batch of transactions in.

QDoes the account need to exist in QuickBooks first?

Yes — create the bank or credit-card account in your Chart of Accounts before importing. If the account name in the .iif doesn't match, QuickBooks will create a brand-new account instead of posting to the right one.

QWill re-importing the same file duplicate transactions?

Yes. IIF doesn't check for duplicates, so importing the same file twice posts everything again. Import one clean range, and back up the company file beforehand — an IIF import can't be rolled back in bulk.

QDoes IIF work with QuickBooks Online?

No — IIF is a QuickBooks Desktop format. For QuickBooks Online, use a QBO file or a CSV import instead.

QWhy do IIF imports usually fail?

Almost always formatting — wrong delimiter, missing headers, odd encoding or stray characters. This export is written as proper tab-delimited IIF with the headers QuickBooks expects, which avoids the 'list or transaction not supported' error.

QCan I convert a scanned bank statement to IIF?

Yes — scans and phone photos are OCR'd first, then written to .iif, so image-only statements convert fine.

QCan I convert a multi-currency statement?

Single-currency statements from any country convert cleanly; for a mixed-currency statement, convert one currency at a time so the amounts post correctly.

QWhich banks can I convert?

Any bank, anywhere — extraction reads each statement's own layout rather than a fixed template, so even non-English formats produce a valid .iif.

QDoes it cost anything, and is my upload secure?

You can convert on the free tier without an account; uploads are encrypted, the .iif is built only from the extracted transactions, and the file isn't kept past the job. Locked PDFs prompt for the password to open them.

QHow accurate is the extraction?

Strong on digital and scanned statements, though no converter is perfect on every layout — check the transaction count and tie to the closing balance before you import.

Keep going