[GNC] Help Selling & Buying Securities

[Jack Frillman]

I sort of got it to work but my cash balance is all messed up.
See attached for the example of my transactions.

In the parent account the cash Balance should be $1,115.05 not $4,676.09 
and I can't figure out why.

Where did I mess up?


On 8/10/21 8:29 AM, Eric Coates via gnucash-user wrote:
> Jack
>
> I'm assuming that your "Invest Account - ABC" is set up as a stock 
> (check using the Edit Account button) and you have set an opening 
> balance of 100 shares of ABC in that account. If that is correct you 
> sell them by an entry similar to the one shown in the attached Sell 
> Shares png but you would show that the cash is paid into your Parent 
> Invest Account (which should be set up as type Asset but with Security 
> /currency set as your base currency.)
>
> After setting up an account "Invest Account - XYZ" buying the XYZ 
> shares can be recorded using an entry similar to that shown in the Buy 
> Shares png again using the Parent Invest Account as the source of 
> funds. (I'm pretty sure that people cleverer than I would do the sale 
> and purchase as one transaction but I prefer to keep things simple. 
> Like what I am!)
>
> However, it seems that a more common hierarchy of accounts would be 
> something like that shown in the Accounts png. Under Assets set up an 
> account (commonly) called after the broker you use - marking it as a 
> place holder. Then under that set up separate accounts for cash  and 
> each of the shares you have (See the notes above as to Type etc). If, 
> at some future point, you want to buy shares using "new money" do a 
> Transfer from (typically) your bank account to the Cash sub account; 
> similarly, selling shares and withdrawing the money is done by a 
> transfer from Cash to the bank account.
>
> There's a good write up of the procedure available at
> https://code.gnucash.org/docs/C/gnucash-guide/invest-buy-stock1.html
> which also deals with commission and taxes. It must be good, it set me 
> right!
>
> Best wishes
> Eric
>
> =======================
> On 10/08/2021 01:34, Jack Frillman via gnucash-user wrote:
>> I'm clueless on how to sell a security and use that money to buy 
>> another security. All I have done to date is reinvest interest & 
>> dividends.
>>
>> I have an account structure that looks like this.
>>
>> Parent Invest Account - This is for holding a cash balance.
>>    ABC - Invest account for ABC security.
>>    XYZ - Invest account for XYZ security.
>>    xxx - Many more investment accounts for xxx securities.
>>
>> I'm selling all 100 shares of the security ABC.
>> I'm going to buy 50 shares of the security XYZ.
>> How should I do this?
>>
>> I tried to transfer the cash from the selling of ABC to the Parent 
>> Investment Account then transfer the required amount of cash from the 
>> Parent Investment Account to XYZ account then buy those XYZ shares.  
>> But I got so confused I didn't know what was going on and deleted 
>> everything and started over trying it with a split transaction and 
>> OMG that was even worse.
>>
>> Please advise.
>> Thanks.
>>
>
>
> _______________________________________________
> 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.

-- 
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

-------------- next part --------------
A non-text attachment was scrubbed...
Name: Buy.png
Type: image/png
Size: 19587 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210810/53fcef37/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Parent.png
Type: image/png
Size: 35073 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210810/53fcef37/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sell.png
Type: image/png
Size: 24412 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210810/53fcef37/attachment-0005.png>