[GNC] Reconciliation {oops}

[Mark at Lorimark]

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 <mark at lorimarksolutions.com>
> Sent: Tuesday, March 24, 2026 3:31 PM
> To: gnucash-user at gnucash.org
> 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 <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.
> 
>