[GNC] Online quote retrieval not working in Gnu ash 5.0

[TFT]

Hi All,
 
Apologies for duplicate request as first request didn’t go out with images!

Require some assistance please to reinstate Online Quote retrieval for USA and 
Australian (ASX) stocks.
 
Previously running Gnucash 4.13 and no problem retrieving quotes upgraded to 
v5.0 and went through the previous setting to ensure all ok but cannot get ASX 
stocks to update – seems like the USA stocks are updating and the USD / AUD 
currency is updating. Have gone through the FAQ, documentation and using 
Gnucash cant find a solution
 
Current system:

 
Retrieving quotes from “get quotes” executes the Perl script and seems to run 
and ends after about 20 sec with zero reported errors. 
 
All Australian stocks not updated; AUD/USD currency is updated as are some USA 
stocks but USA exchange currently closed.
 
Checked Finance::Quote as per below.
 

 
Running the following commands, I get stock price updates.
 

 
The settings in security editor are greyed out so cant select quote source for 
Australian shares have set as below, previously had to include .AX after 
Australian shares to get update have tried both ANZ and ANZ.AX in the symbol / 
abbreviation field – same result no update
 

 
Appreciate any assistance to get this working again.
 
Thank you. 
Kevin
 

Sent from my iPad
___
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] Online Quote Retrieval not working in GnuCash 5.0

[TFT]

Hi All,
>  
> Require some assistance please to reinstate Online Quote retrieval for USA 
> and Australian (ASX) stocks.
>  
> Previously running Gnucash 4.13 and no problem retrieving quotes upgraded to 
> v5.0 and went through the previous setting to ensure all ok but cannot get 
> ASX stocks to update – seems like the USA stocks are updating and the USD / 
> AUD currency is updating. Have gone through the FAQ, documentation and using 
> Gnucash cant find a solution
>  
> Current system:
> 
>  
> Retrieving quotes from “get quotes” executes the Perl script and seems to run 
> and ends after about 20 sec with zero reported errors.
>  
> All Australian stocks not updated; AUD/USD currency is updated as are some 
> USA stocks but USA exchange currently closed.
>  
> Checked Finance::Quote as per below.
>  
> 
>  
> Running the following commands, I get stock price updates.
>  
> 
>  
> The settings in security editor are greyed out so cant select quote source 
> for Australian shares have set as below, previously had to include .AX after 
> Australian shares to get update have tried both ANZ and ANZ.AX in the symbol 
> / abbreviation field – same result no update
>  
> 
>  
> Appreciate any assistance to get this working again.
>  
> Thank you.
> Kevin
>  
___
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] Starting balance of new account is not $0

[Jim DeLaHunt]

Rich:

You have received several replies, but I have a sense that some of them 
are talking past you. The issue may be that the term "Starting Balance" 
can mean multiple things in GnuCash.


On 2023-04-26 06:09, Rich James wrote:

I'm trying to resolve some reconciliation issues and decided to go back to
my first statement from last year when I opened the account to establish
that everything is balanced.  However, when I start to reconcile and put in
the statement date and ending balance, the reconciliation window shows a
Starting Balance of several hundred dollars instead of $0.  This gives me
an incorrect difference that I can't properly clear.

Is there a known issue where this can occur?  Or can anyone suggest a way
to resolve this?  I'm seeing similar behavior with another account as well.


"Starting Balance" meaning 1: Another term for "Opening Balance". In the 
account register, the running total amount after the first transaction.  
If you told the GnuCash "New Account" setup dialogue[1] that an account 
which you are creating has a non-zero Opening Balance, then GnuCash 
creates the first transaction in this account, with the "Opening 
Balance" amount in the new account, and an offsetting amount in the 
Equity:Opening Balances account.


"Starting Balance" meaning 2: The value shown in the "Reconcile Window", 
bottom right corner, labelled "Starting Balance". This is no more or 
less than the sum of all transactions in that account which are marked 
as "Reconciled". As Derek Atkins pointed out,



You cannot go "back in time" to reconcile.  When you reconcile an account
at date X, you are reconciling from "the beginning of time" to date X.
You cannot then go back to a date earlier than X to (re)reconcile.
Rich, I think you are using meaning 2 when you say "the reconciliation 
window shows a Starting Balance of several hundred dollars instead of 
$0." From your description, this sounds like expected behaviour. You 
have "reconciliation issues", so that says to me that you have already 
marked some of the transactions in this account as "reconciled". The 
"Starting Balance" value which you see in the Reconciliation Window 
should be exactly equal to the sum of those transactions as they affect 
this account.


So, maybe a question you have is, "How to I untangle incorrect 
reconciliations in an account"? For that question, it would be helpful 
to know what are the "reconciliation issues" you see, what transactions 
are in the account, and what reconciliation you have done so far.


Does this help? Best regards,
    —Jim DeLaHunt


[1] /GnuCash Tutorial and Concepts Guide/, Figure 2.11 "*New Account 
Hierarchy Setup: Account Setup"* 



[2] /GnuCash Tutorial and Concepts Guide,/ Section 2.9.4. 
"*Reconciliation*" 



___
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] Seaking feedback on (potential) "Running Total" feature for transaction report

[Vincent Dawans]

Hello all.

I have been working for a while on implementing a "Running Total" feature
in the transaction report. That would be a feature where running totals are
calculated based on report transaction sort order as shown, so you could
combine any transaction in any groups and sort order and still get a
running total (or subtotals) that would match the existing total/subtotals
on the last transaction. See attached screenshot for an example where all 3
levels of running totals are presented (in practice each level can be
turned on or off to reduce clutter).

Hence this feature is different from the existing Running Balance which
gives you the running balance for the underlying accounts (and therefore
assumes the report is sorted by account and register order), while also
showing a balance forward (which the running totals won't do).

If anybody is interested in having such a feature, please look at what I
have done so far and give some feedback as to what sort of improvements you
would like to see or issues you think might arise with the draft
implementation so far, or even whether (and why) this is not a
worthwhile feature at all.

Best would be to leave comments either on the "bug/enhancement" report or
the Pull request (because they are easier to access in the long term) but
the mailing list is OK as well. This is a work in progress and all
comments, whether in support or criticism, are welcome. Also there is no
rush to implement this, so comments can come any time.

More information on the origin of this feature in the bug/enhancement
report:
https://bugs.gnucash.org/show_bug.cgi?id=798879

Actual presentation of what was done so far and screenshots are in the
draft Pull Request:
https://github.com/Gnucash/gnucash/pull/1617

Sincerely,

Vincent Dawans
___
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] Starting balance of new account is not $0

[Michael or Penny Novack]

A brand new credit account would have a zero balance.  A brand new cash or
checking account *could* have the initial deposit as the starting balance.
Am I completely off the rails here?


I wouldn't say completely.

But because folks new to double entry bookkeeping can be tripped up by 
details.


1) If a new credit card is issued in the course of a transaction with a 
vendor (whose credit card it is) it might have an initial charge. I have 
experienced this << offer -- we will give you X off on that purchase 
today if you open a CC with us >> So IF you create accounts with the 
opening balance wizard, could have an initial balance. But see "2", 
because just like that this purchase had another side to the transaction 
(other than equity).


2) If you open a new bank account with an initial balance (initial 
deposit) that is a transaction with a defined date. This is a case where 
I would certainly not use the wizard. I would create the account with 
zero balance and then enter a transaction for the deposit. There was 
another side to that transaction other than equity.


3) There is no need to use the wizard at all. In the old days this was 
done with a transaction (or transactions) defining the opening date of 
the books. You can still do it that way.


Michael D Novack


___
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 5 - import transactions

[Christian Lynbech]

Sure.

I am not using AqBanking, my problem is with CSV import. I did notice
those errors/warnings in the log but I could not immediately find
anywhere to turn aQbanking off. I know I had tried at one point to
experiment to see if my bank somehow showed up, it didn't, and I have
never used it for anything. It is of course possible something lingers
from that.

Attached are three files:

  test.gnucash - a very simple book (based on the simple check book template)

  abc.csv - two transactions (already imported into test.gnucash)

  def.csv - two more transactions (not yet imported)

def.csv is formed from abc.csv, just with dates and amounts modified
such that gnucash would not think they can reconciled. It is therefore
otherwise the very same transactions and I would expect matching to
occur.

As abc.csv has been imported, test.gnucash contains the import settings
(named "test") that I am using.


   /Christian



test.gnucash
Description: Binary data


abc.csv
Description: Binary data


def.csv
Description: Binary data




---
On Wed, Apr 26 2023, Geert Janssens wrote:

I have tried to look into this, but I don't have enough information to go 
further.

First off, from your logs I infer you are importing data via AqBanking. I have 
no accounts that are
compatible with aqbanking so I can't go that route.

Instead I have tried to import data via the generic CSV importer. If I tweak my 
import data to fall in the
bayesian thresholds, it is properly matched this way.

So to continue, I will need some test data from you. Can you create a minimal 
book with a few
transactions in it already and a csv file to import in there that should give 
matches ? Please do
change any private data.

Additionally, please specify which profile you are using in the Aqbanking 
importer.

Perhaps the easiest is to append all of these in a new bug report. The mailing 
list is a bit cumbersome
to track updates.

Regards,

Geert

Op dinsdag 25 april 2023 21:34:33 CEST schreef Christian Lynbech:

> I have now done a few more experiments and is not any less confused.

> 

> So to iterate, using 4.14, automatching works, using 5.0 it does not

> work.

> 

> I tried turning on logging as John suggested. When I import to 5.0, I

> get nothing logged during the operation. However, when trying to do the

> import with 4.14, I am getting a number of warnings like this:

> 

> * 20:07:17  INFO  [GncTxImport::update_pre_split_props] User

> warning: Column 'Konto' could not be understood.

> 

> The word "Konto" is danish for "Account". Even so, automatching did

> work. I am attaching the log files from the two attempts below.

> 

> I then thought, perhaps this is a language thing (I am using danish both

> on my computer and in the books), so I c'tried changing the language to

> english but it did change the results, no automatching on verson 5.

> Also, the warnings I see in version 4, now was in english (e.g

> "Account").

> 

> I have also tried generating a completely new book, as simple as can be,

> but the behaviour is exactly the same, so it is not something something

> that has piled up in my actual book.

> 

> Since this does not appear to be a universal issue, it is possible that

> it is somehow language related.

> 

> Attached below are the two aforementioned log files, the one named with

> "4" is from the 4.14 run (which works) and the one with a "5" is from the

> 5.0 version (that is not working).

> 

> I can provide my test book and sample CSV files as well, if anybody

> would like to see them.

> 

> Thanks for taking an interest in my issue.

> 

>/Christian
___
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] Starting balance of new account is not $0

[Rich James]

Hi, It's not Derek that asked the question, but me.

That being said, I tried again today to reconcile using my latest statement
and now I am able to reconcile correctly.  I honestly don't know why it was
so off yesterday.  I've used gnuCash for years and have never had the issue
I originally raised.  It has to be me doing something incorrectly, but I
have no idea what it was.  I checked myself multiple times before deciding
to post something about it.

I'm sorry to waste everyone's time.  Thanks,
Rich

On Wed, Apr 26, 2023 at 9:09 AM Phyllis Bruce  wrote:

> Derek, when you *first came into Gnucash* did you enter current balances
> as equity?  Any balance on a credit card would be negative to equity.  Your
> cash accounts would be positive.  It's not too late to do that.  Enter the
> beginning balance on the statement you are trying to reconcile as equity
> for that account.  Use help to get to the tutorials and best practices.
>
> On Wed, Apr 26, 2023 at 8:21 AM Derek Atkins  wrote:
>
>> Hi,
>>
>> On Wed, April 26, 2023 9:09 am, Rich James wrote:
>> > I'm trying to resolve some reconciliation issues and decided to go back
>> to
>> > my first statement from last year when I opened the account to establish
>> > that everything is balanced.  However, when I start to reconcile and put
>> > in
>> > the statement date and ending balance, the reconciliation window shows a
>> > Starting Balance of several hundred dollars instead of $0.  This gives
>> me
>> > an incorrect difference that I can't properly clear.
>> >
>> > Is there a known issue where this can occur?  Or can anyone suggest a
>> way
>> > to resolve this?  I'm seeing similar behavior with another account as
>> > well.
>>
>> You cannot go "back in time" to reconcile.  When you reconcile an account
>> at date X, you are reconciling from "the beginning of time" to date X.
>> You cannot then go back to a date earlier than X to (re)reconcile.
>>
>> Hope this helps,
>>
>> >
>> > Thanks,
>> > Rich
>>
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>>
>> -derek
>>
>> --
>>Derek Atkins 617-623-3745
>>de...@ihtfp.com www.ihtfp.com
>>Computer and Internet Security Consultant
>>
>> ___
>> 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] Starting balance of new account is not $0

[Phyllis Bruce]

H.  Yes I did mean Rich.  I was assuming he was just getting started
and that he cancelled his reconciliation because it didn't work for him.

My starting balance in all my reconcilable (?) accounts was not zero.  When
I created the accounts I entered the ending balance of the previous
statement as the starting balance (the equity).  I had no trouble at all in
reconciling those first statements.  Of course, I entered any *unreconciled*
transactions into Gnu so they were available to the first reconciliation.
A brand new credit account would have a zero balance.  A brand new cash or
checking account *could* have the initial deposit as the starting balance.
Am I completely off the rails here?

On Wed, Apr 26, 2023 at 9:15 AM Derek Atkins  wrote:

> Hi,
>
> On Wed, April 26, 2023 10:09 am, Phyllis Bruce wrote:
> > Derek, when you *first came into Gnucash* did you enter current balances
> > as
> > equity?  Any balance on a credit card would be negative to equity.  Your
> > cash accounts would be positive.  It's not too late to do that.  Enter
> the
> > beginning balance on the statement you are trying to reconcile as equity
> > for that account.  Use help to get to the tutorials and best practices.
>
> I think you meant to direct that to Rich, not to me.
>
> (For the record, yes, when I started my accounts in.. 2002.. I did indeed
> put in starting balances.)
>
> BUT, you must put them in prior to reconciling.  And even so, the first
> time you reconcile you will get a starting balance of 0.
>
> -derek
>
> > On Wed, Apr 26, 2023 at 8:21 AM Derek Atkins  wrote:
> >
> >> Hi,
> >>
> >> On Wed, April 26, 2023 9:09 am, Rich James wrote:
> >> > I'm trying to resolve some reconciliation issues and decided to go
> >> back
> >> to
> >> > my first statement from last year when I opened the account to
> >> establish
> >> > that everything is balanced.  However, when I start to reconcile and
> >> put
> >> > in
> >> > the statement date and ending balance, the reconciliation window shows
> >> a
> >> > Starting Balance of several hundred dollars instead of $0.  This gives
> >> me
> >> > an incorrect difference that I can't properly clear.
> >> >
> >> > Is there a known issue where this can occur?  Or can anyone suggest a
> >> way
> >> > to resolve this?  I'm seeing similar behavior with another account as
> >> > well.
> >>
> >> You cannot go "back in time" to reconcile.  When you reconcile an
> >> account
> >> at date X, you are reconciling from "the beginning of time" to date X.
> >> You cannot then go back to a date earlier than X to (re)reconcile.
> >>
> >> Hope this helps,
> >>
> >> >
> >> > Thanks,
> >> > Rich
> >>
> >> > Please remember to CC this list on all your replies.
> >> > You can do this by using Reply-To-List or Reply-All.
> >>
> >> -derek
> >>
> >> --
> >>Derek Atkins 617-623-3745
> >>de...@ihtfp.com www.ihtfp.com
> >>Computer and Internet Security Consultant
> >>
> >> ___
> >> 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.
> >>
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>
___
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] Starting balance of new account is not $0

[Derek Atkins]

Hi,

On Wed, April 26, 2023 10:09 am, Phyllis Bruce wrote:
> Derek, when you *first came into Gnucash* did you enter current balances
> as
> equity?  Any balance on a credit card would be negative to equity.  Your
> cash accounts would be positive.  It's not too late to do that.  Enter the
> beginning balance on the statement you are trying to reconcile as equity
> for that account.  Use help to get to the tutorials and best practices.

I think you meant to direct that to Rich, not to me.

(For the record, yes, when I started my accounts in.. 2002.. I did indeed
put in starting balances.)

BUT, you must put them in prior to reconciling.  And even so, the first
time you reconcile you will get a starting balance of 0.

-derek

> On Wed, Apr 26, 2023 at 8:21 AM Derek Atkins  wrote:
>
>> Hi,
>>
>> On Wed, April 26, 2023 9:09 am, Rich James wrote:
>> > I'm trying to resolve some reconciliation issues and decided to go
>> back
>> to
>> > my first statement from last year when I opened the account to
>> establish
>> > that everything is balanced.  However, when I start to reconcile and
>> put
>> > in
>> > the statement date and ending balance, the reconciliation window shows
>> a
>> > Starting Balance of several hundred dollars instead of $0.  This gives
>> me
>> > an incorrect difference that I can't properly clear.
>> >
>> > Is there a known issue where this can occur?  Or can anyone suggest a
>> way
>> > to resolve this?  I'm seeing similar behavior with another account as
>> > well.
>>
>> You cannot go "back in time" to reconcile.  When you reconcile an
>> account
>> at date X, you are reconciling from "the beginning of time" to date X.
>> You cannot then go back to a date earlier than X to (re)reconcile.
>>
>> Hope this helps,
>>
>> >
>> > Thanks,
>> > Rich
>>
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>>
>> -derek
>>
>> --
>>Derek Atkins 617-623-3745
>>de...@ihtfp.com www.ihtfp.com
>>Computer and Internet Security Consultant
>>
>> ___
>> 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.
>>
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Starting balance of new account is not $0

[Phyllis Bruce]

Derek, when you *first came into Gnucash* did you enter current balances as
equity?  Any balance on a credit card would be negative to equity.  Your
cash accounts would be positive.  It's not too late to do that.  Enter the
beginning balance on the statement you are trying to reconcile as equity
for that account.  Use help to get to the tutorials and best practices.

On Wed, Apr 26, 2023 at 8:21 AM Derek Atkins  wrote:

> Hi,
>
> On Wed, April 26, 2023 9:09 am, Rich James wrote:
> > I'm trying to resolve some reconciliation issues and decided to go back
> to
> > my first statement from last year when I opened the account to establish
> > that everything is balanced.  However, when I start to reconcile and put
> > in
> > the statement date and ending balance, the reconciliation window shows a
> > Starting Balance of several hundred dollars instead of $0.  This gives me
> > an incorrect difference that I can't properly clear.
> >
> > Is there a known issue where this can occur?  Or can anyone suggest a way
> > to resolve this?  I'm seeing similar behavior with another account as
> > well.
>
> You cannot go "back in time" to reconcile.  When you reconcile an account
> at date X, you are reconciling from "the beginning of time" to date X.
> You cannot then go back to a date earlier than X to (re)reconcile.
>
> Hope this helps,
>
> >
> > Thanks,
> > Rich
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> 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 5 - import transactions

[Geert Janssens]

I have tried to look into this, but I don't have enough information to go 
further.

First off, from your logs I infer you are importing data via AqBanking. I have 
no accounts that 
are compatible with aqbanking so I can't go that route.

Instead I have tried to import data via the generic CSV importer. If I tweak my 
import data to 
fall in the bayesian thresholds, it is properly matched this way.

So to continue, I will need some test data from you. Can you create a minimal 
book with a 
few transactions in it already and a csv file to import in there that should 
give matches ? 
Please do change any private data.

Additionally, please specify which profile you are using in the Aqbanking 
importer.

Perhaps the easiest is to append all of these in a new bug report. The mailing 
list is a bit 
cumbersome to track updates.

Regards,

Geert

Op dinsdag 25 april 2023 21:34:33 CEST schreef Christian Lynbech:
> I have now done a few more experiments and is not any less confused.
> 
> So to iterate, using 4.14, automatching works, using 5.0 it does not
> work.
> 
> I tried turning on logging as John suggested. When I import to 5.0, I
> get nothing logged during the operation. However, when trying to do the
> import with 4.14, I am getting a number of warnings like this:
> 
> * 20:07:17  INFO  [GncTxImport::update_pre_split_props] User
> warning: Column 'Konto' could not be understood.
> 
> The word "Konto" is danish for "Account". Even so, automatching did
> work. I am attaching the log files from the two attempts below.
> 
> I then thought, perhaps this is a language thing (I am using danish both
> on my computer and in the books), so I c'tried changing the language to
> english but it did change the results, no automatching on verson 5.
> Also, the warnings I see in version 4, now was in english (e.g
> "Account").
> 
> I have also tried generating a completely new book, as simple as can be,
> but the behaviour is exactly the same, so it is not something something
> that has piled up in my actual book.
> 
> Since this does not appear to be a universal issue, it is possible that
> it is somehow language related.
> 
> Attached below are the two aforementioned log files, the one named with
> "4" is from the 4.14 run (which works) and the one with a "5" is from the
> 5.0 version (that is not working).
> 
> I can provide my test book and sample CSV files as well, if anybody
> would like to see them.
> 
> Thanks for taking an interest in my issue.
> 
>/Christian


___
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] Starting balance of new account is not $0

[Derek Atkins]

Hi,

On Wed, April 26, 2023 9:09 am, Rich James wrote:
> I'm trying to resolve some reconciliation issues and decided to go back to
> my first statement from last year when I opened the account to establish
> that everything is balanced.  However, when I start to reconcile and put
> in
> the statement date and ending balance, the reconciliation window shows a
> Starting Balance of several hundred dollars instead of $0.  This gives me
> an incorrect difference that I can't properly clear.
>
> Is there a known issue where this can occur?  Or can anyone suggest a way
> to resolve this?  I'm seeing similar behavior with another account as
> well.

You cannot go "back in time" to reconcile.  When you reconcile an account
at date X, you are reconciling from "the beginning of time" to date X. 
You cannot then go back to a date earlier than X to (re)reconcile.

Hope this helps,

>
> Thanks,
> Rich

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Starting balance of new account is not $0

[Rich James]

I'm trying to resolve some reconciliation issues and decided to go back to
my first statement from last year when I opened the account to establish
that everything is balanced.  However, when I start to reconcile and put in
the statement date and ending balance, the reconciliation window shows a
Starting Balance of several hundred dollars instead of $0.  This gives me
an incorrect difference that I can't properly clear.

Is there a known issue where this can occur?  Or can anyone suggest a way
to resolve this?  I'm seeing similar behavior with another account as well.

Thanks,
Rich
___
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] CVS Deposit Issue

[Chris Ledbetter via gnucash-user]

Thanks for taking the time to fully explain this.  Very helpful.

> On Apr 26, 2023, at 5:02 AM, Geert Janssens  
> wrote:
> 
> Hi Chris,
> 
> The names "Deposit" and "Withdrawal" are a bit misleading. In 5.0 they have 
> been renamed to "Amount" and "Amount (negated)" in the hopes this will 
> slightly improve the situation.
> 
> Internally, gnucash stores only one single amount per transaction(split). So 
> that's what eventually has to be derived from the CSV data. Which columns to 
> select depends on the initial structure of your CSV data.
> 
> I'll give a few examples to illustrate (I have added spaces in the examples 
> to have a nicer alignment - they should not be in the CSV data):
> 
> Example 1:
> Date,   Description,   Amount
> 23/04/2024, Sell Widget A, 100.00
> 23/04/2024, Buy Groceries, -56.00
> 
> This is an example of a CSV file in which all the amounts are in a single 
> column. Incoming money is represented with a positive amount, money going out 
> is represented with a negative amount.
> 
> To import this you'd set the Amount column to "Deposit" (or "Amount" in 5.0), 
> which gnucash interprets as "use these amounts as they are, no changes 
> required".
> 
> Example 2:
> Date,   Description,   Debit,  Credit
> 23/04/2024, Sell Widget A, 100.00,   0.00
> 23/04/2024, Buy Groceries, 0.00,56.00
> 
> This is an example of a CSV file in which incoming money is represented as a 
> positive number in the Debit column and money going as a positive number in 
> the Credit column.
> 
> To import this you'd set the Debit column to "Deposit" (or "Amount" in 5.0) 
> and the Credit column to "Withdrawal" ("Amount (negated)" in 5.0). That way 
> you instruct GnuCash to use the Debit numbers unchanged and negate the Credit 
> numbers.
> 
> 
> Example 3:
> Date,   Description,   Deposit, Withdrawal
> 23/04/2024, Sell Widget A, 100.00,  -100.00
> 23/04/2024, Buy Groceries, -56.00,56.00
> 
> This example is similar to your demo. It has both a deposit and a withdrawal 
> column which essentially hold the same information, albeit one is negated 
> version of the other.
> 
> GnuCash only needs this information once, so in this case you choose only one 
> column in the importer. You can either set the "Deposit" column to "Deposit" 
> (or "Amount" in 5.0) or set the "Withdrawal column to "Withdrawal" (or 
> "Amount (negated)" in 5.0), but not both. If you set both, GnuCash will 
> assume you meant to combine both columns in to a single one (like the 
> previous example) and will perform the calculation
> amount = deposit - withdrawal
> for each row. And that would indeed result in doubling all amounts while 
> importing for this kind of CSV file.
> 
> Hopefully this will clear it up for you.
> 
> Regards,
> 
> Geert
> 
> Op woensdag 26 april 2023 01:13:51 CEST schreef Chris Ledbetter via 
> gnucash-user:
> > I am importing Transactions via CSV.  When the importing is finished the
> > Deposit is being doubled upon import.  I am using 4.12 and have not updated
> > yet since I am doing a lot of input and would rather not mess with this
> > until later.  I use a MacBook Pro M1 Ventura 13.3.1.  Here is a demo import
> > CSV file that Deposits $15 via import but should be $7.50.  I have been
> > going in and dividing transactions in the register by 2 to get the correct
> > values.  I just tried dividing the cells by 2 before exporting to CSV but
> > when the system doubles the amount at import, there is often a penny
> > difference.  If there is an easy work around that will be fine.  I can get
> > by doing the math in the register but I’d rather not.  Here is a screenshot
> > of my sample numbers file that I export to CSV before I import.  Thanks
> 
> 

___
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] CVS Deposit Issue

[Geert Janssens]

Hi Chris,

The names "Deposit" and "Withdrawal" are a bit misleading. In 5.0 they have 
been renamed 
to "Amount" and "Amount (negated)" in the hopes this will slightly improve the 
situation.

Internally, gnucash stores only one single amount per transaction(split). So 
that's what 
eventually has to be derived from the CSV data. Which columns to select depends 
on the 
initial structure of your CSV data.

I'll give a few examples to illustrate (I have added spaces in the examples to 
have a nicer 
alignment - they should not be in the CSV data):

Example 1:
Date,   Description,   Amount
23/04/2024, Sell Widget A, 100.00
23/04/2024, Buy Groceries, -56.00

This is an example of a CSV file in which all the amounts are in a single 
column. Incoming 
money is represented with a positive amount, money going out is represented 
with a 
negative amount.

To import this you'd set the Amount column to "Deposit" (or "Amount" in 5.0), 
which gnucash 
interprets as "use these amounts as they are, no changes required".

Example 2:
Date,   Description,   Debit,  Credit
23/04/2024, Sell Widget A, 100.00,   0.00
23/04/2024, Buy Groceries, 0.00,56.00

This is an example of a CSV file in which incoming money is represented as a 
positive 
number in the Debit column and money going as a positive number in the Credit 
column.

To import this you'd set the Debit column to "Deposit" (or "Amount" in 5.0) and 
the Credit 
column to "Withdrawal" ("Amount (negated)" in 5.0). That way you instruct 
GnuCash to use 
the Debit numbers unchanged and negate the Credit numbers.


Example 3:
Date,   Description,   Deposit, Withdrawal
23/04/2024, Sell Widget A, 100.00,  -100.00
23/04/2024, Buy Groceries, -56.00,56.00

This example is similar to your demo. It has both a deposit and a withdrawal 
column which 
essentially hold the same information, albeit one is negated version of the 
other.

GnuCash only needs this information once, so in this case you choose only one 
column in the 
importer. You can either set the "Deposit" column to "Deposit" (or "Amount" in 
5.0) or set the 
"Withdrawal column to "Withdrawal" (or "Amount (negated)" in 5.0), but not 
both. If you set 
both, GnuCash will assume you meant to combine both columns in to a single one 
(like the 
previous example) and will perform the calculation
amount = deposit - withdrawal
for each row. And that would indeed result in doubling all amounts while 
importing for this 
kind of CSV file.

Hopefully this will clear it up for you.

Regards,

Geert

Op woensdag 26 april 2023 01:13:51 CEST schreef Chris Ledbetter via 
gnucash-user:
> I am importing Transactions via CSV.  When the importing is finished the
> Deposit is being doubled upon import.  I am using 4.12 and have not updated
> yet since I am doing a lot of input and would rather not mess with this
> until later.  I use a MacBook Pro M1 Ventura 13.3.1.  Here is a demo import
> CSV file that Deposits $15 via import but should be $7.50.  I have been
> going in and dividing transactions in the register by 2 to get the correct
> values.  I just tried dividing the cells by 2 before exporting to CSV but
> when the system doubles the amount at import, there is often a penny
> difference.  If there is an easy work around that will be fine.  I can get
> by doing the math in the register but I’d rather not.  Here is a screenshot
> of my sample numbers file that I export to CSV before I import.  Thanks
___
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 5 - import transactions

[Geert Janssens]

Hi and welcome to the list!

You have got it right, so far no solution has been offered. This is likely 
because we're looking 
at a regression introduced in version 5.0 but nobody has had the time yet to 
investigate this 
further. I plan to look into this somewhere this week.

If the matching is really important for you, you may try installing gnucash 
4.14 in the interim.

Regards,

Geert

Op woensdag 26 april 2023 00:37:41 CEST schreef Valued Customer via 
gnucash-user:
> Hi. This is the first time I've tried to use the mailing list for help. I
> think I may having the same issue being described in this string. iMac
> Intel 2021 Ventura
> Gnucash Version: 5.0
> Build ID: 5.0+(2023-03-25)
> 
> When I import transactions from CVS no matching is occurring even though
> many of the transactions' descriptions are exact matches. If there is a
> solution in this email exchange, I'm not understanding it.
> 
> I've spent a lot of time with Gnucash over the last few months and have
> entered two years worth of transactions. I've had some limited success with
> the import matcher but, my last attempt resulted in zero matches.
> 
> Mitch
> 
> 
> 
> Sincerely,
> Valued Customer
> 
> Sent with Proton Mail secure email.
> 
> --- Original Message ---
> 
> On Tuesday, April 25th, 2023 at 3:16 PM, Joseph St. Denis via gnucash-user 
>  wrote:
> > I finally got the CVS download to work in 5.0. I had to drop using the
> > type of transaction to get it to work. Instead of the four columns that I
> > used in 4.13. When I tried a second CVS transfer from a second account
> > Gnucash shutdown. When I reopened Gnucash all the transactions were
> > present.
> > 
> > All the best
> > 
> > Joseph St Denis
> > 
> > Get Outlook for Androidhttps://aka.ms/AAb9ysg
> > 
> > 
> > From: gnucash-user gnucash-user-bounces+stdenis0=yahoo@gnucash.org on
> > behalf of Christian Lynbech christ...@defun.dk
> > 
> > Sent: Tuesday, April 25, 2023 3:34:33 PM
> > To: john jra...@ceridwen.us
> > 
> > Cc: gnucash-user@gnucash.org gnucash-user@gnucash.org
> > 
> > Subject: Re: [GNC] Gnucash 5 - import transactions
> > 
> > I have now done a few more experiments and is not any less confused.
> > 
> > So to iterate, using 4.14, automatching works, using 5.0 it does not
> > work.
> > 
> > I tried turning on logging as John suggested. When I import to 5.0, I
> > get nothing logged during the operation. However, when trying to do the
> > import with 4.14, I am getting a number of warnings like this:
> > 
___
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.