Reporting distributions in different currencies

[pg888]

I have a US$ portfolio and a £ portfolio, and I need to report both in both currencies.

To achieve this I have the setup that I described in the last post of this topic - http://www.fundmanagersoftware.com/forum/viewtopic.php?f=4&t=707. In summary my default currency is £ and I have exchange rates set up in Currency Settings to enable the switch to $.

I have daily prices imported for the two currencies.

This works just fine for viewing prices of investments. I can switch Exchange Rate Adjusted on and off and (a) the portfolio (and historic graph) values change from one currency to another and (b) the capital gains tax report changes the gains or losses from one currency to the other. This is great.

However, the distributions (dividends) report does not do this. It remains stuck in each investment's currency. So say I have a dividend of £20 on a £ investment, when I switch to Exchange Rate Adjusted it will not show up in $, it just stays as the £20 amount.

I don't understand why investment prices change but distribution amounts do not.

Any guidance would be appreciated.

[pg888]

I've just ascertained that weirdly the reporting of dividends in different currencies IS working, except for one stock (the one I'm trying to report). When I report a bunch of stocks the £ dividends change to $ no problem, EXCEPT for this one stock.

I cannot see the difference between that one and the others. In properties they are all set up as Stocks and their currency is £. The dividends are all entered in the same way (as dividends), and they all show up in the Distributions report in the Dividends column, it is just that this one stock doggedly remains in £ when the others happily switch to $.

Is there some other setting for an investment that could affect this?

[Mark]

Hi pg888,

There are no other settings that could affect this. One possibility is you have pounds listed twice in the list of currencies, and you have the exchange rate assigned to only one of them, but this one investment is assigned to the other pounds. It would still show as pounds in the investment property, but it would be a different position in the currency list. Could this be the problem?

[pg888]

Mark

Thanks, that was indeed the case. Because I have £ as the default currency and another £ for conversion to $, there are indeed 2 £ options for currency in the Investment Properties, and I had selected the default rather than the $ conversion.

Thanks for your help, it's all working as it should now.

Peter