Skip to the converter
StatementZap

Guides

How to make an IIF file from a bank statement

Turn statement rows into a QuickBooks Desktop IIF import of checks and deposits.

  1. 1

    Know what IIF imports

    IIF is a Desktop import of transactions, not a Web Connect statement. Each row becomes a check or a deposit with one offset line. It does not carry the OFX fit id that Web Connect uses to skip duplicates.

  2. 2

    Read the statement

    Upload the CSV, Excel file, or text PDF. Money out becomes a CHECK offset to Uncategorized Expense. Money in becomes a DEPOSIT offset to Uncategorized Income. The two lines of each transaction sum to zero.

  3. 3

    Download IIF

    The file is tab-separated, uses Windows line endings, and dates are M/D/YYYY. The header rows are !TRNS, !SPL, and !ENDTRNS.

  4. 4

    Import it

    In QuickBooks Desktop choose File, then Utilities, then Import, then IIF Files. Post into the account you intended. After the import, replace Uncategorized Expense and Uncategorized Income with the accounts you actually use.

Questions

Will IIF skip rows I already imported?

No. Unlike Web Connect, this IIF file has no fit id. Importing it twice adds the transactions twice.