I store data in XML formatted persistent store rather than in a SQL backend, and I have not had any problem with reconciliation module. If anything that has been one of the most robust - to the point I say has never failed on me - in my day-to-day use for past six or so years. I cannot say that for SQL backend as I have never used it with it and I am always leery using it as a backend as there are many moving parts to the SQL sub-system itself where a small glitch could have a disproportionally quite a large blast radius of its impact.
Unless there really good reason for SQL backend need, I would refrain from it. With gnucash you can actually go back-and-forth quite easily between two storage methods as I recall. -----Original Message----- From: Mark at Lorimark <[email protected]> Sent: Wednesday, March 25, 2026 4:00 PM To: Kalpesh Patel <[email protected]>; [email protected] Subject: Re: [GNC] Reconciliation {oops} 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.
