Reconciliation window: closing balance distorted and reconciliation date

Maf. King maf at chilwell.net
Fri May 2 06:35:13 EDT 2008


On Friday 02 May 2008, Jannick Asmus wrote:
> Hi James,
>
> thanks for your input.
>
> On 02.05.2008 11:27, James Kerr wrote:
> > On Friday 02 May 2008, Jannick Asmus wrote:
> >> Hi,
> >>
> >> the following problems occur after opening the reconciliation window:
> >>
> >> 1. Closing balance inappropriate when reconciliation date is before date
> >> of advanced transactions already reconciled:
> >
> > I always type in the closing balance from the bank statement. I think
> > that's what you're supposed to do. There will often be a difference
> > between the date transactions are recorded by the bank and the date you
> > record them in gnucash.
>
> That's correct with regard to the bank account. Here I get the current
> balance with the online banking module. I think this is better. But
> unfortunately this method does not apply to other accounts like tax
> liabilities.
>
> So the problem is still open.
>

Hi, 
I'm not quite understanding what you are trying to do here.  
I think that you are entering transactions in advance (because you know that 
they are going to happen),  then you get a statement from the organisation 
concerned (who don't assume anything about your future) which doesn't show 
the future transactions?

As I understand it (& IANAA) "Reconciling" is a process where two parties (eg. 
you and your bank) communicate to agree what transactions _have_ happened, 
and thus, what the balance owing on a set date is.

How can you reconcile a txn, until you have a "statement" from the other 
party? Could you expand a little on what you are trying to do?

> >> 2. The default date is not the current date - _sometimes_. Does GC store
> >> the date when it was manually changed? If so how can GC "forget" this
> >> information?
> >
> > In my experience it assumes that the statement date is one month on from
> > the date of the last statement. (This will not always be the case,
> > depending on how your bank deals with weekends and holidays etc.) It only
> > uses the current date if the next "due" date is later than the current
> > date.
>

I think that GC uses slightly more intelligence than (last_date+1_month).  
IIRC, the new statement date is calculated using the time gap between the 
last two statements - ie something like:
last_date + (last_date-previous_date).  I'm sure that if I have this wrong, a 
dev will point it out!

> Hmm, I am not sure whether my GC behaves like this. It seems that for
> some accounts there is a reconciliation date stored which is independent
> of any other date like the current date.
>
I see what you mean, in that the default date generally works for my monthly 
bank/credit card statements, but certain accounts where I only get annual 
statements often show the wrong date.  So far, I've just lived with it as a 
minor inconvenience which happens a couple of times a year.

HTH,
Maf.





More information about the gnucash-user mailing list