paypal2qbo.py

import csv
import argparse
import time

def main():
    parser = argparse.ArgumentParser()
    parser.add_argument('infile', nargs='+', type=argparse.FileType('r'))
    args = parser.parse_args()

    transactions = []
    for f in args.infile:
        for line in csv.DictReader(f):
            # The single line has a gross payment and a fee payment, so we need to split those apart
            tstamp = time.strptime('{Date} { Time}'.format(**line), '%m/%d/%Y %H:%M:%S')

            # This is the "gross" payment
            transactions.append((
                tstamp,
                '{ Type} From { Name}'.format(**line),
                line[' Gross'].replace(',', '')
            ))

            if line[' Fee'] != '0.00':
                transactions.append((
                    tstamp,
                    '{ Type} Fee From { Name}'.format(**line),
                    line[' Fee'].replace(',', '')
                ))

    with open('QuickBooksOutput.csv', 'w') as f:
        writer = csv.DictWriter(f, fieldnames=['Date', 'Description', 'Amount'])
        writer.writeheader()

        for txn in sorted(transactions, key=lambda l: time.mktime(l[0])):
            writer.writerow({
                'Date': time.strftime('%m/%d/%Y', txn[0]),
                'Description': txn[1],
                'Amount': txn[2]
            })


if __name__ == '__main__':
    main()