Open Lot Report - Dividends spilling over into ex-div. lots

[sushi512]

Hi everybody,

I'm using the FM personal edition.

Also I'm a big fan of the open lot reports but one detail simply drives me nuts:

I have purchased the same ETF twice = 2 lots in the open lot report

When I record dividends, I make sure to tell FM which was the record date so the software understands which lots actually received the dividends.

In the report, I would then expect a lot purchased after the ex-date to show "0" in the distributions field as dividend are paid.

What happens is this:
An ETF yielded 132 Euros of dividend. Record date was December 13th. Payout was on December 31st.

I purchased a second lot of this ETF on December 28th. This lot was ex-dividend by that time. Still, open lot report claims a fraction of the dividend goes to this lot as well.

Is this intended behavior? If yes, I'd really appreciate if somebody could explain me the logic behind that.

Thank you for your time!

[Mark]

Hi sushi512,

Yes, that is how it will work. The "for shares owned on" is only used for calculating the distribution per share for things like graphing the share price plus distributions. Hopefully we can improve this in the future. If this is an issue, one option you have is to record the 2 lots in 2 separate investments.

[sushi512]

Mark,

thanks for the fast reply. I hope you will find the time to address this issue in the future.

Best,
Nils