Turn a bank statement into a QuickBooks Desktop IIF file

IIF (Intuit Interchange Format) is a tab-delimited file format that Intuit created specifically for importing data into QuickBooks Desktop. It has been the standard bulk-import method for QuickBooks Pro, Premier, and Enterprise since the early versions, and it remains the fastest way to bring bank transactions, vendor lists, and chart-of-accounts data into your company file. Unlike CSV imports that require you to manually map columns through a wizard each time, an IIF file carries its own structure -- QuickBooks reads it natively with no additional configuration.

The reason IIF is preferred over CSV for QuickBooks Desktop comes down to how the format handles double-entry bookkeeping. Every transaction in an IIF file consists of a TRNS line (the main entry against your bank account) and a matching SPL line (the offset entry against an expense or income category). This mirrors exactly how QuickBooks records transactions internally, so the import creates clean, balanced journal entries. A CSV file, by contrast, only contains a single line per transaction with no account mapping -- QuickBooks has to guess where to post the offset, and you end up doing extra cleanup.

Our converter handles the column mapping automatically. When you upload a bank statement PDF, AI extracts every transaction and maps each one to the correct IIF fields: TRNSTYPE (CHECK for debits, DEPOSIT for credits), DATE, ACCNT (your bank account name), NAME (the payee), AMOUNT, and MEMO (the AI-assigned spending category). The SPL line is generated with the opposite amount and the category account name, creating a proper balanced entry for every row. No manual spreadsheet work required.

For businesses that process multiple months of statements at once -- quarterly reconciliation, year-end cleanup, or catching up on bookkeeping -- IIF is especially valuable. You can combine several months into a single file and import them all at once, and QuickBooks will post each transaction to the correct date. Just be aware that QuickBooks Desktop does not have automatic duplicate detection for IIF, so import each date range only once to keep your books clean.