[GNC] importing csv multisplit multicurrency problems

Geert Janssens geert.gnucash at kobaltwit.be
Thu Mar 5 12:01:02 EST 2020


There are several bugs with multi-currency csv imports. I don't think it's 
currently possible to do such imports. Sorry.

Geert

Op donderdag 5 maart 2020 14:14:56 CET schreef Gio Bacareza:
> I'm encountering problems with importing transactions in csv when accounts
> have different currencies.
> 
> I've been reading the debates. So this is not about definitions of
> multi-split or terminology.
> 
> I did a test with a sample csv with the following contents:
> 
> Date,Description,Account,Deposit,Withdrawal
> 1/3/2019,Description,test_foreign,,200
> ,,Trading:CURRENCY:PHP,,10013
> ,,Trading:CURRENCY:USD,200,
> ,,test_local,10013,
> 
> gnucash imported successfully but it created an extra line Imbalance-USD.
> See results below:
> Date   Description   Account   Deposit   Withdrawal
> 1/3/2019   Description                             200
>       Trading:CURRENCY:USD   197.78
>       test_local   10013
>       Imbalance-USD   2.22
>       test_foreign                                         200
>       Trading:CURRENCY:PHP                  10013
> 
> 1. Why does it do that when imported transactions is already balanced in
> the first place?
> 2. When I try to manually correct in gnucash (197.78->200), it wouldn't
> allow me. It keeps the imbalance no matter what I do.
> 3. How do I solve this?
> 
> Thanks,
> 
> gio






More information about the gnucash-user mailing list