[GNC] CSV importer Debet/Credit issue

[Geldnerd]

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 <koos2024 at pohw.nl>
> To: gnucash-user at gnucash.org
> Subject: [GNC] CSV importer Debet/Credit issue
> Message-ID: <f6b29864-ee44-46c7-8429-8434e93fc9d9 at 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
> 
> ------------------------------