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? > > Thanks, > > Matt. > > -- > > --- > 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. > -- --- 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.
