import csv from datetime import datetime with open('transactions.CSV', newline='') as csvfile: with open("temp-trans-out.txt", "w") as output: trans = csv.reader(csvfile, delimiter=',', quotechar='|') for t in trans: dt = datetime.strptime(t[0], '%m/%d/%Y') dt = dt.strftime("%Y-%m-%d") line = '%s * "%s"\n Liabilities:SchoolsFirst:Card -%s USD\n Expenses:Misc:Amazon %s USD\n\n' % (dt, t[1], t[5], t[5]) output.write(line) output.close() csvfile.close()