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
test book.gnucash
Description: application/gnucash
test book - SWE bank statement.csv
Description: MS-Excel spreadsheet
_______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
