[GNC] Potential issue with inversion of currency conversion rate during CSV import of transactions

[Bjoern]

Hi,

I have submitted it under https://bugs.gnucash.org/show_bug.cgi?id=799082 .


Kind regards
Bjoern


Am 11.09.2023 um 21:24 schrieb Geert Janssens:
> Hi,
>
>
> That looks like a bug indeed. To make sure this doesn't get lost on the mailing list, can you file a bug report for this in bugzilla please ?
>
>
> Regards,
>
>
> Geert
>
>
> Op zaterdag 9 september 2023 13:51:39 CEST schreef Bjoern:
>
>  > Hi!
>
>  >
>
>  > I came across a potential issue with the use of the correct rate for
>
>  > cross-currency transactions during CSV imports where I hope others here
>
>  > could reproduce the issue or tell me where I took a wrong turn during
>
>  > thinking.
>
>  >
>
>  >
>
>  > use case:
>
>  > As a German national I live and work abroad in Sweden temporarily. I have
>
>  > both DEU and SWE bank accounts. Salary comes via the DEU account in EUR,
>
>  > which I transfer to the SWE account to cover local expenses in SEK. I use
>
>  > GnuCash to track personal expenses.
>
>  >
>
>  > The main, or up until recently only, currency I have used in GnuCash is the
>
>  > EUR so all expense accounts are in that. To avoid duplicate accounts for
>
>  > each expense in both EUR and SEK I convert spent SEK to EUR when filing the
>
>  > transactions to the existing GnuCash accounts already in EUR.
>
>  >
>
>  >
>
>  > issue:
>
>  > When using the CSV transactions import feature for the SWE bank statements
>
>  > GnuCash uses the reciprocal value of the available conversion rates
>
>  > displayed. In other words, the transaction dialogue states it would go from
>
>  > SEK to EUR when in fact after the import the transaction would register as
>
>  > if the conversion had been done for EUR to NOK instead. Given the rates the
>
>  > effect on values is quite pronounced.
>
>  >
>
>  >
>
>  > notes:
>
>  > The manual input of cross-currency transactions into GnuCash works as
>
>  > intended. I use the trading account feature.
>
>  >
>
>  > I included an example book for further testing.
>
>  > Conversion rates (10 SEK to 1 EUR) and expense values are roughly realistic.
>
>  > So the imported transaction for "butter" costing 40 SEK in realiter should
>
>  > account for as 4 EUR in the groceries expense and not the registered 400
>
>  > EUR (1 SEK to 10 EUR erroneously). Attached as well is a mock CSV statement
>
>  > for the SWE bank to use during import.
>
>  >
>
>  >
>
>  > software details:
>
>  > GnuCash Version: 5.3 Build ID: 5.3+(2023-06-26) with Finance::Quote: 1.57
>
>  > Windows 10
>
>  >
>
>  >
>
>  > Thanks and kind regards
>
>  > Björn
>
>
>