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

[Alan A Holmes]

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.