Re: [GNC] Reconcile Opening Balance

2021-05-04 Thread Mahon Finbar 
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, > wrote:


Hi,

On Mon, May 3, 2021 9:40 am, Mahon Finbar wrote:
> Hi,
>
> I am sure this has come up beforebut.
>
> 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

de...@ihtfp.com  www.ihtfp.com

       Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org 
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
gnucash-user@gnucash.org
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.

Re: [GNC] Reconcile Opening Balance

2021-05-04 Thread Ove Grunnér 
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,  wrote:

> Hi,
>
> On Mon, May 3, 2021 9:40 am, Mahon Finbar wrote:
> > Hi,
> >
> > I am sure this has come up beforebut.
> >
> > 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
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
gnucash-user@gnucash.org
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.

Re: [GNC] Reconcile Opening Balance

2021-05-03 Thread Derek Atkins 
Hi,

On Mon, May 3, 2021 9:40 am, Mahon Finbar wrote:
> Hi,
>
> I am sure this has come up beforebut.
>
> 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
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

[GNC] Reconcile Opening Balance

2021-05-03 Thread Mahon Finbar 

Hi,

I am sure this has come up beforebut.

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?


Barry

___
gnucash-user mailing list
gnucash-user@gnucash.org
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.