Adv Port Report - Capitalization of Commissions

[CDB-Man]

Hi Larry,

I'm on GNUcash 2.6.7.  My Adv Port. options look like this:

http://i.imgur.com/igKDup5.png

When you select from the dropdown "include in basis", it will capitalize
the costs correctly, and reflect the -$5 in the unrealized column, instead
of the realized column.  This lines up with the tax treatment, so it in and
of itself is not an issue.

The issue I'm raising is that for the report to pick up on this, the
commission needs to go to an expense, meaning that on other reports such as
balance sheet, and just in the asset register itself, the costs are not
capitalized into the asset account, since the cost is being sent to an
expense account.

Hope that helps!

Regards,
CDB

*CDB-Man*
*Email:* cdbman.online at gmail.com

On Mon, Dec 28, 2015 at 1:41 PM, Larry Evans <cppljevans at suddenlink.net>
wrote:

> On 12/26/2015 11:03 PM, CDB-Man wrote:
> > Hey everyone,
> Hi CDB-Man,
> >
> > I was talking to jralls over on IRC, and he suggested posing the question
> > to the group here, and more specifically to *Mike Alexander* as well, the
> > maintainer of the Adv. Portfolio Report if he's listening.
> >
> > The conversation is recorded in the #gnucash IRC logs, starting at
> 13:47:26
> > time stamp.
> > http://lists.gnucash.org/logs/2015/11/2015-11-21.html#T13:47:26
> > Most of the issue and my suggested possible solution is detailed in the
> > conversation.
> >
> > *To put it into paragraph form instead:*
> > Essentially, the issue at hand is how the advanced portfolio report
> handles
> > commissions on purchase of securities.  Current behaviour is to only
> > consider an amount as commissions, if the amount is a debit to an expense
> > account.
> >
> > The advanced portfolio report itself will capitalize the commissions into
> > the cost basis if you tell it to do so in the options.
>
> I tried to do what you've suggested here:
>
> https://www.dropbox.com/sh/86jzjk74fjm0h1t/AADHSEVBNC_Fw0oBc-Ukg8doa?dl=0
>
> Could yo please let me know if I got it right?
>
> The Advance Portfolio Report shows a cost basis of $100.00 which doesn't
> reflect the commission of $5.00.  OTOH, the 'Realized Gain" does because
> it shows -$5.00.
>
> Also, I couldn't find the option which "will capitalize the commissions
> into the cost basis".  I only saw, on the General tab:
>
>   [ ] Ignore brokerage fees when calculating return
>
> I'm using Gnucash 2.6.1.  Could you please let me know where
> you found this report option?
>
> -regards,
> Larry
> [snip]
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>