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.
