[GNC] New Balsheet (and P&L report)

Tue Jun 26 13:18:21 EDT 2018

Have you read https://www.mscs.dal.ca/~selinger/accounting/tutorial.html
and the companion https://www.mscs.dal.ca/~selinger/accounting/gnucash.html?

I finished both last night and am working through chapter 12 of the
current guide.  I think it is an accounting setup issue more than a
reporting issue.  And our sample company is setup wrong based on what I
read.

On 06/25/2018 09:03 PM, Christopher Lam wrote:
> Hi Stephen
>
> Thank you for valuable feedback... all these issues are cosmetic /
> account selection, and are relatively trivial.... except that
> Placeholder accounts can also contain transactions therefore must not
> necessarily accumulate their children account amounts.
>
> My major concern relates to switching amounts to a so-called "Report
> Currency". But IMO this leads to balance sheets to being confused with
> 'stock valuation'
>
> The existing balance sheet offers weighted-average, average-cost,
> nearest, latest. AFAIU weighted-average and average-cost obtains
> prices from the actual transactions; nearest means 'use price nearest
> to report-date', and latest means 'use today's nearest price'
>
> Let's say I bought:
> 100 AAPL at $10 in 2006, and
> 50 AAPL at $20 in 2009; and
> AAPL was $110 in 2015
> AAPL is about $180 in 2018
>
> I'm wanting stock valuation in 2015.
> - original currency - shows 150 AAPL, no price conversion (i.e. simplest)
> - cost price - 100x$10 + 50x$20 = $2000 (labour intensive because each
> stock transaction must be analysed, and converted using any available
> price entry to the report currency)
> - nearest - 150x$110 = $16,500 (simple)
> - latest - 150x$180 = $27,000 (also simple)
>
> Please check latest showing balsheet multicolumn amounts converted to
> report currency; although they're esthetically nice, this has
> increased the level of complexity a magnitude a tad too high... (I
> wouldn't know how/if income/expense amounts can/must be subject to
> price conversion...)
>
> I'd be keen to remove price conversion to report currency myself...
>
>
> On 26 June 2018 at 03:34, Stephen M. Butler <kg7je at arrl.net
> <mailto:kg7je at arrl.net>> wrote:
>
>     Christopher,
>
>     I am attaching the three balance sheet reports available from
>     within GNC
>     for both our test company and for my apartment building.  Of the
>     three,
>     the accountant likes the layout and totals of the eguile version
>     the best.
>
>     Her specific comments regarding the Multicolumn (pnl) are:
>
>     1.  Not unheard of to compare this year-to-date with last year-ti-date
>     on a balance sheet (and income/expense) report.  Less likely to be
>     beginning period/end period.  Most generally only done for last report
>     of the year (to compare back to prior year).  She prefers the single
>     point-in-time version for personal and small company finances.
>
>     2.  Placeholder accounts should not show $0.00.  Their true value
>     is the
>     total for their level.
>
>     3.  The dates should not be repeated for each section of the report. 
>     Once at the top is enough.
>
>     4.  Equity is the same as Net Worth.  Its total should include:
>         a.  Equity account totals
>         b.  Trading account totals  (if there are no trading accounts,
>     suppress that portion)
>         c.  Period to date Profit/Loss which should match the (Income -
>     Expense) from the Income Statement.
>
>     5.  Assets = Liabilities + Equity   and the total of Liabilities and
>     Equity should be shown and match the total of Assets.
>
>     6.  Put in the column underlines for the totals as is done on the
>     eguile
>     version.  Then you can remove the "Total for XXX" labels as it will be
>     obvious it is a total.
>
>
>     Now, for our test company, I think we have a problem with the GPB
>     valuations.  We haven't done any bookkeeping with multiple
>     currencies. 
>     So will need input from somebody else.
>
>        
>
>     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/25/2018 06:56 AM, Christopher Lam wrote:
>     > Seeking beta testers.
>     >
>     >
>     https://github.com/christopherlam/gnucash/tree/maint-balsheet-pnl
>     <https://github.com/christopherlam/gnucash/tree/maint-balsheet-pnl>
>     >
>     > Or, anyone with v3.2 onwards can copy the file directly into the
>     > build's standard-reports folder:
>     >
>     https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm
>     <https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm>
>     >
>     > Adds new balsheet and income statement (i.e. Profit&Loss) report. I
>     > still have further ideas in the pipeline, just wish to check
>     accuracy
>     > of amounts produced. Not all options have been implemented.
>     >
>     > C
>     > _______________________________________________
>     > gnucash-user mailing list
>     > gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>     > To update your subscription preferences or to unsubscribe:
>     > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>     > If you are using Nabble or Gmane, please see
>     > https://wiki.gnucash.org/wiki/Mailing_Lists
>     <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.
>     >
>
>