CSV to IIF Converter for QuickBooks Desktop

Can you convert a CSV file to IIF?

Yes. An IIF file is plain tab separated text in a layout QuickBooks Desktop defines, so a converter that reads the CSV correctly can write one. Reading it correctly is the hard part. The tool has to find the header row (some banks put account details above it), decide which column is the posting date, turn a debit and credit pair into one signed amount, flip the signs on card exports where purchases come out positive, and skip pending rows and totals. BankXLSX does that on upload and shows you the parsed rows before you download anything.

Once the rows are right, the IIF itself is mechanical. Every transaction becomes a TRNS line on your bank or card account, a matching SPL line on the offsetting account, and an ENDTRNS line that closes the pair. The TRNS and SPL amounts cancel each other out, which is the balance check QuickBooks runs on import. If you want the field by field detail, the IIF headers, TRNS and SPL guide walks through it.

Why QuickBooks Desktop will not take your bank CSV

QuickBooks Desktop has no general import for bank register transactions from a CSV. Intuit staff say the same thing in the QuickBooks Community: in Desktop, bank data comes in through Web Connect as a .QBO file, or through an IIF file, and CSV or Excel transaction files need a third party tool. The Excel and CSV import wizards in Desktop cover lists such as customers, vendors, items and the chart of accounts. They do not post checks and deposits to a bank register.

That leaves a lot of people stuck. Plenty of banks and card issuers only offer CSV and PDF downloads, some dropped their QuickBooks file years ago, and the CSV download often stops at 90 days or 18 months. If you keep the books in QuickBooks Desktop Pro, Premier, Accountant or Enterprise, the CSV is the file you have and IIF is one of only two doors in.

IIF or QBO for QuickBooks Desktop, which should you download

BankXLSX writes both from the same upload on the Plus plan, so the choice is about how you want the transactions to land, not about the converter. The short version: QBO goes through the review screen and protects you from duplicates, IIF goes straight into the register.

If you are not sure, start with QBO for the current period and use IIF for history you are rebuilding, where clicking Add on every line in Bank Feeds would take hours. The QBO file format page covers the Web Connect route in more detail.

What the IIF file from BankXLSX contains

Nothing is hidden in the file, and you can open it in Notepad to check it before QuickBooks sees it. This is the exact layout the converter writes.

Two things to set up before the first import. First, the account name. QuickBooks posts to the account named on the TRNS line, and if no account with that name exists it can create a new one. Either rename your existing QuickBooks account to match, or open the IIF in a text editor and replace the account name on every TRNS line with the exact name you use. Second, the names. Payee text that does not match an existing name may be added to your lists, so import one month first and look at what was created before you load a year.

How to import an IIF file into QuickBooks Desktop

Back up the company file, then choose File, Utilities, Import, IIF Files, pick the file and let QuickBooks finish. When it reports the import is complete, open the register for that account and compare the ending balance with the statement for the same period. If the balance matches, run the next month. If it does not, the usual cause is an overlapping date range or a month imported twice, and since IIF has no duplicate check you fix that by deleting the extra entries, or by restoring the backup.

After the import, the offsetting lines sit in Uncategorized Income and Uncategorized Expenses. Most bookkeepers either reclassify them in batches (QuickBooks Accountant has a Reclassify Transactions tool in Client Data Review) or edit them in the register. If you would rather tag every row before it reaches QuickBooks, the transaction categorization tool on Plus labels rows during conversion so you can review the categories in Excel first.

CSV layouts the converter reads

Bank CSV files are less standard than people expect. These are the variations that break simpler converters and that BankXLSX handles on upload.

Files can be up to 15 MB and 20,000 transactions. If the bank gives you no CSV at all, or you need months the download no longer reaches, upload the PDF statement or a scan instead. The same IIF download comes out of a PDF bank statement to IIF conversion.

How BankXLSX compares with other CSV to IIF converters

The main desktop alternative is ProperSoft, whose ProperConvert app includes a CSV2IIF converter. It is a good tool, and in one area it does more than we do, so here is the honest picture. ProperSoft prices were read from its purchase page on 13 October 2026.

If your CSVs already carry a clean category column and you want each line posted to its own expense account in one shot, ProperConvert is cheaper and fits that job. BankXLSX makes more sense when the source is a mix of CSV exports and PDF statements, when several people in a firm need access, or when the same month also has to go out as QBO, Excel or a Quicken file. The ProperSoft alternative page has the longer comparison.

Who converts CSV to IIF

Mostly bookkeepers and accountants with clients who never left QuickBooks Desktop: contractors on Premier or Enterprise, nonprofits on older installs, firms doing catch up work for a client whose bank feed broke months ago. Intuit stopped selling new Pro Plus and Premier Plus subscriptions in the US in 2024, but existing company files and Enterprise keep running, and every one of those files still needs bank activity. When a client hands over twelve CSV downloads and a box of statements, IIF is the fastest way to get a year into the register. For that kind of rebuild, the catch up bookkeeping converter page lays out the whole workflow.