You can do this with hledger's CSV converter, using "amount-in" and
"amount-out".
http://hledger.org/csv.html#csv-amounts -> CSV Amounts
On 10/24/18 5:44 PM, Emile Cantin wrote:
I have this issue too; my bank exports "credit" and "debit" columns.
Savings accounts and loans are even crazier; they have separate columns for
interest, credit, and debit. A loan payment is counted as part interest,
part credit on the principal. Credit card accounts are of course yet
another format.
I did some very heavy pre-processing on these files using Node.js (I'm a JS
dev, so that's my personal poison), but I'm still not really happy with the
result.
I'm eager to see what others have to say on this one.
Emile
Le mer. 24 oct. 2018 à 15:15, <[email protected]> a écrit :
I'm trying to use the built in Ledger convert command to import a .csv
downloaded from my credit card company which has separate columns for
credit and debit amounts. Only one of these is filled so most transactions
are an entry in the debit column and the credit column is empty but for
e.g. a payment the debit column is empty and the credit column has the
amount. I can't figure out how to do this with convert as it doesn't like
an empty 'amount' column and I don't see a way to specify debit/credit
separately.
Is there a way to do this directly using the convert command or do I need
to do some pre-processing or use a different csv conversion tool?
--
---
You received this message because you are subscribed to the Google Groups "Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
