Simple to YNAB

gistfile1.txt

import pandas as pd
trans = pd.read_csv("2014-04-02-exported_transactions.csv", parse_dates=[0])
trans = trans[trans.Pending == False]
trans = trans[["Date","Amount","Description","Memo"]]
trans = trans.copy(deep=True)
trans["Inflow"] = trans.Amount.map(lambda x: x if x > 0 else 0)
trans["Outflow"] = trans.Amount.map(lambda x: -x if x <= 0 else 0)
del trans["Amount"]
trans["Payee"] = trans["Description"]
del trans["Description"]
trans["Category"] = ""
trans.Memo.fillna("", inplace=True)
trans = trans[["Date","Payee","Category","Memo","Outflow","Inflow"]]
trans["Date"] = trans.Date.map(lambda date: date.strftime("%m/%d/%y"))
trans.to_csv("to_ynab.csv", index=False)