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.
