[GNC] Moving from Sage Accounting and would like to keep sub-account totals viewable

[Derek Atkins]

Hi David,

David Carlson <david.carlson.417 at gmail.com> writes:

> Derek,
>
> If what you call a rolling balance is what I call a running balance,  then I
> think that the account register view will show that when it is sorted in
> chronological order.  In fact, as others have already noted, you can see that
> in your top level accounts.  Where you won't see it is in mixed commodity/
> mixed currency cases such as stock brokerage accounts or other mixed currency
> accounts. For those cases it is necessary to use a report that can evaluate
> appropriate exchange rates. 

Yes, rolling/running balance.  However, while there is a balance column
being displayed, it might not show the *correct* balance because each
split shown has a precomputed balance for the actual account it is tied
to.  This balance is recomputed whenever a split in the account is
modified.  However, it is NOT computed in real-time for display.

So when you do a "Open Subaccounts" view, it is not recomputing the
balance including everything, but rather it is still showing the
pre-computed balance of the split's account balance for that split.

It *MAY* look correct at some points in time, but in general, no, it is
not.

> David Carlson 

-derek

> On Mon, Nov 18, 2019, 8:22 AM Derek Atkins <derek at ihtfp.com> wrote:
>
>     Rick,
>    
>     Richard Danielson <rdan217 at gmail.com> writes:
>    
>     > Re the subtotals issue, I used to have a number of subtotals
>     > (e.g. groceries, snacks and restaurants in the food category) which
>     > showed up in income accounts.  That is what I can't figure out in GC. 
>     > I can make accounts sub-accounts for heading accounts, and get the
>     > totals for the sub-accounts to show in the income statement, but can't
>     > get the program to sum the sub-accounts into the heading accounts.
>    
>     Note that a parent account will only roll up the balance in sub-accounts
>     in the CoA or Reports.  If you *open* the parent account then it wont
>     show the transactions (or balances) from the sub-accounts.  It is
>     unclear from your question how/where you are trying to view the
>     rolled-up balances.
>    
>     There is an option to "Open Subaccounts", which will merge all the
>     transactions from the subaccounts, but it wont show a rolling balance.
>    
>     Hope this helps,
>    
>     > Rick
>    
>     > Please remember to CC this list on all your replies.
>     > You can do this by using Reply-To-List or Reply-All.
>    
>     -derek
>    
>     --
>            Derek Atkins                 617-623-3745
>            derek at ihtfp.com             www.ihtfp.com
>            Computer and Internet Security Consultant
>

-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant