Skip to content

Latest commit

 

History

History
27 lines (18 loc) · 1.59 KB

README.md

File metadata and controls

27 lines (18 loc) · 1.59 KB
Raw

easyBankcsv2qif.py

This is a little python script to convert a CSV file from the online bank platform Easybank (or Bawak PSK works also) into QIF format. This format can be read by many accounting applications like Homebank or GnuCash.

The script extracts the following fields for each transaction:

  • account number
  • transaction date
  • amount
  • currency (default is fixed to EUR)
  • transaction description: since this information is often very cryptic, the conversion tries to rebuild a suitable description. Additionally, other useful information is some how encoded in this field. Therefor some heuristics try to extract this info, like:
    • transaction type: like transfer, payment, withdraw...
    • payee
    • memo

Additionally, the script is able to change the character encoding of the input data.

For usage details, see ./easyBankcsv2qif.py -h

Currently I'm using this script for converting Easybank and Bawag-PSK CSV file into QIF, which I import in Homebank to manage my transactions.

easyBankcsv2qifFrontend.py

This script is a small GTK3 frontend for easyBankcsv2qif.py. It takes the input file's filename as parameter, asks the user for the output filename, does the csv 2 qif conversion and after a short summary the input file is deleted. This script is designed to open the downloaded CSV file from the ebanking Webapp directly with the browser, thus avoiding the need of the command line.

Note: the Frontend script uses a fixed enconding, from iso-8859-1 to utf-8

Note: this is my first python script. Any comments on it are welcome ;)