[GNC] How to handle multiple entries of multiply reconciled entries

[Greg Feneis]

Duplicate transactions could happen if the user isn't carefully reviewing
what the matcher has cooked up during importing of account data from the FI
to GnuCash. EG if I import credit card data, payments to my credit card are
automatically attributed to my checking account.  Then, If I import data
from my checking account data, a failure in matching promotes the same
transaction to be added again because the existing transaction isn't
matched to the transaction being imported.  The matcher's automation is
good for the majority of the work, but the user still needs to review its
work and occasionally correct things.  Anyway, perhaps a scenario like this
is causing your duplicates?




Kind regards,

Greg Feneis




On Thu, Feb 3, 2022 at 8:09 AM Alan A Holmes <gnucash at alanaholmes.me.uk>
wrote:

> Hi Jeff,
>
> Did you take a copy of the database before you upgraded to version 4.9. If
> so you could take a copy of this backup and open that in version 4.9, which
> might tell you if the corruption existed before upgrading to version 4.9.
>
> Do you have anyway of finding out which version you had before version
> 4.9? Was it another flatpack version, or was it the version as part of
> Ubuntu 20.04 LTS? That version might still be available on your machine, or
> you could re-install that version, which would allow you to look at any
> backup copy before upgrading to version 4.9 in that version to see if the
> corruption existed.
>
> You could also look at any/all backup copy taken automatically by version
> 4.9 to see if the corruption exists. This depends on how many days of
> backups/logs you have specified should be kept in the settings. This might
> show when the corruption first started.
>
> If you can find a backup copy that isn't corrupted then you could start
> with that copy and then either manually enter all transactions since then,
> or use the log files created since then to re-apply a subset of
> transactions (I think I remember a thread somewhere that said you can be
> selective in which transactions to re-apply).
>
>
> Alan A Holmes
>
> -----Original Message-----
> From: gnucash-user <gnucash-user-bounces+gnucash=
> alanaholmes.me.uk at gnucash.org> On Behalf Of Jeff
> Sent: 03 February 2022 07:43
> To: Gnucash userlist <gnucash-user at gnucash.org>
> Subject: [GNC] How to handle multiple entries of multiply reconciled
> entries
>
> How I did this is beyond me, somehow I confused GNC to let it happen or
> had a data corruption when the journal was improperly saved (power outage,
> GNC lost a poker game, thought it was Quirken, etc).  I use uncompressed
> XML on Ubuntu 20.04LTS.
>
> I have discovered multiple (dozens) of transactions that are duplicates in
> several registers but; reconciled to the wrong accounts.  I am not sure of
> the easiest and proper way to correct them.
>
> Example of the simplest ones are:  using Check 101, Cash, salary.
>
> 01/01/10 chk 101 -> Cash -> chk 101 reconciled
>
> 01/01/10 chk 101 -> salary -> salary reconciled
>
> These are posted as 2 entirely separate transactions, in the same
> register, but are supposed to be only one transaction:
>
> 01/01/10 chk 101 -> salary -> both reconciled
>
> As a result my current balance is now off by off by over $4,000.
>
> And the real kicker, is that these errors now go back 3 years in this
> journal.  I know these errors did not exist prior to FlatPak 4.9, not sure
> which version I upgraded from to 4.9.  Plus they would have shown up when I
> did reports for taxes and income expense statements last year.
>
> Suggestions, besides burning more midnight oil than this old man has left,
> other than to delete all of them and enter all of them correctly as I find
> them.  I'm in tax time crunch here.
>
> --
> --JEffrey Black M.B.A.
>
> _______________________________________________
> 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.
>