CSV to IIF Converter

Turn a CSV into an Intuit Interchange Format file for QuickBooks Desktop. IIF is tab-delimited, which means a tab inside one of your descriptions silently shifts every field after it along by one — so those are stripped before they can do it.

QuickBooks Desktop has no CSV import for transactions. IIF is what it takes.

Columns defined by name, not position

An IIF names its own columns on a line beginning "!", and the order varies between files. Both sides of this read that line rather than counting across, which is why a file from one QuickBooks version does not scramble in another.

Tabs and line breaks taken out of your text

They are structural in IIF. A payee containing one corrupts the row, and the corruption is silent — the memo ends up imported as the amount.

The account is left for you to name

QuickBooks posts the other side of each transaction somewhere, and your CSV does not say where. The file marks it clearly unset instead of picking a plausible-looking expense account on your behalf.

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)