[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