[GNC] CSV Importer - Debit vs Credit

[wheelercsg-lists at yahoo.com]

Hi, Paul,

I have a TD Bank account, so I looked at the available options. If you 
choose "Microsoft Money", that appears to result in an OFX download. I 
usually choose "Intuit Quicken", because that results in a QFX download, 
which GnuCash can import.

On 2024-07-04 12:00 p.m., gnucash-user-request at gnucash.org wrote:
> Date: Thu, 4 Jul 2024 11:30:29 -0400
> 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?
>