Read Me

Conversion of ABN-AMRO mutations in TXT format tp QIF format.

Usage:
> abnimport.py inputfile report
    this will read inputfile and generate a report.
    
> abnimport.py inputfile outputfile
    this will covert txt data into qif file.

options: 
    -h = show help text
    -v = show more verbose output
    -c = categorise
    
abntxt.py   takes care of the import
qif.py      takes care of the export
category.py adds categories to the mutations

Some mutations are missing payee while they are actually
banking cost of ABN so these are fixed in abntxt.py
mutations get assigned a category
    the selection is based a text search in payee and comment
    The list is in a separate file category.conf

GEA = geldautomaat (cash machine, atm, automated teller machine)
BEA = betaalautomaat (betalen in een winkel/bedrijf/mobiele pin)

The raw data from abnamro really is a mess
To improve the data use a category.conf

The format works like this:
GREENPEACE/ STEUN = Giften:Greenpeace

If we find a transaction with name is "Greenpeace"
and the comment field has "Steun"
Than we assume it's a gift to Greenpeace and 
we assign it category: Giften:Greenpeace

For some transactions the name field is empty
than we use only the comment field like
/IKEA = Huis:Overig

For some tranasactions the name field is all we have
because either comment is empty or has completely useless data
example:
ZIGGO/ = Huis:Telecom

Sometimes the Name (Payee) is empty and i really want to 
make the data as complete as possible, so use:
/ BERKMAN = Berkman / Auto:Benzine
The name is empty, but we find "BERKMAN" in the comment
and than we are sure the payee is Berkman.

After the program done it's work we import the qif file 
into Grisbi and hopefulle we have only a few missing items
these missing items we have to manually add payee or category
But if we know the same transaction could happen again,
than update category.conf

When you have a bunch of transactions you may have to build 
your private category.conf
That is where reverse category comes to play:
Run this and you get a list of items and use a simple text editor
to add the categories you want to assign.