[GNC] CSV Importer - Debit vs Credit

[devaps at asia.com]

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" <paul at kroitor.ca>
To: <gnucash-user at 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?