<div dir="ltr"><div>Ik krijg van de ING-bank een CSV-bestand, die pas ik in Excel aan om de bedragen in de kolommen <b>Bij</b> en <b>Af </b>te krijgen. Die conversie importeer ik iin GNU-cash.</div><div class="gmail_quote gmail_quote_container"><div dir="ltr"><div>Is er een manier om deze conversieslag over te slaan en het CSV bestand direct in te lezen in GNU-cash? </div><div><table border="0" cellpadding="0" cellspacing="0" width="976" style="border-collapse:collapse;width:732pt">
<colgroup><col width="65" style="width:49pt">
<col width="130" style="width:98pt">
<col width="142" style="width:106pt">
<col width="149" style="width:112pt">
<col width="38" span="2" style="width:28pt">
<col width="84" style="width:63pt">
<col width="106" style="width:80pt">
<col width="90" style="width:67pt">
<col width="106" style="width:80pt">
<col width="28" style="width:21pt">
</colgroup><tbody><tr height="19" style="height:14.4pt">
<td height="19" colspan="3" width="337" style="height:14.4pt;width:253pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"><b><br>1. Ontvangen CSV bestand van ING bank</b></td>
<td width="149" style="width:112pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td width="38" style="width:28pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td width="38" style="width:28pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td width="84" style="width:63pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td width="106" style="width:80pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td width="90" style="width:67pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td width="106" style="width:80pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td width="28" style="width:21pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
</tr>
<tr height="19" style="height:14.4pt">
<td height="19" style="height:14.4pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">Datum</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">Naam / Omschrijving</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"> Rekening</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"> Tegenrekening</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">Code</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"><b>Af/ Bij</b></td>
<td style="text-align:center;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"> Bedrag (EUR)</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"> Mutatiesoort</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"> Mededelingen</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">Saldo na mutatie</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">Tag</td>
</tr>
<tr height="19" style="height:14.4pt">
<td height="19" align="right" style="height:14.4pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">20250322 </td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">Naam 1 </td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"> NL24INGB0000123456</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"> NL02INGB00012345678</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">GT</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"><b>Bij</b></td>
<td align="right" style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"><b>17,5</b></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"> Online bankieren</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"> Mededeling 1</td>
<td align="right" style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">1058,87</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
</tr>
<tr height="19" style="height:14.4pt">
<td height="19" align="right" style="height:14.4pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">20250312 </td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"> Naam2</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"> NL24INGB0000123456</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"> NL02INGB00087654321 </td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">IC</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"><b>Af</b></td>
<td align="right" style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"><b>74,43 </b></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"> Incasso</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"> Mededeling 2</td>
<td align="right" style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">1041,37</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
</tr>
<tr height="19" style="height:14.4pt">
<td height="19" style="height:14.4pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"><br><br></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
</tr>
<tr height="19" style="height:14.4pt">
<td height="19" colspan="2" style="height:14.4pt;font-weight:700;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">2.
Via Excel conversie naar:</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
</tr>
<tr height="19" style="height:14.4pt">
<td height="19" style="height:14.4pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">Datum</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">Naam / Omschrijving</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"><blockquote style="margin:0 0 0 40px;border:none;padding:0px">Rekening</blockquote></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><b> Bij</b></blockquote></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><b> Af</b></blockquote></td>
<td colspan="2" style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">Mededelingen</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
</tr>
<tr height="19" style="height:14.4pt">
<td height="19" align="right" style="height:14.4pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">20250322 </td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">Naam 1</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">NL24INGB0000123456</td>
<td style="text-align:right;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"><b>17,5</b></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><br></blockquote></blockquote></blockquote></td>
<td colspan="2" style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">Mededeling 1</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
</tr>
<tr height="19" style="height:14.4pt">
<td height="19" align="right" style="height:14.4pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">20250312 </td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">Naam 2</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">NL24INGB0000123456</td>
<td style="text-align:left;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><br></blockquote></td>
<td style="text-align:left;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><b>74,</b>43 </blockquote></td>
<td colspan="2" style="text-align:center;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">Mededeling 2</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
</tr>
<tr height="19" style="height:14.4pt">
<td height="19" style="height:14.4pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
</tr>
<tr height="19" style="height:14.4pt">
<td height="19" style="height:14.4pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
</tr>
<tr height="19" style="height:14.4pt">
<td height="19" colspan="2" style="height:14.4pt;font-weight:700;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none">3.
Import in GnuCash</td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
<td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td>
</tr>
<tr height="19" style="height:14.4pt">
<td height="19" style="height:14.4pt;padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none" align="left" valign="top"><br></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td><td style="padding:0px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none"></td></tr>
</tbody></table></div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><img src="cid:ii_m8wzerxu2" alt="image.png" width="950" height="62" style="margin-right:0px"><br></div><div dir="ltr"><br></div><div>Is het mogelijk om GnuCash zo in te stellen dat de conversie in Excel niet meer nodig is?</div><div dir="ltr"><br></div><div dir="ltr">Met vriendelijke groet,<div><br></div><div>Henk Meijerink<br><b></b></div></div></div></div></div>
</div></div>