[GNC] Importing Transactions from CSV

[M]

Ah ha.

I was opening my csv file in a spreadsheet editor and manipulating the 
data before importing.

I made a couple simple test csv files and they worked exactly as you 
described.

I think the issue may be a formatting error my spreadsheet software was 
doing.

Thanks for the help, I think I have it solved.

Mike

On 12/15/22 6:58 AM, Murugan Muruganandam wrote:
> you dont need to change the file, if  it is negative, GNUCash will 
> move it to debit column in this case.  Select the column as withdrawal
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> ------------------------------------------------------------------------
> *From:* gnucash-user 
> <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org> on 
> behalf of M <M_Stagl at hotmail.com>
> *Sent:* Wednesday, December 14, 2022 11:15 PM
> *To:* gnucash-user at gnucash.org <gnucash-user at gnucash.org>
> *Subject:* [GNC] Importing Transactions from CSV
> My credit card company recently stopped publishing their transactions in
> OFX format.  They now 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?
>
> Is there any way to streamline the import of this data without modifying
> the CSV file to move negative numbers to another column? I suppose I
> could write a python script to do this automatically, but I was
> wondering if I am missing something in Gnucash.
>
> Thanks!
>
> Mike
> _______________________________________________
> 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.