Re: [GNC] Why does the sample "investments" account tree have intermediate "Bond", "Mutual Fund", and "Stock" accounts?

[devaps]

Jim,

The default account hierarchy that’s provided when you choose investment 
accounts is just that. You can choose to have it per your tracking 
requirements. 

Like you, my parent brokerage account is a placeholder and I have a $Cash 
account under that which acts as a staging account for buys and sells. The 
default hierarchy is giving you all possible types of investments one usually 
has in a brokerage account. So my modified hierarchy looks like this -

Assets
..Investments
….Brokerage account
…..Stock
…...$Cash
…….ISIN 1
…….ISIN 2  and so on
….Mutual Fund
……Fund 1
……Fund 2 and so on

ETFs are technically mutual funds, but since they trade like stocks, I track 
them under stocks instead of mutual funds. From what I can tell, there’s no 
difference between account type stock and mutual fund. Perhaps they exist as 
two separate types to allow for different treatment in the future, if need 
arises. 

If you have bonds as well as stocks in your brokerage account, then you can 
move $Cash under brokerage account. 

I don’t invest in mutual funds through my brokerage account. I keep that just 
for stocks and ETFs. My mutual fund investments are done directly with the fund 
companies, so the structure I have makes the selection of accounts in report 
options easier. I can just select the parent placeholder Mutual Fund and say 
select all children to run a report on just mutual funds. 

So yes, there’s no harm in having AMZN directly under brokerage and use a $Cash 
account for staging purposes. I also don’t like to include transactions in 
parent accounts, so they are all placeholders for me like you described. This 
works well for me. 

Cheers,
Deva

<>

From: Jim DeLaHunt 
To: Gnucash Users 
Subject: [GNC] Why does the sample "investments" account tree have
intermediate "Bond", "Mutual Fund", and "Stock" accounts?
Message-ID: <009a32e9-b8bd-1547-cbec-0320661f1...@jdlh.com>
Content-Type: text/plain; charset=UTF-8; format=flowed

Hello, folks:

I have been using GnuCash for a long time, starting with the GnuCash 
template account tree and modifying it gradually, but never thinking 
hard about it. Until now. I am adding a bunch of investment accounts. 
This makes me look more closely at the template account structure 
depicted in 
.

This structure is:

  * Assets
  o Investments
  + Brokerage account
  # Bond
  # Mutual Fund
  # Stock
  * AMZN

What is the reason for the template inserting the layer of subaccounts 
between "Brokerage account" and "AMZN" (for Amazon.com stock)? Why 
shouldn't the child accounts denominated in each security be directly 
under the "Brokerage account" account (as long as the parent account is 
denominated in the currency which the securities are priced in)?

For my own purposes, it seems simpler to me to have the per-security 
child accounts be directly under the "Brokerage account". Is there a 
rationale for the intermediate accounts which I am missing?

Also, in the template, the "Brokerage account" is of type "Bank", and is 
not a placeholder. That seems to imply that cash and cash-equivalent 
transactions should be applied directly to "Brokerage account". Somehow 
I ended up making a child account "Cash CAD" (or "Cash USD", or 
whichever), and applying all the cash-equivalent transactiosn there. My 
equivalent of "Brokerage account" has no transactions, and is often a 
placeholder account, and has account type "Asset" rather than "Bank".?? 
Is there a reason to put the cash transactions directly in the brokerage 
account, or is this a matter of personal preference? (In which case, I 
will keep the structure I have.)

Thank you in advance for your insight,
  ?Jim DeLaHunt
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Why does the sample "investments" account tree have intermediate "Bond", "Mutual Fund", and "Stock" accounts?

[David T. via gnucash-user]

Jim, 

I'll address a little of this from my non-technical, non-accountant 
perspective. 

I don't know the rationale behind those intermediate accounts, and I don't use 
them. That said, each investment type behaves a little differently, and perhaps 
separating them makes some operations easier to manage. But I don't know. 

As for the main brokerage account question, I will say that I mostly have 
followed the template format and put cash transactions into it, without 
noticeable problem. There is a camp of Gnucash users who feel strongly that one 
should only put transactions into leaf (lowest layer) accounts, and one of them 
will explain their reasoning, I'm sure.  

I've experimented with using a subaccount for these transactions, but I don't 
like trying to find that cash account later on, since it ends up embedded in 
the alphabetical sequence of accounts. I could kludge the name for the cash 
account to bring it to the top, but that just annoys my aesthetic. 

(For the record, I use account codes for most accounts, but not for 
commodities, and let commodity accounts sort by name. Assigning codes for 
commodities accounts is cumbersome, given a large set of commodities/accounts. 
Ideally, I'd assign a code just to the cash account and get it at the top, but 
the sorting puts nothing before something, leaving the cash account at the 
bottom. I don't know if I can sort by account type, but even if I did, I don't 
know how I'd sort the chart by code and then type...)

Best, 
David

On August 14, 2022 4:40:17 AM GMT+03:00, Jim DeLaHunt  
wrote:
>Hello, folks:
>
>I have been using GnuCash for a long time, starting with the GnuCash template 
>account tree and modifying it gradually, but never thinking hard about it. 
>Until now. I am adding a bunch of investment accounts. This makes me look more 
>closely at the template account structure depicted in 
>.
>
>This structure is:
>
> * Assets
> o Investments
> + Brokerage account
> # Bond
> # Mutual Fund
> # Stock
> * AMZN
>
>What is the reason for the template inserting the layer of subaccounts between 
>"Brokerage account" and "AMZN" (for Amazon.com stock)? Why shouldn't the child 
>accounts denominated in each security be directly under the "Brokerage 
>account" account (as long as the parent account is denominated in the currency 
>which the securities are priced in)?
>
>For my own purposes, it seems simpler to me to have the per-security child 
>accounts be directly under the "Brokerage account". Is there a rationale for 
>the intermediate accounts which I am missing?
>
>Also, in the template, the "Brokerage account" is of type "Bank", and is not a 
>placeholder. That seems to imply that cash and cash-equivalent transactions 
>should be applied directly to "Brokerage account". Somehow I ended up making a 
>child account "Cash CAD" (or "Cash USD", or whichever), and applying all the 
>cash-equivalent transactiosn there. My equivalent of "Brokerage account" has 
>no transactions, and is often a placeholder account, and has account type 
>"Asset" rather than "Bank".   Is there a reason to put the cash transactions 
>directly in the brokerage account, or is this a matter of personal preference? 
>(In which case, I will keep the structure I have.)
>
>Thank you in advance for your insight,
> —Jim DeLaHunt
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] What is the difference between Account types "Stock" and "Mutual fund"?

[David T. via gnucash-user]

And I designate ETFs as Mutual Funds...

On August 14, 2022 5:44:55 AM GMT+03:00, Derek Atkins  wrote:
>Pretty much the only distinction is the UI labels.
>-derek
>Sent using my mobile device. Please excuse any typos.
>On August 13, 2022 21:53:17 Jim DeLaHunt  wrote:
>
>> Hello, folks:
>> 
>> I am starting to read more closely the GnuCash instructions for tracking
>> investments, after a long time bumbling along tracking current assets,
>> but not really investments.
>> 
>> Now I read in the instructions "9.4.1. Setup Accounts for Stocks and
>> Mutual Funds"
>> 
>> that when I create a sub-account of a brokerage account, denominated in
>> a particular security, I should set the Account Type to either "Stock"
>> or "Mutual Fund".
>> 
>> Is there any difference in how GnuCash treats accounts of those two
>> types?  Or is the distinction just documentation?  I suppose it is not a
>> problem to select type "Stock" for my stocks, and "Mutual Fund" for my
>> mutual funds.  I also have Exchange-Traded Funds (ETFs), for which there
>> is no specific account type. Does it matter which type I pick for ETFs?
>> 
>> The Account Type documentation at "Table 5.1. Types of GnuCash Accounts"
>> 
>> describes types "Stock" and "Mutual Fund" differently. However, it does
>> not say that GnuCash treats the types differently. Below that table, it
>> uses the same wording to describe the possible child accounts of the two
>> types.
>> 
>> Is there a functional difference in how GnuCash treats accounts of type
>> "Stock" and "Mutual Fund"?
>> 
>> Thank you,
>>  —Jim DeLaHunt
>> 
>> 
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
>-
>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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to bulk import about 130 Securities entries?

[Geoff]

Hi Jim

I don't have any experience manipulating GnuCash XML files, but in 
principle what you want to do should work, although it does void your 
GnuCash warranty.


However, if you are going to all this effort you may find it more 
worthwhile to invest your time in learning how to use a general purpose 
automation tool.  This approach has two advantages over data manipulation:
(1) Automation drives the GnuCash GUI and thus protects you from 
accidental data corruption.
(2) You will be able to use your new automation skills to automate any 
subsequent GnuCash tasks, for example loading historical transactions to 
your 130 securities.


For Windows, check out:
AutoHotKey https://www.autohotkey.com/
or:
Power Automate Desktop https://powerautomate.microsoft.com/en-us/desktop/

I can't recommend anything for Linux, but Google is your friend:
https://alternativeto.net/software/autohotkey/?platform=linux

Hope this helps.

Regards

Geoff
=

On 14/08/2022 11:28 am, Jim DeLaHunt wrote:

Hello, folks:

I am a long-time GnuCash user, and for all those years I have pretty 
much not attempted to track my investments in GnuCash. But now I want to 
start.  My first goal is to import many years of past activity.


I have downloaded the transactions from my brokerage account as a CSV 
file. The first thing I get out of this is the name and symbol of about 
130 securities. I am wondering if there is a practical way to bulk 
import these into GnuCash. That is, instead of visiting Tools -- 
Security Editor, and pressing the Add button 130 times, and filling out 
the "New security" dialogue 130 times, is there a more efficient path?


Looking at the File… Import menu, I do not see an option to import 
Securities. Looking at the documentation, wiki, and list archives, I 
don't see a mention of this. Is there some bulk import mechanism I am 
overlooking?


I took a look at the uncompressed XML contents of a new, simple .gnucash 
book file. It appears that the data entered in the "New security" 
dialogue gets stored as  entities. There appears to be a 
pretty simple relationship between the fields of the dialogue and the 
text within the  entity. The entities are stored in a 
certain order, sorted by  then . There is a 
 entity which seems to contain a 
text count of the non-CURRENCY gnc:commodity entries.


This makes me wonder if I could transform my list of 130 security names 
and symbols into  entities, and insert them into the 
GnuCash XML of my book.


Are there complexities or pitfalls about this approach which I might be 
overlooking?  We can certainly stipulate that manipulating the XML 
content directly is unsupported and risky, I must be careful and keep 
backups, I might blow off my fingers, etc.  For what it's worth, I 
believe that I am pretty proficient with editing XML, processing CSV 
files, and scripting manipulations of text data.


Once I have the securities added to the book, I then need to add the 
appropriate child accounts to my brokerage accounts, each denominated in 
the appropriate security type and symbol. It looks like that is 
straightforward to do with a CSV of accounts in the correct format, and 
the File… Import…  Import Accounts from CSV… menu item. I have a few 
child accounts which I entered from the UI which will serve as 
examples.  Is there any way in which this is more difficult than it looks?


Cheers,
  —Jim "ADBE ALNIX AOL … VUG VWO ZTD81" DeLaHunt

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Crash in Trial Balance report

[Christopher Lam]

May I suggest that any report crash of this sort should be logged in
Bugzilla?

On Sat, 13 Aug 2022, 9:13 pm Fred Tydeman,  wrote:

> I am running Linux and GnuCash 4.11
> When I try to do a Trial Balance report, I get a crash.
> Screenshot attached.
> I assume it is due to bad data somewhere,
> but I have no idea where or what it is.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] What is the difference between Account types "Stock" and "Mutual fund"?

[Derek Atkins]

Pretty much the only distinction is the UI labels.
-derek
Sent using my mobile device. Please excuse any typos.
On August 13, 2022 21:53:17 Jim DeLaHunt  wrote:


Hello, folks:

I am starting to read more closely the GnuCash instructions for tracking
investments, after a long time bumbling along tracking current assets,
but not really investments.

Now I read in the instructions "9.4.1. Setup Accounts for Stocks and
Mutual Funds"

that when I create a sub-account of a brokerage account, denominated in
a particular security, I should set the Account Type to either "Stock"
or "Mutual Fund".

Is there any difference in how GnuCash treats accounts of those two
types?  Or is the distinction just documentation?  I suppose it is not a
problem to select type "Stock" for my stocks, and "Mutual Fund" for my
mutual funds.  I also have Exchange-Traded Funds (ETFs), for which there
is no specific account type. Does it matter which type I pick for ETFs?

The Account Type documentation at "Table 5.1. Types of GnuCash Accounts"

describes types "Stock" and "Mutual Fund" differently. However, it does
not say that GnuCash treats the types differently. Below that table, it
uses the same wording to describe the possible child accounts of the two
types.

Is there a functional difference in how GnuCash treats accounts of type
"Stock" and "Mutual Fund"?

Thank you,
 —Jim DeLaHunt



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] What is the difference between Account types "Stock" and "Mutual fund"?

[Jim DeLaHunt]

Hello, folks:

I am starting to read more closely the GnuCash instructions for tracking 
investments, after a long time bumbling along tracking current assets, 
but not really investments.


Now I read in the instructions "9.4.1. Setup Accounts for Stocks and 
Mutual Funds" 
 
that when I create a sub-account of a brokerage account, denominated in 
a particular security, I should set the Account Type to either "Stock" 
or "Mutual Fund".


Is there any difference in how GnuCash treats accounts of those two 
types?  Or is the distinction just documentation?  I suppose it is not a 
problem to select type "Stock" for my stocks, and "Mutual Fund" for my 
mutual funds.  I also have Exchange-Traded Funds (ETFs), for which there 
is no specific account type. Does it matter which type I pick for ETFs?


The Account Type documentation at "Table 5.1. Types of GnuCash Accounts" 
 
describes types "Stock" and "Mutual Fund" differently. However, it does 
not say that GnuCash treats the types differently. Below that table, it 
uses the same wording to describe the possible child accounts of the two 
types.


Is there a functional difference in how GnuCash treats accounts of type 
"Stock" and "Mutual Fund"?


Thank you,
 —Jim DeLaHunt



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Why does the sample "investments" account tree have intermediate "Bond", "Mutual Fund", and "Stock" accounts?

[Jim DeLaHunt]

Hello, folks:

I have been using GnuCash for a long time, starting with the GnuCash 
template account tree and modifying it gradually, but never thinking 
hard about it. Until now. I am adding a bunch of investment accounts. 
This makes me look more closely at the template account structure 
depicted in 
.


This structure is:

 * Assets
 o Investments
 + Brokerage account
 # Bond
 # Mutual Fund
 # Stock
 * AMZN

What is the reason for the template inserting the layer of subaccounts 
between "Brokerage account" and "AMZN" (for Amazon.com stock)? Why 
shouldn't the child accounts denominated in each security be directly 
under the "Brokerage account" account (as long as the parent account is 
denominated in the currency which the securities are priced in)?


For my own purposes, it seems simpler to me to have the per-security 
child accounts be directly under the "Brokerage account". Is there a 
rationale for the intermediate accounts which I am missing?


Also, in the template, the "Brokerage account" is of type "Bank", and is 
not a placeholder. That seems to imply that cash and cash-equivalent 
transactions should be applied directly to "Brokerage account". Somehow 
I ended up making a child account "Cash CAD" (or "Cash USD", or 
whichever), and applying all the cash-equivalent transactiosn there. My 
equivalent of "Brokerage account" has no transactions, and is often a 
placeholder account, and has account type "Asset" rather than "Bank".   
Is there a reason to put the cash transactions directly in the brokerage 
account, or is this a matter of personal preference? (In which case, I 
will keep the structure I have.)


Thank you in advance for your insight,
 —Jim DeLaHunt

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to bulk import about 130 Securities entries?

[Jim DeLaHunt]

Hello, folks:

I am a long-time GnuCash user, and for all those years I have pretty 
much not attempted to track my investments in GnuCash. But now I want to 
start.  My first goal is to import many years of past activity.


I have downloaded the transactions from my brokerage account as a CSV 
file. The first thing I get out of this is the name and symbol of about 
130 securities. I am wondering if there is a practical way to bulk 
import these into GnuCash. That is, instead of visiting Tools -- 
Security Editor, and pressing the Add button 130 times, and filling out 
the "New security" dialogue 130 times, is there a more efficient path?


Looking at the File… Import menu, I do not see an option to import 
Securities. Looking at the documentation, wiki, and list archives, I 
don't see a mention of this. Is there some bulk import mechanism I am 
overlooking?


I took a look at the uncompressed XML contents of a new, simple .gnucash 
book file. It appears that the data entered in the "New security" 
dialogue gets stored as  entities. There appears to be a 
pretty simple relationship between the fields of the dialogue and the 
text within the  entity. The entities are stored in a 
certain order, sorted by  then . There is a 
 entity which seems to contain a 
text count of the non-CURRENCY gnc:commodity entries.


This makes me wonder if I could transform my list of 130 security names 
and symbols into  entities, and insert them into the 
GnuCash XML of my book.


Are there complexities or pitfalls about this approach which I might be 
overlooking?  We can certainly stipulate that manipulating the XML 
content directly is unsupported and risky, I must be careful and keep 
backups, I might blow off my fingers, etc.  For what it's worth, I 
believe that I am pretty proficient with editing XML, processing CSV 
files, and scripting manipulations of text data.


Once I have the securities added to the book, I then need to add the 
appropriate child accounts to my brokerage accounts, each denominated in 
the appropriate security type and symbol. It looks like that is 
straightforward to do with a CSV of accounts in the correct format, and 
the File… Import…  Import Accounts from CSV… menu item. I have a few 
child accounts which I entered from the UI which will serve as 
examples.  Is there any way in which this is more difficult than it looks?


Cheers,
 —Jim "ADBE ALNIX AOL … VUG VWO ZTD81" DeLaHunt

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Crash in Trial Balance report

[David Carlson]

I can't see the screenshot from here, but what John is suggesting is that
GnuCash uses (or may use) a price of $0 in some transactions in that report
when it computes the average cost.  That could lead to a divide-by-zero
error which can cause a crash.  He goes on to hint at a way to find the
error if that indeed is the problem.

On Sat, Aug 13, 2022 at 4:17 PM Fred Tydeman  wrote:

> I do not understand what you mean by "numbers in the list"
> I have many securities that have zero balance (due to being sold).
> I looked at /tmp/guncash.trace and what I see there mostly matched the
> Report Error in the Trial Balance display.
>
> On Sat, Aug 13, 2022 at 1:44 PM john  wrote:
>
> >
> >
> > > On Aug 13, 2022, at 6:12 AM, Fred Tydeman 
> > wrote:
> > >
> > > I am running Linux and GnuCash 4.11
> > > When I try to do a Trial Balance report, I get a crash.
> > > Screenshot attached.
> > > I assume it is due to bad data somewhere,
> > > but I have no idea where or what it is.
> > >  > 09-09-47.png>___
> >
> > The failure is in computing the average cost of some security and I think
> > it's hitting a failed conversion, maybe a divide-by-zero. You should be
> > able to figure out which security by comparing the numbers in the list
> with
> > the values of the first transactions in the security's register. Hope you
> > don't have too many securities to examine.
> >
> > Regards,
> > John Ralls
> >
> >
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Crash in Trial Balance report

[Fred Tydeman]

I do not understand what you mean by "numbers in the list"
I have many securities that have zero balance (due to being sold).
I looked at /tmp/guncash.trace and what I see there mostly matched the
Report Error in the Trial Balance display.

On Sat, Aug 13, 2022 at 1:44 PM john  wrote:

>
>
> > On Aug 13, 2022, at 6:12 AM, Fred Tydeman 
> wrote:
> >
> > I am running Linux and GnuCash 4.11
> > When I try to do a Trial Balance report, I get a crash.
> > Screenshot attached.
> > I assume it is due to bad data somewhere,
> > but I have no idea where or what it is.
> >  09-09-47.png>___
>
> The failure is in computing the average cost of some security and I think
> it's hitting a failed conversion, maybe a divide-by-zero. You should be
> able to figure out which security by comparing the numbers in the list with
> the values of the first transactions in the security's register. Hope you
> don't have too many securities to examine.
>
> Regards,
> John Ralls
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Zero balances in report

[Fred Tydeman]

When I changed the account depth to "all", the zero entries (which are
stocks) went away.
But, that makes the report harder to read.
Seems like a bug to me.

On Sat, Aug 13, 2022 at 1:56 PM john  wrote:

>
>
> > On Aug 13, 2022, at 7:54 AM, Michael Hendry 
> wrote:
> >
> > On 13 Aug 2022, at 14:08, Fred Tydeman  wrote:
> >>
> >> I am running Linux and GnuCash 4.11
> >> I do an Account Summary report.
> >> I have set the options to not show zero balances.
> >> Yet, the report shows many zero balances.
> >> The attached screen shot shows part of the report
> >> along with the options.
> >>  09-01-37.png>___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >
> > I’ve just tried this, and when I untick “Include accounts with zero
> total balances” and tick “Omit zero balance figures” I get the desired
> output.
> >
> > Did you remember to hit the “Apply” button after changing these
> tick-boxes?
>
> That's not it, you can see that the apply button is greyed out in the
> screenshot.
>
> The report is summarizing all of the commodities held in some parent
> account including the zero balance ones. I'm not sure if that's a bug or a
> feature, but to get the display I think you want go to the Accounts tab of
> the report options dialog and increase the account depth so that the
> individual commodity accounts are displayed.
>
> Regards,
> John Ralls
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Zero balances in report

[John Ralls]

> On Aug 13, 2022, at 10:55 AM, john  wrote:
> 
> 
> 
>> On Aug 13, 2022, at 7:54 AM, Michael Hendry  wrote:
>> 
>> On 13 Aug 2022, at 14:08, Fred Tydeman  wrote:
>>> 
>>> I am running Linux and GnuCash 4.11
>>> I do an Account Summary report.
>>> I have set the options to not show zero balances.
>>> Yet, the report shows many zero balances.
>>> The attached screen shot shows part of the report
>>> along with the options.
>>> >> 09-01-37.png>___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> I’ve just tried this, and when I untick “Include accounts with zero total 
>> balances” and tick “Omit zero balance figures” I get the desired output.
>> 
>> Did you remember to hit the “Apply” button after changing these tick-boxes?
> 
> That's not it, you can see that the apply button is greyed out in the 
> screenshot.
> 
> The report is summarizing all of the commodities held in some parent account 
> including the zero balance ones. I'm not sure if that's a bug or a feature, 
> but to get the display I think you want go to the Accounts tab of the report 
> options dialog and increase the account depth so that the individual 
> commodity accounts are displayed. 

Another thought: I was doing something else and noticed output like 
;;; WARNING (gnc:resolve-unknown-comm: can't calculate rate for  £10,407.64  =  
6,786.5711 GB000fund01  to  $0.00)

Check your trace file, maybe you have similar warnings or errors that will help 
find the bad transaction.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Zero balances in report

[john]

> On Aug 13, 2022, at 7:54 AM, Michael Hendry  wrote:
> 
> On 13 Aug 2022, at 14:08, Fred Tydeman  wrote:
>> 
>> I am running Linux and GnuCash 4.11
>> I do an Account Summary report.
>> I have set the options to not show zero balances.
>> Yet, the report shows many zero balances.
>> The attached screen shot shows part of the report
>> along with the options.
>> > 09-01-37.png>___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> I’ve just tried this, and when I untick “Include accounts with zero total 
> balances” and tick “Omit zero balance figures” I get the desired output.
> 
> Did you remember to hit the “Apply” button after changing these tick-boxes?

That's not it, you can see that the apply button is greyed out in the 
screenshot.

The report is summarizing all of the commodities held in some parent account 
including the zero balance ones. I'm not sure if that's a bug or a feature, but 
to get the display I think you want go to the Accounts tab of the report 
options dialog and increase the account depth so that the individual commodity 
accounts are displayed. 

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Crash in Trial Balance report

[john]

> On Aug 13, 2022, at 6:12 AM, Fred Tydeman  wrote:
> 
> I am running Linux and GnuCash 4.11
> When I try to do a Trial Balance report, I get a crash.
> Screenshot attached.
> I assume it is due to bad data somewhere,
> but I have no idea where or what it is.
>  09-09-47.png>___

The failure is in computing the average cost of some security and I think it's 
hitting a failed conversion, maybe a divide-by-zero. You should be able to 
figure out which security by comparing the numbers in the list with the values 
of the first transactions in the security's register. Hope you don't have too 
many securities to examine.

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Tax Accounting for Trust Income Received in Following Fiscal Year

[john]

One of these years I'll find time to rewrite that chapter. I don't know of any 
case where someone in GnuCash's target user base of individuals and very small 
companies would need to book unrealized gains that way; mostly only big 
financial companies need to do that. 

The normal way of tracking portfolio performance runs off of the price 
database. The account balances on the Accounts page are converted to the book's 
root currency at the most recent price in the price database and most reports 
default selection is to use the price nearest in time to the report date. You 
can create prices with the Add button in the Price Database dialog, Tools>Price 
Database.

Regards,
John Ralls


> On Aug 12, 2022, at 8:33 PM, flywire  wrote:
> 
> Despite the example in my previous post, I'm inclined to just manage the
> share portfolio value rather than the shares by revaluing annually as
> described in
> https://www.gnucash.org/docs/v4/C/gnucash-guide/capgain_example1.html#capgain_exampleunrealized2
> . It involves an Income:Unrealized Gains transaction and I'd prefer not to
> generate that under income. How does revaluation work when shares are set
> up directly? I can't see an Income:Unrealized Gains transaction.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Zero balances in report

[Michael Hendry]

On 13 Aug 2022, at 14:08, Fred Tydeman  wrote:
> 
> I am running Linux and GnuCash 4.11
> I do an Account Summary report.
> I have set the options to not show zero balances.
> Yet, the report shows many zero balances.
> The attached screen shot shows part of the report
> along with the options.
>  09-01-37.png>___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

I’ve just tried this, and when I untick “Include accounts with zero total 
balances” and tick “Omit zero balance figures” I get the desired output.

Did you remember to hit the “Apply” button after changing these tick-boxes?

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Scheduled transactions do not appear in the register until is pressed

[Glenn Fowler]

Just confirming the nightly works as expected! Upon opening, the scheduled
transactions were already there with no user interaction. (bonus: also
noticed the links to the various paths in Help > About)

On Fri, Aug 12, 2022 at 4:44 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Yet another example of how awesome the GnuCash team is. Thanks John!
>
> Regards,
> Adrien
>
> On 8/12/22 3:11 PM, John Ralls wrote:
> > That was it: The registers weren't refreshed unless the SLR dialog runs
> and the user clicks OK. I've pushed a fix that will be in tomorrow's
> nightlies (https://code.gnucash.org/builds/win32/maint and
> https://code.gnucash.org/builds/flatpak.maint).
> >
> > Regards,
> > John Ralls
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Scheduled transactions do not appear in the register until is pressed

[Tom Veik]

Thanks John!  Installed the nightly this morning and did some simple 
testing.  Seems to be working now.


Tom

On 8/12/2022 3:11 PM, John Ralls wrote:

That was it: The registers weren't refreshed unless the SLR dialog runs and the 
user clicks OK. I've pushed a fix that will be in tomorrow's nightlies 
(https://code.gnucash.org/builds/win32/maint and 
https://code.gnucash.org/builds/flatpak.maint).

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Crash in Trial Balance report

[Fred Tydeman]

I am running Linux and GnuCash 4.11
When I try to do a Trial Balance report, I get a crash.
Screenshot attached.
I assume it is due to bad data somewhere,
but I have no idea where or what it is.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.