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....@gnucash.org> on
behalf of M <m_st...@hotmail.com>
*Sent:* Wednesday, December 14, 2022 11:15 PM
*To:* gnucash-user@gnucash.org <gnucash-user@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@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.
