pending2ynab.py

#!/usr/bin/env python

"""
1. Copy pending transactions from chase.com
2. `pbpaste | path/to/pending2ynab.py > ~/Desktop/ynabimport.csv`
3. Import ~/Desktop/ynabimport.csv file into YNAB
"""

import re
import sys
from datetime import date

print('Date,Payee,Category,Memo,Outflow,Inflow')

payee_pattern = re.compile('^(?:POS DEBIT )?(.*) Link .*$')

for line in sys.stdin:
    infields = line.strip().split('\t')
    payee = payee_pattern.findall(infields[2])
    outfields = [
       date.today().strftime('%m/%d/%Y'),
       payee and payee[0],
       '',
       '',
       infields[3].strip(),
       infields[4].strip(),
    ]
    print(','.join(outfields))