[GNC] Reconciliation discrepancies

[Jean Laroche]

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.org at gnucash.org>
> On Behalf Of Rich Shepard
> Sent: Tuesday, April 12, 2022 8:49 AM
> To: gnucash-user at 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 at 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 at 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.