[GNC] Reconciliation {oops}

[Mark at Lorimark]

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 <mark at lorimarksolutions.com> 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
> gnucash-user at gnucash.org
> 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.