Advanced Portfolio Report

[Richard Ullger]

Mike,

On 20/01/14 23:28, Mike Alexander wrote:
> I'm sorry you find the new version so unacceptable.  I've put a few
> comments below.  If you could create a bug reprot and attach some
> documents illustrating some of the problems, that would help deal with
> them.
> 
> --On January 20, 2014 9:08:33 PM +0000 Richard Ullger
> <rullger at gmail.com> wrote:
> 
>> The new version of the report is reporting brokerage in the realised
>> gain column as a negative amount, changing the total gain and Rate of
>> Return % columns. In my opinion this is incorrect, regardless of
>> whether 'Ignore brokerage fees when calculating returns' is selected.
>> Brokerage is reported in the Brokerage Fees column and taken into
>> account in the Total Return column.
> 
> I didn't change this.  I also didn't design it this way in the first
> place, but I suspect it  was done this way because that's the way US
> income tax wants it done.  In the US brokerage fees are subtracted from
> the gain for income tax purposes.  It might be more correct to add them
> to the basis (that's the way the IRS describes it), but subtracting them
> from the gain has a similar effect.
> 
> What do you think 'Ignore brokerage fees when calculating returns'
> should do?  Or do you think the option should be removed entirely?  Or
> am I completely misunderstanding what you're talking about?

In previous versions of the report, brokerage was not taken into account
in the Realised Gain column. The 'Ignore brokerage fees when calculating
returns' setting determines whether the brokerage column is displayed
and the figure taken into account in the Total Return column.

>> The income column is incorrect. Although different from the income on
>> the original report which is also incorrect, it is reporting the
>> reinvested income, not the actual income received. The old report
>> would only include income if it was recorded as a split in the
>> reinvestment transaction, but was still reporting an incorrect
>> amount. I have recorded dividends as an income split in a
>> reinvestment transaction, but that is not the income reported in the
>> Income column on the report. The report shows the amount reinvested
>> in shares including the charges.
> 
> What income is it not reporting?  Dividend income?  In order for it to
> be shown you must include a split tying the transaction to the stock
> account as described in
> <https://bugzilla.gnome.org/show_bug.cgi?id=581191>.   Otherwise the
> report will never see it.  Is this the problem you're having?   If not
> please let me have an example of the problem.
> 
> I just checked again and both reinvested and non-reinvested dividend
> income is showing up in the Income column.  Reinvested dividends also
> affect the basis, as they should.

If income of say 374.92 is entered in the stock account with one blank
split line tying the income to the stock account, that income is
correctly recorded on the report. For example,

Acc		Tot Buy		Tot Sell
Stock Account					(Blank split)
Income				374.92
Cash		374.92

If the income is entered as a split of a dividend reinvestment where you
have a stock purchase, the income recorded on the report is the
consideration of 366.95 instead of the actual income of 374.92. For example,

Acc		Tot Buy		Tot Sell
Stock Account	366.95
Commission	3.66
Stamp Duty	1.83
Cash				372.44
Income				374.92
Cash		374.92

The reason I have been recording income as a split of the reinvestment
is because when I first started using the report some years ago, this
was the only way that income would be included on the report.

> 
>> The Total Return column is not including residual income, that is,
>> income not reinvested.
> 
> Is this the same problem as previous paragraph?  If not what is it?

Yes, that sentence followed on from the previous paragraph.

> 
>> The Money In and Brokerage Fees columns are now correct on the new
>> report.
>>
>> Additionally, charges from share sales are not being included in the
>> Brokerage Fees column. This was also the case in the original report.
> 
> Are you sure?  It works for me.  I presume you're talking about
> commissions and other broker fees.  I just tried it again to be sure.
> Again if you have an example file where it doesn't work, that would be
> useful.

This is working on the latest version of the report.

Regards,

Richard.