[GNC] Unable to reconcile

Thu Jul 4 13:35:24 EDT 2019

 Alan,

Your experience was strange.  If it ever repeats, it would be interesting
to see if it relates to a language or font issue or something completely
different.

David Carlson

On Thu, Jul 4, 2019 at 9:42 AM Alan A Holmes <gnucash at alanaholmes.me.uk>
wrote:

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

-- 
David Carlson