[GNC] CSV importer Debet/Credit issue

[Stephen M. Butler]

In my experience you will need to have a pre-process to massage the data 
to make a debit column and a credit column.  Or split the file into two 
files, one with the credits and another one with the debits.  Each file 
would need a lightly different mapping for the amount column.  Be sure 
to save the configuration so it will be easy to use the next time.

Stephen M Butler
Stephen.M.Butler51 at gmail.com
kg7je at arrl.net
253-350-0166
-------------------------------------------
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

On 12/7/24 12:01, Koos Pol wrote:
> 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 at 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.