[GNC] Capital losses in Advanced Portfolio Report

David Carlson david.carlson.417 at gmail.com
Mon Oct 22 18:20:43 EDT 2018


Christian,

You are referring to the "Tutorial and Concepts Guide where it says:
"Account for the profit or loss as coming from an Income:Capital Gains or
Expenses:Capital Loss account. " (section 9.7.1.1)" I presume, since the
preferred method of accounting for capital losses may vary according to
local laws and/or user preferences.

Whether the advanced portfolio report design is in error is not necessarily
true.

David C

On Mon, Oct 22, 2018 at 1:50 PM Christian Kluge <frakturfreak at gmail.com>
wrote:

> A well defined error is still an error.
>
> Am 22.10.2018 um 00:22 schrieb Christopher Lam:
> > It's hard wired because that's what the report writer wrote, and was
> > merged into gnucash, as a voluntary contribution.
> >
> > It's rather difficult to modify these reports and maintain full
> > compatibility with everyone who has used them previously and expect the
> > report output to be predictable. Often the report behaviours are only
> > discovered by users reporting unusual behavior.
> >
> > As discovered here this report expects transfers from STOCK/FUND
> > accounts to
> >
> >  * ASSET/LIABILITY for stock/fund purchases/sales
> >  * INCOME for capital gains/losses
> >  * EXPENSE for transactional costs eg brokerage fees
> >
> >
> > This is now well-defined (albeit not well documented yet), works well
> > within the Gnucash engine. IMHO the report shouldn't be modified.
> >
> > On 22/10/18 2:39 am, Christian Kluge wrote:
> >> Hi,
> >>
> >> isn’t this hard wiring and expecting bad style? Could you make in a way,
> >> to select the both account types for the report?
> >>
> >> I’d feel confortable making a debit entry to an income account if it
> >> isn’t either a contra-income account like rebates or cash discounts or
> >> as a correction entry on a normal standard income account.
> >>
> >> Kind regards
> >>
> >> Christian Kluge
> >>
> >> Am 21.10.2018 um 16:35 schrieb John Ralls:
> >>> That’s because the Advanced Portfolio Report is hard-wired to expect
> >>> capital gains and losses to be posted to an income report with gains
> >>> as credits and losses as debits.
> >>>
> >>> Regards,
> >>> John Ralls
> >>>
> >>>
> >>>> On Oct 21, 2018, at 3:18 AM, José A. Fernández Troncoso
> >>>> <jstroncoso at gmail.com> wrote:
> >>>>
> >>>> Yes, when I create a sale transaction on the stock, a capital loss is
> >>>> calculated automatically by the report and shown as a negative
> >>>> amount in
> >>>> the Realized Gain column. That's fine by me.
> >>>>
> >>>> The problem is that when I add a split to record the loss manually on
> >>>> the Expenses:Capital Loss acount, the amount recorded on the stock
> >>>> acount split (in the Total Sell column) is then added to the Income
> >>>> column of the report, as if it were a dividend.
> >>>>
> >>>> Regards,
> >>>> Jose
> >>>>
> >>>> On Saturday, October 20, 2018 at 10:14:59 PM CEST Richard Ullger
> wrote:
> >>>>> On 20/10/2018 17:19, José Antonio Fernández Troncoso wrote:
> >>>>>> Hello,
> >>>>>>
> >>>>>> In my advanced porfolio report, capital losses linked to a stock
> >>>>>> account are added to the Income column as if they were dividends.
> >>>>>>
> >>>>>> Could anyone using this report provide some feedback as to whether
> >>>>>> this also happens to them? Is there a bug in the report or am I
> >>>>>> doing something wrong?
> >>>>>>
> >>>>>> I'm using GnuCash Version: 3.2. Build ID: 3.2+ (2018-06-24).
> >>>>> I've been using this report for some time and have never seen this
> >>>>> behaviour. I'm currently using Build ID: git 3.3+ (2018-09-29)
> >>>>>
> >>>>> The income column reflects the income that I have recorded against
> the
> >>>>> stock.
> >>>>>
> >>>>> A capital loss is shown as a negative amount in the Realised Gain
> >>>>> column. However there appears to be a bug in the amount of Realised
> >>>>> Gain. The report seems to try to calculate the gain/loss rather than
> >>>>> report on any gain/loss recorded against the stock.
> >>>>>
> >>>>> A loss in the valuation is shown as a negative amount in the
> >>>>> Unrealised Gain column.
> >>>>>
> >>>>> Regards,
> >>>>>
> >>>>> Richard.
> >>>>>
> >>>>> _______________________________________________
> >>>>> gnucash-user mailing list
> >>>>> gnucash-user at gnucash.org
> >>>>> To update your subscription preferences or to unsubscribe:
> >>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>>> If you are using Nabble or Gmane, please see
> >>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>>>> -----
> >>>>> Please remember to CC this list on all your replies.
> >>>>> You can do this by using Reply-To-List or Reply-All.
> >>>>
> >>>>
> >>>> _______________________________________________
> >>>> gnucash-user mailing list
> >>>> gnucash-user at gnucash.org
> >>>> To update your subscription preferences or to unsubscribe:
> >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>> If you are using Nabble or Gmane, please see
> >>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>>> -----
> >>>> Please remember to CC this list on all your replies.
> >>>> You can do this by using Reply-To-List or Reply-All.
> >>> _______________________________________________
> >>> gnucash-user mailing list
> >>> gnucash-user at gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> If you are using Nabble or Gmane, please see
> >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>> -----
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>>
> >>
> >> _______________________________________________
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -----
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list