As an after-thought, put minus sign in front of lines with credits and
payments to minimize number of edits, and then adjust your amount column as
withdrawal (or credit based upon your books settings). The minus sign will
move the amount over to "deposit" side. Once you are satisfied how it
imports, you can save that as a template to use it next time in the future
so you don't have to figure it out again.

-----Original Message-----
From: Kalpesh Patel <kalpesh.pa...@usa.net> 
Sent: Thursday, July 04, 2024 12:59 PM
To: 'Paul Kroitor' <p...@kroitor.ca>; 'gnucash-user@gnucash.org'
<gnucash-user@gnucash.org>
Subject: RE: [GNC] CSV Importer - Debit vs Credit

Sadly, you will have to do some pre-processing before import. Put minus sign
in front of debits or credits, depending upon how the book is setup. GNUCash
does not have a conditional way of importing data in CSV by looking at a
column. CSV files can be edited in any text editor.

-----Original Message-----
From: Paul Kroitor <p...@kroitor.ca> 
Sent: Thursday, July 04, 2024 11:30 AM
To: gnucash-user@gnucash.org
Subject: [GNC] CSV Importer - Debit vs Credit

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.

Reply via email to