Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

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

Questions on using, creating, or understanding data in Fund Manager reports.

Postby sushi512 » Sun Feb 24, 2019 12:21 am

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!
Attachments
openlot_report2.jpg
record of transaction
openlot_report2.jpg (82.88 KiB) Viewed 1480 times
openlot_report.jpg
result in open lot report
openlot_report.jpg (231.33 KiB) Viewed 1480 times
sushi512
 
Posts: 2
Joined: Sat Feb 23, 2019 11:54 pm

Postby Mark » Sun Feb 24, 2019 7:47 pm

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.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby sushi512 » Mon Feb 25, 2019 10:50 am

Mark,

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

Best,
Nils
sushi512
 
Posts: 2
Joined: Sat Feb 23, 2019 11:54 pm


Return to Reports

Who is online

Users browsing this forum: No registered users and 5 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.