Re: [GNC] New Balsheet (and P report)

2018-06-30 Thread Christopher Lam
Latest iteration of balsheet-pnl
https://screenshots.firefox.com/SzeQeQcyTTTGtb1a/null

Rules:
1. All totals will now be shown by the parent account - i.e. the first row
"Asset" has all asset amounts combined.
2. Every account-with-children will be bold and annotated "Total for ..."
to indicate this is an aggregate amount. See "Total Broker 200FUND + $2000"
3. Every account-with-children-with-own-amounts will have that amount shown
underneath the above aggregate. See "Broker $2000"
4. Account without children will be shown similar as 3. See "Broker:Stock
200FUND"

I dare say this strategy is much clearer than the existing balance sheet
reports.
C

On 30 June 2018 at 17:03, Christopher Lam  wrote:

> Hi Dave
>
> On 28/06/18 17:24, DaveC49 wrote:
>
>> Christopher,
>>
>> " except that Placeholder accounts
>> can also contain transactions therefore must not necessarily accumulate
>> their children account amounts. "
>>
>> I have to disagree with the above from an accounting perspective.
>>
>
> I was not describing UI restrictions; I was describing Report format. How
> to report 'accounts' with children, but with their own amounts?
>
> ---Answer 1---
>
> I had a multilevel strategy which (to me) was more clever, but it would
> seem is not desired.
> 1. If account has children, just render its own amount (e.g.
> Expenses:Utilities:Home = $10)
> 2. Move on to its child accounts (e.g. Expenses:Utilities:Home:Electric =
> $35, Expenses:Utilities:Beachhouse:Electric = $40)
> 3. If we are moving to a *higher* level account, then start rendering all
> intermediate sublevels will be subtotals, e.g.
>
>   Expenses = $0
>   Expenses:Utilities = $0
>   Expenses:Utilities:Home = $10 <- note this is a parent account
> with own $10 amount, gets its own row
>   Expenses:Utilities:Home:Water = $40
>   Expenses:Utilities:Home:Electric = $35
>   TOTAL Expenses:Utilities:Home = $85
>
>   Expenses:Utilities:Beachhouse
>   Expenses:Utilities:Beachhouse:Electric = $40
>   Expenses:Utilities:Beachhouse:Water = $20
>   TOTAL Expenses:Utilities:Beachhouse = $60
>
>   TOTAL Expenses:Utilities = $145
>
> However this approach seems to be adding too much complexity so I've
> removed it.
>
> ---Answer 2---
>
> In my current draft balsheet-pnl I am specifically *not* querying the
> account's placeholder flag. As we know it is being used both as a
> 'grouping' account (e.g. Asset:Fixed) and as a 'disabled' account flag
> (e.g. Asset:Closed:MyOldBank:Current).
>
> So the above P will be rendered as follows:
>
>   Total Expenses:Utilities = $145
>
>   Total Expenses:Utilities:Home = $85
>   Expenses:Utilities:Home = $10<-- 'parent' account with own
> $10 amount
>   Expenses:Utilities:Home:Water = $40
>   Expenses:Utilities:Home:Electric = $35
>
>   Total Expenses:Utilities:Beachhouse = $60<- parent account
> without amount... it doesn't get its own row
>   Expenses:Utilities:Beachhouse:Electric = $40
>   Expenses:Utilities:Beachhouse:Water = $20
>
> This is the 'recursive-balance' strategy. In this one, the Totals will
> always be presented in the parent account.
>
> ---
>
> Both methods are suitable for the current placeholder strategy.
>
>
>
> If accounts are setup as Placeholders initially (i.e. the checkbox set in
>> New Account dialog when they are created) they are readonly hence you
>> cannot
>> select them as targets for transactions (Placeholders do not appear in the
>> list of target accounts for a transaction and if you open the account
>> register you are warned that it is read only and you cannot enter
>> transactions from it so they cannot accumulate any balance when they are
>> initially set as Placeholder accounts.
>>
>> If you change an existing account to be a Placeholder and it already has
>> transactions into it then its balance will contain the sum of those
>> transactions. If you then createa sub account of it and create
>> transactions
>> into the sub-account, then the balance of the parent placeholder account
>> balance is correctly the sum of the balances of any sub accounts plus the
>> sum of any transactions into it before it was changed to a placeholder.
>>
>> If it was initially a placeholder, a user could subsequently change it to
>> be
>> a non-placeholder account  allowing it to accumulate transactions into it
>> and subsequently change it back.
>>
>> In either of these two cases, the correct balance for the placeholder
>> account is always the balance of any transactions into the placeholder
>> account itself plus the sum of balances of it's sub-accounts. In most
>> accounting practice the balances of the subaccounts would be indented to
>> the
>> right.
>>
>> To maintain consistency with this practice, if it is possible you could
>> present the balance of any direct transactions to the placeholder account
>> indented in the same manner as the sub-accounts as if it was a sub-account
>> and then have the non-indented balance for the placeholder account being
>> the
>> sum of that 

Re: [GNC] New Balsheet (and P report)

2018-06-30 Thread Christopher Lam

Hi Dave

On 28/06/18 17:24, DaveC49 wrote:

Christopher,

" except that Placeholder accounts
can also contain transactions therefore must not necessarily accumulate
their children account amounts. "

I have to disagree with the above from an accounting perspective.


I was not describing UI restrictions; I was describing Report format. 
How to report 'accounts' with children, but with their own amounts?


---Answer 1---

I had a multilevel strategy which (to me) was more clever, but it would 
seem is not desired.
1. If account has children, just render its own amount (e.g. 
Expenses:Utilities:Home = $10)
2. Move on to its child accounts (e.g. Expenses:Utilities:Home:Electric 
= $35, Expenses:Utilities:Beachhouse:Electric = $40)
3. If we are moving to a *higher* level account, then start rendering 
all intermediate sublevels will be subtotals, e.g.


  Expenses = $0
  Expenses:Utilities = $0
  Expenses:Utilities:Home = $10 <- note this is a parent 
account with own $10 amount, gets its own row

  Expenses:Utilities:Home:Water = $40
  Expenses:Utilities:Home:Electric = $35
  TOTAL Expenses:Utilities:Home = $85

  Expenses:Utilities:Beachhouse
  Expenses:Utilities:Beachhouse:Electric = $40
  Expenses:Utilities:Beachhouse:Water = $20
  TOTAL Expenses:Utilities:Beachhouse = $60

  TOTAL Expenses:Utilities = $145

However this approach seems to be adding too much complexity so I've 
removed it.


---Answer 2---

In my current draft balsheet-pnl I am specifically *not* querying the 
account's placeholder flag. As we know it is being used both as a 
'grouping' account (e.g. Asset:Fixed) and as a 'disabled' account flag 
(e.g. Asset:Closed:MyOldBank:Current).


So the above P will be rendered as follows:

  Total Expenses:Utilities = $145

  Total Expenses:Utilities:Home = $85
  Expenses:Utilities:Home = $10    <-- 'parent' account with 
own $10 amount

  Expenses:Utilities:Home:Water = $40
  Expenses:Utilities:Home:Electric = $35

  Total Expenses:Utilities:Beachhouse = $60    <- parent 
account without amount... it doesn't get its own row

  Expenses:Utilities:Beachhouse:Electric = $40
  Expenses:Utilities:Beachhouse:Water = $20

This is the 'recursive-balance' strategy. In this one, the Totals will 
always be presented in the parent account.


---

Both methods are suitable for the current placeholder strategy.



If accounts are setup as Placeholders initially (i.e. the checkbox set in
New Account dialog when they are created) they are readonly hence you cannot
select them as targets for transactions (Placeholders do not appear in the
list of target accounts for a transaction and if you open the account
register you are warned that it is read only and you cannot enter
transactions from it so they cannot accumulate any balance when they are
initially set as Placeholder accounts.

If you change an existing account to be a Placeholder and it already has
transactions into it then its balance will contain the sum of those
transactions. If you then createa sub account of it and create transactions
into the sub-account, then the balance of the parent placeholder account
balance is correctly the sum of the balances of any sub accounts plus the
sum of any transactions into it before it was changed to a placeholder.

If it was initially a placeholder, a user could subsequently change it to be
a non-placeholder account  allowing it to accumulate transactions into it
and subsequently change it back.

In either of these two cases, the correct balance for the placeholder
account is always the balance of any transactions into the placeholder
account itself plus the sum of balances of it's sub-accounts. In most
accounting practice the balances of the subaccounts would be indented to the
right.

To maintain consistency with this practice, if it is possible you could
present the balance of any direct transactions to the placeholder account
indented in the same manner as the sub-accounts as if it was a sub-account
and then have the non-indented balance for the placeholder account being the
sum of that plus the balances of any subaccounts.

Where you are trying to create a multicolumn/multiperiod type report, which
I have gathered is your objective, having to have indented sub-accounts will
make it very complex and difficult to fit on a fixed page size if you have
to preserve indenting of the sub-account structure.

I would like to plead that the current Balance and Income Statements and
other standard accounting reports not be replaced by a multiperiod report,
but that this become an additional optional report.


The multicolumns are only enabled if the period option allows it. It can 
easily be disabled, or made off by default.


The current balance sheet has the amounts indented in a completely 
unpredictable method. I cannot fix it, sorry...


Please beta test the report as it stands, or comment on the screenshots, 
especially https://screenshots.firefox.com/3AGgKiSkmdebjOsf/null ... 
your input is 

Re: [GNC] New Balsheet (and P report)

2018-06-30 Thread DaveC49
Christopher,

" except that Placeholder accounts 
can also contain transactions therefore must not necessarily accumulate 
their children account amounts. "

I have to disagree with the above from an accounting perspective.

If accounts are setup as Placeholders initially (i.e. the checkbox set in
New Account dialog when they are created) they are readonly hence you cannot
select them as targets for transactions (Placeholders do not appear in the
list of target accounts for a transaction and if you open the account
register you are warned that it is read only and you cannot enter
transactions from it so they cannot accumulate any balance when they are
initially set as Placeholder accounts.

If you change an existing account to be a Placeholder and it already has
transactions into it then its balance will contain the sum of those
transactions. If you then createa sub account of it and create transactions
into the sub-account, then the balance of the parent placeholder account
balance is correctly the sum of the balances of any sub accounts plus the
sum of any transactions into it before it was changed to a placeholder.

If it was initially a placeholder, a user could subsequently change it to be
a non-placeholder account  allowing it to accumulate transactions into it
and subsequently change it back.

In either of these two cases, the correct balance for the placeholder
account is always the balance of any transactions into the placeholder
account itself plus the sum of balances of it's sub-accounts. In most
accounting practice the balances of the subaccounts would be indented to the
right. 

To maintain consistency with this practice, if it is possible you could
present the balance of any direct transactions to the placeholder account
indented in the same manner as the sub-accounts as if it was a sub-account
and then have the non-indented balance for the placeholder account being the
sum of that plus the balances of any subaccounts.

Where you are trying to create a multicolumn/multiperiod type report, which
I have gathered is your objective, having to have indented sub-accounts will
make it very complex and difficult to fit on a fixed page size if you have
to preserve indenting of the sub-account structure. 

I would like to plead that the current Balance and Income Statements and
other standard accounting reports not be replaced by a multiperiod report,
but that this become an additional optional report.

Gnucash is used in many different jurisdictions not all of which have as yet
adopted the IFRS produced by the IASB. (The US while moving towards the IFRS
uses a GAAP which is not yet compliant). Even if this were the case, many
jurisdictions still have local divergences from strict IFRS adherence
because of the need to be consistent with other laws in their jurisdiction.
Having fairly plain vanilla single period reports which users can then
produce customised versions  for their specific requirements is fairly
essential to meet the need to operate across many jurisdictions, which is
one of GnuCash's strengths. That may be more difficult to do with a
multiperiod report.

A cautious user would hopefully not create the situation where placeholder
accounts have transactions into them, but Murphy's law applies and if it can
happen it no doubt will and does. 

The case where after a given date company or reporting policy requires a
more detailed breakdown with sub-accounts but prior to that date there was
only a single account is one situation where transactions to a parent
account might occur. I personally would treat that by creating a sub-account
for all transactions into the original account prior to that date to which
all existing transactions could be transferred along with the sub-accounts
for the future reporting structure for future transactions. At some point in
the future that sub-account with the original parent account transactions
could possibly be hidden, but the data is still preserved.

It would be ideal perhaps if Gnucash on creation of a subaccount required
the parent account to be made a placeholder and any existing transactions
transferred to either that subaccount (or another appropriate account) but
that is not built in currently. There may be other use cases where this is
not desirable however.

regards

David Cousens




-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.


Re: [GNC] New Balsheet (and P report)

2018-06-26 Thread Stephen M. Butler
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  > 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 
> 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
> 
> >
> > 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) report. I
> > still have further ideas in the 

Re: [GNC] New Balsheet (and P report)

2018-06-25 Thread 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  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
> 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
> >
> > 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) 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
> > 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.
> >
>
>
___
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 

Re: [GNC] New Balsheet (and P report)

2018-06-25 Thread Stephen M. Butler
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
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
>
> 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) 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
> 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.
>

  CL Inc Balance Sheet 06/25/2018


   Assets
   [1]Asset $0.00
 [2]Bank1 $0.00
   [3]Checking $0.00
   [4]Savings $100.00
   [5]Bonds $2,000.00
 [6]Bank2 $500.00
 [7]ForeignBank $0.00
 [8]Broker $2,000.00
   [9]Stock $4,000.00
 [10]House $500.00
   Total Assets $9,100.00
 __
 __

   Liabilities
   [11]Liability $0.00
 [12]Bank2 $0.00
   [13]Loan -$9,000.00
   [14]Creditcard -$500.00
   Total Liabilities $9,500.00
 __

   Equity
   [15]Equity $400.00
   Total Equity -$400.00
 __

   Total Liabilities & Equity $9,100.00

References

   1. gnc-register:acct-guid=7fcbfd020fc34c04b40a9dc974b86bef
   2. gnc-register:acct-guid=f99452f2d77548d6bf358d0ec762869b
   3. gnc-register:acct-guid=c6ba7462d05848fb8ef0bd33d26009f2
   4. gnc-register:acct-guid=9cd11b4781fc41f5aa19af7ecf2a5542
   5. gnc-register:acct-guid=ac1afdb4517a40fd9181d58395ad59d6
   6. gnc-register:acct-guid=000682dbdb2149f9891a3f3fe0f20bf5
   7. gnc-register:acct-guid=18b586b15e6449a79429ec81c2c501ee
   8. gnc-register:acct-guid=d6bdb46b4af0421eb376fc804836b6c4
   9. gnc-register:acct-guid=a9eecc82cd904f44822550882a56bcb8
  10. gnc-register:acct-guid=8e6fd8b862e84e0a9bfe6dd3c0ce21d7
  11. gnc-register:acct-guid=26e0d29bd40f40468e7cda0650d8902d
  12. gnc-register:acct-guid=4643a6d3c5c34c9d83d5e53c5ae34e59
  13. gnc-register:acct-guid=c0fae8ed7a484d1ca883f34402cf56f6
  14. gnc-register:acct-guid=686ff299b6a845cf9c906ba24b71dea9
  15. gnc-register:acct-guid=3758364a8113489f9ce00013b2c1f065
  CL Inc

Balance Sheet (eguile) 06/25/2018

   Assets Accounts
   [1]Asset
  [2]Bank1
 [3]Checking  $0.00
 [4]Savings $100.00
 [5]Bonds $2,000.00
  Total [6]Bank1  

[GNC] New Balsheet (and P report)

2018-06-25 Thread Christopher Lam

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