Projects / fineco2qif

fineco2qif

fineco2qif is a Python script that can convert bank statements as released by FinecoBank (which are MS Excel files) into QIF, in such a way that they can be easily imported into common financial applications, such as GnuCash.

Licenses
Operating Systems

Recent releases

  •  23 Jan 2009 18:53

    Release Notes: This version is fully functional but does almost no sanity checks, so please use it with caution.

    Recent comments

    17 Sep 2010 08:21 marcoaicardi

    Ho aggiornato il file di patch, sembrava dare alcuni errori.


    --- fineco2qif.py 2009-01-23 17:13:00.000000000 +0100
    +++ fineco-carta2qif.py 2010-09-17 10:17:17.368338655 +0200
    @@ -1,10 +1,15 @@
    #!/usr/bin/python
    -# Importer script to convert Fineco xls files into QIF files,
    +# Importer script to convert Fineco Credit Card xls files into QIF files,
    # for use, among others, by gnucash.
    #
    +# Based on the fineo2qif.py script by
    # Antonino Sabetta - antonino.sabetta@isti.cnr.it
    # (C) - 2009
    #
    +# Modified by Marco Aicardi - marco [a] aicardi d0t org
    +#
    +# Released under GPLv3 License - www.gnu.org/licenses/g...
    +#
    # This is based on Jelmer Vernooij's script
    # for PostBank mijn.postbank.nl .csv files.
    # Jelmer Vernooij <jelmer@samba.org>, 2007
    @@ -36,8 +41,7 @@
    assert line == ['Risultato ricerca movimenti']

    line = rows.next()
    - assert line == ['DataOperazione','Data Valuta','Entrate','Uscite','Descrizione','Causale']
    -
    + assert line == ['Data operazione','Data Registrazione','Descrizione Operazione','Tipo spesa','Tipo rimborso','Importo in euro']

    ##
    # begin main program
    @@ -75,10 +79,8 @@
    p = l[0].split("/")
    print "D%s/%s/%s" % (p[0], p[1], p[2]) # you can easily get month-day-year here...
    # print 'D%s/%s/%s' % (l[0][4:6], l[0][6:8], l[0][0:4]) # date
    - if l[2] == '':
    - print 'T-%s' % l[3] # negative amount
    - else:
    - print 'T%s' % l[2] # positive amount
    - print 'P%s' % l[4] # payee / description
    - print 'M%s' % l[5] # comment
    + print 'T-%s' % l[5] # negative amount
    + print 'P%s' % l[2] # payee / description
    + print 'M%s' % l[2] # comment
    print '^\n' # end transaction
    +

    27 Jul 2010 09:55 marcoaicardi

    Come giÓ ti ho segnalato via email mi sono permesso di modificare il tuo script per permettere di elaborare gli XLS della carta di credito fineco.

    Questo Ŕ il patch delle modifiche che ho fatto:

    --- fineco2qif.py 2009-01-23 17:13:00.000000000 +0100
    +++ fineco-carta2qif.py 2010-05-11 22:18:22.992442538 +0200
    @@ -2 +2 @@
    -# Importer script to convert Fineco xls files into QIF files,
    +# Importer script to convert Fineco Credit Card xls files into QIF files,
    @@ -4,0 +5 @@
    +# Based on the fineo2qif.py script by
    @@ -7,0 +9,4 @@
    +# Modified by Marco Aicardi - marco [a] aicardi d0t org
    +#
    +# Released under GPLv3 License - http://www.gnu.org/licenses/gpl-3.0.html
    +#
    @@ -39 +44 @@
    - assert line == ['DataOperazione','Data Valuta','Entrate','Uscite','Descrizione','Causale']
    + assert line == ['Data operazione','Data Registrazione','Descrizione Operazione','Tipo spesa','Tipo rimborso','Importo in euro']
    @@ -78,6 +83,3 @@
    - if l[2] == '':
    - print 'T-%s' % l[3] # negative amount
    - else:
    - print 'T%s' % l[2] # positive amount
    - print 'P%s' % l[4] # payee / description
    - print 'M%s' % l[5] # comment
    + print 'T-%s' % l[5] # negative amount
    + print 'P%s' % l[2] # payee / description
    + print 'M%s' % l[2] # comment

    Screenshot

    Project Spotlight

    OpenStack4j

    A Fluent OpenStack client API for Java.

    Screenshot

    Project Spotlight

    TurnKey TWiki Appliance

    A TWiki appliance that is easy to use and lightweight.