ing2ofx

Intro

The intent of this script is to convert ing (www.ing.nl) csv files to ofx files that can be read by a program like GnuCash (www.gucash.org).

This script is adapted from pb2ofx.pl Copyright 2008, 2009, 2010 Peter Vermaas, originally found at http://blog.maashoek.nl/2009/07/gnucash-en-internetbankieren/ which is now offline.

The ofx specification can be downloaded from http://www.ofx.net/

A tutorial on how to keep your bank records in GnuCash can be read on: http://www.chmistry.nl/financien/beginnen-met-boekhouden-in-gnucash/

Windows users

Now available Graphical User Interface with all-in-one msi installer: See https://github.com/chmistry/ing2ofx/releases

Usage - Graphical user interface:

On the command line: python gui.py

Usage - command line:

usage: ing2ofx [-h] [-o, --outfile OUTFILE] [-d, --directory DIR]
               [-c, --convert] [-b, --convert-date]
               csvfile

This program converts ING (www.ing.nl) CSV files to OFX format. The default
output filename is the input filename.

positional arguments:
  csvfile               A csvfile to process

optional arguments:
  -h, --help            show this help message and exit
  -o, --outfile OUTFILE
                        Output filename
  -d, --directory DIR   Directory to store output, default is ./ofx
  -c, --convert         Convert decimal separator to dots (.), default is
                        false
  -b, --convert-date    Convert dates with dd-mm-yyyy notation to yyyymmdd

Output

1. An ofx file converted from the csv file (default in the folder ./ofx)
2. Some statistics:

TRANSACTIONS: 349
IN:           test2.csv
OUT:          test2.ofx