Hi John,
Thanks for the feedback. Always learning. Let me answer.
I did check whether this was a currency exchange rate issue. But I'm sure
it's not because:
(a) I imported daily prices to gnucash prior to export and I
pre-converted the currencies using the same price. In this case, the AUD to
PHP on 02/27/2020 is 33.54241157. That is the same price I use to
pre-convert. So 1678.08*33.54241157 = 56286.85. So unless gnucash uses
other means to calculate, it couldn't be an exchange rate issue.
(b) Why is it then that when I import the same 2 transactions one at a
time, the issue does not happen?
(c) It could be purely coincidental but the amount in 1st transaction
(AUD to AUD so no conversion) is AUD 1486.00 and that is precisely what
gnucash.
Thanks for feedback on images. I'm recreating the scenarios below for
reference:
Test 1:
Import:
Withdraw Deposit
02/21/2020,test first transaction,Account 1 in AUD,1486,0,,
,,Account 2 in AUD,0,1486,,
02/27/2020,test second transaction,Account 1 in AUD,0,1678.08,,
,,Account 3 in PHP,56286.85,0,,note- conversion price stored in gnucash is
is 33.54241157. That is the same price I use to pre-convert.
So 1678.08*33.54241157 = 56286.85
Result:
02/21/2020,test first transaction,Account 1 in AUD,1486,0
,,Account 2 in AUD,0,1486
,,,,
02/27/2020,test second transaction,Account 1 in AUD,0,1486
,,Orphan,,192.08
,,Account 3 in PHP,56286.85,0
,,Trading:CURRENCY:PHP,1678.08,
,,Trading:CURRENCY:USD,,1678.08
Test2: 2 imports. 1 by 1
Result: Correct
02/21/2020,test first transaction,Account 1 in AUD,1486,0,,
,,Account 2 in AUD,0,1486,,
02/27/2020,test second transaction,Account 1 in AUD,0,1678.08,,
,,Account 3 in PHP,56286.85,0
On Fri, Aug 14, 2020 at 12:42 AM John Ralls <jra...@ceridwen.us> wrote:
> 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 <gbacar...@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@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.
>
>
--
cheers,
Gio
_______________________________________________
gnucash-user mailing list
gnucash-user@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.
