Some time ago, I had the same problem. My data is in postgresql, and I was able to clear multiple reconciliations using sql. I took the precaution of dumping my database beforehand. Unfortunately, I didn’t take notes, but it saved a lot of time.
— Peter West [email protected] `“And I tell you, ask, and it will be given to you; seek, and you will find; knock, and it will be opened to you. For everyone who asks receives, and the one who seeks finds, and to the one who knocks it will be opened.”` > On 6 Nov 2026, at 9:05 am, Paul Kroitor <[email protected]> wrote: > > Yes, thank you, that's worth exploring (next time -- both my work-around and > the one in your other message nicely resolve my problem today). > > The reason I find myself doing this is a long story. It's interesting and > instructive but unfortunately not suitable for public posting. Basically, I > need to re-reconcile a number of 2025 expense claims between two different > sets of books. I'm sending you privately a more explanation to satisfy your > curiosity. > > Paul > > PS: I love Gnucash's "reconcile to zero" capability for this kind of thing. > Quicken doesn't have it, but in Gnucash I use it all the time. > > > On 2026-11-05 5:25 p.m., Adrien Monteleone wrote: >> If you right-click on the 'y' (there is no 'r' case) there is an entry in >> the context menu to unreconcile a transaction. Since that function exists, >> it *might* be possible to set a custom key-binder to it, but no guarantees. >> >> I would back up a step though and ask why do you need to un-reconcile so >> many transactions? >> >> Regards, >> Adrien >> >> On 11/5/26 15:05, Paul Kroitor wrote: >>> I've never noticed this before, but there's no tab stop for the R column in >>> a register. Tab just jumps over it, going straight from the Transfer column >>> to the first amount column (e.g. Increase). It behaves similarly any ledger >>> mode I try: Basic, Auto-split, or Journal. >>> >>> In fact, I can't find any way with the keyboard to get the cursor to the R >>> column at all, or to modify the data there. Only clicking the character in >>> the column with the mouse cursor changes the field, and it only cycles >>> between n and c. According to the manual, R is only possible to achieve >>> using the main reconciliation mechanism. >>> >>> I need to unreconcile hundreds of transactions in a ledger, for which I >>> wanted to use a quick keyboard macro. But the macro can't get to the right >>> column. Is there an unreconcile hot-key? >> >> _______________________________________________ >> 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. _______________________________________________ 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.
