IIF to CSV Converter

IIF is tab-delimited and looks like it should open in a spreadsheet, and then does not — because it interleaves several kinds of row, each with its own set of columns declared above it. This reads that structure properly and gives you one clean table.

QuickBooks Desktop's own format, opened as a spreadsheet.

The "!" lines read as the definitions they are

An IIF declares its columns inline, and the order differs between files. Mapping by name rather than by position is why a file from one QuickBooks version does not come out scrambled.

Transactions and splits not double-counted

The bank side and the category side of a transaction are the same money with opposite signs. Adding both would double every figure in the file.

Your columns kept

Class, document number and memo come across rather than being dropped for not fitting a simpler shape.

Related guides

• OFX, QFX, QBO and QIF: Which Format Does Your Software Want?
• Why QuickBooks Rejects Your QBO File
• Why Your QIF Import Lands a Month Out
• How to Convert a CSV to QBO for QuickBooks
• Bank Feeds vs Statement Conversion: When You Need Each
• Bank Statement Converter vs Manual Data Entry: A Real Comparison
• Why Your Converted Bank Statement Doesn't Balance
• The Bank Statement Date Format Problem (DD/MM vs MM/DD)