IIF Format

CSV to IIF Converter Free Online - (QuickBooks Desktop)

QuickBooks Desktop has no CSV import. It never has, and Intuit's answer has never changed: convert the file first. So convert CSV to IIF here, free, and import CSV bank transactions to QuickBooks Desktop without retyping a row. What you get back is built to survive the import rather than merely be valid — accounts declared before anything references them, and every entry written as a balanced pair.

Bank-grade security - Files processed securely and deleted immediately
Trouble converting a file? Tell us — we fix issues fast. Report it

Not the file you need?

On QuickBooks Online?
Online can't read IIF — make a .qbo instead
On Tally instead?
Same CSV, written as Tally XML vouchers
Only have a PDF?
Skip the CSV step entirely

Why Use Our CSV to IIF Converter Tool?

Accounts are declared before they're used

Error 11110 — "The Account Name on a distribution does not exist" — is the most reported IIF failure, and it fires when the file names an account your chart of accounts has never heard of. Every account here is declared in an !ACCNT block before anything references it, and only the ones actually used.

Every entry balances, by construction

IIF is double-entry: every TRNS line needs an SPL line for the exact negative amount, or QuickBooks refuses the batch with "Transaction Amounts Are Out of Balance". Written as matched pairs here — which is precisely where hand-built and spreadsheet-built files come apart.

Nothing to download, nothing to install

The established alternatives are Windows programs — ProperSoft's CSV2IIF, the free converter passed around the GRC forums, and a scattering of IIF file converter utilities. This is a CSV to IIF converter online: it runs in the browser on any machine, including a Mac, with no signup and no trial wall on the number of transactions.

How to convert CSV to IIF in three steps

1

Start with your bank's CSV

Exported from your bank's portal, a card issuer, a payment processor or a spreadsheet. A header row is optional, and quoted fields containing commas parse fine.

2

Upload the CSV

Use the box above, up to 10MB. Columns are found in the data rather than asked for, whatever order and header names your bank happens to use.

3

Set the type and date order, download

A CSV states neither, so choose bank or credit card and your date order. Then download the .iif and import it in QuickBooks Desktop.

Why QuickBooks Desktop rejects most IIF files

You cannot import CSV into QuickBooks Desktop at all

It is not a formatting problem — the option does not exist. Desktop reads IIF and Web Connect files and nothing else, so every route to import CSV transactions into QuickBooks Desktop begins the same way: convert CSV to QuickBooks Desktop format first, which in practice means IIF. QuickBooks Online is the opposite case — it accepts CSV but cannot read IIF.

Error 11110 stops the whole import

"The Account Name on a distribution does not exist in QuickBooks." Name matching is unforgiving — case-sensitive, punctuation-sensitive and whitespace-sensitive, so "Meals & Entertainment" and "Meals and Entertainment" are different accounts, and a sub-account needs its full Parent:Child path. One mismatch rejects the batch.

QuickBooks 2019 quietly broke IIF import

The rewritten importer tries to correct things it thinks are wrong. Reconciled status is dropped and everything arrives uncleared, semicolons truncate the rest of the line, non-ASCII names come through as question marks, document numbers are cut at twelve characters, and the whole import runs ten to twenty times slower.

Dates are read by the computer, not the file

An IIF file does not declare its own date order. QuickBooks interprets it using the regional settings of whichever machine imports it, so a file written month-first and imported on a day-first install turns 03/04 into 4 March without warning or error.

Who ends up needing an IIF file

QuickBooks Desktop users

There is no CSV upload in QuickBooks Desktop and there never has been. IIF and Web Connect are the only two import routes, and IIF is the one that takes a plain transaction list.

Desktop 2023 after 31 May 2026

Bank feeds stopped on that date when Intuit ended support. The software still opens and the data is intact, but transactions now have to be imported by hand — this is that route.

Banks that only export CSV

Credit unions, neobanks and business accounts have quietly dropped OFX and QFX downloads. CSV is all they ship, and QuickBooks Desktop cannot read a byte of it.

Credit card statements

A card statement needs CREDIT CARD and CCARD REFUND lines, not CHECK and DEPOSIT. Set the account type before downloading and the right transaction types are written for you.

Bookkeepers with mixed clients

Chart of accounts names differ from client to client, and IIF matches them exactly or not at all. Convert per client and rename the declared accounts once, rather than hand-editing every batch.

Anyone outside the US

QuickBooks reads IIF dates using the importing computer's regional settings, not the file. Choose day-first and 03/04 stays 3 April instead of becoming 4 March.

Frequently Asked Questions — CSV to IIF Converter

QHow do I import a CSV file into QuickBooks Desktop?

Convert the CSV to an IIF file first, then go to File → Utilities → Import → IIF Files and select it. That is the entire route to import CSV to QuickBooks Desktop; there is no way to upload CSV to QuickBooks Desktop directly, because the menu option has never existed — which is the reason a CSV to IIF converter is needed at all.

QCan you import CSV into QuickBooks Desktop without converting it?

No. Desktop accepts IIF files and Web Connect (.qbo) files only. Intuit's own community answer to this question is to convert the file to IIF or QBO first, and that has not changed in the years the thread has been running.

QWhat is the best CSV to IIF converter?

It depends on whether you need it once or every week. ProperSoft's CSV2IIF and the IIF Transaction Creator tools are paid Windows programs built for repeat work with saved mappings; Somacon's free page is a bare textarea that handles deposits and checks and states plainly that no support is provided. For a few statements a month, a free CSV to IIF converter online does the same job without an install.

QDoes IIF work with QuickBooks Online?

No. IIF is a QuickBooks Desktop format only — Pro, Premier, Enterprise and Mac. QuickBooks Online cannot read it at all and instead accepts CSV, or QBO, QFX and OFX files. If you are on Online, use the CSV to QBO converter instead.

QWhy do I get error 11110, "The Account Name on a distribution does not exist"?

Because the IIF file names an account your chart of accounts does not contain, and QuickBooks will not create it on the fly. This file declares each account it uses in an !ACCNT block before any transaction refers to it, which is what prevents the error. If you would rather post into accounts you already have, rename them in the file before importing.

QWhat does "Transaction Amounts Are Out of Balance" mean?

IIF is a double-entry format, so every TRNS line needs a matching SPL line carrying the exact opposite amount. If the two sides do not sum to zero, QuickBooks rejects the transaction. Files written here are always generated as matched pairs, so the batch balances.

QShould I use "Import without review" in QuickBooks 2019 and later?

Often yes, despite Intuit not recommending it. The importer introduced in 2019 rewrites data it believes is wrong and silently drops fields, so many users find the older path — the "Import it for me, I'll fix it later" link — imports valid files that the new button refuses. Import into a test company file first either way.

QWhat is an IIF file?

Intuit Interchange Format: a plain tab-separated text file that QuickBooks Desktop reads directly. Open an IIF file example in a text editor and you will see rows that begin with a keyword — !ACCNT declares accounts, !TRNS and !SPL define the transaction columns. Because the IIF file QuickBooks Desktop expects is tab-separated, a stray tab inside a description shifts every later column into the wrong field; those are stripped when your file is written.

QMy dates imported the wrong way round — how do I fix it?

Re-convert with the other date order and import again. The IIF file format carries no date-order declaration, so QuickBooks falls back to the regional settings of the importing PC, which is why the same file behaves differently on a US and a UK machine.

QDoes this work for credit card statements as well as bank accounts?

Yes, and the distinction matters. A bank account produces CHECK and DEPOSIT lines while a credit card produces CREDIT CARD and CCARD REFUND lines, and QuickBooks treats them differently. Choose the account type before downloading and the correct transaction types are written.

QIs there a CSV to IIF converter free download for Windows?

Several, and that is rather the problem: a search for a CSV to IIF converter free download leads almost entirely to Windows executables, so Mac users are stuck before they start. This is a CSV to IIF converter online free of any install or signup, which makes the operating system irrelevant.

QCan I convert Excel to IIF as well?

Not on this page yet — a dedicated Excel to IIF converter is coming. For now, save the workbook as CSV from Excel — File → Save As → CSV UTF-8 — and convert that here. The result is identical, because the conversion reads the rows rather than the file wrapper.

QWhere is the IIF file actually created?

In your browser. The CSV is parsed there and the .iif is written there, so the finished file never touches a server. Only the rows go out for column detection, and nothing is kept once the conversion finishes.

Other Conversion Formats

PDF to QIF Converter

Convert to QIF

CSV to QIF Converter

Convert to QIF

CSV to QBO Converter

Convert to QBO

CSV to OFX Converter

Convert to OFX

CSV to QFX Converter

Convert to QFX

CSV to Tally XML Converter

Convert to Tally XML

Convert CSV to IIF and import it without the error screen

Your bank sends CSV. QuickBooks Desktop reads IIF. Convert CSV to IIF file format here in about ten seconds, then import it through File → Utilities → Import → IIF Files and pick your account. Free to get started, no signup, and nothing to install.