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