[GNC] Unable to reconcile

[Alan A Holmes]

Just to say that I had a problem reconciling one of my accounts, my Current Account / Cheque account, this morning. I did what I normally do, i.e. obtain electronic statements up to today's date and then reconcile based on the balance on the bank statement as of this morning. It ended up being £0.78 out!

I spend 10-15 minutes investigating, starting the reconcile from scratch, checking each debit/credit to ensure that the amounts matched exactly, and still the same problem. On the 3rd attempt it went and balanced exactly, no problem.

The difference between the 1st and 2nd attempts that failed and the third attempt that worked is that on the 3rd attempt I typed in the ending balance, whereas on the 1st and 2nd attempts I cut and pasted the ending balance from the latest statement, a pdf document. The amount in the "Ending Balance" box on the "Reconcile Information" window looked to be exactly the same, but obviously wasn't.

Thought I'd enter my twopenneth in case it may have a bearing on what someone else has done.


Alan A Holmes

-----Original Message-----
From: gnucash-user [mailto:gnucash-user-bounces+gnucash=alanaholmes.me.uk at gnucash.org] On Behalf Of Anna
Sent: 02 July 2019 14:03
To: David Carlson
Cc: gnucash-user at gnucash.org; Derek Atkins
Subject: Re: [GNC] Unable to reconcile

It was mentioned that this issue arose after an update - in fact, that it was the first reconciliation since that update.

On 01/07/2019 17:10:49, David Carlson <david.carlson.417 at gmail.com> wrote:
As others have also mentioned, they are not seeing the same issue that you are, at least with the given details.  While your last message does list the transaction dates in detail, it does not mention other factors such as whether this, for you, is a new issue in a recent update or whether reconciling in GnuCash is a process that you may be trying for the first time, or whether you have verified the other steps, including checking the starting and ending balances.

Now that release 3.6 is out, you (and others) can also check whether that release behaves the same way.  Historically, others have not seen your issue, but you are correct that it should not be requiring that transactions be dated on the cleared date, unless you are specifically trying to match dates to the dates shown on your bank statement.  For one account in my data, I actually do try to do that.


David Carlson


On Mon, Jul 1, 2019 at 10:55 AM Anna <anna.tricoter at gmail.com [mailto:anna.tricoter at gmail.com]> wrote:

If you read my message, you will see that this is just what I did.  

As mentioned in my update, if a cheque is written on 23 May, for instance, but not presented until 2nd June, and the reconciliation date is 31st May, then with the new version of Gnucash the date of the cheque must be changed to beyond the reconciliation period.

Best
Anna

On 28/06/2019 17:09:33, David Carlson <david.carlson.417 at gmail.com [mailto:david.carlson.417 at gmail.com]> wrote:
Another way looking at this issue is while reconciling to be sure that all transactions on the bank statement are checked and all transactions in the statement period that have not cleared yet are not checked.   Then the reconciliation can be completed.  There is no requirement for outstanding transactions to be checked. 


If, as you suggested,  the reconciliation ending balance cannot be changed to match the bank statement balance to complete the reconciliation thus requiring all transactions to be checked,  that would be a serious issue requiring a big report.

Please excuse my spell checker re-writes . I cannot be sure that it says what I mean. 

David Carlson 

On Fri, Jun 28, 2019, 4:27 AM Anna <anna.tricoter at gmail.com [mailto:anna.tricoter at gmail.com]> wrote:

Yes, that's the first thing I checked.  You'll see that my initial post confirmed this.

This is the first reconciliation since upgrading to a newer version.

I've done some more investigation, and found that it is because one of the transactions had been entered under an incorrect date.  This new version will not allow reconciliation until all transactions within the date span are marked off, meaning that if a cheque is entered, the date will have to be changed from the date it was written to the date it was presented.

Regards
Daisy
On 27/06/2019 09:41:02, Derek Atkins <derek at ihtfp.com [mailto:derek at ihtfp.com]> wrote:
Hi,

On Wed, June 26, 2019 3:58 pm, Daisy wrote:
> I'm trying to reconcile current account. Opening and closing balances
> tally, as does reconciled balance, but I cannot finish the reconciliation
> because the cleared balance is different. Total paid in and total paid out
> are correct.
>
> Have made sure that all transactions that should be reconciled are marked
> off.
>
> What is causing this discrepancy?

Make sure your ending balance, as entered when you start the reconcile
process, matches your statement ending balance. And then make sure only
the items on the statement are checked off in the reconcile window.

> 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.



--

David Carlson
_______________________________________________
gnucash-user mailing list
gnucash-user at 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.


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus