Skip to content

Convert ABN Amro CSV/TXT bank statements to QIF

Notifications You must be signed in to change notification settings

ChocoMelvin/abncsv2qif

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 

Repository files navigation

abncsv2qif

Convert ABN Amro CSV bank statements to QIF

Usage

Go to Internet bankieren of ABN Amro (http://www.abnamro.nl) and login with your e.Identifier2. When you are in the digital banking environment, you can go to 'bij- en afschrijvingen' in the 'downloaden' section (the menu on the left). There you can select the period of which you want to download your transactions and in the dropdown select the format of the file you want to download. It is important that you choose TXT there.

After you have downloaded the file, you go to a commandline (for example using the Terminal app) and locate the file. Then enter (in the directory where you checked out this project):

On Linux

abncsv2qif <filename> > newfile.qif

On Windows

python2 abncsv2qif <filename> > newfile.qif

After this, newfile.qif will be a QIF file containing all the data of the downloaded file. This file can be imported in YNAB by going to your ABN checking account and then click the 'Import' button at the top and select your generaged file.

Known issues

The conversion is not flawless, mainly because there is no documentation available on the structure of the files you can download from ABN Amro, so I created the tool mostly by trail-and-error.

Credit

All credit goes to @msturm since he has written most of the code for this.

About

Convert ABN Amro CSV/TXT bank statements to QIF

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 100.0%