Here is how I deal with this. When I Download a statement from a bank I convert it to a standard format to make importing to gnucash easier, as all banks have different formats. When I do this conversion I also add a new transaction for each day when the statement has an end of day balance. Description: Balance on 01/01/2021, €1,234.56 Date: 01/01/2021 Withdrawal: 0 Transfer account: Information Balance
That way it is very easy to spot where there is a mistake. If you can't automate this you can easily create a manual transaction each month or week when you reconcile your account. Kind regards Ove On Mon, 3 May 2021, 15:54 Derek Atkins, <[email protected]> wrote: > Hi, > > On Mon, May 3, 2021 9:40 am, Mahon Finbar wrote: > > Hi, > > > > I am sure this has come up before....but..... > > > > Reconciling an account - I have a starting balance of €x,xxx.xx and an > > ending balance from the date of the latest bank statement of €x,xxx.xx. > > > > So far so good. I have checked the entries in the a/c and all are either > > R or c. I have also checked there are no non-cleared that I don't know > > about. > > > > However, I have a surplus when 'reconciled' and I cannot find out > why....😅 > > > > Is there anywhere I can find where the starting balance number comes > > from? Is that 'wrong' giving a surplus or am I missing transaction(s) > > somewhere? > > Within GnuCash it is computed (the sum on all reconciled data). > It *should* match the ending balance from your previous statement. You > can go check that. If it does NOT match, then you might have > inadvertantly un-reconciled a previous transaction, or possibly moved it > or accidentally changed it. > > If the balance DOES match, then go through each transaction carefully -- > most likely there is a typo in there, a missing transaction, or an extra > transaction. (I had this issue recently where I mis-typed something, and > strangely the difference exactly equalled another transaction.. It took > me about 3 passes before I finally found the issue). > > > Barry > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- > Derek Atkins 617-623-3745 > [email protected] www.ihtfp.com > Computer and Internet Security Consultant > > _______________________________________________ > gnucash-user mailing list > [email protected] > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
