Re: [GNC] Fwd: The two modules

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

[GNC] Credit Card Reconciliation

2018-06-18 Thread gmccollam
In Gnu cash 3.1 the credit card reconciliation is not working correctly. 
After I finish marking all the cleared transactions and select the gears
icon to "Finish the reconciliation of this account" it briefly flashes the
screen to enter the payment, but it goes away just as quickly.  It used to
open and stay open so you could enter the payment information, but it no
longer does that.  Do anyone know why it is not working now?



--
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] Credit Card Reconciliation

2018-06-18 Thread David Reiser
It’s probably a bug related to gtk. My main menu disappears along with the 
transfer funds window/dialog. If I click on the main gnucash window, the menu 
bar comes back, and I can pick “Transfer Funds” from the Windows menu, and that 
gets me back where I need to be.

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Jun 18, 2018, at 5:12 PM, gmccollam  wrote:
> 
> In Gnu cash 3.1 the credit card reconciliation is not working correctly. 
> After I finish marking all the cleared transactions and select the gears
> icon to "Finish the reconciliation of this account" it briefly flashes the
> screen to enter the payment, but it goes away just as quickly.  It used to
> open and stay open so you could enter the payment information, but it no
> longer does that.  Do anyone know why it is not working now?
> 
> 
> 
> --
> 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.

[GNC] Difference between Net Loss and Retained Earnings

2018-06-18 Thread Gareth Davies via gnucash-user
Again another Newby question.

 

When I generate a Profit and Loss report it shows a net Loss for the period
of £567, yet on the Balance Sheet report it shows a Retained Earnings figure
of £701.

 

I don’t understand why the difference, as I thought Retained  Earnings meant
Profit.

 

Any help much appreciated.

___
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] Credit Card Reconciliation

2018-06-18 Thread John Ralls



> On Jun 18, 2018, at 2:12 PM, gmccollam  wrote:
> 
> In Gnu cash 3.1 the credit card reconciliation is not working correctly. 
> After I finish marking all the cleared transactions and select the gears
> icon to "Finish the reconciliation of this account" it briefly flashes the
> screen to enter the payment, but it goes away just as quickly.  It used to
> open and stay open so you could enter the payment information, but it no
> longer does that.  Do anyone know why it is not working now?
> 

https://bugzilla.gnome.org/show_bug.cgi?id=795519, already fixed.

Regards,
John Ralls

___
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] Fwd: The two modules

2018-06-18 Thread Christopher Lam

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

Re: [GNC] Credit Card Reconciliation

2018-06-18 Thread Gyle McCollam
My main menu doesn't disappear and my "Windows" on the gnu menu bar doesn't 
have a "Transfer Funds" option, only "New Window" & "New Window with Page".  
Thanks for the attempted solution, wish it would have worked for me.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: David Reiser 
Sent: Monday, June 18, 2018 5:16 PM
To: gmccollam
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Credit Card Reconciliation

It’s probably a bug related to gtk. My main menu disappears along with the 
transfer funds window/dialog. If I click on the main gnucash window, the menu 
bar comes back, and I can pick “Transfer Funds” from the Windows menu, and that 
gets me back where I need to be.

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Jun 18, 2018, at 5:12 PM, gmccollam  wrote:
>
> In Gnu cash 3.1 the credit card reconciliation is not working correctly.
> After I finish marking all the cleared transactions and select the gears
> icon to "Finish the reconciliation of this account" it briefly flashes the
> screen to enter the payment, but it goes away just as quickly.  It used to
> open and stay open so you could enter the payment information, but it no
> longer does that.  Do anyone know why it is not working now?
>
>
>
> --
> 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] Difference between Net Loss and Retained Earnings

2018-06-18 Thread Rick Copple
Net loss or profit is for a specific period of time. Retained earnings would be 
for the whole file up until the last closing period. So if your annual start 
date is the end of the calendar year, then the retianed earnings would be the 
equivalent of running a profit and loss since the beginning of the file up 
until 12/31/2017.

⁣Rick Copple
Window Cleaning Specialist
Copple Cleaning Service
​

On Jun 18, 2018, 4:20 PM, at 4:20 PM, Gareth Davies via gnucash-user 
 wrote:
>Again another Newby question.
>
> 
>
>When I generate a Profit and Loss report it shows a net Loss for the
>period
>of £567, yet on the Balance Sheet report it shows a Retained Earnings
>figure
>of £701.
>
> 
>
>I don’t understand why the difference, as I thought Retained  Earnings
>meant
>Profit.
>
> 
>
>Any help much appreciated.
>
>___
>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 Reply-All.