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

[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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test book.gnucash
Type: application/x-gnucash
Size: 27463 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230909/2a9fcaca/attachment-0001.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test book - SWE bank statement.csv
Type: application/vnd.ms-excel
Size: 46 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230909/2a9fcaca/attachment-0001.xlb>