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

2021-12-09 Thread Thomas
Maybe something along the lines of "Money Invested"?

On Thu, 9 Dec 2021 at 13:26, D  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  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  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  
 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 
>  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.
>>>
>>>
>>>
>>> 

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

2021-12-09 Thread D via gnucash-user
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  
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  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
> 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
>
>> >> 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 Nabbl

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

2021-12-09 Thread Thomas
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  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  
> > 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 
> >> 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 

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

2021-12-08 Thread David Carlson
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  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 
> 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 
> >> 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.
> 

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

2021-12-08 Thread Richard Ullger
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  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 
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.


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

2021-12-08 Thread Thomas
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  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 
> 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.


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

2021-12-08 Thread David Carlson
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 
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.


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

2021-12-08 Thread Tom Teixeira

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.


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

2021-12-08 Thread Thomas
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 also tried to decipher the template definition in GitHub, but
unfortunately, I couldn't identify what I would need to do to achieve
my goal.

Version: 4.8
Version-ID: 4.8a+(2021-09-28)

Thanks a lot in advance!

Best,
Thomas
___
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.