[GNC] CSV Importer - Debit vs Credit
Kalpesh Patel
kalpesh.patel at usa.net
Thu Jul 4 12:59:10 EDT 2024
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 <paul at kroitor.ca>
Sent: Thursday, July 04, 2024 11:30 AM
To: gnucash-user at 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?
More information about the gnucash-user
mailing list