[GNC] Fwd: The two modules

Stephen M. Butler kg7je at arrl.net
Fri Jun 22 12:49:25 EDT 2018


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 initial, unidentified, child.  That way, when you add up
the column the total would include the contribution from the parent.

A balance sheet is made at a single point in time, such as, close of
business on xxxx.   [or start of business, ..., midday, etc]

Stephen M Butler, PMP, PSM
Stephen.M.Butler51 at gmail.com
kg7je at arrl.net
253-350-0166
-------------------------------------------
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

On 06/21/2018 11:15 PM, Christopher Lam wrote:
> 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... would this be a legitimate
> amendment?
>
> And are multiple-date balsheets legit?
>
> Ta
>
>
> On 22/06/18 09:09, Stephen M. Butler wrote:
>> 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 -   " : Bank1
>> 112 -   " :    "  :Checking
>> 114 -   " :    "  : Savings
>> 116 -   " :    "  : Bonds
>> 120 -   " : Bank2
>> 130 -   " : ForeignBank   (GBP currency)
>> 140 -   " : Broker
>> 142 -   " :    "  : Cash
>> 144 -   " :    "  : Stock
>> 150 -   " : House
>>
>> 200 - Liability
>> 220 -   " : Bank2
>> 222 -   " :   "  : Loan
>> 224 -   " :   "  : Creditcard
>>
>> 300 - Equity
>>
>> 400 - Income
>>
>> 500 - Expense
>>
>> We may fill in the above further as we work along.  So, our initial
>> transaction will be to setup our initial balances:
>> [Normally we would setup somewhat prior to the above purchases and buy
>> things out of the checking account -- but, we just installed the
>> software and are starting in the middle.]
>>
>> Transaction 001
>>      114 Debit $100
>>      116 Debit $2000
>>      120 Debit $500
>>      130 Debit GBP 500  (equivalent to $625 at time of purchase)
>>      142 Debit $2000
>>      144 Debit $4000 (20 units @ $200)
>>      222 Credit $9000
>>      224 Credit $500
>>      300 Debit $275   [Note, we are below water here.  Equity should
>> be a
>> credit account and we are in the hole.]
>>
>> At this point I went to the house accountant and asked about unrealized
>> gain and how to book it.  She said you don't.  Not until there is an
>> event in which it is sold or traded.  For tomorrow GBP might drop back
>> to parity, the stock might crash, and the housing market could implode.
>>
>> So, we may need input from others who might have a different viewpoint.
>>
>> Stephen M Butler, PMP, PSM
>> Stephen.M.Butler51 at gmail.com
>> kg7je at arrl.net
>> 253-350-0166
>> -------------------------------------------
>> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>>
>> On 06/18/2018 03:32 PM, Christopher Lam wrote:
>>> 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)
>>> Asset:Bank1 (bal=$0.00)
>>> Asset:Bank1:Savings (bal=$100)
>>> Asset:Bank1:Bonds (bal=$2000)
>>> Asset:Bank2:Current (bal=$500)
>>> Asset:House (bal=$100,000, cost price)
>>> Asset:ForeignBank:Savings (bal=GBP 500, bought last year at a rate of
>>> 1 GBP = 1.25 USD
>>> Asset:Broker (bal=$2000) i.e.cash with broker
>>> Asset:Broker:Funds [stock] (bal=20units bought @ $200 each)
>>> Liability (bal=$0)
>>> Liability:Bank2 (bal=$0)
>>> Liability:Bank2:Loan (bal=-$9,000)
>>> Liability:Bank2:Creditcard (bal=-$500)
>>>
>>> Let's assume the current valuation of the unit funds is $250 i.e.
>>> unrealized gains of $1000; the house is currently valued at $110,000,
>>> and today 1 GBP = 1.30 USD :)
>>>
>>> How should the full expanded balance sheet look like? (XLS is fine)
>>> (if there are missing lines e.g. retained earnings etc please make up
>>> numbers and offer exact source)
>>>
>>> Thanks!
>>>
>>>
>>> On 19/06/18 00:16, Stephen M. Butler wrote:
>>>> Yes, it is the alignment of numbers that is the problem.
>>>>
>>>> Stephen M Butler, PMP, PSM
>>>> Stephen.M.Butler51 at gmail.com
>>>> kg7je at 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 wrote:
>>>>> Hi Stephen
>>>>> Thank you this is very helpful.
>>>>>   From my understanding the non-eguile version does produce
>>>>> satisfactory
>>>>> headings and contents.
>>>>> However its alignment of numbers is odd?
>>>>> Is the alignment of subtotals and totals perfect in your amended
>>>>> eguile report? How should it look if there are deeper levels of
>>>>> subaccounts?
>>>>> For html export, open the report tab, then File>Export>Export Report.
>>>>> I believe the standard balsheet can be refined but this will take
>>>>> some
>>>>> time.
>>>>> C
>>>>>
>>>>> On 18 June 2018 at 00:32, Stephen M. Butler <kg7je at arrl.net
>>>>> <mailto:kg7je at arrl.net>> wrote:
>>>>>
>>>>>       Interesting on the age.  I thought I'd downloaded the most
>>>>> recent
>>>>>       Linux
>>>>>       install.  But, my version is 2.6.19 built from rev
>>>>> c1b5e6c8d+ on
>>>>>       2018-04-09.  May be best to wait for the next release due out
>>>>>       early next
>>>>>       week and see how those reports look.
>>>>>
>>>>>       In the interim, attached are:
>>>>>       1.  GVE.gnucash -- my current set of books for an apartment
>>>>>       building I'm
>>>>>       selling
>>>>>       2.  Balance Sheet - standard.pdf -- Standard Balance Sheet
>>>>> report
>>>>>       (unformatted)
>>>>>       3.  Balance Sheet - formatted.pdf -- Eguile balance sheet
>>>>> after my
>>>>>       changes were applied
>>>>>               (Wife still has problems but willing to work with this.
>>>>>       Specifically, the "Profit/Loss" line should be part of Equities
>>>>> and be
>>>>>       added just after Retained earnings.  She thinks I should have
>>>>> just one
>>>>>       line of retained earnings rather than the yearly line I created
>>>>> when
>>>>>       closing the books each year -- I'll have to clean up my
>>>>> chart of
>>>>>       accounts to accomplish that -- sigh!)  Plus, I have top level
>>>>> accounts
>>>>>       with the five major names (Assets, Liabilities, Equities --
>>>>> maybe
>>>>>       should
>>>>>       rename to Capital, Income and Expense).  So the report does
>>>>> look funny
>>>>>       with the section titles repeated due to my top level accounts.
>>>>>
>>>>>       I was going to include the eguile version -- but it no longer
>>>>> wants to
>>>>>       link in when I put that code back in place.  Wish I truly
>>>>>       understood how
>>>>>       that linkage works.  Doesn't seem to function as documented
>>>>> -- at
>>>>>       least
>>>>>       as to how I read/understood the document!  But, since eguile is
>>>>> going
>>>>>       away, that probably doesn't matter.
>>>>>
>>>>>       Also, is there a way to dump the html version of the reports.
>>>>> I think
>>>>>       that is what you wanted but I've only figured out how to
>>>>> capture
>>>>>       the pdf
>>>>>       version to a file rather than letting it print.  Seems strange
>>>>> as I do
>>>>>       have 20 years on Unix type systems -- but mostly as an Oracle
>>>>> DBA and
>>>>>       didn't delve deep into the O/S.  Even my korn shell scripting
>>>>> ability
>>>>>       has atrophied in the past year.
>>>>>
>>>>>       I need to head out and attempt to destroy some bamboo that the
>>>>>       previous
>>>>>       owner let escape.  Plus put in the column bases for the
>>>>> greenhouse the
>>>>>       wife wants for her orchids.  Isn't retirement fun!  How did
>>>>> I ever
>>>>>       have
>>>>>       time to make the daily trip to downtown Seattle for a living?
>>>>>
>>>>>       --Steve
>>>>>
>>>>>
>>>>>       Stephen M Butler, PMP, PSM
>>>>>       Stephen.M.Butler51 at gmail.com
>>>>> <mailto:Stephen.M.Butler51 at gmail.com>
>>>>>       kg7je at arrl.net <mailto:kg7je at arrl.net>
>>>>>       253-350-0166
>>>>>       -------------------------------------------
>>>>>       GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477
>>>>> 0385 81D8
>>>>>
>>>>>       On 06/15/2018 09:06 PM, Christopher Lam wrote:
>>>>>       > Thanks; this is from an old version of eguile balsheet
>>>>> which is
>>>>>       > already obsolete in 3.X onwards, and I know it'll be more
>>>>>       difficult to
>>>>>       > fix as time goes by. There are already changes from
>>>>> timepair to
>>>>>       > time64, compulsory CSS, removal of slots access... There
>>>>> is no
>>>>>       active
>>>>>       > eguile maintainer anymore, and I really cannot understand
>>>>> eguile.
>>>>>       >
>>>>>       > Would you be kind to comment upon the HTML output (File >
>>>>> Export >
>>>>>       > Export Report) of the standard (non-eguile) balsheet, with
>>>>> desired
>>>>>       > amendments? I can try to amend with backward compatibility.
>>>>>       >
>>>>>       > For bonus points, if you have a sample datafile with accounts
>>>>> and
>>>>>       > transactions that highlight the various functionality of
>>>>> balsheet
>>>>>       > (e.g. income/expense, equity, any foreign currency
>>>>> conversions or
>>>>>       > stock purchases - I'm sure the wife will have them in her
>>>>> textbooks)
>>>>>       > I'm sure I can fix the standard balsheet to her standards!
>>>>>       >
>>>>>       > So, wishlist:
>>>>>       >
>>>>>       >   * datafile with example transactions
>>>>>       >   * current html report of standard balsheet
>>>>>       >   * annotated ideal report produced by standard balsheet :)
>>>>>       >
>>>>>       > Let's keep this discussion public for external input too.
>>>>>       >
>>>>>       > Regards
>>>>>       >
>>>>>       > ---------- Forwarded message ----------
>>>>>       > From: *Stephen M. Butler* <kg7je at arrl.net
>>>>> <mailto:kg7je at arrl.net> <mailto:kg7je at arrl.net
>>>>>       <mailto:kg7je at arrl.net>>>
>>>>>       > Date: 16 June 2018 at 00:45
>>>>>       > Subject: The two modules
>>>>>       > To: Christopher Lam <christopher.lck at gmail.com
>>>>>       <mailto:christopher.lck at gmail.com>
>>>>>       > <mailto:christopher.lck at gmail.com
>>>>> <mailto:christopher.lck at gmail.com>>>
>>>>>       >
>>>>>       > Hope this helps.  As I mentioned in the list email, perhaps
>>>>>       there is a
>>>>>       > way to show the Trading Accounts if they are present and
>>>>> suppress if
>>>>>       > they are not.
>>>>>       >
>>>>>       > Also, I think it would be acceptable to have an
>>>>> Income/Expense
>>>>>       Report on
>>>>>       > a separate page but generated by the same module.  That would
>>>>> ensure
>>>>>       > that the Profit/Loss line (or whatever folks want to call it)
>>>>>       would be
>>>>>       > the same for both reports.  But my wife was adamant that they
>>>>>       are two
>>>>>       > separate reports.
>>>>>       >
>>>>>       > Thanks for the example as this is my first time seeing this
>>>>>       language.
>>>>>       > You might find that I took some shortcuts where it wasn't
>>>>>       appropriate
>>>>>       > for the long haul -- especially around the printing of the
>>>>>       Profit/Loss
>>>>>       > line.  I'm still now sure what the #t #f and a couple of the
>>>>> other
>>>>>       > parameters actually do -- I just got the report to look
>>>>> right!
>>>>>       >
>>>>>       > --Steve
>>>>>       >
>>>>>       > --
>>>>>       > Stephen M Butler, PMP, PSM
>>>>>       > Stephen.M.Butler51 at gmail.com
>>>>>       <mailto:Stephen.M.Butler51 at gmail.com>
>>>>>       <mailto:Stephen.M.Butler51 at gmail.com
>>>>>       <mailto:Stephen.M.Butler51 at gmail.com>>
>>>>>       > kg7je at arrl.net <mailto:kg7je at arrl.net> <mailto:kg7je at arrl.net
>>>>>       <mailto:kg7je at arrl.net>>
>>>>>       > 253-350-0166
>>>>>       > -------------------------------------------
>>>>>       > GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A
>>>>> 5477 0385
>>>>>       81D8
>>>>>       >
>>>>>       >
>>>>>
>>>>>
>>>
>
> .
>



More information about the gnucash-user mailing list