Thanks for your quick reply. I did understand those options, and I blame TD for their stupid CSV format, but I'd rather avoid writing a trivial preprocess applet. For the record, if I did so the first approach I would try is simply adding a negative sign to all the debit amounts.
It must be a fairly common request though -- maybe the importer could be enhanced to deal with this situation. -----Original Message----- From: gnucash-user <gnucash-user-bounces+paul=kroitor...@gnucash.org> On Behalf Of Deva via gnucash-user Sent: Thursday, July 4, 2024 12:15 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] CSV Importer - Debit vs Credit Paul, I don’t use the importer, but from reading the list responses, I seem to recall that if you are using a single column for the amount, then deposits and withdrawals should be of opposite sign. So for a bank import, if you choose debits to be positive, then credits must be negative. You can also preprocess the csv file to separate the debits and credits into 2 separate columns, wherein both amounts can remain positive. This is just from memory. I’m sure folks who use the importer will provide better responses. Cheers. ------------------------------ From: "Paul Kroitor" <p...@kroitor.ca> To: <gnucash-user@gnucash.org> Subject: [GNC] CSV Importer - Debit vs Credit Message-ID: <02c201dace27$1a8f5b60$4fae1220$@kroitor.ca> Content-Type: text/plain; charset="us-ascii" I'm sure this has been asked in a dozen different variations over the years but I'm now faced with the issue myself since I now need to use CSV for downloading (I hate TD Bank, who have removed the OFX download option). I can't immediately find any old messages describing this particular issue, so I thought I'd just ask. Simplified, TD Bank CSV downloads only basically have four fields: * Date * Description * "Debit" or "Credit" * Amount (always positive) Import works fine, except that I can't see any way (short of pre-editing the file) to get the CSV importer to understand that the amount field goes in a different column (D or C) depending on a different field's value. This must be fairly common - am I just blind? _______________________________________________ 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.
