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 <rull...@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....@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 <tjteixe...@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@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@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@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@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@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.