Re: [GNC] Fwd: The two modules

2018-06-30 Thread Stephen M. Butler
On 06/28/2018 10:02 PM, DaveC49 wrote: > Hi Stephen, > > I agree with your wife about not including the Income Statement inside a > Balance Sheet. These serve different functions and it just makes a Balance > Sheet more complicated than necessary. From an accounting perspective you > should be

Re: [GNC] Fwd: The two modules

2018-06-30 Thread DaveC49
Hi Stephen, I agree with your wife about not including the Income Statement inside a Balance Sheet. These serve different functions and it just makes a Balance Sheet more complicated than necessary. From an accounting perspective you should be able to evaluate a balance sheet fairly quickly and

Re: [GNC] Fwd: The two modules

2018-06-30 Thread DaveC49
John, I agree with you that making the accounts with child accounts have no transactions is being unnecessarily restrictive and may not meet all possible use cases but perhaps having the option of being able to restrict it to that case if it suits an individual's purpose is a suitable compromise.

Re: [GNC] Fwd: The two modules

2018-06-29 Thread Geert Janssens
Op donderdag 28 juni 2018 20:34:45 CEST schreef David Carlson: > Is the 'frozen' status which is already in place but seemingly unused > supposed to be for this purpose? > > David C I have no idea what the intent of that status is. Looks like yet another variant of this though. Geert

Re: [GNC] Fwd: The two modules

2018-06-29 Thread Christopher Lam
Hi David It'd seem the Frozen status relates to transaction status (Unreconciled/Cleared/Reconciled/Void/Frozen) only, and is so far unused. I'm going to amend the balsheet-pnl to the desired format. This means the accounts are shown sequentially, and *every* account will also include

Re: [GNC] Fwd: The two modules

2018-06-28 Thread Dale Alspach
I work with an organization that uses QuikBooks. There seems to be a built in mechanism in the report generator in that software that automatically adds a line with name [parent account name] Other which contains the total of the transactions in the parent account not in any subaccount of the

Re: [GNC] Fwd: The two modules

2018-06-28 Thread D via gnucash-user
On June 28, 2018, at 1:12 PM, Geert Janssens wrote: >Op donderdag 28 juni 2018 18:47:18 CEST schreef Stephen M. Butler: [Snip] >> Maybe the financial folks can band together to get the developers to >> enforce no-transactions to a parent account. >I think we should modify the concepts.

Re: [GNC] Fwd: The two modules

2018-06-28 Thread David Carlson
Is the 'frozen' status which is already in place but seemingly unused supposed to be for this purpose? David C On Thu, Jun 28, 2018, 12:31 PM John Ralls wrote: > > > > On Jun 28, 2018, at 10:10 AM, Geert Janssens > wrote: > > > > Op donderdag 28 juni 2018 18:47:18 CEST schreef Stephen M.

Re: [GNC] Fwd: The two modules

2018-06-28 Thread John Ralls
> On Jun 28, 2018, at 10:10 AM, Geert Janssens > wrote: > > Op donderdag 28 juni 2018 18:47:18 CEST schreef Stephen M. Butler: >> On 06/27/2018 04:41 PM, DaveC49 wrote: >>> An active non-placeholder account should not have child/subaccounts, >>> although I don't think GnuCash actually

Re: [GNC] Fwd: The two modules

2018-06-28 Thread Stephen M. Butler
On 06/28/2018 10:10 AM, Geert Janssens wrote: > Op donderdag 28 juni 2018 18:47:18 CEST schreef Stephen M. Butler: >> On 06/27/2018 04:41 PM, DaveC49 wrote: >>> An active non-placeholder account should not have child/subaccounts, >>> although I don't think GnuCash actually prevents this. In this

Re: [GNC] Fwd: The two modules

2018-06-28 Thread Geert Janssens
Op donderdag 28 juni 2018 18:47:18 CEST schreef Stephen M. Butler: > On 06/27/2018 04:41 PM, DaveC49 wrote: > > An active non-placeholder account should not have child/subaccounts, > > although I don't think GnuCash actually prevents this. In this case, the > > parent account total is the sum of

Re: [GNC] Fwd: The two modules

2018-06-28 Thread Stephen M. Butler
On 06/27/2018 04:41 PM, DaveC49 wrote: > Stephen, > > As an accountant I would prefer to have parent accounts as placeholder > accounts which cannot be the target of transactions directly (this can be > set in the edit Account dialog and marks the account as read only) as the > placeholder total

Re: [GNC] Fwd: The two modules

2018-06-28 Thread Mike or Penny Novack
On 6/28/2018 9:39 AM, D via gnucash-user wrote: Before you convert an existing parent account to a placeholder (by checking the placeholder checkbox in the Edit Account dialog), you will need to transfer any transactions into it to an appropriate child/sub-account. My experience is that a

Re: [GNC] Fwd: The two modules

2018-06-28 Thread D via gnucash-user
David, You've now misstated twice that Placeholder accounts cannot have transactions, and I feel it is important to make it unambiguously clear to anyone reading this thread that there is nothing in Gnucash that prevents placeholder accounts from having transactions. Setting an account as a

Re: [GNC] Fwd: The two modules

2018-06-28 Thread Christopher Lam
Hi Dave It's nice to have input from someone in the know. I have used the placeholder flag to tag accounts which are now closed, e.g. closed bank accounts, loans paid off, old unused expense categories. This is not expressly disallowed by the UI, and the advantage here is the account does

Re: [GNC] Fwd: The two modules

2018-06-28 Thread DaveC49
Stephen, As an accountant I would prefer to have parent accounts as placeholder accounts which cannot be the target of transactions directly (this can be set in the edit Account dialog and marks the account as read only) as the placeholder total should then be the sum of its active child

Re: [GNC] Fwd: The two modules

2018-06-26 Thread Stephen M. Butler
On 06/25/2018 01:51 AM, DaveC49 wrote: > Stephen, > > You can possibly force the case of sum of the children account totals being > the parent account total by making the parent a placeholder account. Then > it cannot have any transactions into it, only the child accounts. > > David Cousens > >

Re: [GNC] Fwd: The two modules

2018-06-25 Thread DaveC49
Stephen, There is no need to install the libofx7specifically. If you install libofx-dev that should install the the appropriate version of the library for your ubuntu version (i.e. libofx4 on 14.04(Trusty), libofx6 on 16.04 (Xenial) and libofx7 on 18.04 (Bionic) David Cousens - David

Re: [GNC] Fwd: The two modules

2018-06-25 Thread DaveC49
Stephen, You can possibly force the case of sum of the children account totals being the parent account total by making the parent a placeholder account. Then it cannot have any transactions into it, only the child accounts. David Cousens - David Cousens -- Sent from:

Re: [GNC] Fwd: The two modules

2018-06-22 Thread Stephen M. Butler
Geert, Thank you.  Thank you.  I now have a working version Version: 3.1 Build ID: 3.1+ (2018-04-28) up and running on Ubuntu 18.04 On 06/22/2018 11:32 AM, Geert Janssens wrote: > Ok, in that case I think the easiest way forward is to not use > GMOCK_ROOT and > GTEST_ROOT and let gnucash

Re: [GNC] Fwd: The two modules

2018-06-22 Thread Geert Janssens
Op vrijdag 22 juni 2018 19:09:47 CEST schreef Stephen M. Butler: > On 06/22/2018 12:29 AM, Geert Janssens wrote: > > Op donderdag 21 juni 2018 00:01:32 CEST schreef Stephen M. Butler: > >> Found libofx7 and installed that instead of libofx6 and libofx4. > > > > These numbers seem to increase

Re: [GNC] Fwd: The two modules

2018-06-22 Thread Stephen M. Butler
On 06/22/2018 12:29 AM, Geert Janssens wrote: > Op donderdag 21 juni 2018 00:01:32 CEST schreef Stephen M. Butler: >> Found libofx7 and installed that instead of libofx6 and libofx4. >> > These numbers seem to increase regularly... I have updated the install > instruction to only install

Re: [GNC] Fwd: The two modules

2018-06-22 Thread Stephen M. Butler
The accountant is real uncomfortable with removing the cash account.  She feels that the children should add up to the total for the parent.  Given that GnuCash allows a parent to also have funds/transactions in addition to the children, I guess the work around would be to treat those as the

Re: [GNC] Fwd: The two modules

2018-06-22 Thread Geert Janssens
Op donderdag 21 juni 2018 00:01:32 CEST schreef Stephen M. Butler: > Found libofx7 and installed that instead of libofx6 and libofx4. > These numbers seem to increase regularly... I have updated the install instruction to only install libofx-dev. This will automatically pull in the

Re: [GNC] Fwd: The two modules

2018-06-22 Thread Christopher Lam
Hi Stephen Thank you this is useful. Confirms my suspicions that unrealized gains shouldn't appear in balsheet. From your illustrations below, the only addition I'd offer is there wouldn't be a separate 142 Broker:Cash account, it'd be "140 Broker $2000", "144 Broker:Stock $4000" entries...

Re: [GNC] Fwd: The two modules

2018-06-21 Thread Stephen M. Butler
Christopher Going to the latest version is stymied until I hear back from one of the developers on what went wrong with make. I'm new to using GnuCash so have not delved into the Foreign currency or stocks. So, let's build a COA together and see what happens (on paper): 100 - Asset 110 -   " :

Re: [GNC] Fwd: The two modules

2018-06-20 Thread Stephen M. Butler
Found libofx7 and installed that instead of libofx6 and libofx4. After a few other missed steps I now have completed the "cmake ../gnucash-3.1" step  However the "make" step has problems: ... [ 29%] Built target test-core-guile Scanning dependencies of target scm-test-core [ 29%] Generating

Re: [GNC] Fwd: The two modules

2018-06-20 Thread Stephen M. Butler
Thank you.  Found those entries and also found I had missed to OFX portion -- but apt-get complains on that one: $ sudo apt-get install libofx6 libofx4 libofx-dev Reading package lists... Done Building dependency tree   Reading state information... Done Package libofx6 is not available, but

Re: [GNC] Fwd: The two modules

2018-06-20 Thread nvsoar
Seems to me that I read recently that gwenhywfar is an AQ Banking package.  On the same google page is an entry that it can be downloaded from Source Forge. nvsoar On 06/20/18 13:17, Stephen M. Butler wrote: Then I ran into this problem.  Researching. I don't see 'gwenhywfar' listed on the

Re: [GNC] Fwd: The two modules

2018-06-20 Thread Stephen M. Butler
Then I ran into this problem.  Researching. I don't see 'gwenhywfar' listed on the installation page.  Attempting to install says package not found.  $ cmake -D CMAKE_INStALL_PREFIX=/usr/local ../gnucash-3.1 -- The C compiler identification is GNU 7.3.0 -- The CXX compiler identification is GNU

Re: [GNC] Fwd: The two modules

2018-06-20 Thread Stephen M. Butler
I decided to pull down the latest version (I know a new one is coming in just a few days) to be sure I could compile it and utilize the latest versions of the reports for this mock company. But, I ran into a slight problem installing the packages and hope I made the right choice:  $ sudo apt-get

Re: [GNC] Fwd: The two modules

2018-06-18 Thread Christopher Lam
Hi Stephen One of the most unique features of gnucash is the multilevel account hierarchy, meaning both parent accounts and child accounts can carry balances. Would you mind liaising with the house accountant to ask about the following COA and the resulting balance sheet Asset (bal=$0.00)

Re: [GNC] Fwd: The two modules

2018-06-18 Thread Stephen M. Butler
Yes, it is the alignment of numbers that is the problem. Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/18/2018 06:35 AM, Christopher Lam