Giter Club home page Giter Club logo

easybankcsv2qif's Introduction

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 ;)

easybankcsv2qif's People

Contributors

bernharddenner avatar wodka avatar

Stargazers

 avatar

Watchers

 avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.