Re: [GNC] Reconciliation discrepancies
One potential source of problem is banks that mess up the unique identifier of downloaded transactions. In my case Citibank is inconsistent in assigning a unique and constant FITID for each transaction. So if I re-download transactions, there's a chance that the FITID of a previously downloaded transaction will not be the same as the first time I downloaded it. This means GC will think it's a new transaction and I'll end up with a duplicated transactions and failure to reconcile. This was so annoying I had to write a small python script to correct the issue myself in the ofx file before importing it in GC. Jean On 4/12/22 4:16 PM, John Layman wrote: I've been using GnuCash for 12 years and have rarely had a reconcile discrepancy that could be blamed on the software (that was a date bug that reared its head a while back - quickly corrected). And the incidence of error on the bank's part has been extremely rare. Most occasions when I've encountered a sizable imbalance have been due to transactions I bungled by inadvertently entering them with a munged date. The faulty entry has eventually been found lurking back in time among previously balanced data. The GnuCash reconciliation process displays the beginning balance, and I've learned to first double check that number and the reconciliation date for correspondence with the bank statement when there is an imbalance. Searching the account for unreconciled transactions is a good way to reveal any junk entries that were inadvertently plunked down back in time. In my experience, whenever you encounter something puzzling in GnuCash, the most likely cause is user error or a failure to RTFM. -Original Message- From: gnucash-user On Behalf Of Rich Shepard Sent: Tuesday, April 12, 2022 8:49 AM To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Reconciliation discrepancies On Tue, 12 Apr 2022, Liz wrote: By looking at such a small number of transactions it is possible to find whatever the errors are. I too have been on Gnucash for a couple of decades, but still found 4 errors in one file this March, payments not entered as received, and digit transposition. Liz, The reason I started this thread is all transactions for the month match. No switched digits, no missing GnuCash transactions. And, now and then during the month I check the accounts on the bank's web site and marked GnuCash transactions as cleared as they appear on the bank's web page. I hope you find what is happening and let us know. Based on everyone's response my assumption that it's something unknowable at the bank's side seems to be confirmed. Thanks, Rich ___ 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. ___ 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] Reconciliation discrepancies
I've been using GnuCash for 12 years and have rarely had a reconcile discrepancy that could be blamed on the software (that was a date bug that reared its head a while back - quickly corrected). And the incidence of error on the bank's part has been extremely rare. Most occasions when I've encountered a sizable imbalance have been due to transactions I bungled by inadvertently entering them with a munged date. The faulty entry has eventually been found lurking back in time among previously balanced data. The GnuCash reconciliation process displays the beginning balance, and I've learned to first double check that number and the reconciliation date for correspondence with the bank statement when there is an imbalance. Searching the account for unreconciled transactions is a good way to reveal any junk entries that were inadvertently plunked down back in time. In my experience, whenever you encounter something puzzling in GnuCash, the most likely cause is user error or a failure to RTFM. -Original Message- From: gnucash-user On Behalf Of Rich Shepard Sent: Tuesday, April 12, 2022 8:49 AM To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Reconciliation discrepancies On Tue, 12 Apr 2022, Liz wrote: > By looking at such a small number of transactions it is possible to > find whatever the errors are. I too have been on Gnucash for a couple > of decades, but still found 4 errors in one file this March, payments > not entered as received, and digit transposition. Liz, The reason I started this thread is all transactions for the month match. No switched digits, no missing GnuCash transactions. And, now and then during the month I check the accounts on the bank's web site and marked GnuCash transactions as cleared as they appear on the bank's web page. > I hope you find what is happening and let us know. Based on everyone's response my assumption that it's something unknowable at the bank's side seems to be confirmed. Thanks, Rich ___ 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] Reconciliation discrepancies
Rich, One possible cause for this is a transaction (or more) accidentally entered since the time you were last getting correct reconciliations at a date sometime in the past. This has occurred for me sometimes when I have mistyped a date entry, particularly the year, on entry. e.g date went in as 2020 not 2022. If this were the case it will throw the account balances out wrt to any statement. It is very unlikely for a bank to have an error in a statement (if they did it would likely be a programming error which would produce errors in a large number of customers statements which would normally be reported to them fairly quickly, corrected and corrected statements reissued). Similarly an error in GnuCash would likely cause a large number of people to be simultaneously reporting reconciliation problems although since my bank only issues statements every 6 months for personal accounts reconciliation is now a lot less frequent for me than it was in the past when I still had business accounts. If they haven't been marked as reconciled, any such transactions should appear at the top of the debit or credit panes of the reconciliation dialogue and have a date outside the range of the current reconciliation and they will not be included in the sum for the starting balance for the present reconciliation which could therefore appear to be correct but the closing balances in your GnuCash account will be thrown out. If somehow they had been marked as reconciled, they are not going to appear in the debit and credit panes of the dialogue, but the starting balance should not match the starting balance on the statement in this case. Locating any transactions of this sort can be a time consuming business when and if it does occur. David Cousens On Tue, 2022-04-12 at 05:49 -0700, Rich Shepard wrote: > On Tue, 12 Apr 2022, Liz wrote: > > > By looking at such a small number of transactions it is possible to find > > whatever the errors are. I too have been on Gnucash for a couple of > > decades, but still found 4 errors in one file this March, payments not > > entered as received, and digit transposition. > > Liz, > > The reason I started this thread is all transactions for the month match. No > switched digits, no missing GnuCash transactions. And, now and then during > the month I check the accounts on the bank's web site and marked GnuCash > transactions as cleared as they appear on the bank's web page. > > > I hope you find what is happening and let us know. > > Based on everyone's response my assumption that it's something unknowable at > the bank's side seems to be confirmed. > > Thanks, > > Rich > ___ > 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] Reconciliation discrepancies
On Tue, April 12, 2022 12:58 pm, R. Victor Klassen wrote: >> On Apr 12, 2022, at 10:20 AM, David T. wrote: >> >> Reconciled entries *are* marked read only. If you aren't getting a >> notice on editing, it's because you told gnucash not to notify you any >> more. That can be reset somewhere in the preferences. >> >> David > > Well that would implicate data corruption No, more likely than not the user got the warning, clicked "don't show me again", and then clicked "cancel." > 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] Reconciliation discrepancies
Well that would implicate data corruption Sent from my iPhone > On Apr 12, 2022, at 10:20 AM, David T. wrote: > > Reconciled entries *are* marked read only. If you aren't getting a notice on > editing, it's because you told gnucash not to notify you any more. That can > be reset somewhere in the preferences. > > David > > >> On April 12, 2022 5:25:51 AM PDT, "R. Victor Klassen" >> wrote: >> I run into such issues once in every one or two blue moons. The starting >> balance is off. >> I’ve reconciled successfully the previous month, but something somehow >> (dis)appeared in the meantime. I assume it disappeared, although the >> symptoms could be generated by something appearing. >> >> I hope it’s more than a year old, and live with it. Meaning I do a balance >> adjustment and move on. >> >> It’s disturbing, but the size of my file is such that I have no reasonable >> means of tracking down whatever may have happened. >> >> Possible that it’s user error, but unlikely. Possible that it results from >> one of the periodic crashes I experience, or power failures, that appear to >> be fully recovered from at the time. Pretty much impossible to reproduce. >> If it is due to user error, that would be an argument in favour of the >> ability to mark old transactions as read-only. Yes I’m very aware that >> “read-only” can be worked around. But when it’s about protecting one from >> oneself, that kind of read-only could be useful. If it’s due to bit >> rot/power glitches/crash recovery, not so much. >> >>> On Apr 12, 2022, at 6:09 AM, Liz wrote: >>> >>> On Mon, 11 Apr 2022 14:36:41 -0700 (PDT) >>> Rich Shepard wrote: >>> Every now and then one of my bank accounts doesn't reconcile because what the bank shows differs from what GnuCash shows. The amounts are significant. What puzzles me is that the previous month's balances (bank and GC) match and so do all the transactions. But, the end of month balances don't match. >>> >>> Rich when I get into a mess, I do very small increments on the >>> reconcile. For example, just choosing a date about 10 transactions >>> down, or one week, and then I will go through very slowly, doing small >>> chunks. >>> Assume this is one month, and I am doing weekly... >>> I find the bank's ending balance for 7th of month, put 7th of correct >>> month and the balance from the bank statement into the reconcile >>> dialogue, and check off that week's items from the bank statement. When >>> the residual is zero, I mark finished, and move forward to the 14th. >>> (Procedure loops) >>> >>> By looking at such a small number of transactions it is possible to >>> find whatever the errors are. >>> I too have been on Gnucash for a couple of decades, but still found 4 >>> errors in one file this March, payments not entered as received, and >>> digit transposition. >>> >>> I hope you find what is happening and let us know. >>> >>> liz >>> 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. ___ 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] Reconciliation discrepancies
Do you by chance have sub-accounts at play, and are you including them in the reconcile? Sub-accounts *shouldn't* matter because 'if done correctly' they shouldn't affect the parent balance, and serve just as a segregation/classification tool. But the caveat is that transactions there might be incorrect and would roll-up to the parent if included in reconciliation. Regards, Adrien On 4/12/22 7:49 AM, Rich Shepard wrote: Based on everyone's response my assumption that it's something unknowable at the bank's side seems to be confirmed. ___ 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] Reconciliation discrepancies
Reconciled entries *are* marked read only. If you aren't getting a notice on editing, it's because you told gnucash not to notify you any more. That can be reset somewhere in the preferences. David On April 12, 2022 5:25:51 AM PDT, "R. Victor Klassen" wrote: >I run into such issues once in every one or two blue moons. The starting >balance is off. >I’ve reconciled successfully the previous month, but something somehow >(dis)appeared in the meantime. I assume it disappeared, although the symptoms >could be generated by something appearing. > >I hope it’s more than a year old, and live with it. Meaning I do a balance >adjustment and move on. > >It’s disturbing, but the size of my file is such that I have no reasonable >means of tracking down whatever may have happened. > >Possible that it’s user error, but unlikely. Possible that it results from >one of the periodic crashes I experience, or power failures, that appear to be >fully recovered from at the time. Pretty much impossible to reproduce. >If it is due to user error, that would be an argument in favour of the ability >to mark old transactions as read-only. Yes I’m very aware that “read-only” >can be worked around. But when it’s about protecting one from oneself, that >kind of read-only could be useful. If it’s due to bit rot/power >glitches/crash recovery, not so much. > >> On Apr 12, 2022, at 6:09 AM, Liz wrote: >> >> On Mon, 11 Apr 2022 14:36:41 -0700 (PDT) >> Rich Shepard wrote: >> >>> Every now and then one of my bank accounts doesn't reconcile because >>> what the bank shows differs from what GnuCash shows. The amounts are >>> significant. What puzzles me is that the previous month's balances >>> (bank and GC) match and so do all the transactions. But, the end of >>> month balances don't match. >> >> Rich when I get into a mess, I do very small increments on the >> reconcile. For example, just choosing a date about 10 transactions >> down, or one week, and then I will go through very slowly, doing small >> chunks. >> Assume this is one month, and I am doing weekly... >> I find the bank's ending balance for 7th of month, put 7th of correct >> month and the balance from the bank statement into the reconcile >> dialogue, and check off that week's items from the bank statement. When >> the residual is zero, I mark finished, and move forward to the 14th. >> (Procedure loops) >> >> By looking at such a small number of transactions it is possible to >> find whatever the errors are. >> I too have been on Gnucash for a couple of decades, but still found 4 >> errors in one file this March, payments not entered as received, and >> digit transposition. >> >> I hope you find what is happening and let us know. >> >> liz >> ___ >> 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. ___ 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] Reconciliation discrepancies
On Tue, 12 Apr 2022, Liz wrote: By looking at such a small number of transactions it is possible to find whatever the errors are. I too have been on Gnucash for a couple of decades, but still found 4 errors in one file this March, payments not entered as received, and digit transposition. Liz, The reason I started this thread is all transactions for the month match. No switched digits, no missing GnuCash transactions. And, now and then during the month I check the accounts on the bank's web site and marked GnuCash transactions as cleared as they appear on the bank's web page. I hope you find what is happening and let us know. Based on everyone's response my assumption that it's something unknowable at the bank's side seems to be confirmed. Thanks, Rich ___ 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] Reconciliation discrepancies
On Tue, 12 Apr 2022, Alan A Holmes wrote: I had a problem with reconciling just over a year ago. It happened on 2 separate occasions. My workflow to reconcile on both occasions was :- ... It only happened the twice. I still follow the workflow in steps 1-5 now, but don't have the problem is step 5. Any differences I've found was down to me. Alan, That looks like what I do, too, but I don't copy-and-paste the bank statement's closing balance. I type it. There are occasions when I forget to enter a transaction into GnuCash, and that's remedied during the reconciliation process. Because these discrepancies appear infrequently but only since I moved my accounts to this bank in 2010 I suspect it's something at their end. And my banker can't do anything about it because it's somewhere in their IT department it'll probably remain an annoying mystery. Thanks, Rich ___ 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] Reconciliation discrepancies
I run into such issues once in every one or two blue moons. The starting balance is off. I’ve reconciled successfully the previous month, but something somehow (dis)appeared in the meantime. I assume it disappeared, although the symptoms could be generated by something appearing. I hope it’s more than a year old, and live with it. Meaning I do a balance adjustment and move on. It’s disturbing, but the size of my file is such that I have no reasonable means of tracking down whatever may have happened. Possible that it’s user error, but unlikely. Possible that it results from one of the periodic crashes I experience, or power failures, that appear to be fully recovered from at the time. Pretty much impossible to reproduce. If it is due to user error, that would be an argument in favour of the ability to mark old transactions as read-only. Yes I’m very aware that “read-only” can be worked around. But when it’s about protecting one from oneself, that kind of read-only could be useful. If it’s due to bit rot/power glitches/crash recovery, not so much. > On Apr 12, 2022, at 6:09 AM, Liz wrote: > > On Mon, 11 Apr 2022 14:36:41 -0700 (PDT) > Rich Shepard wrote: > >> Every now and then one of my bank accounts doesn't reconcile because >> what the bank shows differs from what GnuCash shows. The amounts are >> significant. What puzzles me is that the previous month's balances >> (bank and GC) match and so do all the transactions. But, the end of >> month balances don't match. > > Rich when I get into a mess, I do very small increments on the > reconcile. For example, just choosing a date about 10 transactions > down, or one week, and then I will go through very slowly, doing small > chunks. > Assume this is one month, and I am doing weekly... > I find the bank's ending balance for 7th of month, put 7th of correct > month and the balance from the bank statement into the reconcile > dialogue, and check off that week's items from the bank statement. When > the residual is zero, I mark finished, and move forward to the 14th. > (Procedure loops) > > By looking at such a small number of transactions it is possible to > find whatever the errors are. > I too have been on Gnucash for a couple of decades, but still found 4 > errors in one file this March, payments not entered as received, and > digit transposition. > > I hope you find what is happening and let us know. > > liz > ___ > 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] Reconciliation discrepancies
On Mon, 11 Apr 2022 14:36:41 -0700 (PDT) Rich Shepard wrote: > Every now and then one of my bank accounts doesn't reconcile because > what the bank shows differs from what GnuCash shows. The amounts are > significant. What puzzles me is that the previous month's balances > (bank and GC) match and so do all the transactions. But, the end of > month balances don't match. Rich when I get into a mess, I do very small increments on the reconcile. For example, just choosing a date about 10 transactions down, or one week, and then I will go through very slowly, doing small chunks. Assume this is one month, and I am doing weekly... I find the bank's ending balance for 7th of month, put 7th of correct month and the balance from the bank statement into the reconcile dialogue, and check off that week's items from the bank statement. When the residual is zero, I mark finished, and move forward to the 14th. (Procedure loops) By looking at such a small number of transactions it is possible to find whatever the errors are. I too have been on Gnucash for a couple of decades, but still found 4 errors in one file this March, payments not entered as received, and digit transposition. I hope you find what is happening and let us know. liz ___ 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] Reconciliation discrepancies
Hi Rich, I had a problem with reconciling just over a year ago. It happened on 2 separate occasions. My workflow to reconcile on both occasions was :- 1. Open the bank statement, and copy the closing balance. 2. Open the appropriate account in GnuCash. 3. Click the reconcile icon. 4. Enter the Statement Date as the date of the bank statement, and paste closing balance from 1. Into the ending balance field. 5. Select all the appropriate transactions, checking their values. 6. I'd then find difference, usually several hundred £'s. No missed or incorrect transactions in GnuCash. 7. Cancel the reconcile. 8. Repeat steps 1-7. 9. Start tearing hair out. 10. Repeat steps 2-3 11. Enter the Statement Date as the date of the bank statement, and type in closing balance from the bank statement Into the ending balance field. 12. Repeat step 5. 13. Lucky for me rather than unlucky. The account would balance. Conclusion - Even though the bank account balance I copied and pasted was the same as I typed in it appears as though something got copied across that caused the problem. Whether it was an invisible character, or a bad character, or what, I have no idea. It only happened the twice. I still follow the workflow in steps 1-5 now, but don't have the problem is step 5. Any differences I've found was down to me. Alan A Holmes -Original Message- From: gnucash-user On Behalf Of Rich Shepard Sent: 11 April 2022 22:37 To: gnucash-user@gnucash.org Subject: [GNC] Reconciliation discrepancies Every now and then one of my bank accounts doesn't reconcile because what the bank shows differs from what GnuCash shows. The amounts are significant. What puzzles me is that the previous month's balances (bank and GC) match and so do all the transactions. But, the end of month balances don't match. Many decades ago a penny or two difference when reconciling a bank account was common; I assume due to rounding errors. But why it is now more common (but sporatic) puzzles both me and my banker. We've gone over the transactions shown by the bank and by GC and neither of us can explain the discrepancies. Has anyone an idea of why this happens? Rich ___ 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] Reconciliation discrepancies
A possibility that has not been mentioned yet is if there are transactions in more than one currency or involving securities. If so, there are many possible additional sources of discrepancy. Also, if the discrepancies suddenly appeared, say, after updating GnuCash to release 4.10, for example, that release is very new and may have 'bugs', known or unknown. David Carlson On Mon, Apr 11, 2022 at 11:30 PM wrote: > Rich > > Have been using GnuCash for a similar period of time and have not noticed > any > reconciliation problems (other than those reported as bugs on the list - > any > that are are generally fixed pretty quickly) up to v4.9, particulaarly in > recent > versions. Haven't yet done a reconciliation with 4.10. > > Anytime I have had a problem it has usually been a transposition, date > errors > and or missing transaction from the reconciliation period and different > ordering > in GnuCash and in the banks record leading to me missing a transaction. > Scheduled transactions if you have them might have different values from > the > bank's as might interest calculations if you calculate them yourself. I > have had > problems where the bank has a completely different order from my own > entries and > even the imported OFX entries because of clearance requirements for entry > into > the statement at the bank end. > > Have you tried checking the bank's balance by importing their opening and > closing balances and transactions into a spread sheet and summing them? > Unfortunately most pdfs will not import tables cleanly into most > spreadsheets > but I have resorted to entering the numbers by hand (individually cut and > paste) > to check. Only once have I discovered a bank error and they were most > apologetic. > > David Cousens > > On Mon, 2022-04-11 at 16:09 -0700, Rich Shepard wrote: > > On Mon, 11 Apr 2022, Gyle McCollam wrote: > > > > > These may not apply, but check that your reconciliation date is the > same > > > as the bank's. Also, check the dates of the transactions as GC shows > > > transaction past the reconciliation date, that you don't want to > > > reconcile. The ending balance that GC shows for the reconciliation can > be > > > changed, so put in the bank's balance and see if you get a zero > > > difference. > > > > Gyle, > > > > I check both the reconciliation date and that date's balance. There are > > discrepancies between the purchase date entered in GnuCash and when the > > transaction cleared the bank but those are immaterial. > > > > As an aside, I've used GnuCash for more than two decades, starting in > 1997. > > These large, sporatic discrepancies appeared only a few years ago, long > > after I moved my business and personal accounts to my current bank. I did > > catch the bank several years ago for charging me twice for the same > Amazon > > purchase and my banker had that quickly fixed. That was the only obvious > > error I've seen. > > > > Thanks, > > > > Rich > > ___ > > 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. > -- 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] Reconciliation discrepancies
Rich Have been using GnuCash for a similar period of time and have not noticed any reconciliation problems (other than those reported as bugs on the list - any that are are generally fixed pretty quickly) up to v4.9, particulaarly in recent versions. Haven't yet done a reconciliation with 4.10. Anytime I have had a problem it has usually been a transposition, date errors and or missing transaction from the reconciliation period and different ordering in GnuCash and in the banks record leading to me missing a transaction. Scheduled transactions if you have them might have different values from the bank's as might interest calculations if you calculate them yourself. I have had problems where the bank has a completely different order from my own entries and even the imported OFX entries because of clearance requirements for entry into the statement at the bank end. Have you tried checking the bank's balance by importing their opening and closing balances and transactions into a spread sheet and summing them? Unfortunately most pdfs will not import tables cleanly into most spreadsheets but I have resorted to entering the numbers by hand (individually cut and paste) to check. Only once have I discovered a bank error and they were most apologetic. David Cousens On Mon, 2022-04-11 at 16:09 -0700, Rich Shepard wrote: > On Mon, 11 Apr 2022, Gyle McCollam wrote: > > > These may not apply, but check that your reconciliation date is the same > > as the bank's. Also, check the dates of the transactions as GC shows > > transaction past the reconciliation date, that you don't want to > > reconcile. The ending balance that GC shows for the reconciliation can be > > changed, so put in the bank's balance and see if you get a zero > > difference. > > Gyle, > > I check both the reconciliation date and that date's balance. There are > discrepancies between the purchase date entered in GnuCash and when the > transaction cleared the bank but those are immaterial. > > As an aside, I've used GnuCash for more than two decades, starting in 1997. > These large, sporatic discrepancies appeared only a few years ago, long > after I moved my business and personal accounts to my current bank. I did > catch the bank several years ago for charging me twice for the same Amazon > purchase and my banker had that quickly fixed. That was the only obvious > error I've seen. > > Thanks, > > Rich > ___ > 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] Reconciliation discrepancies
On Mon, 11 Apr 2022, Gyle McCollam wrote: These may not apply, but check that your reconciliation date is the same as the bank's. Also, check the dates of the transactions as GC shows transaction past the reconciliation date, that you don't want to reconcile. The ending balance that GC shows for the reconciliation can be changed, so put in the bank's balance and see if you get a zero difference. Gyle, I check both the reconciliation date and that date's balance. There are discrepancies between the purchase date entered in GnuCash and when the transaction cleared the bank but those are immaterial. As an aside, I've used GnuCash for more than two decades, starting in 1997. These large, sporatic discrepancies appeared only a few years ago, long after I moved my business and personal accounts to my current bank. I did catch the bank several years ago for charging me twice for the same Amazon purchase and my banker had that quickly fixed. That was the only obvious error I've seen. Thanks, Rich ___ 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] Reconciliation discrepancies
On Mon, 11 Apr 2022, Dan Black wrote: It is possible that you transposed two digits that you may not notice. Dan, I compare each transaction and haven't yet seen one with transposed digits. Thanks for the suggestion, Rich ___ 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] Reconciliation discrepancies
These may not apply, but check that your reconciliation date is the same as the bank's. Also, check the dates of the transactions as GC shows transaction past the reconciliation date, that you don't want to reconcile. The ending balance that GC shows for the reconciliation can be changed, so put in the bank's balance and see if you get a zero difference. Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of Rich Shepard Sent: Monday, April 11, 2022 6:32 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Reconciliation discrepancies On Mon, 11 Apr 2022, Ed Reeder wrote: > When that happens to me I will discover that I entered a transaction > incorrectly. I would check each GC transaction against the banks. Ed, That's what I do. As I wrote, they all match. Thanks, Rich ___ 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] Reconciliation discrepancies
It is possible that you transposed two digits that you may not notice. Try downloading an ofx or csv file and try importing it. Let the computer do the comparing for you. On April 11, 2022 6:33:15 PM Rich Shepard wrote: On Mon, 11 Apr 2022, Ed Reeder wrote: When that happens to me I will discover that I entered a transaction incorrectly. I would check each GC transaction against the banks. Ed, That's what I do. As I wrote, they all match. Thanks, Rich ___ 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] Reconciliation discrepancies
On Mon, 11 Apr 2022, Ed Reeder wrote: When that happens to me I will discover that I entered a transaction incorrectly. I would check each GC transaction against the banks. Ed, That's what I do. As I wrote, they all match. Thanks, Rich ___ 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] Reconciliation discrepancies
When that happens to me I will discover that I entered a transaction incorrectly. I would check each GC transaction against the banks. On Mon, Apr 11, 2022, at 2:36 PM, Rich Shepard wrote: > Every now and then one of my bank accounts doesn't reconcile because what > the bank shows differs from what GnuCash shows. The amounts are significant. > What puzzles me is that the previous month's balances (bank and GC) match > and so do all the transactions. But, the end of month balances don't match. > > Many decades ago a penny or two difference when reconciling a bank account > was common; I assume due to rounding errors. But why it is now more common > (but sporatic) puzzles both me and my banker. We've gone over the > transactions shown by the bank and by GC and neither of us can explain the > discrepancies. > > Has anyone an idea of why this happens? > > Rich > ___ > 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.
[GNC] Reconciliation discrepancies
Every now and then one of my bank accounts doesn't reconcile because what the bank shows differs from what GnuCash shows. The amounts are significant. What puzzles me is that the previous month's balances (bank and GC) match and so do all the transactions. But, the end of month balances don't match. Many decades ago a penny or two difference when reconciling a bank account was common; I assume due to rounding errors. But why it is now more common (but sporatic) puzzles both me and my banker. We've gone over the transactions shown by the bank and by GC and neither of us can explain the discrepancies. Has anyone an idea of why this happens? Rich ___ 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.