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 <kg...@arrl.net > <mailto:kg...@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.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/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@gnucash.org <mailto:gnucash-user@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. > > > > _______________________________________________ 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.