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

[Thomas]

Maybe something along the lines of "Money Invested"?

On Thu, 9 Dec 2021 at 13:26, D <sunfish62 at yahoo.com> wrote:
>
> 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, at 06:39, Thomas <tduellmann+gnucashuser at 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 <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.
>>
>> ________________________________
>>
>> 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.