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.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 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.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 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 <kg...@arrl.net
<mailto:kg...@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.butle...@gmail.com <mailto:stephen.m.butle...@gmail.com>
kg...@arrl.net <mailto:kg...@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* <kg...@arrl.net
<mailto:kg...@arrl.net> <mailto:kg...@arrl.net
<mailto:kg...@arrl.net>>>
> Date: 16 June 2018 at 00:45
> Subject: The two modules
> To: Christopher Lam <christopher....@gmail.com
<mailto:christopher....@gmail.com>
> <mailto:christopher....@gmail.com
<mailto:christopher....@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.butle...@gmail.com
<mailto:stephen.m.butle...@gmail.com>
<mailto:stephen.m.butle...@gmail.com
<mailto:stephen.m.butle...@gmail.com>>
> kg...@arrl.net <mailto:kg...@arrl.net> <mailto:kg...@arrl.net
<mailto:kg...@arrl.net>>
> 253-350-0166
> -------------------------------------------
> GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385
81D8
>
>
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
