Receipt Bank to QIF

receipt-bank-to-qif.py

#!/usr/bin/python

## Convert from https://www.receipt-bank.com CSV format to QIF
# ./receipt-bank-to-qif.py <receipts.csv  >receipts.qif

import csv, sys

rows = csv.DictReader(sys.stdin)

# read it all in, then we'll write out one payment method at a time
data = {}
for row in rows:
    data.setdefault(row['Payment Method'],[]).append(row)

print """\
!Type:Cat
!Option:AutoSwitch"""

# give the list of accounts/payment methods that are going to come up later
for payment in data.keys():
    print "!Account"
    print "N%s" % payment
    print "^"

print """\
!Clear:AutoSwitch
"""

for payment, transactions in data.items():
    if payment == "cash":
        typ = "Cash"
    else:
        # could be CCard too?
        typ = "Bank"
    print """\
!Account
N%s
^
!Type:%s
""" % (payment, typ)  
    for transaction in transactions:
        if payment == 'cash':
            transaction['cleared'] = 'c'
        else:
            transaction['cleared'] = ''            
        print """\
D%(Date)s
T-%(Total)s
M%(Note)s
P%(Payee)s
N%(Receipt ID)s
C%(cleared)s
L%(Category)s
^""" % transaction