On 2022-12-14 18:15, M wrote:
My credit card company... only offer the transactions in CSV format.
The issue I have is they list both deposits and withdrawals in the
same "Amount" column. They signify deposits as negative amounts, and
withdrawals as positive amounts.
As far as I can tell, Gnucash only allows imports of a "Withdrawals"
or "Deposits" column type when importing transactions in CSV format.
Is this correct?
Yes, but I believe (having not tried this recently) that Gnucash accepts
negative amounts, as well as positive, in either column. When GnuCash
finds a negative amount in a "Withdrawls" column, it makes the number
positive and moves it to the "Deposits" column; and vice versa.
I suspect that if you assign the "Amount" column of your credit card
company's CSV file to the withdrawls column of GnuCash's credit card
account, then the correct numbers will end up in your GnuCash book. But
try this experimentally before you commit to it. I have not tested this
myself before writing this reply.
Best regards,
—Jim DeLaHunt
_______________________________________________
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.