Re: [GNC] Unable to reconcile
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 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...@gnucash.org] On Behalf Of Anna > Sent: 02 July 2019 14:03 > To: David Carlson > Cc: gnucash-user@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 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.trico...@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 [mailto:david.carlson@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.trico...@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 de...@ihtfp.com]> wrote: > Hi, > > On Wed
Re: [GNC] Unable to reconcile
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...@gnucash.org] On Behalf Of Anna Sent: 02 July 2019 14:03 To: David Carlson Cc: gnucash-user@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 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 mailto:anna.trico...@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 mailto:david.carlson@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 mailto:anna.trico...@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 mailto:de...@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
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 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 mailto:anna.trico...@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 mailto:david.carlson@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 mailto:anna.trico...@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 mailto:de...@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 de...@ihtfp.com [mailto:de...@ihtfp.com] www.ihtfp.com [http://www.ihtfp.com] Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org [mailto:gnucash-user@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@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] Unable to reconcile
Please follow Colin's suggestion and include complete details of the version of GnuCash, your OS, the steps that you took before each illustration in the same message so we don't have to guess what you are not telling us. Some of us are using mail clients that make it very hard to navigate backwards through threads or to untangle 'hidden' parts of messages. To anonymize your illustration, create a simple data file with bogus data or use a graphic editor to block out names of accounts. David Carlson On Tue, Jul 2, 2019 at 8:04 AM Anna wrote: > It was mentioned that this issue arose after an update - in fact, that it > was the first reconciliation since that update. > > ___ 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] Unable to reconcile
On Tue, 2 Jul 2019 at 07:58, Anna 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. Post a screenshot (or put it somewhere accessible, not sure if you can post images on this list) showing the reconcile window which will not allow you to just ignore that entry, even if it is dated before the reconcile date. Just to check, you are entering the closing balance from the bank statement aren't you, not from the GC balance? If you can't do that then post a screenshot showing that dialog instead. Colin > > Best > Anna > > On 28/06/2019 17:09:33, David Carlson 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 [mailto:anna.trico...@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 [mailto:de...@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 > de...@ihtfp.com [mailto:de...@ihtfp.com] www.ihtfp.com [http://www.ihtfp.com] > Computer and Internet Security Consultant > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org [mailto:gnucash-user@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. > ___ > 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] Unable to reconcile
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 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 mailto:anna.trico...@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 mailto:de...@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 de...@ihtfp.com [mailto:de...@ihtfp.com] www.ihtfp.com [http://www.ihtfp.com] Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org [mailto:gnucash-user@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. ___ 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] Unable to reconcile
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 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 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 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 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 >> 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. >> > -- David Carlson ___ 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] Unable to reconcile
On 6/27/19 5:45 AM, Anna 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. I am on the latest version and do not have to do this. I have checks still outstanding within the date range and don't have to check them off. In fact, checking them off makes the Difference non-zero. Leaving them unchecked allows the Difference field to go to zero when the correct other transactions are checked off. You need to do some more investigating. Sometimes I find that an earlier transaction was unchecked (do to some action on my part during the intervening time period) which then left the difference column non-zero. However, that transaction should show up on the reconciliation panel as unchecked. It is a simple matter of checking that additional transaction off and watching the difference field go to zero. If you can't get the difference to zero, then you need to understand why and resolve the issue. > > Regards > Daisy > On 27/06/2019 09:41:02, Derek Atkins 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 --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Unable to reconcile
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 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 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 > 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] Unable to reconcile
If you mean you have gone through the reconcile process as you normally do, and ticked everything off that appears in the statement from the bank, but you end up with a Difference which is not zero then almost certainly you have made a small mistake. Either in entering the closing balance or one of the transactions. When this happens to me is usually something like a transaction of 5.83 that I have erroneously entered into GC as 5.38, then when I do the reconcile I do not see the error and just tick it off. Go through each entry carefully and double check that the GC transaction exactly matches that in the statement. Colin On Thu, 27 Jun 2019 at 09:37, 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? > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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] Unable to reconcile
That’s not correct. In order to complete a reconciliation the date is not relevant to GnuCash. The only thing that matters is that you’ve checked off enough (hopefully correct) transactions that explain the difference between opening and ending balances. The ‘Difference’ amount in the bottom right corner has to be zero to finish the reconciliation. Regards, Adrien > On Jun 27, 2019, at 7:45 AM, Anna 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 ___ 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] Unable to reconcile
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 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 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.
Re: [GNC] Unable to reconcile
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 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.