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.
