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.
