One potential source of problem is banks that mess up the unique
identifier of downloaded transactions.
In my case Citibank is inconsistent in assigning a unique and constant
FITID for each transaction. So if I re-download transactions, there's a
chance that the FITID of a previously downloaded transaction will not be
the same as the first time I downloaded it. This means GC will think
it's a new transaction and I'll end up with a duplicated transactions
and failure to reconcile.
This was so annoying I had to write a small python script to correct the
issue myself in the ofx file before importing it in GC.
Jean
On 4/12/22 4:16 PM, John Layman wrote:
I've been using GnuCash for 12 years and have rarely had a reconcile
discrepancy that could be blamed on the software (that was a date bug that
reared its head a while back - quickly corrected). And the incidence of
error on the bank's part has been extremely rare. Most occasions when I've
encountered a sizable imbalance have been due to transactions I bungled by
inadvertently entering them with a munged date. The faulty entry has
eventually been found lurking back in time among previously balanced data.
The GnuCash reconciliation process displays the beginning balance, and I've
learned to first double check that number and the reconciliation date for
correspondence with the bank statement when there is an imbalance.
Searching the account for unreconciled transactions is a good way to reveal
any junk entries that were inadvertently plunked down back in time.
In my experience, whenever you encounter something puzzling in GnuCash, the
most likely cause is user error or a failure to RTFM.
-----Original Message-----
From: gnucash-user <gnucash-user-bounces+john.layman=ieee....@gnucash.org>
On Behalf Of Rich Shepard
Sent: Tuesday, April 12, 2022 8:49 AM
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Reconciliation discrepancies
On Tue, 12 Apr 2022, Liz wrote:
By looking at such a small number of transactions it is possible to
find whatever the errors are. I too have been on Gnucash for a couple
of decades, but still found 4 errors in one file this March, payments
not entered as received, and digit transposition.
Liz,
The reason I started this thread is all transactions for the month match. No
switched digits, no missing GnuCash transactions. And, now and then during
the month I check the accounts on the bank's web site and marked GnuCash
transactions as cleared as they appear on the bank's web page.
I hope you find what is happening and let us know.
Based on everyone's response my assumption that it's something unknowable at
the bank's side seems to be confirmed.
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
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.
