Python code to convert Chase Transactions to YNAB CSV format

ynabit.py

#!/usr/bin/python

import sys

f = open(sys.argv[1])
print "Date,Payee,Category,Memo,Outflow,Inflow"
for l in f.readlines():
    a = l.strip().split(',')
    p = 0
    try:
        p = float(a[4]) * 1.4  # USD to AUD
    except ValueError:
        continue
    outflow = 0.0
    inflow = 0.0
    if p > 0:
        inflow = p
    elif p == 0:
        continue
    else:
        outflow = 0-p

    print "%s,%s,,,%.2f,%.2f" % (a[2],a[3],outflow,inflow)