[GNC] Reconcile Opening Balance

Mahon Finbar mahon.finbar at neuf.fr
Tue May 4 03:48:13 EDT 2021


Yes, the two suggestions are the way, I expect. I was just hoping to 
avoid the formatting stuff, and the drudgery of checking. I enter the 
various bank entries directly in the a/c where they 'belong' as I expect 
most, non accountant trained, people do, especially if you came to Gnu 
from Quicken....😁

Matching from previous balance is  bit of a problem when you only do the 
reconciles when the tax man calls....., to avoid answering awkward 
questions 😁

Most times the difference is in pennies, so I don't worry, [probably 
finger problems].

Thanks for the help. BTW, what import format works best in your opinion?

(I still need to find the lacuna....🙁)

Barry

On 04/05/2021 08:48, Ove Grunnér wrote:
> 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, <derek at ihtfp.com 
> <mailto:derek at ihtfp.com>> 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
>     derek at ihtfp.com <mailto:derek at ihtfp.com> www.ihtfp.com
>     <http://www.ihtfp.com>
>            Computer and Internet Security Consultant
>
>     _______________________________________________
>     gnucash-user mailing list
>     gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>     To update your subscription preferences or to unsubscribe:
>     https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>     If you are using Nabble or Gmane, please see
>     https://wiki.gnucash.org/wiki/Mailing_Lists
>     <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.
>


More information about the gnucash-user mailing list