Invest Perf Rpt - Yield picks up data outside date range

[twj332]

I run Investment performance report for example:
on a sub portfolio for last 3 months
the report gives me the investment, beg NAV, Distrib end NAV etc...
Issue is that some investments are showing distributions outside the 3 month date range - some going back to Oct 2009 - and date range of report is 25/10/2010 - 25/01/2011
Help indicates: Distrib. Sum of any distributions during the date range in distributions/share.

Your help in this matter would be appreciated.
Terry

[Mark]

Hi Terry,

It should only include distributions within the date range of the report. Are you running this report, and listing by investment, or something else? If you are listing by investment I would suggest clicking on a line item in question, and look in the Data Register under the "Distributions (all)" data type to see what you have recorded. Make sure you are sorting by date in the Data Register to help find the distributions affecting this report.

[twj332]

This is exactly what I am doing:
Open portfolio
select sub portfolio
click reports tab at top and drop down I select Investment Performance & Report Setting dialogue box opens and I make following selections:
Title: Investment Performance, Type: Investment Performance, Subtotal By: (not selected), Filter (no filter selected), Hide Totals In footer: (not selected), Period: Last 3 months
Report is opened listing: Date range is 28/10/2010 to today, with 7 columns: Investment, Beg NAV, Distrib., End NAV, Gain, % Gain-F, Return.
Several of the investments have small amounts in Distrib. (I assume from first share issued of div as cash not reinvested but wonder why picking up if outside date range)
So for example:
Enbridge from Rpt shows: Distrib. of 0.43 - if I click on this item the data register opens - I select Distributions All and I find 0.37 recorded 16/11/09 (well outside my report date range) & no item to match the 0.43 showing up in report.
SunLife from Rpt shows: Distrib. of 0.36 - if I click on this item the data register opens - I select Distributions All and I find 0.36 recorded 31/12/09 (in case too outside date range but at least I can see the item.)

Of concern is some items in report do not match data register

Please provide some direction
Terry

[Mark]

Hi Terry,

It sounds like there are 2 issues:

1) Distribution being reported, that isn't in the date range. If you're sure you're looking at all the distributions, and don't see one in the date range, please email me an example investment file, and I'll take a look.

2) Wrong amount for distribution. Please note that this report is showing the distribution per share, which may very well be different than the distribution amount, as the distribution per share is the distribution amount, divided by the number of shares owned when paid. See the "Dist/Shr" column in the Data Register. If this doesn't explain it, please send me an example investment file.

[twj332]

Thanks Mark - I have looked through every thing. Thought your point about the per share amount makes me understand the issue I am having.

Thanks for your help - its all good.