David,
Thank you for the helpful response. I am currently running v. 3.3. and I was
able to find a solution having to do with a currency setting. Currency was not
on my initial radar as I believed all my assets to be denominated in USD. [Does
Gnucash treat a stock in the same category as a foreign currency?] Regardless,
the immediate solution for me was to go to OPTIONS: COMMODITIES, and then
deselect "Show Foreign Currencies." The latter was selected as a default.
Unchecking this option removed all the individual stocks from the balance sheet
and correctly showed the total with the "Investments" hierarchy.
If I ever do start incorporating foreign currency assets, it would be nice to
have another way to collapse the individual stock accounts, but this solution
will work for the time-being. A new challenge for another day.
Thanks again!
Stephen
On Tuesday, January 1, 2019, 5:45:10 PM GMT-5, David Carlson
<david.carlson....@gmail.com> wrote
Stephen,
I just tried running that report in release 2.6.15 and found that the
securities can be suppressed in the report by reducing the level of sub
accounts to two in my data file which has many securities but no foreign
currencies. They are likely to be affected by some additional settings in the
report because they are denominated in shares of the security which would have
to be evaluated into your currency in order to create that report, which
involves a decision of what basis is used for that evaluation and whether you
have [current] values in you data. There is a default for that which should
give some result, but perhaps less accurate than you really want.
That said, things have changed in recent releases 3.3 and 3.4 so those releases
may give different results. Michael gave you some good suggestions to try and
if [a] they do not work and [b] you have already migrated to release 3.4 then
we need more information to help you get to the bottom of your problem.
David C
On Tue, Jan 1, 2019 at 1:01 PM Stephen Knapp via gnucash-user
<gnucash-user@gnucash.org> wrote:
@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-requ...@gnucash.org <gnucash-user-requ...@gnucash.org> wrote:
Send gnucash-user mailing list submissions to
gnucash-user@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-requ...@gnucash.org
You can reach the person managing the list at
gnucash-user-ow...@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." <sunfis...@yahoo.com>
To: "davidcous...@bigpond.com" <davidcous...@bigpond.com>,
"gnucash-user@gnucash.org" <gnucash-user@gnucash.org>
Subject: Re: [GNC] Adding an exchange to the list of exchanges
Message-ID: <1950304245.4607945.1546314787...@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<davidcous...@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@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....@gmail.com>
To: David Cousens <davidcous...@bigpond.com>
Cc: Gnucash Users <gnucash-user@gnucash.org>
Subject: Re: [GNC] Tutorial for moving stock between accounts?
Message-ID:
<cadygsbnvrwofmjqw0ag9xsamm6ys03anzm9+7jt9fvwn3rl...@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 <davidcous...@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@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....@gmail.com>
To: David Cousens <davidcous...@bigpond.com>
Cc: Gnucash Users <gnucash-user@gnucash.org>
Subject: Re: [GNC] Tutorial for moving stock between accounts?
Message-ID:
<CADYgSbnNRXN_t=l796quq_bkyeopzsndpaqa_wqr0hzc1oe...@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....@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 <davidcous...@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@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....@gmail.com>
To: David Cousens <davidcous...@bigpond.com>
Cc: Gnucash Users <gnucash-user@gnucash.org>
Subject: Re: [GNC] Tutorial for moving stock between accounts?
Message-ID:
<cadygsbkbq+txj_p0kq1igktrtoyeff0p3sbu2cmessu5cyg...@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....@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....@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 <davidcous...@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@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 <davidcous...@bigpond.com>
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Adding an exchange to the list of exchanges
Message-ID: <1546325108693-0.p...@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 <oddh...@sonic.net>
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Tutorial for moving stock between accounts?
Message-ID: <20190101024536.f4jgauou7ot6d...@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 <clan...@gmail.com>
To: Tim Kallmer <tkall...@gmail.com>
Cc: Gnucash Users <gnucash-user@gnucash.org>
Subject: Re: [GNC] *.deb package for GnuCash 3.4 Released
Message-ID:
<CAL=0glt4gbu3pvyrtgxc7herdb7qbi9qqsek4kowznhptmy...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
On Mon, 31 Dec 2018 at 17:58, Tim Kallmer <tkall...@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." <sunfis...@yahoo.com>
To: "oddh...@sonic.net" <oddh...@sonic.net>,
"gnucash-user@gnucash.org" <gnucash-user@gnucash.org>
Subject: Re: [GNC] Tutorial for moving stock between accounts?
Message-ID: <1209533355.4652865.1546338904...@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<oddh...@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@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.fin...@neuf.fr>
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Location of GnuCash data files
Message-ID: <73604594-febd-9ad9-e16d-12f1c8981...@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....@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_step...@yahoo.com>
To: "gnucash-user@gnucash.org" <gnucash-user@gnucash.org>
Subject: [GNC] Balance Sheet Report keeps listing all my individual
stocks
Message-ID: <1385985272.4704823.1546356766...@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 <stepbystepf...@comcast.net>
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Balance Sheet Report keeps listing all my
individual stocks
Message-ID: <5c2b937c.7050...@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@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
********************************************
_______________________________________________
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.
