transactions[txn_id].append(txn) return transactions
def reformat_date(date_str): # Supports YYYY-MM-DD or DD/MM/YYYY for fmt in ('%Y-%m-%d', '%d/%m/%Y', '%m/%d/%Y'): try: dt = datetime.strptime(date_str, fmt) return dt.strftime('%m/%d/%Y') except ValueError: continue raise ValueError(f"Date date_str not recognized") 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" transactions[txn_id]
"csv_columns": ["Date", "Description", "Amount", "Account"], "iif_targets": "DATE": "Date", "MEMO": "Description", "AMOUNT": "Amount", "ACCNT": "Account" , "transaction_group_key": ["Date", "Reference"] '%m/%d/%Y'): try: dt = datetime.strptime(date_str
