[GNC] importing csv multisplit multicurrency problems

Gio Bacareza gbacareza at gmail.com
Thu Mar 5 08:14:56 EST 2020


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

-- 
cheers,

Gio


More information about the gnucash-user mailing list