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.
