Re: [GNC] Potential issue with inversion of currency conversion rate during CSV import of transactions
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.
Re: [GNC] Potential issue with inversion of currency conversion rate during CSV import of transactions
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.
[GNC] Potential issue with inversion of currency conversion rate during CSV import of transactions
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.