How to make an IIF file from a bank statement
Turn statement rows into a QuickBooks Desktop IIF import of checks and deposits.
- 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
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
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
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.
- Prefer QBO when you want a bank-statement import that Desktop can match to a register. Use IIF when you specifically need that import path.
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.