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

[Christopher Lam]

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> 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
> 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
> >
> > 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
> >
> > 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
> > 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.
> >
>
>