A script to convert a CSV account transaction file exported from Commerzbank to a format that can be imported into Simplifi.

commerzbank_to_simplifi.py

""" A script to convert a CSV account transaction file exported from Commerzbank to a format that can be imported into Simplifi. """

import csv
from datetime import datetime
from pathlib import Path

HERE = Path(__file__).parent
# EUR_TO_USD: float = 1.13
EUR_TO_USD: float = 1.00

writer = csv.writer(open(HERE/'converted.csv', 'w', newline=''))
writer.writerow(['Date', 'Payee', 'Amount'])

with open(HERE/'big.csv', 'r') as f:
    reader = csv.reader(f, delimiter=';')
    rows = list(reader)[1:]
    for row in rows:
        # 25.11.2021 to 11/25/2021
        date = datetime.strptime(row[0], '%d.%m.%Y').strftime('%m/%d/%Y')
        payee = row[3]
        amount = round(float(row[4].replace(',', '.')) * EUR_TO_USD, 2)
        writer.writerow([date, payee, amount])
        print(f'{date} | {payee[:25]} | {amount}')