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
_______________________________________________ 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.
