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, <[email protected]
<mailto:[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] <mailto:[email protected]> www.ihtfp.com
<http://www.ihtfp.com>
Computer and Internet Security Consultant
_______________________________________________
gnucash-user mailing list
[email protected] <mailto:[email protected]>
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.
_______________________________________________
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.
