Script to read chase statement CSV and show running sum. Ignores payments.

chase_running_sum.py

#!/usr/bin/env python

import sys
import csv

if len(sys.argv) != 2:
    print "Usage: chase_running_sum <chase_csv>"
    exit()

with open(sys.argv[1], 'rb') as csvfile:
    reader = csv.reader(csvfile)
    sum = 0
    for row in reader:
        if 'Transaction Date' == row[0]:
            continue
        tx_date = row[0]
        post_date = row[1]
        title = row[2]
        row_credit = float(row[5])
        if row_credit > 0:
            continue
        sum -= row_credit
        #print row[5] + '\t' + str(sum)
        print("{: <20} {: <40} {: <10} {: >10}".format(tx_date, title, str(row_credit), str(sum)))