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

D sunfish62 at yahoo.com
Thu Dec 9 07:26:05 EST 2021


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+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.


More information about the gnucash-user mailing list