I stand corrected. As you see I am not an accountant! Still good trick to know. Of course I never make mistakes....
Merry Xmas, Doug On Mon, 22 Dec 2025 04:59:51 +0000 Gyle McCollam <[email protected]> wrote: > 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.
