Hi Koos, From your name and domain extension I derive that you are from The Netherlands like me. I haven’t found a way to make the importer combine the C/D and the number to a booking that GnuCash can handle. Therefore I use a spreadsheet to automatically ‘prewash’ the export files from the bank into something that GnuCash can read.
It can be found here: https://www.geldnerd.nl/hoe-importeer-ik-in-gnucash/. Works for ABN AMRO and Rabobank. But can be adapted for any bank. Best regards, Geldnerd > Message: 6 > Date: Sat, 7 Dec 2024 21:01:57 +0100 > From: Koos Pol <koos2...@pohw.nl> > To: gnucash-user@gnucash.org > Subject: [GNC] CSV importer Debet/Credit issue > Message-ID: <f6b29864-ee44-46c7-8429-8434e93fc...@pohw.nl> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Hi, > > The CSV importer *almost* works. The statements from my bank has: > - one column for the amount. The amount is always positive. > - one column have the entries "Debet" or "Credit" to indicate the > direction of the tx. > > Here are a few sample rows: > "01-01-2024","38,10","Debet",... > "11-01-2024","241,58","Credit",... > "23-01-2024","43,35","Debet",... > "11-02-2024","241,58","Credit",... > "06-03-2024","384,95","Debet",... > > Is there any way to have the importer grok this? The "Action" column > didn't work. > > Thanks! > Koos > > ------------------------------ _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
