[GNC] Importing Transactions from CSV

[rovero at comcast.net]

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.net at gnucash.org> On Behalf Of Jim DeLaHunt
Sent: Wednesday, December 14, 2022 6:36 PM
To: gnucash-user at 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 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.