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")
transactions[txn_id].append(txn) return transactions csv to iif converter
converter: input_encoding: utf-8 output_encoding: utf-16 transaction_grouping: "Reference_Number" columns: - csv: "Posting Date" iif: "DATE" transform: "date_to_us" - csv: "Transaction Amount" iif: "AMOUNT" transform: "sign_by_account_type" - csv: "Bank Account" iif: "ACCNT" lookup: "bank_to_qb_accounts.csv" output_file): with open(output_file