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.