Download Rabobank transactions to GNUCash

As a happy user of GNUCash I like to upload my transactions to this application. Recently Rabobank has started to provide a new csv download file. Amongst other things this file now contains the IBAN instead of the BBAN. The file can be downloaded from your internet banking environment at www.rabobank.nl.

Unfortunately the old perl script I used for converting the downloaded file to the ofx format didn’t work anymore. I had to edit the perl script to make it work again. The script is needed because the Rabobank file needs to be converted to ofx format for GNUCash to be able to import it. It is posted below, yours to use. File extenstion has to be changed to .pl after download.

Call it like this “./rabo2ofx_newformat.pl downloadedrabofile.txt > filetoimportingnucash.txt”

rabo2ofx_newformat

Tags: ,

7 Responses to “Download Rabobank transactions to GNUCash”

  1. J. den Boer says:

    Thanks for the updated script. I was already a happy user of your old script but after the rabobank update I had to search again. Great work

  2. F.J. Mosch says:

    Thanks,

    I used rabocsv_to_qif.py earlier.

  3. J. den Boer says:

    I found out that the script skips some of the statements in the rabobank file. They never end up in the .ofx file. This resulted in me searching why the totals didn’t add up

  4. J. den Boer says:

    I figured it out. Rabobank uses longer descriptions than 32 characters some times. In that case the rule gets skipped by the script. Just making the acception of characters bigger in the script fixes the problem

  5. spruit says:

    Thanks for helping. I updated the script. It uses text length 64 now.

  6. Marcel says:

    I’ve more than 1 account at rabobank and when importing the ofx-file all the transactions get imported to all the accounts. B.t.w. I use kmymoney. Your old script always worked flawlessly.

  7. Tom says:

    Bedankt voor het script! Werkt fantastisch!

Leave a Reply