[GNC] Help with mult-currency multi-split import

[John Ralls]

You're relying too much on images to tell your story, made worse by the fact that the list server doesn't work with inline images. Have a look at your message in the archive: https://lists.gnucash.org/pipermail/gnucash-user/2020-August/092596.html

What's more, you've blanked out most of the account names on the images, and the main comment on the register image seems incomplete. If for some reason you think that your account names reveal too much about your finances, replace them with fake names so that the viewer can track the account flow through the process.

To the "why is this here" question on that image, the arrow is pointing to 1468.00. That's the amount of AUD in your imported transaction. The last image, annotated "It Works" has the AUD amount as 1678.08. ISTM that rather indicates that it doesn't work. ISTM the question should be "where does that 168.08 come from?" and I think it comes from using the wrong exchange rate between AUD and whatever the other currency is, resulting in 56286.05 being calculated as 1678.08 AUD. 168.08 = 1678.08 - 1468.00, the amount needed to balance the transaction.

I think that the work around is to specify a price in multi-commodity imports, but I'm not as familiar with the csv importer as I should be so I can't say authoritatively that it will work.

Regards,
John Ralls

> On Aug 13, 2020, at 4:16 AM, Gio Bacareza <gbacareza at gmail.com> wrote:
> 
> I maintain multi-currency accounts. I rely on monthly or quarterly
> statements to enter the transactions into Gnucash. So I rely on the import
> feature.
> 
> Without a reliable import, a system will be too manual for me. So it is
> vital that import works.
> I know that multi-currency imports have been a known issue but I thought I
> had found a solution through correctly doing a multi-split in this manner:
> Date Description Accounts Debit Credit
> mm/dd/yyyy Some description Account Amount in currency 1 0
> Transfer Account 0 Amount in currency 02
> 
> I've tested this with dummy data as well as real information. So far it has
> worked.
> 
> Except my last import. The import was a real mess so I had a little
> experiment. I set it up by taking samples from the actual data.
> Scenario 1: 2 transactions. 1 has conversion. 1 no conversion.
> 
>   1. Set up the import
> 
> [image: image.png]
> 
>   1. Match the accounts
> 
> [image: image.png]
> 
> 
>   1. In "Match Transactions" step, it was already exhibiting weird
>   behaviors.
> 
> [image: image.png]
> 
> 
>   1. Checking the registry, Gnucash added in an amount from the first
>   transaction and completely wrongly assigned transactions in the split. I
>   can't figure out why it does that.
> 
> [image: image.png]
> 
> Checking if it's an exchange rate issue, I find that it's not an exchange
> rate issue. The precalculated conversion uses the same exchange rate as was
> imported to gnucash.
> Scenario 2: Import same 2 transactions above one at a time.
> 
> So to test and try to understand what is happening, I took the same
> transactions and, using the same structure, imported them one at a time.
> [image: image.png]
> [image: image.png]
> 
> Am I missing anything?
> 
> If I have to import these 1 by 1, I might as well just manually enter them
> into the registry. This is a deal breaker.
> 
> Any help is appreciated. Thanks.
> 
> -- 
> cheers,
> 
> Gio
> <image.png><image.png><image.png><image.png><image.png><image.png>_______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.