<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><div dir="auto">What is the platform you use (Linux/Mac/Windows)?  I originally write it for Linux, but it should be easy to adjust.<div dir="auto"><br></div><div dir="auto">Best regards,</div><div dir="auto">Yuri</div></div><div class="gmail_extra"><br><div class="gmail_quote">On May 1, 2020 09:14, Frank ter Braak <frankterbraak@gmail.com> wrote:<br type="attribution"><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">I still have to get started my new bookkeeping on GnuCash but how to import my ING data was one of the challenges so if you have a solution or something to start with I am happy to look into that.<div><br></div><div><div><br><div>
<span style="border-collapse:separate;color:rgb( 0 , 0 , 0 );font-family:'helvetica';font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;border-spacing:0px"><div style="word-wrap:break-word"><span style="border-collapse:separate;color:rgb( 0 , 0 , 0 );font-family:'helvetica';font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;border-spacing:0px"><div style="word-wrap:break-word"><div><div><div>Vriendelijk groetend,</div></div><div>Frank ter Braak</div><div><br></div></div></div></span><br></div></span><br><br>
</div>
<div><br><blockquote><div>Op 30 apr. 2020, om 23:33 heeft Yuri Radomsky <<a href="mailto:myaccount22@outlook.com">myaccount22@outlook.com</a>> het volgende geschreven:</div><br><div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt">Hi group,</div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt"><br></div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt">I will write in English because it's easier for me this way. I am writing to this group because it has info specific for Dutch banks.<br></div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt"><br></div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt">I am using GnuCash for some time now and I have dutch ABN and ING accounts. Importing data from those accounts to GnuCash is a challenge: <br></div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt"> - for ABN TM940 export files GnuCash import settings must be adjusted (skip first 3 lines of each record. Luckily this was googleable)</div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt"> - ING doesn't provide MT940 export, only CSV.</div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt"><br></div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt">What I've done is written some scripts (small program actually) to 'prepare' the import files:</div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt"> - For ABN: remove those first 3 lines, so you don't have to play with GnuCash settings. Future plan: tweak the description so it is more readable.<br></div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt"> - For ING: create a MT940 file from their CSV file, tweak the description to be more readable. <br></div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt"><br></div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt">Is anyone in this groups interested in those scripts? If so, I can make them more user-friendly and share, with some instructions, via GitHub, for example.\</div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt"><br></div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt">Looking forward to your feedback!</div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt"><br></div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt">Best regards,</div><div style="font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:'calibri' , 'helvetica' , sans-serif;font-size:12pt">Yuri<br></div><span style="font-family:'helvetica';font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;float:none;display:inline !important">_______________________________________________</span><br style="font-family:'helvetica';font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none"><span style="font-family:'helvetica';font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;float:none;display:inline !important">Gnucash-nl mailing list</span><br style="font-family:'helvetica';font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none"><a href="mailto:Gnucash-nl@gnucash.org" style="font-family:'helvetica';font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">Gnucash-nl@gnucash.org</a><br style="font-family:'helvetica';font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none"><a href="https://lists.gnucash.org/mailman/listinfo/gnucash-nl" style="font-family:'helvetica';font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">https://lists.gnucash.org/mailman/listinfo/gnucash-nl</a></div></blockquote></div><br></div></div></div></blockquote></div><br></div>