Mike, Gnucash can import a single amount column with deposits as negative amounts and withdrawals as positive amounts without any problem. You may have to experiment with whether to apply the Deposits or Withdrawals header to that data column depending on how the bank has used the signs, to get a correct import. I've forgotten whether GnuCash remembers the header/column assignments in the stored import conditions as I rarely import CSV data these days but I think it does, so once you have a set of import conditions that work you can save them and then recall them anytime you need to import from that source. https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html https://wiki.gnucash.org/wiki/CSV_Import/Export
David Cousens On Wed, 2022-12-14 at 21:15 -0500, M wrote: > 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.
