Posts

Showing posts from 2014

ABN Amro bank statement export to .OFX

I recently started to use YNAB 4 (You Need A Budget) software to manage/monitor my spendings. You can find it here  (referral + $6 discount alert). Great and easy to use software to budget your expenses. But for Dutch users I found a big disadvantage: you cannot import files from ABN Amro. YNAB only imports .OFX (Money) or .QFX (Quicken) and to some extend (they say they do not prefer it) .QIV or .CSV files. On the other end, ABN Amro only exports PDF, Excel (.xls), MT904 (.STA), TXT (.TAB, tab delimited) and CAMT. 053 formats. To get your transactions into YNAB, you need to download a MT904 converter. You can find it here:  http://sourceforge.net/projects/mtconverter/  You need to have Java installed for it to work ( www.java.com ). To use the converter, I created a batch file with the following lines: for /r %%i in (in\*.sta) do ( echo %%~ni java -jar mtconverter-0.01.jar "%%i" out\%%~ni.ofx del %%i ) Save it as convert.bat in the same directory as the .