One of the things (amongst many) I used to do when trying to track down reconciliation problems - such as yours in this case - was to look for the running balance total of the account in question that matched the start balance shown. This often flagged up errors of one sort or another that when corrected resulted in a correct start balance. Other things I looked for were: correct date for the entry, correct statement date, correct amount, correct side of the ledger, duplicated transactions and had any transactions been unreconciled or reconciled in error.
You might also run the 'Reconcilliation report'; I have found that very handy for checking errors - and if you printed it off you could check it against the bank statement line by line; I always found paper to be better than looking at the screen. When I had multiple errors - in a business where too many people, for my liking, had access - I would download the bank into Excel and export from Sage (as was the case) into the same sheet and sort the columns with a short comparison script that flagged discrepancies between the columns. You will find the error if you look for it, but it can be a tedious job. G On Tue, 7 Nov 2023 at 18:51, David Carlson <david.carlson....@gmail.com> wrote: > John, > > If you review which transactions you are marking as reconciled while you > perform the reconciliation, you will note that the list does not exactly > match the list on your bank statement. The transactions that do not match > will make up the difference, which could be missing from either list, > depending on the source of the error. That information should aid in > finding the error. > > It is possible that some old transactions in your data are no longer marked > as reconciled or more recently marked transactions are, or worse yet, some > transactions or split lines have disappeared or been added as a result of > some other error. > > You can make the effort to find and correct whatever caused the discrepancy > or allow GnuCash to create a correcting transaction if necessary to offset > an error that is too difficult to track down. > > On Tue, Nov 7, 2023, 12:04 PM John Reagan <johntrea...@gmail.com> wrote: > > > Thanks for replying. However, it doesn't work out as being okay. When > > I use the */actions/reconcile/ *menu choice to reconcile my account, > > that false beginning balance is factored into the final balance. Where > > it should be zero difference between cleared and reconciled balances, > > there is a false number. > > > > > > How is that beginning balance calculated? If I can check on the numbers > > that are used to calculate the beginning balance, I should be able to > > find the mistake that is generating that error. > > > > > > John > > > > > > > > > > On 11/7/23 9:39 AM, Gyle McCollam wrote: > > > AS long as the ending balance is correct, you are good. Delete the > > > correction transaction and procedd as normal. > > > > > > Thank You, > > > > > > *Gyle McCollam* > > > > > > Gyle McCollam > > > > > > gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email > > > > > > > ------------------------------------------------------------------------ > > > *From:* gnucash-user > > > <gnucash-user-bounces+gylemc=gmail....@gnucash.org> on behalf of John > > > Reagan <johntrea...@gmail.com> > > > *Sent:* Tuesday, November 7, 2023 12:26 PM > > > *To:* gnucash-user@gnucash.org <gnucash-user@gnucash.org> > > > *Subject:* [GNC] Account reconciliation -- Gnucash's beginning balance > > > is incorrect. > > > Hello! > > > > > > > > > I have been using Gnucash for years to keep track of my personal > > > finances and it has always done a good job for me. However, recently I > > > was trying to reconcile my checking account and the starting balance in > > > Gnucash's reconciliation popup window was not only wrong, but showed a > > > negative balance. (I attached a screenshot of that popup window FYI.) > > > I'm reconciling my August 2023 statement that shows an ending balance > of > > > $1378.00 (the correct amount, so this should have just been a slam-dunk > > > reconciliation) but the starting balance for that period was $299.46 > > > which is the reconciled balance at the end of July. Instead, Gnucash is > > > showing a starting balance of $ -200.54. > > > > > > I tried entering a correction transaction of $200.54, but it > didn't > > > change anything. > > > > > > So, any ideas as to what went wrong and how to fix this? Thanks. > > > > > > John > > > > > > > > _______________________________________________ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > 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 > gnucash-user@gnucash.org > 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 gnucash-user@gnucash.org 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.
