[GNC] Zeros in Balance sheet

Fred Tydeman tydeman.fred at gmail.com
Thu Jun 20 12:40:09 EDT 2024


One account I checked in detail has no children.
In the report, it shows as VOO
The only account with that name is a trading account.
The corresponding stock investment account is Vang 500 ETF
The account has two buys and two sells in 2023 with a net of zero.
I am doing a Balance Sheet for today.
I believe that most (if not all) of the zero lines are for stocks that have
been sold
and have no children accounts.

If I run a report with default level of 3, but check Flatten list to depth
limit,
then the zero lines in the report go away.

On Thu, Jun 20, 2024 at 3:54 PM Michael or Penny Novack <
stepbystepfarm at comcast.net> wrote:

> On 6/20/2024 10:03 AM, Fred Tydeman wrote:
> > Fedora Linux 37
> > GnuCash 4.14
> >
> > Doing  Reports: Assets&Liabilities: Balance Sheet
> > In the Options: Display:
> > I uncheck Include accounts with zero total balances
> > I check Omit zero balance figures
> >
> > If I take the default of 3 Levels of subaccounts
> > the report has lots of lines with zero amounts.
> >
> > If I change the Levels of subaccounts to All,
> > then the zero entries go away.
> >
> > Seems wrong.
>
> I'm not so sure wrong. Let me ask you a question
>
> These accounts that appear (even though showing zero) at a small number
> of levels but that disappear then the nesting level is increased enough
> to expand the entire tree ........ Do they have children that are not
> appearing because of level truncation.
>
> Consider THIS situation << where truncation is set so that only Account
> X shows >>
>
>           Account X                        (balance 0)
>
>                  Account Y                   (balance debit  10)
>
>                  Account Z                   (balance credit 10)
>
> In other words, I might want to see an account whose balance is zero IF
> it has children  (being truncated) with non-zero balances. I'd at least
> want to think about it some  before deciding show vs don't show.    And
> possibly any situation where the children COULD BE non-zero. In other
> words, is the "exclude zero" not working as you expect because  because
> truncation of levels means the report can no longer "see" if below there
> all zero or not.
>
> Michael D Novack
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> 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
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


More information about the gnucash-user mailing list