I tried this myself and the positive dollars in the amount column does indeed
go to the deposit column in gnucash and the negative dollars number goes into
the withdraw column. I should also add the test account I used set up is a Type
( bank). Have not tried this on other Types of accounts.
Joe
-----Original Message-----
From: gnucash-user <gnucash-user-bounces+rovero=comcast....@gnucash.org> On
Behalf Of Jim DeLaHunt
Sent: Wednesday, December 14, 2022 6:36 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Importing Transactions from CSV
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.
_______________________________________________
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.
