Re: [GNC] DRP accounts, portfolio reports and making sense of the numbers

2021-08-06 Thread Chris Good
Message: 3
Date: Sat, 7 Aug 2021 10:39:50 +1000
From: Andrew Clark 
To: GnuCash users group 
Subject: [GNC] DRP accounts, portfolio reports and making sense of the
numbers
Message-ID:

Content-Type: text/plain; charset="utf-8"

Somehow my previous email was sent before I had finished typing it.

I have an investment of NAB shares that I acquired as part of their employee
incentive program years ago and I'm trying to figure out the best way to
record it in GnuCash.

The shares were worth $3000 at the time of allotment. They were released to
me at the value of $2732.85. They pay a regular dividend twice a year. That
dividend is reinvested as part of a dividend reinvestment program (DRP).
Any remainder from the DRP is held over until the next cycle.

So take the payment on 2008-12-17.

There was 24.25 held over from the previous cycle.
The dividend was also 24.25.
Total to reinvest is 48.50.
Shares 2 @ 18.64 = 37.28
Remainder held until next cycle 48.50 - 37.28 = 11.22.

[image: image.png]

Now, in the portfolio report, if I set the date ot the date of that
transaction, I get:
[image: image.png]

'Money in' should be $2732.85 but it includes the 13.03 that was used from
the held over dividend? I don't feel like it should, as I have not
contributed any money into the system.

The accounts are laid out as below:

[image: image.png]

Should the DRP Holding account have a different type? Should it be located
somewhere else? Is there a better way to record this?

--
Cheers,

Andrew.
-- next part --
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 30466 bytes
Desc: not available
URL:
<http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210807/55a796
37/attachment.png>
-- next part --
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 25054 bytes
Desc: not available
URL:
<http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210807/55a796
37/attachment-0001.png>
-- next part --
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 5261 bytes
Desc: not available
URL:
<http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210807/55a796
37/attachment-0002.png>

--

Hi Andrew,

I'm also in Australia. I call "DRP Holding" "DRP Residual". I don't know
which is more correct.
This is for my personal accounts.
I am not an accountant. Please check with you accountant.

My structure is as follows:

Assets
Investments
Brokerage Investor1
NAB
...
DRP Residual
NAB

Franking Credit
Investor1
...
Income
Dividend
NAB
Franked
Unfranked
...
Liabilities
Franking Credit Tax Owed
Investor1
...

As it is easy to restructure your chart of accounts just by changing
the account parent, give that a go (backup first).

As part of each dividend transaction, I:
1. only add 1 split for DRP Residual, which is the change in residual
2. Track Franking Credits:
Assets:Investments:Franking Credit:Investor1Dr
Liabilities:Franking Credit Tax Owed:Investor1Cr

After tax is paid and franking credits are used (30th June), clear out
franking credits
Assets:Investments:Franking Credit:Investor1Cr
Liabilities:Franking Credit Tax Owed:Investor1Dr

I use a different self-written system for tracking Franking credits so
you may like to add further subaccounts to your Franking Credit accounts for
stock code.

Regards, Chris Good

___
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] DRP accounts, portfolio reports and making sense of the numbers

2021-08-06 Thread Andrew Clark
Somehow my previous email was sent before I had finished typing it.

I have an investment of NAB shares that I acquired as part of their
employee incentive program years ago and I'm trying to figure out the best
way to record it in GnuCash.

The shares were worth $3000 at the time of allotment. They were released to
me at the value of $2732.85. They pay a regular dividend twice a year. That
dividend is reinvested as part of a dividend reinvestment program (DRP).
Any remainder from the DRP is held over until the next cycle.

So take the payment on 2008-12-17.

There was 24.25 held over from the previous cycle.
The dividend was also 24.25.
Total to reinvest is 48.50.
Shares 2 @ 18.64 = 37.28
Remainder held until next cycle 48.50 - 37.28 = 11.22.

[image: image.png]

Now, in the portfolio report, if I set the date ot the date of that
transaction, I get:
[image: image.png]

'Money in' should be $2732.85 but it includes the 13.03 that was used from
the held over dividend? I don't feel like it should, as I have not
contributed any money into the system.

The accounts are laid out as below:

[image: image.png]

Should the DRP Holding account have a different type? Should it be located
somewhere else? Is there a better way to record this?

-- 
Cheers,

Andrew.
___
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.