Recently I've started using GnuCash for my personal finances. Eventually I got it running well, after I recompiled it myself, because the version in Debian was segfaulting on start-up (it is also very outdated).
My bank, PostBank only supports exporting transactions in it's own custom CSV files which, of course, aren't supported by Gnucash. I wrote a simple Python script that converts PostBank CSV files to QIF, which Gnucash can handle ok.
I'm publishing the script here for others interested in importing PostBank CSV files in their finance apps:
#!/usr/bin/python # Very simple converter from PostBank mijn.postbank.nl .csv files to # QIF files for use by (among others) gnucash. # # Written by Jelmer Vernooĳ <firstname.lastname@example.org>, 2007 import csv, sys rows = csv.reader(sys.stdin) header = rows.next() assert header == (['Datum', 'Naam / Omschrijving', 'Rekening'] + ['Tegenrekening', 'Code', 'Af Bij', 'Bedrag (EUR)'] + ['MutatieSoort', 'Mededelingen']) print '!Type:Bank\n' for l in rows: if "-" in l: p = l.split("-") print "D%s/%s/%s" % (p, p, p) else: print 'D%s/%s/%s' % (l[4:6], l[6:8], l[0:4]) # date if l == 'Bij': print 'T%s' % l # amount elif l == 'Af': print 'T-%s' % l # amount else: raise Error("Unknown field value '%s'" % l) print 'P%s' % l # payee / description print 'M%s' % l # comment print 'L%s' % l print '^\n' # end transactionGo Top