[GNC] Tutorial for moving stock between accounts?

classic Classic list List threaded Threaded
23 messages Options
12
Reply | Threaded
Open this post in threaded view
|

[GNC] Tutorial for moving stock between accounts?

Jon Leech
    Are there any written or video tutorials for moving shares between
stock accounts? There's very little about this in the manual or the list
archives, and my attempts end up subtracting shares from one account and
adding what appears to be USD to the other account.
    Jon
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

David Cousens
Jon,

It is not very clear what situation you are dealing with. One would not
usually move stock from one account to another as such. Their purchase or
sale would normally be recorded in an Asset:Invetment account of type Stock.
What you are recording is the exchange of money to or from your bank account
(another asset account) when you sell or buy the stock. If you are buying
and selling on overseas exchanges then you will have currency exchange
considerations as well.

The following section of the Tutorial and Concepts guide will be a good
starting point
https://www.gnucash.org/docs/v3/C/gnucash-guide/invest-setup1.html

The sections in the guide following the one referenced above deal with
buying and selling stock.

You  may also want to check out the introductory sections relating to double
entry accounting
https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-accounting1.html 
if the above is not clear.

David Cousens



-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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 Cousens
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

Jon Leech
In reply to this post by Jon Leech
David Cousens wrote:
> It is not very clear what situation you are dealing with. One would not
> usually move stock from one account to another as such. Their purchase or
> sale would normally be recorded in an Asset:Invetment account of type Stock.
> What you are recording is the exchange of money to or from your bank account
> (another asset account) when you sell or buy the stock. If you are buying
> and selling on overseas exchanges then you will have currency exchange
> considerations as well.

    I do know how to record purchase and sale of securities, but that's
not what I'm asking about.

    In this case I have literally moved the securities, by transferring
shares directly from one broker to another. No purchase or sale
occurred, and the basis information of the transferred shares is
unchanged (albeit only a portion of the shares in the source account
were transferred).

    Jon
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

David Cousens
Jon,

Sorry for the overkill Jon.
In that case it is fairly simple. If you open the transaction in the account
register they are in then edit the account entry split which debits them to
that account and just select the new account you want to move them to in the
drop down list. If you click on another transaction you will then get a
dialog asking whether you want to confirm the changes. This will remove the
transaction from that register. If you then open the new account  register
you should see the transaction in the register for the new account.

David



-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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 Cousens
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

Jon Leech
In reply to this post by Jon Leech
David Cousens wrote:
> In that case it is fairly simple. If you open the transaction in the account
> register they are in then edit the account entry split which debits them to
> that account and just select the new account you want to move them to in the
> drop down list. If you click on another transaction you will then get a
> dialog asking whether you want to confirm the changes. This will remove the
> transaction from that register. If you then open the new account  register
> you should see the transaction in the register for the new account.

    That would work if I were transferring all of the shares in the
account to another account. But I'm only moving a portion of them (which
I don't think I previously made clear - sorry for that). It may be that
I end up having to synthesize new transactions that didn't actually
occur to accomplish this (e.g. breaking the original purchase into two
parts for the shares transferred / remaining), but I'd prefer the
gnucash history to reflect actual events insofar as possible.

    There is very little about this topic in the mailing list archives.
The last time someone asked was about 5 years ago, AFAICT, and it
doesn't seem like the program is more capable in this area than it was
in 2013. But I am hoping someone else has addressed this specific
problem and documented how they accomplished it.

    Jon
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

GnuCash - User mailing list
In reply to this post by Jon Leech
Jon, 
David C. makes one suggestion. I would ask whether the destination account is also denominated in the selected stock. If not, then gnucash will convert between different commodities (e.g., between shares of stock and USD).
David T.

 
 
  On Tue, Jan 1, 2019 at 7:46, Jon Leech<[hidden email]> wrote:   David Cousens wrote:
> It is not very clear what situation you are dealing with. One would not
> usually move stock from one account to another as such. Their purchase or
> sale would normally be recorded in an Asset:Invetment account of type Stock.
> What you are recording is the exchange of money to or from your bank account
> (another asset account) when you sell or buy the stock. If you are buying
> and selling on overseas exchanges then you will have currency exchange
> considerations as well.

    I do know how to record purchase and sale of securities, but that's
not what I'm asking about.

    In this case I have literally moved the securities, by transferring
shares directly from one broker to another. No purchase or sale
occurred, and the basis information of the transferred shares is
unchanged (albeit only a portion of the shares in the source account
were transferred).

    Jon
_______________________________________________
gnucash-user mailing list
[hidden email]
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
[hidden email]
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.

Untitled (1K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

David Carlson-4
In reply to this post by David Cousens
Now David Cousens, you are confusing me.  If you are referring to
re-writing the original purchase transaction to correct an error, and the
cash that is also transferred in that transaction is also corrected to the
new brokerage account, then I agree with you.

If, however, this is a new transaction representing a transfer of existing
stock 'in kind' or some other asset which is not really sold, such as an
antique or art work, then it would be necessary to figure out the value
that the asset had in the source account and to also transfer that value to
the new account along with the asset.  That transaction pair would be
similar to a sale out of the source account and a purchase in the
destination account.  Again, there is an assumption that the same currency
is used throughout.

David C[arlson]

On Mon, Dec 31, 2018 at 8:30 PM David Cousens <[hidden email]>
wrote:

> Jon,
>
> Sorry for the overkill Jon.
> In that case it is fairly simple. If you open the transaction in the
> account
> register they are in then edit the account entry split which debits them to
> that account and just select the new account you want to move them to in
> the
> drop down list. If you click on another transaction you will then get a
> dialog asking whether you want to confirm the changes. This will remove the
> transaction from that register. If you then open the new account  register
> you should see the transaction in the register for the new account.
>
> David
>
>
>
> -----
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

David Carlson-4
I forgot to mention that if the value has changed at the time of the 'in
kind' transfer from the original value in the source account, then it is
necessary to account for a profit or loss to the source account in the
pseudo-sale transaction and to assign the new value to the new account in
the pseudo-purchase transaction.

David C[arlson]

On Mon, Dec 31, 2018 at 10:00 PM David Carlson <[hidden email]>
wrote:

> Now David Cousens, you are confusing me.  If you are referring to
> re-writing the original purchase transaction to correct an error, and the
> cash that is also transferred in that transaction is also corrected to the
> new brokerage account, then I agree with you.
>
> If, however, this is a new transaction representing a transfer of existing
> stock 'in kind' or some other asset which is not really sold, such as an
> antique or art work, then it would be necessary to figure out the value
> that the asset had in the source account and to also transfer that value to
> the new account along with the asset.  That transaction pair would be
> similar to a sale out of the source account and a purchase in the
> destination account.  Again, there is an assumption that the same currency
> is used throughout.
>
> David C[arlson]
>
> On Mon, Dec 31, 2018 at 8:30 PM David Cousens <[hidden email]>
> wrote:
>
>> Jon,
>>
>> Sorry for the overkill Jon.
>> In that case it is fairly simple. If you open the transaction in the
>> account
>> register they are in then edit the account entry split which debits them
>> to
>> that account and just select the new account you want to move them to in
>> the
>> drop down list. If you click on another transaction you will then get a
>> dialog asking whether you want to confirm the changes. This will remove
>> the
>> transaction from that register. If you then open the new account  register
>> you should see the transaction in the register for the new account.
>>
>> David
>>
>>
>>
>> -----
>> David Cousens
>> --
>> Sent from:
>> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>> _______________________________________________
>> gnucash-user mailing list
>> [hidden email]
>> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

David Carlson-4
Now I see that I was also confused by the way that G Mail was showing this
thread on my screen.  David Cousens' original answer was  correct  but it
was hidden from my view.  The process is essentially the same either way,
the only difference being that for an 'in kind' transfer the sale and
purchase are just virtual transactions.  This sort of situation might come
up in transfers of custodial assets in or out of trusts or other tax
favored accounts.

David C[arlson]

David C[arlson]

On Mon, Dec 31, 2018 at 10:09 PM David Carlson <[hidden email]>
wrote:

> I forgot to mention that if the value has changed at the time of the 'in
> kind' transfer from the original value in the source account, then it is
> necessary to account for a profit or loss to the source account in the
> pseudo-sale transaction and to assign the new value to the new account in
> the pseudo-purchase transaction.
>
> David C[arlson]
>
> On Mon, Dec 31, 2018 at 10:00 PM David Carlson <
> [hidden email]> wrote:
>
>> Now David Cousens, you are confusing me.  If you are referring to
>> re-writing the original purchase transaction to correct an error, and the
>> cash that is also transferred in that transaction is also corrected to the
>> new brokerage account, then I agree with you.
>>
>> If, however, this is a new transaction representing a transfer of
>> existing stock 'in kind' or some other asset which is not really sold, such
>> as an antique or art work, then it would be necessary to figure out the
>> value that the asset had in the source account and to also transfer that
>> value to the new account along with the asset.  That transaction pair would
>> be similar to a sale out of the source account and a purchase in the
>> destination account.  Again, there is an assumption that the same currency
>> is used throughout.
>>
>> David C[arlson]
>>
>> On Mon, Dec 31, 2018 at 8:30 PM David Cousens <[hidden email]>
>> wrote:
>>
>>> Jon,
>>>
>>> Sorry for the overkill Jon.
>>> In that case it is fairly simple. If you open the transaction in the
>>> account
>>> register they are in then edit the account entry split which debits them
>>> to
>>> that account and just select the new account you want to move them to in
>>> the
>>> drop down list. If you click on another transaction you will then get a
>>> dialog asking whether you want to confirm the changes. This will remove
>>> the
>>> transaction from that register. If you then open the new account
>>> register
>>> you should see the transaction in the register for the new account.
>>>
>>> David
>>>
>>>
>>>
>>> -----
>>> David Cousens
>>> --
>>> Sent from:
>>> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>>> _______________________________________________
>>> gnucash-user mailing list
>>> [hidden email]
>>> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

GnuCash - User mailing list
In reply to this post by Jon Leech
What part of creating a transaction that moves shares from the old account to the new account does not work? It would seem to me that:
Old account decrease 100 sharesNew account add shares
Would work just fine. 
David T.

 
 
  On Tue, Jan 1, 2019 at 14:34, Jon Leech<[hidden email]> wrote:   David Cousens wrote:
> In that case it is fairly simple. If you open the transaction in the account
> register they are in then edit the account entry split which debits them to
> that account and just select the new account you want to move them to in the
> drop down list. If you click on another transaction you will then get a
> dialog asking whether you want to confirm the changes. This will remove the
> transaction from that register. If you then open the new account  register
> you should see the transaction in the register for the new account.

    That would work if I were transferring all of the shares in the
account to another account. But I'm only moving a portion of them (which
I don't think I previously made clear - sorry for that). It may be that
I end up having to synthesize new transactions that didn't actually
occur to accomplish this (e.g. breaking the original purchase into two
parts for the shares transferred / remaining), but I'd prefer the
gnucash history to reflect actual events insofar as possible.

    There is very little about this topic in the mailing list archives.
The last time someone asked was about 5 years ago, AFAICT, and it
doesn't seem like the program is more capable in this area than it was
in 2013. But I am hoping someone else has addressed this specific
problem and documented how they accomplished it.

    Jon
_______________________________________________
gnucash-user mailing list
[hidden email]
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
[hidden email]
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.

Untitled (2K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

Jon Leech
On Tue, Jan 01, 2019 at 10:35:03AM +0000, David T. wrote:
> What part of creating a transaction that moves shares from the old account to the new account does not work? It would seem to me that:
> Old account decrease 100 shares
> New account add shares
> Would work just fine.

    Could you give a bit more detail? The way I know to 'decrease' or
'increase' shares is by Selling or Buying them in a split transaction,
which also involves a cash account from which fees or proceeds are
handled. But here the shares are moving between accounts, and no cash is
involved.

    Maybe a framework for this is to say that I want to adjust the share
count in the two security accounts in much the same way I adjust the
cash value in two cash accounts - by moving the underlying commodity
(shares or cash, respectively) between them.

    It might be more clear what I'm trying to accomplish, and why I'm
stymied, if I show a couple of screenshots of a failed attempt. Attached
src.jpg is of an account containing 33 shares of CEG (let's leave aside
that the security no longer exists - this is only for demonstration
purposes). dst.jpg shows another account denominated in the same
security, and I'd like to transfer 13 of those 33 shares to it.

    Just to get the share counts correct, it seemed obvious to enter a
transaction where I Transfer from the src to dst account, and enter a
negative number of shares. This *does* adjust the share count correctly
on the src side, but on the dst side (dst.gif) instead of showing a
number of *shares* transferred, it shows a 'Buy' of 13.00 and zero
resulting shares.

    I have also attempted to do this with a split, but (a) AFAICT
there's no 'Action' in a split that relates to transferring shares
between accounts - there are 'Sell', 'Buy', 'Fee', things related to
dividends and capital gains, etc. - and (b) it insists on forcing a
monetary Price on the transaction which makes the split imbalanced, even
though no money whatsoever is involved.

    So this is why I'm hoping to find an actual detailed example of how
to accomplish this transfer in the gnucash framework. I appreciate the
responses, but none of it quite seems to speak to the thing I'm trying
to accomplish - or I don't yet understand what people are saying I
should do.

    Jon

_______________________________________________
gnucash-user mailing list
[hidden email]
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.

src.gif (49K) Download Attachment
dst.gif (42K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

David Cousens
In reply to this post by Jon Leech
Jon,

https://wiki.gnucash.org/wiki/Concept_of_Lots gives some clues on how to perform stock splits and how shares are treated
as lots

also
https://www.gnucash.org/docs/v3/C/gnucash-help/stock-split.html

David Cousens

On Mon, 2018-12-31 at 18:45 -0800, Jon Leech wrote:

> David Cousens wrote:
> > In that case it is fairly simple. If you open the transaction in the account
> > register they are in then edit the account entry split which debits them to
> > that account and just select the new account you want to move them to in the
> > drop down list. If you click on another transaction you will then get a
> > dialog asking whether you want to confirm the changes. This will remove the
> > transaction from that register. If you then open the new account  register
> > you should see the transaction in the register for the new account.
>
>     That would work if I were transferring all of the shares in the
> account to another account. But I'm only moving a portion of them (which
> I don't think I previously made clear - sorry for that). It may be that
> I end up having to synthesize new transactions that didn't actually
> occur to accomplish this (e.g. breaking the original purchase into two
> parts for the shares transferred / remaining), but I'd prefer the
> gnucash history to reflect actual events insofar as possible.
>
>     There is very little about this topic in the mailing list archives.
> The last time someone asked was about 5 years ago, AFAICT, and it
> doesn't seem like the program is more capable in this area than it was
> in 2013. But I am hoping someone else has addressed this specific
> problem and documented how they accomplished it.
>
>     Jon
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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
[hidden email]
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 Cousens
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

David Cousens
Jon,

The latter reference is probably not useful for what you intend.

David



-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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 Cousens
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

Christopher Lam
In reply to this post by Jon Leech
There may not be any internal technical restrictions preventing you from
directly decreasing the share count of a share account, and increasing in
another.

However this is pretty much uncharted territory when it comes to reports
and reporting assumptions.

Typically I'd expect someone who tries to move shares between brokers to be
liquidating their brokerage account, record any capital gains or losses,
and immediately buy shares in the other account.

Any inaccuracies in any reports will be dealt with under caveat emptor
rules :)

On Wed., 2 Jan. 2019, 17:25 Jon Leech <[hidden email] wrote:

> On Tue, Jan 01, 2019 at 10:35:03AM +0000, David T. wrote:
> > What part of creating a transaction that moves shares from the old
> account to the new account does not work? It would seem to me that:
> > Old account decrease 100 shares
> > New account add shares
> > Would work just fine.
>
>     Could you give a bit more detail? The way I know to 'decrease' or
> 'increase' shares is by Selling or Buying them in a split transaction,
> which also involves a cash account from which fees or proceeds are
> handled. But here the shares are moving between accounts, and no cash is
> involved.
>
>     Maybe a framework for this is to say that I want to adjust the share
> count in the two security accounts in much the same way I adjust the
> cash value in two cash accounts - by moving the underlying commodity
> (shares or cash, respectively) between them.
>
>     It might be more clear what I'm trying to accomplish, and why I'm
> stymied, if I show a couple of screenshots of a failed attempt. Attached
> src.jpg is of an account containing 33 shares of CEG (let's leave aside
> that the security no longer exists - this is only for demonstration
> purposes). dst.jpg shows another account denominated in the same
> security, and I'd like to transfer 13 of those 33 shares to it.
>
>     Just to get the share counts correct, it seemed obvious to enter a
> transaction where I Transfer from the src to dst account, and enter a
> negative number of shares. This *does* adjust the share count correctly
> on the src side, but on the dst side (dst.gif) instead of showing a
> number of *shares* transferred, it shows a 'Buy' of 13.00 and zero
> resulting shares.
>
>     I have also attempted to do this with a split, but (a) AFAICT
> there's no 'Action' in a split that relates to transferring shares
> between accounts - there are 'Sell', 'Buy', 'Fee', things related to
> dividends and capital gains, etc. - and (b) it insists on forcing a
> monetary Price on the transaction which makes the split imbalanced, even
> though no money whatsoever is involved.
>
>     So this is why I'm hoping to find an actual detailed example of how
> to accomplish this transfer in the gnucash framework. I appreciate the
> responses, but none of it quite seems to speak to the thing I'm trying
> to accomplish - or I don't yet understand what people are saying I
> should do.
>
>     Jon
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

GnuCash - User mailing list
In reply to this post by Jon Leech
Jon,

I can't test this right now, since I'm not at my machine...

Try this:

Open your source account.

Move to the entry point in the register.

Click the 'Split' button. Enter your description.

Tab to the Shares field in the first split and type -13.

Tab to the price field and type 0.

Now, use **tab** to move to the Transfer field on the second line, set it to your destination account and tab to shares and type 13.

Does that work?

David T.



On January 2, 2019, at 2:55 PM, Jon Leech <[hidden email]> wrote:

>On Tue, Jan 01, 2019 at 10:35:03AM +0000, David T. wrote: > What part of creating a transaction that moves shares from the old account to the new account does not work? It would seem to me that: > Old account decrease 100 shares > New account add shares > Would work just fine. Could you give a bit more detail? The way I know to 'decrease' or 'increase' shares is by Selling or Buying them in a split transaction, which also involves a cash account from which fees or proceeds are handled. But here the shares are moving between accounts, and no cash is involved. Maybe a framework for this is to say that I want to adjust the share count in the two security accounts in much the same way I adjust the cash value in two cash accounts - by moving the underlying commodity (shares or cash, respectively) between them. It might be more clear what I'm trying to accomplish, and why I'm stymied, if I show a couple of screenshots of a failed attempt. Attached src.jpg is of an account containing 33 shares of CEG (let's leave aside that the security no longer exists - this is only for demonstration purposes). dst.jpg shows another account denominated in the same security, and I'd like to transfer 13 of those 33 shares to it. Just to get the share counts correct, it seemed obvious to enter a transaction where I Transfer from the src to dst account, and enter a negative number of shares. This *does* adjust the share count correctly on the src side, but on the dst side (dst.gif) instead of showing a number of *shares* transferred, it shows a 'Buy' of 13.00 and zero resulting shares. I have also attempted to do this with a split, but (a) AFAICT there's no 'Action' in a split that relates to transferring shares between accounts - there are 'Sell', 'Buy', 'Fee', things related to dividends and capital gains, etc. - and (b) it insists on forcing a monetary Price on the transaction which makes the split imbalanced, even though no money whatsoever is involved. So this is why I'm hoping to find an actual detailed example of how to accomplish this transfer in the gnucash framework. I appreciate the responses, but none of it quite seems to speak to the thing I'm trying to accomplish - or I don't yet understand what people are saying I should do. Jon

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

Jon Leech
On Wed, Jan 02, 2019 at 05:38:13PM +0530, D wrote:

> Jon,
>
> I can't test this right now, since I'm not at my machine...
>
> Try this:
>
> Open your source account.
>
> Move to the entry point in the register.
>
> Click the 'Split' button. Enter your description.
>
> Tab to the Shares field in the first split and type -13.
>
> Tab to the price field and type 0.
>
> Now, use **tab** to move to the Transfer field on the second line, set it to your destination account and tab to shares and type 13.
>
> Does that work?

    Thanks! This works, for the most part. The share counts in source
and destination accounts are altered correctly, which is enough to let
me do what I need. It does set a Price of 1 for the second line and a
Tot Buy of 13.00, and then creates a new Imbalance line in the split
with a Tot Sell of 13.00.

    I cannot change the Price to 0 on the second line, unlike the first.
Trying it results in it immediately being restored to 1, so the
Imbalance seems unavoidable. I can set the Price to a non-zero number
and make gnucash recalculate the Tot Buy / Imbalance fields, but that
seems pointless, since there is no actual Price or cash associated with
this transaction.

    Jon
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

David Carlson-4
In reply to this post by GnuCash - User mailing list
Jon,

I believe that, as discussed earlier by Christopher Lam and David T,
GnuCash may not prevent you from creating a transaction containing only two
lines, one removing shares from one brokerage account and one another
adding shares to a different brokerage account, and it may even be possible
for the shares to be different securities, superficially simulating a
buyout or other unusual non-cash security transaction.  However, if one
does this without correctly accounting for the values of the shares and
security accounts involved, then one is setting himself up for
discrepancies in future reports involving the values of those security
accounts.  This is most easily seen by the example of looking at the
security accounts in the chart of accounts view.  Every security account
that is no longer used because all of the shares have been sold should not
only show 0 shares, but also show 0 current value in your currency.
Chapter 9 in the tutorial goes into great detail on how to correctly
account for the correct capital gains and losses when selling securities
and using the Trial Balance report to verify that the correct cost basis
amount is converted from unrealized into realized gain or loss.  The same
principles should be used to account for values even when no currency is
involved.

There is a little known assistant feature in GnuCash to enter stock splits
which is also documented in the tutorial chapter 9.  That assistant is
under Actions in the menu and it provides a way to assign correct values to
before and after shares when a stock is split.  The result of using that
assistant would create a model for other types of virtual transactions not
involving cash.

If you do not track the value of your securities or your net worth in
GnuCash, then it is much easier to skip all the effort to correctly account
for realized gains and losses and just forward your brokers' tax report to
your accountant.

That is my 2 cents...

David Carlson

On Wed, Jan 2, 2019 at 6:12 AM D via gnucash-user <[hidden email]>
wrote:

> Jon,
>
> I can't test this right now, since I'm not at my machine...
>
> Try this:
>
> Open your source account.
>
> Move to the entry point in the register.
>
> Click the 'Split' button. Enter your description.
>
> Tab to the Shares field in the first split and type -13.
>
> Tab to the price field and type 0.
>
> Now, use **tab** to move to the Transfer field on the second line, set it
> to your destination account and tab to shares and type 13.
>
> Does that work?
>
> David T.
>
>
>
> On January 2, 2019, at 2:55 PM, Jon Leech <[hidden email]> wrote:
>
> >On Tue, Jan 01, 2019 at 10:35:03AM +0000, David T. wrote: > What part of
> creating a transaction that moves shares from the old account to the new
> account does not work? It would seem to me that: > Old account decrease 100
> shares > New account add shares > Would work just fine. Could you give a
> bit more detail? The way I know to 'decrease' or 'increase' shares is by
> Selling or Buying them in a split transaction, which also involves a cash
> account from which fees or proceeds are handled. But here the shares are
> moving between accounts, and no cash is involved. Maybe a framework for
> this is to say that I want to adjust the share count in the two security
> accounts in much the same way I adjust the cash value in two cash accounts
> - by moving the underlying commodity (shares or cash, respectively) between
> them. It might be more clear what I'm trying to accomplish, and why I'm
> stymied, if I show a couple of screenshots of a failed attempt. Attached
> src.jpg is of an account containing 33 shares of CEG (let's leave aside
> that the security no longer exists - this is only for demonstration
> purposes). dst.jpg shows another account denominated in the same security,
> and I'd like to transfer 13 of those 33 shares to it. Just to get the share
> counts correct, it seemed obvious to enter a transaction where I Transfer
> from the src to dst account, and enter a negative number of shares. This
> *does* adjust the share count correctly on the src side, but on the dst
> side (dst.gif) instead of showing a number of *shares* transferred, it
> shows a 'Buy' of 13.00 and zero resulting shares. I have also attempted to
> do this with a split, but (a) AFAICT there's no 'Action' in a split that
> relates to transferring shares between accounts - there are 'Sell', 'Buy',
> 'Fee', things related to dividends and capital gains, etc. - and (b) it
> insists on forcing a monetary Price on the transaction which makes the
> split imbalanced, even though no money whatsoever is involved. So this is
> why I'm hoping to find an actual detailed example of how to accomplish this
> transfer in the gnucash framework. I appreciate the responses, but none of
> it quite seems to speak to the thing I'm trying to accomplish - or I don't
> yet understand what people are saying I should do. Jon
>
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

GnuCash - User mailing list
In reply to this post by Jon Leech

Well, now that you have it mostly right, maybe go in to the second account register and see whether you can change the second split price to zero from there, using the same tabbing technique. 
 
 
  On Thu, Jan 3, 2019 at 12:23, Jon Leech<[hidden email]> wrote:   On Wed, Jan 02, 2019 at 05:38:13PM +0530, D wrote:

> Jon,
>
> I can't test this right now, since I'm not at my machine...
>
> Try this:
>
> Open your source account.
>
> Move to the entry point in the register.
>
> Click the 'Split' button. Enter your description.
>
> Tab to the Shares field in the first split and type -13.
>
> Tab to the price field and type 0.
>
> Now, use **tab** to move to the Transfer field on the second line, set it to your destination account and tab to shares and type 13.
>
> Does that work?
    Thanks! This works, for the most part. The share counts in source
and destination accounts are altered correctly, which is enough to let
me do what I need. It does set a Price of 1 for the second line and a
Tot Buy of 13.00, and then creates a new Imbalance line in the split
with a Tot Sell of 13.00.

    I cannot change the Price to 0 on the second line, unlike the first.
Trying it results in it immediately being restored to 1, so the
Imbalance seems unavoidable. I can set the Price to a non-zero number
and make gnucash recalculate the Tot Buy / Imbalance fields, but that
seems pointless, since there is no actual Price or cash associated with
this transaction.

    Jon
_______________________________________________
gnucash-user mailing list
[hidden email]
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
[hidden email]
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.

Untitled (2K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

Fred Bone
In reply to this post by Jon Leech
On Wednesday, January 2, 2019 at 5:58, Jon Leech said:

> On Wed, Jan 02, 2019 at 05:38:13PM +0530, D wrote:
> > Jon,
> >
> > I can't test this right now, since I'm not at my machine...
> >
> > Try this:
> >
> > Open your source account.
> >
> > Move to the entry point in the register.
> >
> > Click the 'Split' button. Enter your description.
> >
> > Tab to the Shares field in the first split and type -13.
> >
> > Tab to the price field and type 0.
> >
> > Now, use **tab** to move to the Transfer field on the second line, set
> > it to your destination account and tab to shares and type 13.
> >
> > Does that work?
>
>     Thanks! This works, for the most part. The share counts in source and
> destination accounts are altered correctly, which is enough to let me do
> what I need. It does set a Price of 1 for the second line and a Tot Buy of
> 13.00, and then creates a new Imbalance line in the split with a Tot Sell
> of 13.00.
>
>     I cannot change the Price to 0 on the second line, unlike the first.
> Trying it results in it immediately being restored to 1, so the Imbalance
> seems unavoidable. I can set the Price to a non-zero number and make
> gnucash recalculate the Tot Buy / Imbalance fields, but that seems
> pointless, since there is no actual Price or cash associated with this
> transaction.

Oh yes there is.

If you started with 100 shares and transferred 50 from A to B, the
account wiith A is now worth half what it was and the account with B is
worth the other half. If you don't tell Gnucash what the transfer value
is, you can't expect it to make the relevant calculations when the time
comes (e.g. you sell one and want to know your capital gain).

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tutorial for moving stock between accounts?

Jon Leech
In reply to this post by David Carlson-4
    (BTW, sorry for messing up the threading. I have had a pending
subscription request since before I started this thread, which still
hasn't been approved, so I'm limited to responding to messages that are
CCed directly to me, or cutting and pasting other content from the web
archive).

Christopher Lam wrote:

> There may not be any internal technical restrictions preventing you from
> directly decreasing the share count of a share account, and increasing in
> another.
>
> However this is pretty much uncharted territory when it comes to reports
> and reporting assumptions.
>
> Typically I'd expect someone who tries to move shares between brokers to be
> liquidating their brokerage account, record any capital gains or losses,
> and immediately buy shares in the other account.

    I don't know how typical my use case is, but that seems like an
unwise thing to do, in general. I wouldn't want to realize capital gains
or losses solely as a side effect of moving shares from one broker to
another!

    All brokers I have accounts with have a process for directly
transferring shares, usually just filling out a web form identifying the
other broker and the specific shares / lots to transfer.

    Jon
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
12