[GNC] Advanced Portfolio Template: Population of data with dividends

[Thomas]

Thanks for the clarification Richard!
it seems like the dividends are added in another column that I did not
look into as I always expected to see the dividends in the 'money in'
column.

Thanks to all of your feedback!

On Wed, 8 Dec 2021 at 19:09, Richard Ullger <rullger at gmail.com> wrote:
>
> I recall the discussions that took place on the mailing list years ago
> when fixing up the Advanced Portfolio Report.
>
> The 'Money In' column reflects only the actual cash You have used to
> purchase the security. Dividend and interest income is included in the
> 'Income' column only and not in the 'Money In' column.
>
> 'Basis' does include the cost of the security whether bought from your
> own funds or from income.
>
>
> On 08/12/2021 17:36, Thomas wrote:
> > Thanks Tom and David for your quick replies!
> >
> > I actually found that info some time ago as well, but it seems not to
> > do the trick (for me).
> > In the security's account I have the buy transactions (which are taken
> > into account by the advanced portfolio template) and also the dividend
> > payments in a "neutral" transaction as part of the dividend payment
> > transaction. That means that the dividend transaction has multiple
> > accounts involved (translated, so terms might not be 100% accurate):
> > - "Earnings:Dividends" containing the whole amount I get from the company
> > - "Expenses:Taxes" the amount of taxes that was deducted from the above
> > - "Assets:ClearingAccount" the amount that remained after the deduction of taxes
> > - "Assets:Securities:CompanyXY" just added without any amount
> >
> > Is there something I am missing to make it work?
> >
> > Best,
> > Thomas
> >
> > On Wed, 8 Dec 2021 at 16:45, David Carlson <david.carlson.417 at gmail.com> wrote:
> >>
> >> IIRC Tom's suggestion is the key to getting dividends correctly assigned in
> >> the Advanced Portfolio Report.  I cannot find the documentation either, but
> >> there is a lot of information in the Tutorial chapter on investments <
> >> https://gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=guide>
> >>
> >> On Wed, Dec 8, 2021 at 9:36 AM Tom Teixeira <tjteixeira at earthlink.net>
> >> wrote:
> >>
> >>> On 12/8/21 10:09 AM, Thomas wrote:
> >>>> Dear User-List,
> >>>>
> >>>> I successfully populated the advanced portfolio template with most of
> >>>> the data by selecting of all the accounts of my securities.
> >>>> What I did not manage to get filled is the "money in" column, to also
> >>>> include received dividends in the calculations. I tried to add the
> >>>> accounts with the dividends, but that was not successful.
> >>>> My question essentially is, how to properly fill the "money in" column
> >>>> with dividends.
> >>>
> >>> I don't remember where it is in the manual, but add a split to the
> >>> dividend transaction and include the asset account for the stock. You
> >>> shouldn't have to enter any amount for the stock itself unless you are
> >>> reinvesting some or all of the dividend.
> >>>
> >>>
> >>> _______________________________________________
> >>> 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.
> >>>
> >>
> >>
> >> --
> >> David Carlson
> >> _______________________________________________
> >> 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.