Well, it seems that "Money In" is an ambiguous phrase. Perhaps there is a better term that this report could use instead? "Purchase Cost" comes to mind....
On Dec 9, 2021, 06:39, at 06:39, Thomas <tduellmann+gnucashu...@gmail.com> wrote: >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. _______________________________________________ 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.