[GNC] Importing Transactions from CSV

Murugan Muruganandam m.muruganandam at hotmail.com
Thu Dec 15 07:58:38 EST 2022


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.


More information about the gnucash-user mailing list