Mark, It shouldn't be necessary to unreconcile and rereconcile everything to correct a reconciliation error. As per my last post you can examine and edit, if necessary, the register with the reconcile window still open.
The most common types of errors are going to be missing entries to the register (possibly split assigned to a different wrong accountaccount) or duplicate entries for the same transaction (not always with the same date) and incorrect amounts having been entered. The main thing is to locate the cause and correct it, preferrably using the tools within GnuCash. GnuCash enforces a number of basic accounting rules internally. Editing the data file directly, while it can be done, if you know what you are doing, can produce even more damage to your data if you make a mistake. On Wed, 2026-03-25 at 15:00 -0500, Mark at Lorimark wrote: > Hi Kalpesh, > > Yea, I don't know... > > The reconciliation module has always left me with a little bit of > fear. > When operating, I have found myself suddenly with a reconciliation > error > and it seemed like the only way I could get our of trouble was go > back > and undo all the 'y' reconciliations and re-do them. Not ideal! > > I need to play more with that component. > > ~mark petryk > ~c:469-556-5075 > ~w:http://www.lorimarksolutions.com > ~q:i don't know where it's going to go, > ...and i don't know what to wear when it gets there. > > On 3/25/26 14:47, Kalpesh Patel wrote: > > Wouldn't (re-)reconciling to the last transaction that got changed > > correct things without messing around with SQL database queries > > and/or XML file? I believe if you just change the date then it > > automatically recalculates the ending balance to reconcile against > > I believe (could be wrong on this latter one but excel or > > equivalent is a good tool). > > > > -----Original Message----- > > From: Mark at Lorimark <[email protected]> > > Sent: Tuesday, March 24, 2026 3:31 PM > > To: [email protected] > > Subject: Re: [GNC] Reconciliation {oops} > > > > Ok, I'm going this route :) > > > > I'm on SQL so I can edit that way. I'll just edit the split and > > change it there. For whatever reason the reconciliation_date > > wasn't set, so I wonder about that... hmm... > > > > Thank you, all > > > > ~mark petryk > > ~w:http://www.lorimarksolutions.com > > ~q:i don't know where it's going to go, > > ...and i don't know what to wear when it gets there. > > > > On 3/24/26 05:59, Kevin Buckley via gnucash-user wrote: > > > On Monday, March 23rd, 2026 at 21:26, Mark at Lorimark > > > <[email protected]> wrote: > > > > > > > > So, looking at one of my registers, I see a few hundred > > > > transactions > > > > up a reconciliation 'Y' is now a 'N'... I must have > > > > accidentality > > > > clicked on the column and cleared the reconciliation. > > > > > > > > How can I get the 'Y' reapplied without having to go through > > > > all the > > > > reconciliation steps all over again? > > > > > > > > > How easy do you find it to use a text editor? > > > > > > Let's have a look at what changes, in the GnuCash XMK file, after > > > a > > > reconciliation is performed > > > > > > For each transaction that got reconciled, this is the diff > > > > > > 13789c13912,13915 > > > < <split:reconciled-state>c</split:reconciled-state> > > > --- > > > > <split:reconciled-state>y</split:reconciled-state> > > > > <split:reconcile-date> > > > > <ts:date>2026-03-24 15:59:59 +0000</ts:date> > > > > </split:reconcile-date> > > > > > > So the "c" got changed to a "y" and a three-line stanza got added > > > that > > > contains the date of the reconciliation > > > > > > Now let's see what happens if we unreconcile a single TXN, the > > > diff in > > > the file is even smaller - can you guess why? > > > > > > 13912c13912 > > > < <split:reconciled-state>y</split:reconciled-state> > > > --- > > > > <split:reconciled-state>n</split:reconciled-state> > > > > > > So all that's happened is that a "y" got changed to an "n" > > > > > > Better still, if we look at the file, starting from the state > > > line > > > > > > <split:reconciled-state>n</split:reconciled-state> > > > <split:reconcile-date> > > > <ts:date>2026-03-24 15:59:59 +0000</ts:date> > > > </split:reconcile-date> > > > > > > we see that the stanza containing the date we did the > > > reconciliation > > > on is STILL IN THE FILE, even though the TXN is marked as not > > > being > > > reconciled now. > > > > > > > > > Isn't GnuCash's XML storage format wonderful! > > > > > > > > > Just make sure you make a backup before you start to edit things, > > > and > > > give it a try. > > > > > > > > > _______________________________________________ > > > gnucash-user mailing list > > > [email protected] > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > ----- > > > 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 > [email protected] > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -- David Cousens _______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
