Doug, Just a note, if you reverse/invert to consecutive digits the difference is divisible by 9, not 11.
Thank You, Gyle McCollam Gyle McCollam [email protected]<mailto:[email protected]> email ________________________________ From: gnucash-user <[email protected]> on behalf of Doug via gnucash-user <[email protected]> Sent: Sunday, December 21, 2025 4:38 PM To: Randy Orrison <[email protected]>; gnucash-user <[email protected]> Subject: Re: [GNC] Accidentally unreconclied a transaction - how to mark reconciled again? Randy, 2 things: does the account balance look right? Do you have a duplicate transaction? One thing you can do is to re-run your last reconciliation. Look at the unreconciled transactions. tick the one you mentioned & look at the balance. If it is zero, just finish the reconciliation, & all fixed.if the balance is the same as the item you ticked, you will need to do some detective work. (try a search for that amount: it is not unknown for a date to be really wrong, & if that was ticked off last reconciliation, for that to be where the problem lies. Get your Sherlock hat & Magnifying glass out! (Sherlock Holmes the pommie detective...). Remember you can always cancel a reconciliation before completion, so no harm in trialling a reconciliation. There are some accounting tricks: number reversal usually gives a difference divisible by 11 (not sure why!) From all my Gnucash user years, most of my errors have been caused by finger troubles, not system failure. Best blame the user, not the tool! ~Doug On Sun, 21 Dec 2025 13:51:42 +0000 "Randy Orrison" <[email protected]> wrote: > Hi Doug, > > > On Sun, 21 Dec 2025, at 11:46 AM, Doug wrote: > > I have had this happen a few times over the years. What I do is to not > > panic, & clear the transaction at the next reconcile. > > > > If you reconcile everything but that transaction, the balance should be the > > unreconciled transaction, so just tick it & > > finish the reconcile. You can even use the last reconcile (where everything > > was already reconciled), which should be sitting at the unreconciled > > amount. Again tick & proceed. > > I've just reconciled my December statement. The starting balance was > correct, I ticked all the transactions on the statement, and the reconciled > balance matched the ending balance on the statement. This problematic > transaction from months ago was still unticked. If I tick it, then the > reconcile windows says there's a discrepancy and won't let me proceed. > > It is an unusual amount, so it's easy for me to filter for all transactions > across all my accounts for that amount - there are no others this year. (In > fact, the only other transaction for that amount was in 2012. That one is > reconciled, and in an account that was closed a long time ago.) > > I have been using GnuCash since 2008, so I have encountered many instances of > difficult to reconcile transactions where I've put things on the wrong date > or the wrong account, but this one has me stumped. > > On Sun, 21 Dec 2025, at 11:05 AM, [email protected] wrote: > > Or you could just delete the mystery transaction. > > I did just try that in a copy of my file... As expected, it created a problem > in the savings account. I re-created the transaction, and was able to > re-reconcile my savings account and reconcile just that one transaction > there, but then it's back in my checking account as not reconciled and I > can't reconcile it. > > I've also just tried marking a different transaction as unreconciled, and > that changes the starting balance when I try to reconcile the account - so > that's not what happened. > > ... > > I have now managed to find it! Here's how, in case it helps someone else. I > exported the transactions from my checking account to a CSV file - which > includes the date it was reconciled. With that I was able to filter in Excel > to identify the transactions that were reconciled on the statement that > included the mystery transaction. I was then able to compare the > transactions that I had reconciled against the original statement - I had > recorded and reconciled that transfer in the checking account as two separate > transfers on different dates from the wrong account (for reasons that made > sense at the time). When I later reconciled the savings account, I added a > single transfer for the whole amount on the correct date - which created the > transaction in the checking account that couldn't be reconciled. > > Thank you again for your helpful ideas! > > Randy > > > > > > > > On Sun, 21 Dec 2025 16:35:26 +0530 > > sunfish62--- via gnucash-user <[email protected]> wrote: > > > > > If your starting and ending balances are correct without this transaction > > > included, then there's something wrong. Either the transaction doesn't > > > really exist, or another one of equal amount (which has itself been > > > reconciled) doesn't exist. > > > > > > Perhaps this transaction belongs in another account in your finances? > > > I've been known to have that happen, especially when auto fill kicks in. > > > > > > The only way to truly figure it all out is to dereconcile back to before > > > the transaction in question and re do everything again, very carefully. > > > > > > You could just leave it there until you figure out what it is. > > > > > > Or you could just delete the mystery transaction. > > > > > > David T. > > > > > > On Dec 21, 2025, 4:14 PM, at 4:14 PM, Randy Orrison <[email protected]> > > > wrote: > > > >Hi, > > > > > > > >I have a transaction in my checking account from a couple months ago > > > >that I can't reconcile. It's showing as unreconciled in the register, > > > >but when I mark it as reconciled while doing reconciliation, the > > > >balance is off by the amount of that transaction. > > > > > > > >When I do reconciliation of statements on that account, the starting > > > >and ending balances are correct, but that one transaction - which has > > > >cleared through the bank and appeared on the statement for that month - > > > >can't be reconciled. > > > > > > > >I've looked to see if there's some other transaction on the wrong date > > > >for that amount, or perhaps it was entered into the wrong account, or > > > >anything else, but there's no explanation I can see other than that I > > > >accidentally marked it as unreconciled at some point and ignored the > > > >warning. > > > > > > > >Is there some way to just mark it as reconciled, to correct the error I > > > >made by marking it as unreconciled? > > > > > > > >Thanks, > > > > > > > >Randy > > > >_______________________________________________ > > > >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. _______________________________________________ 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.
