Unlike standard bank imports, IIF files allow you to specify exact income/expense accounts, classes, and split categories for every transaction before they even hit your company file.
Banks export positive for deposits, negative for withdrawals. QuickBooks expects:
CSV is flat (one row = one event), while IIF is hierarchical (one transaction can span multiple rows for split accounting). Conversion requires based on transaction IDs or date/amount combinations. csv to iif converter
Specialized tools are the most reliable way to handle the complex multi-line requirements of IIF files without manual errors. ProperSoft ProperConvert [Big Red Consulting IIF Creator](bigredconsulting.com) Quickly converting bank/credit card CSVs Key Capability Automatically identifies date, amount, and payee columns Platform Windows & Mac standalone app General conversion steps for most tools:
Technically, you can open a CSV file in Notepad or Excel and manually type the IIF headers (like !TRNS , !SPL , !ENDTRNS ). However, this is for several reasons: Unlike standard bank imports, IIF files allow you
The software will ask you to match your CSV headers to IIF fields.
def generate_iif(transactions, output_file): with open(output_file, 'w', encoding='utf-16') as f: # IIF prefers UTF-16 f.write("!TRNS\tTRNSTYPE\tDATE\tACCNT\tAMOUNT\tMEMO\tNAME\n") f.write("!SPL\tTRNSTYPE\tDATE\tACCNT\tAMOUNT\tMEMO\t\n") Conversion requires based on transaction IDs or date/amount
IIF remains importable even for versions of QuickBooks that no longer support QBO files.
When choosing a tool like the ProperConvert app or CSV2IIF , look for these essential features:
Whether you are importing 50 or 500 transactions, a converter can process them in seconds, reducing a half-hour task to just a few minutes.