Advanced Portfolio Report

Mike Alexander mta at umich.edu
Mon Jan 20 18:28:06 EST 2014


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?

> 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.

> 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?

> 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.

                Mike




More information about the gnucash-user mailing list