Re: [GNC] Using GnuCash as an Accounting Tutor

2023-09-09 Thread David Cousens
Thomas,

I started using GnuCash while I was doing a Masters's degree in Accounting
(coursework with minor thesis) somewhere around 2007 when I needed to be able to
do exercises in the basic financial accounting subjects to prepare basic balance
sheets, income statments for specific case studies.  I picked it up pretty
quickly (I had had previous experience using MYOB for bookkeeping for my
business). 
Most of the  exercises were mainly from Horngren et al's book Financial
Accounting (Australian Edition) bute also had a  case study for a dummy business
set in Australia which came as a booklet with  structured set of
exercises/problems which built up a set of accounts as the course progressed. It
was called "Cafe Sweets " by Rebecca CW Tan andpublished by Pearson in Australia
.It wasn't based around GnuCash but MYOBs but I did it all in GnuCash without
any problems.

David Cousens

On Sun, 2023-09-10 at 08:14 +0530, tkp...@gmail.com wrote:
> Dear all,
> 
> I teach a course in Corporate Valuation Theory that is taken by students
> from a variety of disciplines. Many of them have not studied accounting, and
> while I devote two lectures and two homework assignments to the subject, it
> is impossible to convey the depth of this vast subject and for students to
> internalize why double-entry accounting is so extraordinarily powerful. 
> 
>  
> 
> I currently use examples built in Excel but am exploring the possibility of
> moving to GnuCash, which allows its users to think in terms of double-entry
> accounting using debits and credits, and to make entries using these terms.
> It allows students to create different types of accounts
> (asset/liability/equity), make journal entries for them using proper
> accounting terminology, and then create financial statements. 
> 
>  
> 
> Question: Do you know of a simple accounting primer that uses GnuCash and
> has many examples and some problem sets as well? If so, I would be very
> appreciative if you would share it with me.
> 
>  
> 
> Sincerely and with many thanks in advance
> 
>  
> 
> Thomas Philips
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Using GnuCash as an Accounting Tutor

2023-09-09 Thread flywire
The first two sections of the GnuCash Guide
https://www.gnucash.org/viewdoc.phtml?doc=guide are a tutorial to introduce
accounting and the application respectively.

The whole concept of reconciling a cheque account is very dated in a time
when countries move to abandon cash, but it covers the basics. By the time
the exercises in the key parts of the second section have been completed,
people will have a reasonable understanding of applying the concepts.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Using GnuCash as an Accounting Tutor

2023-09-09 Thread john
The only book I know about is 
https://www.packtpub.com/product/gnucash-24-small-business-accounting-beginners-guide/9781849513869.
 The GnuCash version is obviously a bit old but the general operation of 
GnuCash hasn't changed.

Regards,
John Ralls


> On Sep 9, 2023, at 19:44,   wrote:
> 
> Dear all,
> 
> I teach a course in Corporate Valuation Theory that is taken by students
> from a variety of disciplines. Many of them have not studied accounting, and
> while I devote two lectures and two homework assignments to the subject, it
> is impossible to convey the depth of this vast subject and for students to
> internalize why double-entry accounting is so extraordinarily powerful. 
> 
> 
> 
> I currently use examples built in Excel but am exploring the possibility of
> moving to GnuCash, which allows its users to think in terms of double-entry
> accounting using debits and credits, and to make entries using these terms.
> It allows students to create different types of accounts
> (asset/liability/equity), make journal entries for them using proper
> accounting terminology, and then create financial statements. 
> 
> 
> 
> Question: Do you know of a simple accounting primer that uses GnuCash and
> has many examples and some problem sets as well? If so, I would be very
> appreciative if you would share it with me.
> 
> 
> 
> Sincerely and with many thanks in advance
> 
> 
> 
> Thomas Philips
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Using GnuCash as an Accounting Tutor

2023-09-09 Thread tkpmep
Dear all,

I teach a course in Corporate Valuation Theory that is taken by students
from a variety of disciplines. Many of them have not studied accounting, and
while I devote two lectures and two homework assignments to the subject, it
is impossible to convey the depth of this vast subject and for students to
internalize why double-entry accounting is so extraordinarily powerful. 

 

I currently use examples built in Excel but am exploring the possibility of
moving to GnuCash, which allows its users to think in terms of double-entry
accounting using debits and credits, and to make entries using these terms.
It allows students to create different types of accounts
(asset/liability/equity), make journal entries for them using proper
accounting terminology, and then create financial statements. 

 

Question: Do you know of a simple accounting primer that uses GnuCash and
has many examples and some problem sets as well? If so, I would be very
appreciative if you would share it with me.

 

Sincerely and with many thanks in advance

 

Thomas Philips

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Stock quotes hung

2023-09-09 Thread Fred Tydeman
I was wrong.  The gnucash-cli command, after a couple of minutes, did
finish.
And looking at the price history, it did get the AT&T price for yesterday.
So, it looks like things are very slow for some reason.
Perhaps the internet at this airbnb is causing problems.

On Sat, Sep 9, 2023 at 5:19 PM Fred Tydeman  wrote:

> I have removed Get Quotes for all of my stocks and have just GBP currency
> getting quotes.
> Doing the gnucash-cli command works.
>
> If I add in just one stock (T == AT&T), gnucash-cli hangs.
>
> I tried adding in --debug to that gnucash-cli, but nothing stood out as a
> problem.
>
> Suggestions?
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Stock quotes hung

2023-09-09 Thread Fred Tydeman
I have removed Get Quotes for all of my stocks and have just GBP currency
getting quotes.
Doing the gnucash-cli command works.

If I add in just one stock (T == AT&T), gnucash-cli hangs.

I tried adding in --debug to that gnucash-cli, but nothing stood out as a
problem.

Suggestions?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Stock quotes hung

2023-09-09 Thread John Ralls
Unfortunately no. The Securities window can show which ones are set (click the 
arrow at the right end of the header row and check Get Quotes) but the control 
isn't sensitive so you have to double-click on each line item and change it in 
the Security Editor dialog box.

Regards,
John Ralls

> On Sep 9, 2023, at 2:41 PM, Fred Tydeman  wrote:
> 
> Is there an easy way to add or remove Get Quotes for many stocks at a time?
> 
> On Sat, Sep 9, 2023 at 11:50 AM john  wrote:
> 
> GnuCash 4.14 uses the old perl utilities gnc-fq-check and gnc-fq-dump. The 
> info and dump commands were added to gncuash-cli --quotes in 5.0.
> 
> FWIW I retrieved an AAPL quote from yahoo_json just now, so the problem isn't 
> with Yahoo! messing with their URI again. Most likely there's an issue with 
> one of your more thinly-traded securities, so repeat the triage steps from 
> when this happened a few weeks ago to figure out which one.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Who this "Jim" is, and intermittent delivery of gnucash-user posts [was: Re: gnucash_user: rounding errors and significant digits]

2023-09-09 Thread John Ralls
Jim,

And I'm sorry for making you waste your time investigating that. I didn't check 
the archive, I searched my local mailbox on the subject ("gnucash_user: 
rounding errors and significant digits") and turned up only Bruces most recent 
two posts. Armed with the date from your 108251 link I looked in my mailbox on 
that date and found your posts.

Regards,
John Ralls


> On Sep 9, 2023, at 2:10 PM, Jim DeLaHunt  wrote:
> 
> I'm sorry, I made a mistake in my message below. 
> 
> The Jim message which Bruce was quoting, in the Bruce message to which John 
> replied, did in fact make it to the gnucash-user list archive[4], but in 
> August, so of course it was not in the September archive[1].
> 
> Thus, the list archive is not evidence for intermittent delivery of my 
> gnucash-user posts. Maybe there is in fact no delivery problem.
> 
> Sorry for the confusion,
> —Jim "Jim" DeLaHunt
> 
> [1] 
> 
> [4] 
> 
> On 2023-09-09 13:25, Jim DeLaHunt wrote:
>> On 2023-09-09 12:36, john wrote:
>>> I don't know who this "Jim" is, their replies are not making it to the 
>>> list
>> Oh dear. I spend time writing my messages to Bruce McCoy. It would be a pity 
>> if they didn't make it to the list. 
>> 
>> This "Jim" is me, Jim DeLaHunt . 
>> 
>> The Jim message which Bruce was quoting, in the Bruce message to which John 
>> replied, did not make it to the gnucash-user list archive[1].  However, I 
>> did receive a copy of my reply via the gnucash-user email list[2] at the 
>> time. The reply which I sent to the Bruce message today did in fact get to 
>> the archive[3]. So maybe my messages are intermittently failing to reach 
>> some gnucash-user recipients?
>> 
>> Looking at the other headers, I wonder if maybe some spam detection services 
>> (ARC? SPF?) are intermittently raising false positives on some of my 
>> gnucash-user posts. I don't know how to interpret the headers of my 
>> gnucash-user replies to investigate that.
>> 
>> Best regards,
>>  —Jim "Jim" DeLaHunt
>> 
>> [1] 
>> 
>> [2] Some of the mail headers of the copy of my reply which I received from 
>> gnucash-user:
>> 
>>> ...
>>> Received: from inbound-trex-4 (unknown [127.0.0.6])
>>> by postfix-inbound-v2-8.inbound.mailchannels.net (Postfix) with ESMTP 
>>> id C524B600069
>>> for 
>>> 
>>> ; Mon, 21 Aug 2023 21:01:05 + (UTC)
>>> ...
>>> Received: from code.gnucash.org (code.gnucash.org [204.107.200.65])
>>> (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384)
>>> by 100.112.2.51 (trex/6.7.2);
>>> Mon, 21 Aug 2023 21:01:05 +
>>> ...
>>> Received: from seahorse.cherry.relay.mailchannels.net
>>>  (seahorse.cherry.relay.mailchannels.net [23.83.223.161])
>>>  (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
>>>  key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest 
>>> SHA256)
>>>  (No client certificate requested)
>>>  by code.gnucash.org (Postfix) with ESMTPS id 2FEE14B342
>>>  for 
>>> 
>>> ; Mon, 21 Aug 2023 17:00:08 -0400 (EDT)
>>> ...
>>> 
>> 
>> [3] 
>> 
>> 
>> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Gnu Cash stopped working 2 days ago.

2023-09-09 Thread John Ralls
David,

That's very strange, `string->number` is a guile function used only in the QIF 
importer. Please run 
  /Application/Gnucash.app/Contents/MacOS/Gnucash --debug
and attach the resulting tracefile (see 
https://wiki.gnucash.org/wiki/Tracefile). It may be quite long so don't try to 
paste in the contents.

Regards,
John Ralls

> On Sep 9, 2023, at 12:57 PM, (Alan) David Smith  
> wrote:
> 
> Dear John, 
> 
> Thank you for your suggestions: there is nothing in the crash report and this 
> is what the terminal output is:
> 
> Last login: Fri Sep  8 23:30:43 on console
> alandavidsmith@Alans-MacBook-Pro ~ % 
> /Applications/Gnucash.app/Contents/MacOS/Gnucash
> Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash
> 
> (process:46072): gnc.gui-WARNING **: 20:54:04.010: [mac_set_languages()] 
> Language list: en:en_GB:C
> Backtrace:
>   3 (apply-smob/1 #)
> In ice-9/boot-9.scm:
>   2312:4  2 (save-module-excursion #)
> In ice-9/eval-string.scm:
> 36:6  1 (read-and-eval # #:lang _)
> In unknown file:
>   0 (read #)
> 
> ERROR: In procedure read:
> In procedure string->number: Value out of range: 9739
> 
> Some deprecated features have been used.  Set the environment
> variable GUILE_WARN_DEPRECATED to "detailed" and rerun the
> program to get more information.  Set it to "no" to suppress
> this message.
> alandavidsmith@Alans-MacBook-Pro ~ %
> 
> Regards,
> 
> DAvid
> 
> On 09/09/2023, 17:55, "john"  wrote:
> 
>Open /Applications/Utilities/Console and click Crash Reports in the 
> sidebar. If GnuCash is crashing there will be a detailed report there. If 
> there's nothing, try opening /Applications/Utilities/Terminal and running 
> GnuCash from the command line:
>   /Applications/Gnucash.app/Contents/MacOS/Gnucash
> 
>to see if it prints an error on the terminal window.
> 
>Regards,
>John Ralls
> 
> 
>> On Sep 9, 2023, at 08:25, smit...@smith54.karoo.co.uk wrote:
>> 
>> Dear Sir,
>> 
>> It stopped working suddenly. I then updated it to 5.3 and it still was
>> shutting down on opening it.  I have also only just updated to the latest
>> version of Ventura. This has made no difference. I have checked the Apple
>> permissions - again there is nothing obvious.
>> 
>> Regards,
>> 
>> David
>> 
>> -Original Message-
>> From: gnucash-user
>>  On Behalf Of
>> G R Hewitt
>> Sent: Saturday, September 9, 2023 2:57 PM
>> To: (Alan) David Smith ; GnuCash User List
>> 
>> Subject: Re: [GNC] Gnu Cash stopped working 2 days ago.
>> 
>> Hi Alan,
>> Has the MacOS been recently updated? This may have broken something or
>> other.
>> 
>> You might try getting a fresh installation of GnuCash and installing it, or
>> you could use Time Machine and go back a couple of days and restore just the
>> program file.
>> 
>> If none of those work I'd look at the security settings to make sure GnuCash
>> has sufficient rights.
>> 
>> On Sat, 9 Sept 2023 at 13:18, (Alan) David Smith via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>> 
>>> Hello  everyone,
>>> 
>>> 
>>> I am using MacBook Pro M! And my Gnu Cash has suddenly stopped 
>>> opening. It looks was though it is opening up normally and then just
>> switches off.
>>> 
>>> Does anyone no why - It does not make sense to me.
>>> 
>>> Regards,
>>> 
>>> David Smith
>>> 
>>> 54 Pryme Street
>>> Anlaby, HU10 6SH.
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> 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
>> -
>> 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
>> -
>> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Stock quotes hung

2023-09-09 Thread Fred Tydeman
Is there an easy way to add or remove Get Quotes for many stocks at a time?

On Sat, Sep 9, 2023 at 11:50 AM john  wrote:

>
> GnuCash 4.14 uses the old perl utilities gnc-fq-check and gnc-fq-dump. The
> info and dump commands were added to gncuash-cli --quotes in 5.0.
>
> FWIW I retrieved an AAPL quote from yahoo_json just now, so the problem
> isn't with Yahoo! messing with their URI again. Most likely there's an
> issue with one of your more thinly-traded securities, so repeat the triage
> steps from when this happened a few weeks ago to figure out which one.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Who this "Jim" is, and intermittent delivery of gnucash-user posts [was: Re: gnucash_user: rounding errors and significant digits]

2023-09-09 Thread Jim DeLaHunt

I'm sorry, I made a mistake in my message below.

The Jim message which Bruce was quoting, in the Bruce message to which 
John replied, did in fact make it to the gnucash-user list archive[4], 
but in August, so of course it was not in the September archive[1].


Thus, the list archive is not evidence for intermittent delivery of my 
gnucash-user posts. Maybe there is in fact no delivery problem.


Sorry for the confusion,
    —Jim "Jim" DeLaHunt

[1] 

[4] 



On 2023-09-09 13:25, Jim DeLaHunt wrote:

On 2023-09-09 12:36, john wrote:

I don't know who this "Jim" is, their replies are not making it to the list


Oh dear. I spend time writing my messages to Bruce McCoy. It would be 
a pity if they didn't make it to the list.


This "Jim" is me, Jim DeLaHunt .

The Jim message which Bruce was quoting, in the Bruce message to which 
John replied, did not make it to the gnucash-user list archive[1].  
However, I did receive a copy of my reply via the gnucash-user email 
list[2] at the time. The reply which I sent to the Bruce message today 
did in fact get to the archive[3]. So maybe my messages are 
intermittently failing to reach some gnucash-user recipients?


Looking at the other headers, I wonder if maybe some spam detection 
services (ARC? SPF?) are intermittently raising false positives on 
some of my gnucash-user posts. I don't know how to interpret the 
headers of my gnucash-user replies to investigate that.


Best regards,
 —Jim "Jim" DeLaHunt

[1] 

[2] Some of the mail headers of the copy of my reply which I received 
from gnucash-user:



...
Received: from inbound-trex-4 (unknown [127.0.0.6])
by postfix-inbound-v2-8.inbound.mailchannels.net (Postfix) with ESMTP 
id C524B600069
for; Mon, 21 Aug 2023 21:01:05 + (UTC)
...
Received: from code.gnucash.org (code.gnucash.org [204.107.200.65])
(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384)
by 100.112.2.51 (trex/6.7.2);
Mon, 21 Aug 2023 21:01:05 +
...
Received: from seahorse.cherry.relay.mailchannels.net
  (seahorse.cherry.relay.mailchannels.net [23.83.223.161])
  (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
  key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256)
  (No client certificate requested)
  by code.gnucash.org (Postfix) with ESMTPS id 2FEE14B342
  for; Mon, 21 Aug 2023 17:00:08 -0400 (EDT)
...


[3] 





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Who this "Jim" is, and intermittent delivery of gnucash-user posts [was: Re: gnucash_user: rounding errors and significant digits]

2023-09-09 Thread Jim DeLaHunt

On 2023-09-09 12:36, john wrote:

I don't know who this "Jim" is, their replies are not making it to the list


Oh dear. I spend time writing my messages to Bruce McCoy. It would be a 
pity if they didn't make it to the list.


This "Jim" is me, Jim DeLaHunt .

The Jim message which Bruce was quoting, in the Bruce message to which 
John replied, did not make it to the gnucash-user list archive[1].  
However, I did receive a copy of my reply via the gnucash-user email 
list[2] at the time. The reply which I sent to the Bruce message today 
did in fact get to the archive[3]. So maybe my messages are 
intermittently failing to reach some gnucash-user recipients?


Looking at the other headers, I wonder if maybe some spam detection 
services (ARC? SPF?) are intermittently raising false positives on some 
of my gnucash-user posts. I don't know how to interpret the headers of 
my gnucash-user replies to investigate that.


Best regards,
 —Jim "Jim" DeLaHunt

[1] 

[2] Some of the mail headers of the copy of my reply which I received 
from gnucash-user:



...
Received: from inbound-trex-4 (unknown [127.0.0.6])
by postfix-inbound-v2-8.inbound.mailchannels.net (Postfix) with ESMTP 
id C524B600069
for; Mon, 21 Aug 2023 21:01:05 + (UTC)
...
Received: from code.gnucash.org (code.gnucash.org [204.107.200.65])
(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384)
by 100.112.2.51 (trex/6.7.2);
Mon, 21 Aug 2023 21:01:05 +
...
Received: from seahorse.cherry.relay.mailchannels.net
  (seahorse.cherry.relay.mailchannels.net [23.83.223.161])
  (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
  key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256)
  (No client certificate requested)
  by code.gnucash.org (Postfix) with ESMTPS id 2FEE14B342
  for; Mon, 21 Aug 2023 17:00:08 -0400 (EDT)
...


[3] 



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] gnucash_user: rounding errors and significant digits

2023-09-09 Thread Jim DeLaHunt

Hello, Bruce:

I would like to reply to a few places in your detailed message where I 
think I can clarify the argument.



On 2023-09-09 10:59, Bruce McCoy via gnucash-user wrote:

     "he actual $value of this $price and #shares is $14.99896, a difference of 
$0.00104."

At the moment, using these figures, GnuCash is (14.99896/15.000) * 100 = 
99.9930666... % correct


I think you left out part of my statement, and so made an incorrect 
conclusion. I wrote:


On 2023-08-21 14:00, Jim DeLaHunt wrote:
Logically, $value = $price/share * #shares, and this should be precise 
equality. But is possible for a brokerage statement to report values 
which do not have precise equality. It sounds like Federated Hermes 
reported $15.00 = $6.26 * 2.396, but the actual $value of this $price 
and #shares is $14.99896, a difference of $0.00104.


You say that GnuCash is the entity which is "99.9930666... % 
correct". I argued that it was Federated Hermes which was 
"99.9930666... % correct.  Before you worry about GnuCash's 
handling of securities transactions, you should decide how you are going 
to interpret the error of 0.0069...% in the brokerage statement's 
numbers.


You continue,

On 2023-09-09 10:59, Bruce McCoy via gnucash-user wrote:

For the moment, let's discuss a  minor point.
   
     "GnuCash takes the position that price is approximate and transient, but currency received and paid, and     shares received and issued, are exact and persistent. Thus a GnuCash securities transaction stores the number     of shares and the currency value of the transaction, and derives the price as $value/#shares..."


In this minor point, the viewpoint that the smallest units of currency are considered exact both by 
governments and their financial companies will be investigated.  One conclusion will be that GnuCash should 
consider "price" and "currency received" as exact figures.  A second is that GnuCash 
should consider "shares received and issued" as an approximation, although it is not always true


I believe you misunderstood my statement, in the quotation. I made no 
comment about "the smallest units of currency". I said that "GnuCash 
takes the position that... currency received and paid, and shares 
received and issued, are exact and persistent." That is true regardless 
of what the smallest unit of currency is.


You conclude, 'GnuCash should consider "price"... as exact figures.' No, 
I said something quite different: "GnuCash takes the position that price 
is approximate and transient...".


You conclude, 'GnuCash should consider "shares received and issued" as 
an approximation, although it is not always true' No, I said 
something quite different: "GnuCash takes the position that... shares 
received and issued, are exact and persistent" — not an approximation.


You give an example:

On 2023-09-09 10:59, Bruce McCoy via gnucash-user wrote:

...If someone were to ask us whether the way GnuCash treats the currency pricing is either 
"approximate and transient" in the case of $6.26 per share or "exact and 
persistent"  in the case of the $15.00 annual account fee, what could our answer be?   Buying 
one share will cost 626 pennies.  The annual fee is 1,500 pennies.  Other than the quantity of 
them, what is the essential difference in the pennies used to purchase a share and the pennies used 
to pay the fee?


Our answer to your first question should be, "approximate and 
transient". Buying one share costs (the currency value of the 
transaction) divided by (the number of shares received and issued).  
Thus, buying one share in this transaction costs 3750/599 $/share. The 
brokerage statement's printed price of $6.26 per share is an 
approximation of the actual price which the brokerage charged you. Our 
answer to your second question should be, that you are using one word, 
"pennies", to describe two different quantities — price, and currency 
paid — and thus obscuring the essential difference that the first 
quantity is by design derived from the second quantity.


Now on to the logical leap you make later in your message:

On 2023-09-09 10:59, Bruce McCoy via gnucash-user wrote:

...We could say "GnuCash takes the position that price is approximate and transient, 
but currency received and paid, and shares received and issued, are exact and 
persistent."  Essentially that is how we have always considered the matter.
   
Is "We have always done it this way." a compelling response? ...


Yes, I think the first quote is an accurate statement of GnuCash's 
design for recording securities transactions. The second statement, 
"that is how we have always considered the matter", is a claim about 
history. I don't know if it is true. Maybe GnuCash had a different 
design in the past. I don't know.


But your next sentence frames "we have always done it this way" as a 
supposed _justification_ for GnuCash's current design. I did not say 
that.

Re: [GNC] Gnu Cash stopped working 2 days ago.

2023-09-09 Thread (Alan) David Smith
Dear John, 

Thank you for your suggestions: there is nothing in the crash report and this 
is what the terminal output is:

Last login: Fri Sep  8 23:30:43 on console
alandavidsmith@Alans-MacBook-Pro ~ % 
/Applications/Gnucash.app/Contents/MacOS/Gnucash
Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash

(process:46072): gnc.gui-WARNING **: 20:54:04.010: [mac_set_languages()] 
Language list: en:en_GB:C
Backtrace:
   3 (apply-smob/1 #)
In ice-9/boot-9.scm:
   2312:4  2 (save-module-excursion #)
In ice-9/eval-string.scm:
 36:6  1 (read-and-eval # #:lang _)
In unknown file:
   0 (read #)

ERROR: In procedure read:
In procedure string->number: Value out of range: 9739

Some deprecated features have been used.  Set the environment
variable GUILE_WARN_DEPRECATED to "detailed" and rerun the
program to get more information.  Set it to "no" to suppress
this message.
alandavidsmith@Alans-MacBook-Pro ~ %

Regards,

DAvid

On 09/09/2023, 17:55, "john"  wrote:

Open /Applications/Utilities/Console and click Crash Reports in the 
sidebar. If GnuCash is crashing there will be a detailed report there. If 
there's nothing, try opening /Applications/Utilities/Terminal and running 
GnuCash from the command line:
   /Applications/Gnucash.app/Contents/MacOS/Gnucash

to see if it prints an error on the terminal window.

Regards,
John Ralls


> On Sep 9, 2023, at 08:25, smit...@smith54.karoo.co.uk wrote:
> 
> Dear Sir,
> 
> It stopped working suddenly. I then updated it to 5.3 and it still was
> shutting down on opening it.  I have also only just updated to the latest
> version of Ventura. This has made no difference. I have checked the Apple
> permissions - again there is nothing obvious.
> 
> Regards,
> 
> David
> 
> -Original Message-
> From: gnucash-user
>  On Behalf 
Of
> G R Hewitt
> Sent: Saturday, September 9, 2023 2:57 PM
> To: (Alan) David Smith ; GnuCash User List
> 
> Subject: Re: [GNC] Gnu Cash stopped working 2 days ago.
> 
> Hi Alan,
> Has the MacOS been recently updated? This may have broken something or
> other.
> 
> You might try getting a fresh installation of GnuCash and installing it, 
or
> you could use Time Machine and go back a couple of days and restore just 
the
> program file.
> 
> If none of those work I'd look at the security settings to make sure 
GnuCash
> has sufficient rights.
> 
> On Sat, 9 Sept 2023 at 13:18, (Alan) David Smith via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> Hello  everyone,
>> 
>> 
>> I am using MacBook Pro M! And my Gnu Cash has suddenly stopped 
>> opening. It looks was though it is opening up normally and then just
> switches off.
>> 
>> Does anyone no why - It does not make sense to me.
>> 
>> Regards,
>> 
>> David Smith
>> 
>> 54 Pryme Street
>> Anlaby, HU10 6SH.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
> -
> 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
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] gnucash_user: rounding errors and significant digits

2023-09-09 Thread Stan Brown (using GC 4.14)


On 2023-09-09 12:19, Ken Farley wrote:
> I really don't see what is so difficult to understand about this.
> 
> The key equation is AMOUNT = PRICE * SHARES
> 
> Gnucash works under the philosophy that two of those terms must be
> maintained precisely:
> 
> AMOUNT - the total cost of the transaction. What you ultimately paid in
> the currency of your particular account.
> 
> SHARES - how many units of the security were sold/bought.
> 
> The PRICE, the amount paid per SHARE for this one transaction, is
> calculated using the other two. It's more an informative value than
> anything else.
> 
> What I really care about when I get my statements from investment
> institutions, or trade notifications, is the number of SHARES involved
> and the total cost to me. It truly does not matter as far as maintaining
> a good set of books for my finances, what the exact to-the-20th-decimal
> PRICE was. I just want the SHARES and my current cash balance to be in
> agreement when compared to a financial institution's statement.

Well said, Ken!  I was working on a message that would make those
points, but I'm glad I read yours before I posted mine.

I'll just add one point, for the people who are asking for a change to
GC in this area: you're asking the impossible. It is _mathematically_
not possible to have three decimal numbers A B and C, each rounded to a
desired number of decimal places, fulfill the equation A * B = C
exactly. For some particular numbers A and B, to some suitable number of
decimal places, it will indeed work out, but the general case is
mathematically impossible.

GnuCash has no choice but to consider one of the three quantities to be
only approximate, and I agree with you that share price is the right one
for that role. Number of shares and total amount must be exact to the
generally accepted numbers of decimal places, or people's books won't
balance.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] gnucash_user: rounding errors and significant digits

2023-09-09 Thread john
Bruce,

I don't know who this "Jim" is, their replies are not making it to the list. 
Unfortunately their understanding of GnuCash's handling of amount, value, and 
price is flawed.

Amount is the quantity of a split in the split account's commodity.
Value is that amount converted to the transaction currency, which in turn is 
determined by the account register in which the transaction is created. If that 
account is denominated in a non-currency commodity then it takes the currency 
of the nearest parent account that is denominated in a currency.
Price is the ratio between the two.

Commodities, both currency and otherwise, have minimum fractions. For example 
there is no such thing as a fraction of a car, a tenth of a Japanese Yen, or 
one thousandth of a US Dollar. Financial quantities are always rounded to that 
minimum fraction. GnuCash follows that practice.

GnuCash's number system uses rational numbers represented as the ratio of two 
64-bit integers; that allows a lot of precision but not infinite precision. 
Prices may be rounded to be representable. That's unlikely to have a material 
effect on any calculation, unlike the rounding of quantities, though for that 
to be true GnuCash has to limit the minimum fraction of a commodity to 10^-9, 
otherwise it's possible to have unrepresentable prices in highly inflated 
currencies.

So the claim value = price * shares is logically correct but depends on price * 
shares yielding a legal value in value's currency; the reverse is true as well: 
shares = value/price is true only if value/price produces an amount 
representable in the share commodity's minimum fraction.

The consequence of that rounding is that you should generally tell GnuCash the 
amount and value and let it calculate the price to ensure that GnuCash matches 
whatever rounding got applied at your financial institution.

Regards,
John Ralls


> On Sep 9, 2023, at 10:59, Bruce McCoy via gnucash-user 
>  wrote:
> 
> Jim,
> 
> Thank you for your response of Mon, Aug 21, 2023 at 5:00 PM via GnuCash-user. 
>   In it you said:
> 
> "Logically, $value = $price/share * #shares, and this should be 
> precise equality."
>   
> This is certainly true.   And accuracy is a top consideration in a financial 
> program.  
>
> GnuCash "...stores the price as a rational number, a ratio between 
> numerator and denominator (i.e., a fraction).  Thus it will 
> exactly satisfy the logical equation." 
>
> It is also certainly true that this way of storing a value as a rational 
> number is both excellent and exact.   Our desire is to exactly satisfy the 
> logical equation.  
> 
> "he actual $value of this $price and #shares is $14.99896, a 
> difference of $0.00104."
> 
> At the moment, using these figures, GnuCash is (14.99896/15.000) * 100 = 
> 99.9930666... % correct.  GnuCash is currently doing well.  The 
> incremental change needed is small.  This should encourage us.  This is our 
> major point for discussion.  Please allow me to discuss it in detail in a 
> later post.
>   
> For the moment, let's discuss a  minor point.
>   
> "GnuCash takes the position that price is approximate and transient, 
> but currency received and paid, and shares received and issued, 
> are exact and persistent. Thus a GnuCash securities transaction 
> stores the number of shares and the currency value of the 
> transaction, and derives the price as $value/#shares..."  
> 
> In this minor point, the viewpoint that the smallest units of currency are 
> considered exact both by governments and their financial companies will be 
> investigated.  One conclusion will be that GnuCash should consider "price" 
> and "currency received" as exact figures.  A second is that GnuCash should 
> consider "shares received and issued" as an approximation, although it is not 
> always true.  The details are discussed next.
> 
> It is true that GnuCash treats the number of shares received and issued as 
> exact and persistent quantities.  If someone were to ask us whether the way 
> GnuCash treats the currency pricing is either "approximate and transient" in 
> the case of $6.26 per share or "exact and persistent"  in the case of the 
> $15.00 annual account fee, what could our answer be?   Buying one share will 
> cost 626 pennies.  The annual fee is 1,500 pennies.  Other than the quantity 
> of them, what is the essential difference in the pennies used to purchase a 
> share and the pennies used to pay the fee?  
>  
> If we can show a difference in the pennies of one groups compared with the 
> pennies in the second group, then we could maintain that one group could 
> consist of pennies that are "approximate and transient" and the other group 
> of pennies are "exact and persistent."  What distinction could we make?  We 
> could say "GnuCash takes the position that price is approximate and 
> transient, but currency received and paid, and sh

Re: [GNC] gnucash_user: rounding errors and significant digits

2023-09-09 Thread Ken Farley

I really don't see what is so difficult to understand about this.

The key equation is AMOUNT = PRICE * SHARES

Gnucash works under the philosophy that two of those terms must be 
maintained precisely:


AMOUNT - the total cost of the transaction. What you ultimately paid in 
the currency of your particular account.


SHARES - how many units of the security were sold/bought.

The PRICE, the amount paid per SHARE for this one transaction, is 
calculated using the other two. It's more an informative value than 
anything else.


What I really care about when I get my statements from investment 
institutions, or trade notifications, is the number of SHARES involved 
and the total cost to me. It truly does not matter as far as maintaining 
a good set of books for my finances, what the exact to-the-20th-decimal 
PRICE was. I just want the SHARES and my current cash balance to be in 
agreement when compared to a financial institution's statement.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] gnucash_user: rounding errors and significant digits

2023-09-09 Thread Bruce McCoy via gnucash-user
Jim,
    
Thank you for your response of Mon, Aug 21, 2023 at 5:00 PM via GnuCash-user.   
In it you said:

    "Logically, $value = $price/share * #shares, and this should be precise 
equality."
  
This is certainly true.   And accuracy is a top consideration in a financial 
program.  
   
    GnuCash "...stores the price as a rational number, a ratio between 
numerator and denominator (i.e., a fraction).      Thus it will exactly 
satisfy the logical equation." 
   
It is also certainly true that this way of storing a value as a rational number 
is both excellent and exact.   Our desire is to exactly satisfy the logical 
equation.  

    "he actual $value of this $price and #shares is $14.99896, a difference 
of $0.00104."

At the moment, using these figures, GnuCash is (14.99896/15.000) * 100 = 
99.9930666... % correct.  GnuCash is currently doing well.  The 
incremental change needed is small.  This should encourage us.  This is our 
major point for discussion.  Please allow me to discuss it in detail in a later 
post.
  
For the moment, let's discuss a  minor point.
  
    "GnuCash takes the position that price is approximate and transient, 
but currency received and paid, and     shares received and issued, are 
exact and persistent. Thus a GnuCash securities transaction stores the 
number     of shares and the currency value of the transaction, and 
derives the price as $value/#shares..."  

In this minor point, the viewpoint that the smallest units of currency are 
considered exact both by governments and their financial companies will be 
investigated.  One conclusion will be that GnuCash should consider "price" and 
"currency received" as exact figures.  A second is that GnuCash should consider 
"shares received and issued" as an approximation, although it is not always 
true.  The details are discussed next.

It is true that GnuCash treats the number of shares received and issued as 
exact and persistent quantities.  If someone were to ask us whether the way 
GnuCash treats the currency pricing is either "approximate and transient" in 
the case of $6.26 per share or "exact and persistent"  in the case of the 
$15.00 annual account fee, what could our answer be?   Buying one share will 
cost 626 pennies.  The annual fee is 1,500 pennies.  Other than the quantity of 
them, what is the essential difference in the pennies used to purchase a share 
and the pennies used to pay the fee?  
 
If we can show a difference in the pennies of one groups compared with the 
pennies in the second group, then we could maintain that one group could 
consist of pennies that are "approximate and transient" and the other group of 
pennies are "exact and persistent."  What distinction could we make?  We could 
say "GnuCash takes the position that price is approximate and transient, but 
currency received and paid, and shares received and issued, are exact and 
persistent."  Essentially that is how we have always considered the matter. 
  
Is "We have always done it this way." a compelling response?  If we look at our 
general situations as human beings over the course of the centuries, are we 
living our lives with, for example, many different technologies than our 
ancestors used?  If we looked at the specific cast of GnuCash itself, do we see 
features being added and defects being removed?  From both the general and the 
specific examples, is  "We have always done it this way." a compelling 
response? If so, we might continue as we have up to now.  If not, we might 
consider a change.
  
If we are going to continue as GnuCash has up to now, we have to show the 
essential difference in the pennies used to purchase a share and the pennies 
used to pay the fee.  As I fail to see an essential difference between the 
pennies in one group compared with the pennies in the other group, if someone 
were to ask me to explain why GnuCash holds the position it does in this 
matter, I would not know how to respond.  
  
In double-entry financial transactions involving the smallest units of the same 
currency at the same time, when are the units of one side of the transaction 
given different values than the units on the other side of the transaction?  I 
fail to remember any.
  
If we can not demonstrate an essential difference between the two groups of 
pennies,  how can it be clear that they are different?  If they are not 
different, they have to be the same.  Both values have to be either 
"approximate" or "exact."  If they are approximate, how do we distinguish that 
from their exact value?  If they are exact, then when we divide the fee of 
1,500 pennies by 626 pennies per share we may get an approximation of the 
number of shares purchased.
  
In this latest case, the currency values are considered to be exact and the 
transaction concerning the number of shares involved, although it, on occasion, 
may be exact, may frequently be an approximation.  

In conclusi

Re: [GNC] Gnu Cash stopped working 2 days ago.

2023-09-09 Thread john
Open /Applications/Utilities/Console and click Crash Reports in the sidebar. If 
GnuCash is crashing there will be a detailed report there. If there's nothing, 
try opening /Applications/Utilities/Terminal and running GnuCash from the 
command line:
   /Applications/Gnucash.app/Contents/MacOS/Gnucash

to see if it prints an error on the terminal window.

Regards,
John Ralls


> On Sep 9, 2023, at 08:25, smit...@smith54.karoo.co.uk wrote:
> 
> Dear Sir,
> 
> It stopped working suddenly. I then updated it to 5.3 and it still was
> shutting down on opening it.  I have also only just updated to the latest
> version of Ventura. This has made no difference. I have checked the Apple
> permissions - again there is nothing obvious.
> 
> Regards,
> 
> David
> 
> -Original Message-
> From: gnucash-user
>  On Behalf Of
> G R Hewitt
> Sent: Saturday, September 9, 2023 2:57 PM
> To: (Alan) David Smith ; GnuCash User List
> 
> Subject: Re: [GNC] Gnu Cash stopped working 2 days ago.
> 
> Hi Alan,
> Has the MacOS been recently updated? This may have broken something or
> other.
> 
> You might try getting a fresh installation of GnuCash and installing it, or
> you could use Time Machine and go back a couple of days and restore just the
> program file.
> 
> If none of those work I'd look at the security settings to make sure GnuCash
> has sufficient rights.
> 
> On Sat, 9 Sept 2023 at 13:18, (Alan) David Smith via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> Hello  everyone,
>> 
>> 
>> I am using MacBook Pro M! And my Gnu Cash has suddenly stopped 
>> opening. It looks was though it is opening up normally and then just
> switches off.
>> 
>> Does anyone no why - It does not make sense to me.
>> 
>> Regards,
>> 
>> David Smith
>> 
>> 54 Pryme Street
>> Anlaby, HU10 6SH.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
> -
> 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
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Stock quotes hung

2023-09-09 Thread john



> On Sep 9, 2023, at 06:37, Fred Tydeman  wrote:
> 
> I am running GnuCash 4.14 on Fedora Linux 37
> 
> Last weekend, I could get stock quotes.
> Yesterday and today, all I get is a spinning circle.
> I end up rebooting Linux to get out of a hung session.
> All of my stocks are getting prices from yahoo as json.
> 
> In looking at the online documentation in 11.3 about gnucash-cli,
> I have tried
> gnucash-cli --quotes info
> and
> gnucash-cli --quotes dump
> Both get:  Unknown quotes command 'info' and 'dump'.
> 
> Doing
> gnucash-cli --quotes get /lindata/GnuCash/tybor/tybor.gnucash
> gets: Found Finance::Quote version 1.58
> and a hung session.

GnuCash 4.14 uses the old perl utilities gnc-fq-check and gnc-fq-dump. The info 
and dump commands were added to gncuash-cli --quotes in 5.0.

FWIW I retrieved an AAPL quote from yahoo_json just now, so the problem isn't 
with Yahoo! messing with their URI again. Most likely there's an issue with one 
of your more thinly-traded securities, so repeat the triage steps from when 
this happened a few weeks ago to figure out which one.

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Gnu Cash stopped working 2 days ago.

2023-09-09 Thread smith54
Dear Sir,

It stopped working suddenly. I then updated it to 5.3 and it still was
shutting down on opening it.  I have also only just updated to the latest
version of Ventura. This has made no difference. I have checked the Apple
permissions - again there is nothing obvious.

Regards,

David

-Original Message-
From: gnucash-user
 On Behalf Of
G R Hewitt
Sent: Saturday, September 9, 2023 2:57 PM
To: (Alan) David Smith ; GnuCash User List

Subject: Re: [GNC] Gnu Cash stopped working 2 days ago.

Hi Alan,
Has the MacOS been recently updated? This may have broken something or
other.

You might try getting a fresh installation of GnuCash and installing it, or
you could use Time Machine and go back a couple of days and restore just the
program file.

If none of those work I'd look at the security settings to make sure GnuCash
has sufficient rights.

On Sat, 9 Sept 2023 at 13:18, (Alan) David Smith via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello  everyone,
>
>
> I am using MacBook Pro M! And my Gnu Cash has suddenly stopped 
> opening. It looks was though it is opening up normally and then just
switches off.
>
> Does anyone no why - It does not make sense to me.
>
> Regards,
>
> David Smith
>
> 54 Pryme Street
> Anlaby, HU10 6SH.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Anomalous behaviour of a Bank Account Register

2023-09-09 Thread Gyle McCollam
Sorry to hear that, but it does take a pretty steady hand.  Hopefully, your 
daughter will be able to get it for you.  Good Luck!


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: Peter Jackson 
Sent: Saturday, September 9, 2023 11:07 AM
To: Gyle McCollam 
Subject: Re: [GNC] Anomalous behaviour of a Bank Account Register

Thanks Gyle, I'll ask one of my daughters to try this. My hands are not 
sufficiently steady.
Regards
Peter



On Tue, 5 Sept 2023 at 16:12, Gyle McCollam 
mailto:gmccol...@live.com>> wrote:
Did you approach the line from the left, because that is the only way to expand 
the column by dragging?  If you did and the Deposit or Debit column expanded 
you went too far before clicking and dragging. Another thing you can try but, 
it is less likely to be successful, is when you get the double-sided arrow is 
to double-click the column.  If you are between the 2 lines, actually in the 
Transfer column it will expand to optimal width.  This is harder to do than 
dragging to the left when you first get the double arrow, but it works as I 
tested this.  I will say that  when this happened to me, I had a very hard time 
clicking and dragging and the exact point I needed to, but I eventually got it 
and now it is not as hard to do.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: Peter Jackson mailto:jack...@fastmail.net>>
Sent: Tuesday, September 5, 2023 4:23 AM
To: Gyle McCollam mailto:gmccol...@live.com>>
Subject: Re: [GNC] Anomalous behaviour of a Bank Account Register

Gyle, I think you are right, but I just cannot get your remedy to work.

Nurton Court
Middleton-on-the-Hill
Ludlow SY8 4BD
Tel: 01568 750 248 Mob: 07955 586 476


On Fri, 1 Sept 2023 at 15:56, Gyle McCollam 
mailto:gmccol...@live.com>> wrote:
Based on the screen shot, it looks like the Transfer account has a zero or 
almost zero width.  I say this because the vertical dividing line between the 
description account column and the reconciliation account column seem thicker 
and darker than the other dividing lines.  To test this start at the top of the 
description column close to the Reconciliation column and move your mouse 
slowly to the left.  When the cursor changes to a double headed left/right 
arrow stop.  Then click and drag to the left and see if your transfer column 
appears.  Since the thicker line may mean the transfer column is reduced you 
have to be careful that you have selected the left side of the transfer column 
and not the left side of the reconcile column.  That is why you have to stop 
immediately when the mouse indicator switches to the double-sided arrows.  Once 
you can see the transfer column, you can double click in the header to get the 
optimum size.  That will shift the columns to the right off the page,
  but you can then double click the decription column to shrink it so the other 
columns fit on the page.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user 
mailto:gmail@gnucash.org>>
 on behalf of Peter Jackson mailto:jack...@fastmail.net>>
Sent: Friday, September 1, 2023 7:47 AM
To: GNU Cash User mailto:gnucash-user@gnucash.org>>
Subject: [GNC] Anomalous behaviour of a Bank Account Register

Hello,
I am using Gnucash 5.3 on Windows 11.
I noticed today that the balances on this account were not arithmetically
correct so I ran Check and Repair on all transactions in this account,
which then agreed with my actual bank balance.
I then noticed that this account does not show the Transfer column, but
does have an additional column to the right of Balnce, headed Rate.
Screenshot attached.
I can find no way to remedy this so that it looks like my other Bank
registers.
Can you help please?
Peter
[image: 2023-09-01 Smile.png]
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Gnu Cash stopped working 2 days ago.

2023-09-09 Thread G R Hewitt
Hi Alan,
Has the MacOS been recently updated? This may have broken something or
other.

You might try getting a fresh installation of GnuCash and installing it, or
you could use Time Machine and go back a couple of days and restore just
the program file.

If none of those work I'd look at the security settings to make sure
GnuCash has sufficient rights.

On Sat, 9 Sept 2023 at 13:18, (Alan) David Smith via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello  everyone,
>
>
> I am using MacBook Pro M! And my Gnu Cash has suddenly stopped opening. It
> looks was though it is opening up normally and then just switches off.
>
> Does anyone no why - It does not make sense to me.
>
> Regards,
>
> David Smith
>
> 54 Pryme Street
> Anlaby, HU10 6SH.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Stock quotes hung

2023-09-09 Thread Fred Tydeman
I am running GnuCash 4.14 on Fedora Linux 37

Last weekend, I could get stock quotes.
Yesterday and today, all I get is a spinning circle.
I end up rebooting Linux to get out of a hung session.
All of my stocks are getting prices from yahoo as json.

In looking at the online documentation in 11.3 about gnucash-cli,
I have tried
gnucash-cli --quotes info
and
gnucash-cli --quotes dump
Both get:  Unknown quotes command 'info' and 'dump'.

Doing
gnucash-cli --quotes get /lindata/GnuCash/tybor/tybor.gnucash
gets: Found Finance::Quote version 1.58
and a hung session.

Suggestions?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Transaction Splits for Australian ETF Annual Statements

2023-09-09 Thread flywire
I got sick typing into a spreadsheet so I got the app to extract the data
directly from the pdf to create the transaction splits:
https://github.com/flywire/ETF-Annual-Statement

One line of code will compile it into a Windows *.exe  to avoid python if
anyone wants it. There is a start on a gui shell but it works nicely at
the command line with wildcards.

I'll probably add the contra entry for 30 June too from this data so you
can easily switch between tax reporting and bank account balances.

Feedback welcome.

Regards
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Gnu Cash stopped working 2 days ago.

2023-09-09 Thread (Alan) David Smith via gnucash-user
Hello  everyone,


I am using MacBook Pro M! And my Gnu Cash has suddenly stopped opening. It 
looks was though it is opening up normally and then just switches off. 

Does anyone no why - It does not make sense to me.

Regards,

David Smith

54 Pryme Street
Anlaby, HU10 6SH.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Potential issue with inversion of currency conversion rate during CSV import of transactions

2023-09-09 Thread Bjoern

Hi!

I came across a potential issue with the use of the correct rate for 
cross-currency transactions during CSV imports where I hope others here could 
reproduce the issue or tell me where I took a wrong turn during thinking.


use case:
As a German national I live and work abroad in Sweden temporarily. I have both 
DEU and SWE bank accounts. Salary comes via the DEU account in EUR, which I 
transfer to the SWE account to cover local expenses in SEK. I use GnuCash to 
track personal expenses.

The main, or up until recently only, currency I have used in GnuCash is the EUR 
so all expense accounts are in that. To avoid duplicate accounts for each 
expense in both EUR and SEK I convert spent SEK to EUR when filing the 
transactions to the existing GnuCash accounts already in EUR.


issue:
When using the CSV transactions import feature for the SWE bank statements 
GnuCash uses the reciprocal value of the available conversion rates displayed. 
In other words, the transaction dialogue states it would go from SEK to EUR 
when in fact after the import the transaction would register as if the 
conversion had been done for EUR to NOK instead. Given the rates the effect on 
values is quite pronounced.


notes:
The manual input of cross-currency transactions into GnuCash works as intended.
I use the trading account feature.

I included an example book for further testing.
Conversion rates (10 SEK to 1 EUR) and expense values are roughly realistic.
So the imported transaction for "butter" costing 40 SEK in realiter should 
account for as 4 EUR in the groceries expense and not the registered 400 EUR (1 SEK to 10 
EUR erroneously).
Attached as well is a mock CSV statement for the SWE bank to use during import.


software details:
GnuCash Version: 5.3 Build ID: 5.3+(2023-06-26) with Finance::Quote: 1.57
Windows 10


Thanks and kind regards
Björn


test book.gnucash
Description: application/gnucash


test book - SWE bank statement.csv
Description: MS-Excel spreadsheet
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.