[GNC] CSV Importer - Debit vs Credit

[Paul Kroitor]

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.ca at gnucash.org> On Behalf Of Deva via gnucash-user
Sent: Thursday, July 4, 2024 12:15 PM
To: gnucash-user at 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" <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? 

_______________________________________________
gnucash-user mailing list
gnucash-user at 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.