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

Thomas tduellmann+gnucashuser at gmail.com
Wed Dec 8 12:36:50 EST 2021


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.


More information about the gnucash-user mailing list