[GNC] Balance Sheet Report keeps listing all my individual stocks

Stephen Knapp knapp_stephen at yahoo.com
Tue Jan 1 13:59:23 EST 2019


 @Michael. Thank you for the response. 
I have toggled through all the options in the reports. Selecting and deselecting subtotals. I have also tried putting the individual stocks at different levels in the hierarchy. No matter the "options" setting or how many levels of hierarchy I put the stocks in, it seems that the report is alway treating each stock as a first level hierarchy. Thus far, I have been unable to produce a Balance Sheet without it listing every single individual stock in the report.  
Does this make sense? Thanks again for your help. 


    On Tuesday, January 1, 2019, 12:00:54 PM GMT-5, gnucash-user-request at gnucash.org <gnucash-user-request at gnucash.org> wrote:  
 
 Send gnucash-user mailing list submissions to
    gnucash-user at gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
    https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
    gnucash-user-request at gnucash.org

You can reach the person managing the list at
    gnucash-user-owner at gnucash.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."


Today's Topics:

  1. Re:  Adding an exchange to the list of exchanges (David T.)
  2. Re:  Tutorial for moving stock between accounts? (David Carlson)
  3. Re:  Tutorial for moving stock between accounts? (David Carlson)
  4. Re:  Tutorial for moving stock between accounts? (David Carlson)
  5. Re:  Adding an exchange to the list of exchanges (David Cousens)
  6. Re:  Tutorial for moving stock between accounts? (Jon Leech)
  7. Re:  *.deb package for GnuCash 3.4 Released (Colin Law)
  8. Re:  Tutorial for moving stock between accounts? (David T.)
  9. Re:  Location of GnuCash data files (Finbar Mahon)
  10.  Balance Sheet Report keeps listing all my individual stocks
      (Stephen Knapp)
  11. Re:  Balance Sheet Report keeps listing all my individual
      stocks (Michael or Penny Novack)


----------------------------------------------------------------------

Message: 1
Date: Tue, 1 Jan 2019 03:53:07 +0000 (UTC)
From: "David T." <sunfish62 at yahoo.com>
To: "davidcousens at bigpond.com" <davidcousens at bigpond.com>,
    "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: Re: [GNC] Adding an exchange to the list of exchanges
Message-ID: <1950304245.4607945.1546314787790 at mail.yahoo.com>
Content-Type: text/plain; charset=UTF-8

I am not at my computer to verify, but I understand that this field is a simple text field with a combo box drop down based on prior entries.? In other words, you can type your own entry into the field.?
David T.

 
 
  On Tue, Jan 1, 2019 at 8:50, David Cousens<davidcousens at bigpond.com> wrote:  Hi,
GnuCash v 3.4. I am trying to add a stock account for shares traded on the
ASX from the Select Security dialog in the New Account dialog. ASX does not
appear in the list of exchanges. Is it possible to add exchanges to the
list? If so how and where? I have tried using the Price editor but can't
find a way of adding other exchanges.

David Cousens



-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
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.
  


------------------------------

Message: 2
Date: Mon, 31 Dec 2018 22:00:41 -0600
From: David Carlson <david.carlson.417 at gmail.com>
To: David Cousens <davidcousens at bigpond.com>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Tutorial for moving stock between accounts?
Message-ID:
    <CADYgSbnVRwOfmJqw0ag9XsamM6YS03AnZM9+7JT9fVWn3RLY-Q at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

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 <davidcousens at bigpond.com>
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
> 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.
>


------------------------------

Message: 3
Date: Mon, 31 Dec 2018 22:09:31 -0600
From: David Carlson <david.carlson.417 at gmail.com>
To: David Cousens <davidcousens at bigpond.com>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Tutorial for moving stock between accounts?
Message-ID:
    <CADYgSbnNRXN_t=L796quQ_bkyEOPzSNdpaQA_wqR0hZc1oE3jQ at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

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 <david.carlson.417 at gmail.com>
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 <davidcousens at bigpond.com>
> 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
>> 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.
>>
>


------------------------------

Message: 4
Date: Mon, 31 Dec 2018 22:23:49 -0600
From: David Carlson <david.carlson.417 at gmail.com>
To: David Cousens <davidcousens at bigpond.com>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Tutorial for moving stock between accounts?
Message-ID:
    <CADYgSbkBq+tXj_p0kQ1iGKTrTOyEFF0p3SBU2cmEssu5CYG_pg at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

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 <david.carlson.417 at gmail.com>
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 <
> david.carlson.417 at gmail.com> 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 <davidcousens at bigpond.com>
>> 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
>>> 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.
>>>
>>


------------------------------

Message: 5
Date: Tue, 1 Jan 2019 00:45:08 -0600 (CST)
From: David Cousens <davidcousens at bigpond.com>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Adding an exchange to the list of exchanges
Message-ID: <1546325108693-0.post at n4.nabble.com>
Content-Type: text/plain; charset=us-ascii

Solved my own problem

Tools->Price Editor

Hit ADD button
Type ASX in the textbox  for Type: fill in the other details.

This can't be done from the New Account dialog for an account of Type Stock
however. The commodity has to be created first in the Price editor.

David Cousens



-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html


------------------------------

Message: 6
Date: Mon, 31 Dec 2018 18:45:36 -0800
From: Jon Leech <oddhack at sonic.net>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Tutorial for moving stock between accounts?
Message-ID: <20190101024536.f4jgauou7ot6dyct at celly.oddhack.org>
Content-Type: text/plain; charset=us-ascii

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


------------------------------

Message: 7
Date: Tue, 1 Jan 2019 10:12:10 +0000
From: Colin Law <clanlaw at gmail.com>
To: Tim Kallmer <tkallmer at gmail.com>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] *.deb package for GnuCash 3.4 Released
Message-ID:
    <CAL=0gLt4GbU3pVyrTgxc7heRdB7Qbi9qqsek4KoWznhptmyFFw at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

On Mon, 31 Dec 2018 at 17:58, Tim Kallmer <tkallmer at gmail.com> wrote:
>
> >
> > the .deb package did not work for me on Ubuntu 18.10

As I posted earlier, for ubuntu 18.10 do
sudo apt install libboost-regex1.65.1

Colin


------------------------------

Message: 8
Date: Tue, 1 Jan 2019 10:35:03 +0000 (UTC)
From: "David T." <sunfish62 at yahoo.com>
To: "oddhack at sonic.net" <oddhack at sonic.net>,
    "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: Re: [GNC] Tutorial for moving stock between accounts?
Message-ID: <1209533355.4652865.1546338904062 at mail.yahoo.com>
Content-Type: text/plain; charset="utf-8"

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<oddhack at sonic.net> 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
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.
  
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: Untitled
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190101/06e6c5ab/attachment-0001.ksh>

------------------------------

Message: 9
Date: Tue, 1 Jan 2019 13:23:16 +0100
From: Finbar Mahon <mahon.finbar at neuf.fr>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Location of GnuCash data files
Message-ID: <73604594-febd-9ad9-e16d-12f1c8981872 at neuf.fr>
Content-Type: text/plain; charset=utf-8; format=flowed

Of course! I found everything since Feb 2018! Many thanks and a Happy 
New Year!

Off to load 3.3, I hope that command works there too.

Barry

On Dec 31, 2018, at 2:20 PM, David Carlson <david.carlson.417 at gmail.com> 
wrote:
>>>
>>> The thread GNCupdating advice seems to have answers that could apply 
>>> to this thread.
>>>
>>> Adding to both: In the release 2.6.xx family, a simple method to 
>>> find the last used data file is to start the File > Save as process 
>>> and see where GnuCash wants to put the new file. Then cancel before 
>>> actually saving.
>>>
>>> David C
>>>


------------------------------

Message: 10
Date: Tue, 1 Jan 2019 15:32:46 +0000 (UTC)
From: Stephen Knapp <knapp_stephen at yahoo.com>
To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: [GNC] Balance Sheet Report keeps listing all my individual
    stocks
Message-ID: <1385985272.4704823.1546356766436 at mail.yahoo.com>
Content-Type: text/plain; charset=UTF-8

Hello.?I am having a problem that all my individual stocks are showing up in my Balance Sheet report. I have a hierarchy with INVESTMENTS (Asset): BROKER ACCOUNT(Asset): COMPANY A (Stock), COMPANY (Stock), etc. I have tried all different combinations of hierarchies and the Levels of Subaccounts settings, but the report keeps putting all the individual stocks in the report, versus the sought after investment total.?
Any help would be appreciated.?

------------------------------

Message: 11
Date: Tue, 01 Jan 2019 11:21:16 -0500
From: Michael or Penny Novack <stepbystepfarm at comcast.net>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Balance Sheet Report keeps listing all my
    individual stocks
Message-ID: <5C2B937C.7050008 at comcast.net>
Content-Type: text/plain; charset=UTF-8; format=flowed

On 1/1/2019 10:32 AM, Stephen Knapp via gnucash-user wrote:
> Hello. I am having a problem that all my individual stocks are showing up in my Balance Sheet report. I have a hierarchy with INVESTMENTS (Asset): BROKER ACCOUNT(Asset): COMPANY A (Stock), COMPANY (Stock), etc. I have tried all different combinations of hierarchies and the Levels of Subaccounts settings, but the report keeps putting all the individual stocks in the report, versus the sought after investment total.
> Any help would be appreciated.

I'm not SURE about your question, it seems to have more than one part, 
so pardon my guessing.

a) You want to see a total for "INVESTMENTS" (and you aren't)
      This has to do with the subtotaling options you have selected via 
Edit=>Report Options. You can choose things like whether you want to see 
totals for parent accounts, and if so, before or after, etc.

HINT: If new to gnucash, or even experienced with gnucash but new to a 
particular report, the first thing you should do is run the report as 
"test" immediately entering Report Options to find out all the options 
you have for that report.

b) You have a hierarchy Assets:Investments:Broker Account:(Company A, 
Company B, ....)  That would be four levels of nesting. Are you saying 
that when you set the Balance Sheet nesting level to 3 (Report Options 
again) you still saw the individual stocks?

Michael D Novack


------------------------------

Subject: Digest Footer

_______________________________________________

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.

------------------------------

End of gnucash-user Digest, Vol 190, Issue 1
********************************************
  


More information about the gnucash-user mailing list