If dividends are reinvested, they do add to the cost basis. Wouldn't that be considered "Money In" by the Advanced Portfolio Report? Or is it only "New" money?
I think that the dividend income and security purchase or zero share security reference split lines need to be in the same transaction for the APR to assign the dividends to the correct security. Then, if "Money In" does include the reinvested dividends, the report should find them. On Wed, Dec 8, 2021 at 12:09 PM 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. > -- 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.
