Reviewed · Scope and editorial method
A transaction group is more than one table row
Header records identify the columns used by the following records. TRNS carries the main transaction fields; SPL records carry split details. ENDTRNS ends the group. Tabs matter: visually lining columns up with spaces is not the same file structure.
IIF can carry lists or transaction types beyond the subset handled by this converter. FinanceConvert maps TRNS groups into transaction summaries; an arbitrary IIF export must not be treated as a universal bank statement.
What CSV and Excel outputs preserve
Each TRNS group becomes one transaction. The reader derives its date and signed amount from the group and combines transaction/name/account context into descriptive text. Available SPL information is summarized in Memo.
Those summaries are useful for inspection but are not a lossless representation of the original journal. A spreadsheet row does not recreate all debit/credit legs, lists, company preferences or reconciliation state. Keep the IIF and original accounting backup.
Generated IIF uses paired entries
The writer creates TRNS/SPL pairs with opposite amounts and configurable bank, expense and income account names. A debit becomes a CHECK-style pair and a credit a DEPOSIT-style pair in this implementation.
These defaults are not a classification engine. A statement description cannot establish the correct account, tax treatment or transaction type for your company. Review names and classifications independently, even when the two amounts balance.
Test the accounting destination separately
Intuit documents IIF as a Desktop import/export format and provides sample headers. Consult the appropriate product guidance rather than assuming the same workflow applies to QuickBooks Online.
Take a company backup and test in a copy before importing generated accounting entries. A successful conversion test verifies the writer's structure and values; it is not a certification of an import into your company's actual configuration.
A synthetic source example
!TRNS DATE NAME ACCNT AMOUNT TRNS 01/15/2026 Office supplies Checking -45.00 ENDTRNS TRNS 01/16/2026 Client payment Checking 1200.00 ENDTRNS
This is an example for the reader, not a customer document or a certified bank export. Use “Try a sample file” on a converter to test the complete local workflow.
Checks for this format
- Preserve tabs and inspect the header definitions.
- Compare TRNS group count with the converted transaction count.
- Read the SPL summary and keep the original accounting source.
- Configure account names and test with a copied company before import.
Available conversions from IIF
- IIF to CSV converter — Read IIF bank transaction fields into CSV with debit, credit and identifier columns. Review the preview before downloading.
- IIF to Excel converter — Read IIF bank transaction fields into Excel with typed dates and amounts. Review the preview before downloading.
Format and product references
Publisher documentation describes the format or destination product. It does not certify this converter or any generated file.
All format guides · Check extraction quality · Document storage and deletion