Hi Andreas, Thank you very much for creating this great tool that I came across when looking for an alternative to the now closed application “StockMarketEye”.
I have noticed that the issue of importing dividends from a csv file where the transaction currency differs from the account currency, has been discussed several times in the past. However, the issue seems still to be unresolved - at least the ways I have tried.
When importing a csv file with dividend records for a mix of USD and EUR securities into an account managed in DKK, the import function doesn’t recognise the currency exchange rate, even if it is correctly mapped in the import wizard. I am using the “Account transactions” type of data, but the “Portfolio transactions” gives the same issue.
If I try to record a manual dividend transaction, I can get by without the exchange rate. When you look at the steps for a manual registration of dividend (Transaction / Dividend…) where the security currency differs from the currency of the Cash Account the following fields could be mapped:
The Gross value in DKK is calculated based on the Gross Value in USD divided by the exchange rate that the system has picked up. I can manually enter a different gross value, so it fits with my bank statement and input file:
I then add the taxes, and the end result provides the net amount (Credit Note) in DKK that is posted to my Cash Account.
If I then try to post these values as my csv test file, which are the exact same I use for manual entry, I run into problems
Security Name;Cash Account;Date;Shares;Value;Gross Amount;Taxes
Oracle Corporation;Pension Nordnet - Ratepension;2020-01-24;167;0,24;270,92;40,64
The Exchange Rate is mentioned as an optional field, but nevertheless I get an error message that it is missing.
Allow me to humbly offer a solution for your evaluation:
Could a dedicated “Dividend transactions” type of data mapping with EITHER Gross Amount OR Exchange rate as mandatory fields be a possible solution to this issue?
Again, Thank you for a great product.