Re: QFX Import and Reconciled Transactions

[Liz]

On Fri, 16 Feb 2018 11:07:05 + (UTC)
"David T. via gnucash-user"  wrote:

> RW,
> The QFX specification includes an ID field against which gnucash
> matches. If subsequent imports keep trying to match existing
> transactions, it may be that your bank is reusing the IDs. This has
> been seen before. David
> 
>  
and although my bank did accept it was wrong, they haven't fixed it.
I would think its some banking software, and they have bought from the
same company, who sees no cause to fix it.

As my bank is customer owned, I have more ability to get answers. 

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: QFX Import and Reconciled Transactions

[David T. via gnucash-user]

RW,
The QFX specification includes an ID field against which gnucash matches. If 
subsequent imports keep trying to match existing transactions, it may be that 
your bank is reusing the IDs. This has been seen before. 
David

 
 
  On Fri, Feb 16, 2018 at 14:59, R Winstead wrote:   
David,
Thanks for the information.  I guess what I was hoping was that there might
be something that could be done to tweak the matching process (on the part
of the user), to make transactions that are reconciled, with a "Y" in the R
column, off limits to future matching (and possible updates which would
seem to invalidate a previous reconciliation).  If not, then hopefully
something that could be included in an upcoming release.

Thanks again for the helpful information.


RW

On Fri, Feb 16, 2018 at 12:06 AM, DaveC49  wrote:

> No problem David.
>
> I was interested because I was importing OFX data at the time I saw the
> post
> and I have often been confused about exactly what happens, even though most
> of the time it works without any problem. It appears that that when R is
> checked in the import window, it sets the A column in the account register
> (not R as I previously claimed - I just noticed this) to "c", but not to
> "y"
> ,  which is set when it is reconciled by the reconciliation process. I
> agree
> it would be nice to have some improvement on the documentation around
> importing. Even nicer might be some tooltips on the column headers in the
> various windows.
>
> Cheers
> David
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: QFX Import and Reconciled Transactions

[R Winstead]

David,
Thanks for the information.  I guess what I was hoping was that there might
be something that could be done to tweak the matching process (on the part
of the user), to make transactions that are reconciled, with a "Y" in the R
column, off limits to future matching (and possible updates which would
seem to invalidate a previous reconciliation).  If not, then hopefully
something that could be included in an upcoming release.

Thanks again for the helpful information.


RW

On Fri, Feb 16, 2018 at 12:06 AM, DaveC49  wrote:

> No problem David.
>
> I was interested because I was importing OFX data at the time I saw the
> post
> and I have often been confused about exactly what happens, even though most
> of the time it works without any problem. It appears that that when R is
> checked in the import window, it sets the A column in the account register
> (not R as I previously claimed - I just noticed this) to "c", but not to
> "y"
> ,  which is set when it is reconciled by the reconciliation process. I
> agree
> it would be nice to have some improvement on the documentation around
> importing. Even nicer might be some tooltips on the column headers in the
> various windows.
>
> Cheers
> David
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: QFX Import and Reconciled Transactions

[DaveC49]

Hi David,

Agreed that the process of importing of transactions to an account is a
separate and distinct process from that of reconciliation with an external
statement.

Given that however, the import process, if it matches an existing
transaction in your accounts will classify a transaction as "Reconcile
(auto) match" and the R column is checked. What I am unsure of is whether
this will set the "reconciled" flag on the transaction. 

I just tried reimporting an OFX file which I imported earlier today and it
correctly matched all transactions as currently existing ( these had not
been reconciled against a statement and the reconcile flag was not set in
the account register). I was reluctant to hit OK to see whether it sets the
reconcile flag on the transaction records, but I took the risk of having to
unset a month's records, and it *does not *set the reconcile flag on
re-importing and justs skips importing the records which is the desirable
behaviour (from my point of view). It is the use of reconcile in the context
of importing that is confusing. I would prefer to see a more explanatory
message like "Auto match to existing record - skipping import" in that
comment field, i.e. not use reconcile in this context because of the
confusing the process with reconciliation.

The original question I answered was referring, I think, specifically to the
import process matching imported transactions to already reconciled
transactions, i.e. those with the reconcile flag already set in the account
register and  not just the R column set in the import process (and the
"Reconcile (auto) match" in the comment field of the transaction). 

I have not specifically tested whether Gnucash actually does that yet but I
will give it a go with a test set of books later today and see what actually
does happen.  I remember finding documentation of the Bayesian matching and
what the flags (A, U+R, R ) mean being veryhard to come by a year or two ago
and John Ralls spelled it out for me in a reply to a question at that time,
however I can't find that in the archives but this one  does have it
http://gnucash.1415818.n4.nabble.com/How-does-AqBanking-work-A-U-R-and-R-td4661099.html
or
http://gnucash.1415818.n4.nabble.com/When-importing-QFX-what-does-U-R-actually-do-td4689755.html.



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: QFX Import and Reconciled Transactions

[David Carlson]

Please do not confuse importing transactions with reconciliation.

While you must develop a procedure that is efficient,  the OFX import is
very error prone and needs to be checked against another reference.

David C

On Feb 15, 2018 6:16 PM, "DaveC49"  wrote:

> Any matching procedure on an import is not going to be perfect. Make the
> criteria too tight and almost nothing is matched. Too loose and everything
> is matched, so it is always a compromise.
>
> I have found the order in which I process the OFX imports from my various
> accounts can have some impact on matching or at least the number of
> transactions to an account which will be matched. I have one bank general
> purpose account from which transfers to other accounts (credit card,
> account
> connected to Paypal, savings accounts) are more common so I usually import
> it first as there are then a smaller number of transactions in the other
> accounts which are automatically matched so they are easier to check. If I
> import the other accounts first then the odds of a mismatch are increased
> and there are many more matches to existing transactions.
>
> Perhaps one of the developers may be able to comment on how the matching
> occurs, but I would imagine it is first a match on the amount and then on
> proximity of the dates. The README on the Github gives some idea of how the
> importer works although not detail of its opearation.
>
> At best matching on the importer can only be a guide and its results always
> need to be checked. I usually find any errors I haven't picked up at import
> when I do a reconciliation against the issued statements but my bank now
> only issues statements six monthly on some accounts and quarterly on others
> and only my credit card has a monthly statement (one example of the many
> improvements to customer service) so it takes longer to find errors now.
>
> There are also a number of previous discussions of matching in the
> archives.
> I odn't hthink the code has changed a lot recently.
>
> David
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: QFX Import and Reconciled Transactions

[DaveC49]

Any matching procedure on an import is not going to be perfect. Make the
criteria too tight and almost nothing is matched. Too loose and everything
is matched, so it is always a compromise. 

I have found the order in which I process the OFX imports from my various
accounts can have some impact on matching or at least the number of
transactions to an account which will be matched. I have one bank general
purpose account from which transfers to other accounts (credit card, account
connected to Paypal, savings accounts) are more common so I usually import
it first as there are then a smaller number of transactions in the other
accounts which are automatically matched so they are easier to check. If I
import the other accounts first then the odds of a mismatch are increased
and there are many more matches to existing transactions. 

Perhaps one of the developers may be able to comment on how the matching
occurs, but I would imagine it is first a match on the amount and then on
proximity of the dates. The README on the Github gives some idea of how the
importer works although not detail of its opearation. 

At best matching on the importer can only be a guide and its results always
need to be checked. I usually find any errors I haven't picked up at import
when I do a reconciliation against the issued statements but my bank now
only issues statements six monthly on some accounts and quarterly on others
and only my credit card has a monthly statement (one example of the many
improvements to customer service) so it takes longer to find errors now.

There are also a number of previous discussions of matching in the archives.
I odn't hthink the code has changed a lot recently.

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.