NL Bankstatement converter is a small application to convert csv and pdf files from five Dutch banks and one credit card provider into a csv format that can be easily imported into GnuCash.
The six banks/cards that are currently supported:
- Rabobank - download transactions in
csvfile - ASN Bank - download transactions in
csvfile - ING Bank - download transactions in
csvfile - ANWB VISA ICS Credit Card - download transactions in monthly account statement
pdf - Openbank / Santander - download transactions in
pdffile - Bunq Bank - download transactions in
csvfile
Set your settings in the properties file, like path and name as it is shown on your ANWB Visa ICS Credit Card. If you have Bunq accounts, put unique IBAN identifiers here as well.
If you want the input files to be automatically deleted after the conversion process has finalized, set AUTO_DELETE to YES. If set to NO, input files are archived in the folder /Archive.
- Download the transactions from your bank (ING, ASN, Openbank, Bunq and RaboBank) or monthly account statement (ANWB VISA Card) to the folder you defined in the properties file.
- Launch the application and select the file you would like to convert. A summary will be given on the screen, and at the same time the
csvoutput file will be written to the same folder. - Import your transactions into GnuCash by importing transactions in the CSV format.
Make this file executable under MacOS:
- Change the extension of the file to .command
- In Terminal make the Python script file executable by running
chmod +x Statement_Converter.command - Now you can double-click your Python script within MacOS and it will open a terminal window
Inspiration to solve the Openbank pdfplumber challenge: jsvine.
If you would like me to add your bank statement format as well, just give me a shout.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent