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.butle...@gmail.com
kg...@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@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.
_______________________________________________
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.
