[GNC] CSV Importer - Debit vs Credit

Kalpesh Patel kalpesh.patel at usa.net
Fri Jul 5 07:11:47 EDT 2024


On Windows, those three lines turns to millions of lines ☹.

I just stick with shell in case of *NIX or good old batch on Windows. In theory it is just adding a single comma before or after the value column based on value of another column. 


-----Original Message-----
From: Paul Kroitor <paul at kroitor.ca> 
Sent: Thursday, July 04, 2024 1:17 PM
To: 'Kalpesh Patel' <kalpesh.patel at usa.net>; gnucash-user at gnucash.org
Subject: Re: [GNC] CSV Importer - Debit vs Credit

I can easily write a little Python thingie and put it in my right-click menu, but it's just an added annoyance in this increasingly annoying world.

-----Original Message-----
From: Kalpesh Patel <kalpesh.patel at usa.net>
Sent: Thursday, July 4, 2024 12:59 PM
To: 'Paul Kroitor' <paul at kroitor.ca>; gnucash-user at 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 <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