search

quentinsf / icsv2ledger

Interactive importing of CSV files to Ledger
196 stars 70 forks source link

No way to have multiple currencies #127

Open yisraeldov opened 5 years ago

yisraeldov commented 5 years ago

If I have a file with the currency symbol for credit and debit, the currency symbol is stripped and the transaction is not balanced.

Example CSV:

07/02/19,ALIEXPRESS,$ 12.40,₪ 46.32,
07/02/19,ALIEXPRESS,$ 8.29,₪ 30.97,
07/02/19,ALIEXPRESS.COM,$ 10.98,₪ 41.02,

this will result in transactions like:

2019-02-03 * ALIEXPRESS.COM
    ; MD5Sum: c4d25e113867328107d41df888567599
    ; CSV: 03/02/19,ALIEXPRESS.COM,$ 7.60,₪ 28.34,
    Expenses:Unknown                                                ₪ 7.60
    Liabilities:CreditCard:CalFix                                   ₪ -28.34

2019-02-03 * ALIEXPRESS.COM
    ; MD5Sum: ec1c415dbec58336d539fe46a279bf8b
    ; CSV: 03/02/19,ALIEXPRESS.COM,$ 3.36,₪ 12.53,
    Expenses:Unknown                                                ₪ 3.36
    Liabilities:CreditCard:CalFix                                   ₪ -12.53

2019-02-03 * WWW.ALIEXPRESS.COM
    ; MD5Sum: 1e95004ef338600cfd343c75c88d5b82
    ; CSV: 03/02/19,WWW.ALIEXPRESS.COM,$ 10.58,₪ 39.45,
    Expenses:Unknown                                                ₪ 10.58
    Liabilities:CreditCard:CalFix                                   ₪ -39.45

There should be a way to just get the raw transaction.