Re: [GNC] Reconciliation of accounts is not permanent
Mark, I posted my comment about suggested date too soon. I forgot it is a preference. Regards, Adrien On 9/28/23 9:46 AM, Mark Truelove wrote: Hi, I just wanted to say wow, Gnucash has never suggested today as the reconciliation date for me. It is typically 30 days/a month after the last reconciled date, which I then need to adjust to the statement date about half the time (if it's a day or two off). I can't remember it ever not being that way. Just an observation, not really relevant to my problem. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 of accounts is not permanent
Hi, I just wanted to say wow, Gnucash has never suggested today as the reconciliation date for me. It is typically 30 days/a month after the last reconciled date, which I then need to adjust to the statement date about half the time (if it's a day or two off). I can't remember it ever not being that way. Just an observation, not really relevant to my problem. On Wed, Sep 27, 2023 at 8:20 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Good catch. But that would imply some serious mass editing on the part > of the OP to clear the reconcile flag. (and most likely dimissing the > warning during those edits) > > Neither is out of the question, but either or both would be rare for the > OP to not remember doing so. > > Regards, > Adrien > > On 9/27/23 3:53 PM, John Layman via gnucash-user wrote: > > I can assure you that GnuCash reconciliations 'stick'. I very rarely > encounter a discrepancy in the opening balance of a bank or credit card > account. When I do, there is always a data-related explanation to account > for it. It is not related to a software bug or quirk. Any transaction > mistakenly backdated or inadvertently deleted may throw those balance > figures off, but it's your error, not the software. The software does not > 'lock' reconciled accounts such that you are prevented from making the sort > of inadvertent goof that inserts or deletes a transaction prior to the date > of the previous reconciliation. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - 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 of accounts is not permanent
OK, that explains the difference in behaviour that I'm seeing to what you're seeing. I have Preferences > Register > Reconciling > 'Always reconcile to today' unchecked. Peter On 28/9/2023 11:04, Adrien Monteleone wrote: It seems I forgot that is influenced by: Preferences > Register > Reconciling > 'Always reconcile to today'. Apologies. Regards, Adrien On 9/27/23 7:22 PM, Adrien Monteleone wrote: On the contrary, GnuCash has *always* as far as I can recall after over a decade, suggested today's date for the closing date. I don't ever remember it suggesting a date in the past. And when I tested this last night on an account I know I haven't reconciled in over a year (yes, I'm behind in duties) it suggested yesterday's date, not something over a year old. Is your System date correct? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - 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 of accounts is not permanent
On 28/9/2023 10:22, Adrien Monteleone wrote: On the contrary, GnuCash has *always* as far as I can recall after over a decade, suggested today's date for the closing date. I don't ever remember it suggesting a date in the past. When I do reconciliations, the default statement date is one calendar month after the previous statement date. Once it has aligned to the date of a statement, it continues using that date for me. It works that way for statements like my bank statement, which is dated as the last day of the month and also for one of my credit card statements, where the statement date is near the middle of the month. Our statements are still snail-mailed, so when I do the reconciliation the statement date and the default statement date. However, if I start a reconciliation on one of those counts before the next due statement date, the suggested statement date is the current date. All of that works very well for me. And when I tested this last night on an account I know I haven't reconciled in over a year (yes, I'm behind in duties) it suggested yesterday's date, not something over a year old If I miss the reconciliation of a statement, when reconcile the first one, it offers the date of the missed statement, and once that's been reconciled, it offers the date of the next statement. If I start a reconciliation on a register that has never been reconciled, then the statement date defaults to the current date. Peter ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 of accounts is not permanent
It seems I forgot that is influenced by: Preferences > Register > Reconciling > 'Always reconcile to today'. Apologies. Regards, Adrien On 9/27/23 7:22 PM, Adrien Monteleone wrote: On the contrary, GnuCash has *always* as far as I can recall after over a decade, suggested today's date for the closing date. I don't ever remember it suggesting a date in the past. And when I tested this last night on an account I know I haven't reconciled in over a year (yes, I'm behind in duties) it suggested yesterday's date, not something over a year old. Is your System date correct? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 of accounts is not permanent
On 9/27/23 10:47 AM, Mark Truelove wrote: Hi again. Besides my tendency to be details-specific (given my professional background), I also had some college level accounting and understand double-entry, reconciliation, and the basics. No, I am not an accountant, but I have been using GnuCash mostly successfully for more than twelve years now. I am new to this list, but not to the topics we're discussing. Fair enough, thanks for the clarification. Regarding using the wrong year for the reconciliation date, the program suggests an approximate date based on the last, and at the moment that recommendation is 9/24/22. This is not in a vacuum, however, because all of the unreconciled transactions between August '22 and present are still in the ledger awaiting reconciliation against these 12 or so monthly statements that I just re-downloaded. If I'd simply entered the wrong year, this would not be the case. On the contrary, GnuCash has *always* as far as I can recall after over a decade, suggested today's date for the closing date. I don't ever remember it suggesting a date in the past. And when I tested this last night on an account I know I haven't reconciled in over a year (yes, I'm behind in duties) it suggested yesterday's date, not something over a year old. Is your System date correct? Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 of accounts is not permanent
Good catch. But that would imply some serious mass editing on the part of the OP to clear the reconcile flag. (and most likely dimissing the warning during those edits) Neither is out of the question, but either or both would be rare for the OP to not remember doing so. Regards, Adrien On 9/27/23 3:53 PM, John Layman via gnucash-user wrote: I can assure you that GnuCash reconciliations 'stick'. I very rarely encounter a discrepancy in the opening balance of a bank or credit card account. When I do, there is always a data-related explanation to account for it. It is not related to a software bug or quirk. Any transaction mistakenly backdated or inadvertently deleted may throw those balance figures off, but it's your error, not the software. The software does not 'lock' reconciled accounts such that you are prevented from making the sort of inadvertent goof that inserts or deletes a transaction prior to the date of the previous reconciliation. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 of accounts is not permanent
Hi David, long in the past I probably reconciled multiple accounts in one session without thinking about it, but after the first incident I started saving after I reconcile each statement. This is the third time this has occurred over about 5 years, prompting me to reach out about it instead of just catching up all the lost reconciliations as I did in the past. Consider that while I'm reconciling without issue across several accounts each month (or maybe up to three, admittedly, for inactive accounts), that the glitch when it appears takes me back several months or a year, over which I definitely did not skip saving my activities. I also handle basic activities (paying bills) twice a month, saving of course as I go. My ledger is currently up to date with no lost transactions, it's only the reconciliation of those accounts that has been forgotten. Besides the main credit card account I mentioned earlier, I have another whose recommended reconciliation date fell back to 8/18/2021. I'm holding off on new activity for now for the sake of this conversation. I'll take this to the next level and open a ticket to see if it goes anywhere. Thanks. On Wed, Sep 27, 2023 at 1:27 PM David Carlson wrote: > Mark, > > From this side of the Internet it almost appears that you are forgetting > to save the data file after reconciling, but always remembering to save > other times, which is not very likely. > > Have you tried breaking down your procedure and inserting cross-checks? > > ie, just before starting a reconciliation, save the file, then reconcile > one month, save the file, review the reconcile box of the freshly > reconciled transactions to verify that they are still reconciled on the > correct reconcile date, save again, rinse and repeat as needed? > > I just tried the reconciliation report for the first time and found that > it shows mountains of information about reconciliation status down to split > details when they exist, so that may help you too. > > If, as I suspect, you do indeed discover that some reconciliations are not > being properly recorded in your file, please both let us know here and also > file a bug report. > > On Wed, Sep 27, 2023, 10:49 AM Mark Truelove wrote: > >> Hi again. Besides my tendency to be details-specific (given my >> professional >> background), I also had some college level accounting and understand >> double-entry, reconciliation, and the basics. No, I am not an accountant, >> but I have been using GnuCash mostly successfully for more than twelve >> years now. I am new to this list, but not to the topics we're discussing. >> >> Regarding using the wrong year for the reconciliation date, the program >> suggests an approximate date based on the last, and at the moment that >> recommendation is 9/24/22. This is not in a vacuum, however, because all >> of the unreconciled transactions between August '22 and present are still >> in the ledger awaiting reconciliation against these 12 or so monthly >> statements that I just re-downloaded. If I'd simply entered the wrong >> year, this would not be the case. >> >> I'd hoped this would have been something familiar to someone, only that I >> didn't know about because I hadn't been on the list previously. Based on >> the responses, it's beginning to look a little obscure now. >> >> On Wed, Sep 27, 2023 at 10:52 AM Michael or Penny Novack < >> stepbystepf...@comcast.net> wrote: >> >> > >> > >> > > The purpose of reconciliation is to verify that from the last closing >> > > date to the new closing date, the listed transactions cleared the >> > > account and thus explain the change from the opening balance (last >> > > closing balance) to the new closing balance listed on the statement. >> > > >> > > The actual balance, in your books, on a given day, or as of a given >> > > day, is irrelevant to that reconciliation. >> > >> > >> > Precisely. You EXPECT there to be a difference based on checks written >> > (appear in the gnucash account) that have not yet cleared. In other >> > words, the main part of the job (if no errors) is to verify that the >> > total of checks written but uncleared matches the difference between the >> > bank statement of the account and the gnucash account as of the date of >> > the statement. >> > >> > When it still doesn't match you then need to find the error, a check not >> > entered for the correct amount. Usually at your end but once I had one >> > of these at a bank end. >> > >> > Michael D Novack >> > >> > ___ >> > gnucash-user mailing list >> > gnucash-user@gnucash.org >> > To update your subscription preferences or to unsubscribe: >> > https://lists.gnucash.org/mailman/listinfo/gnucash-user >> > - >> > 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 subscrip
Re: [GNC] Reconciliation of accounts is not permanent
I can assure you that GnuCash reconciliations 'stick'. I very rarely encounter a discrepancy in the opening balance of a bank or credit card account. When I do, there is always a data-related explanation to account for it. It is not related to a software bug or quirk. Any transaction mistakenly backdated or inadvertently deleted may throw those balance figures off, but it's your error, not the software. The software does not 'lock' reconciled accounts such that you are prevented from making the sort of inadvertent goof that inserts or deletes a transaction prior to the date of the previous reconciliation. -Original Message- From: gnucash-user On Behalf Of Mark Truelove Sent: Wednesday, September 27, 2023 11:48 AM To: stepbystepf...@comcast.net Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Reconciliation of accounts is not permanent Hi again. Besides my tendency to be details-specific (given my professional background), I also had some college level accounting and understand double-entry, reconciliation, and the basics. No, I am not an accountant, but I have been using GnuCash mostly successfully for more than twelve years now. I am new to this list, but not to the topics we're discussing. Regarding using the wrong year for the reconciliation date, the program suggests an approximate date based on the last, and at the moment that recommendation is 9/24/22. This is not in a vacuum, however, because all of the unreconciled transactions between August '22 and present are still in the ledger awaiting reconciliation against these 12 or so monthly statements that I just re-downloaded. If I'd simply entered the wrong year, this would not be the case. I'd hoped this would have been something familiar to someone, only that I didn't know about because I hadn't been on the list previously. Based on the responses, it's beginning to look a little obscure now. On Wed, Sep 27, 2023 at 10:52 AM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > > > > The purpose of reconciliation is to verify that from the last > > closing date to the new closing date, the listed transactions > > cleared the account and thus explain the change from the opening > > balance (last closing balance) to the new closing balance listed on the > > statement. > > > > The actual balance, in your books, on a given day, or as of a given > > day, is irrelevant to that reconciliation. > > > Precisely. You EXPECT there to be a difference based on checks written > (appear in the gnucash account) that have not yet cleared. In other > words, the main part of the job (if no errors) is to verify that the > total of checks written but uncleared matches the difference between > the bank statement of the account and the gnucash account as of the > date of the statement. > > When it still doesn't match you then need to find the error, a check > not entered for the correct amount. Usually at your end but once I had > one of these at a bank end. > > Michael D Novack > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - 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 - 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 of accounts is not permanent
Mark, The reconciliation has been working well in GnuCash for 10-12 years that I have been using GnuCash, currently 5.4 on Linux and bugs in it are usually picked up pretty quickly as nearly everyone will be using it. I have just entered six months of OFX files and reconciled them to the EOFY with no problems. Half of that was done with 5.3 then I shifted to 5.4. AFAIK the code for reconciliation between OS's will mainly be the graphic library changes and the core code will be largely common. Problems I have encountered have been missing entries, doubled up entries (usually from trying to fix the reconciliation in another account), wrong dates on manually entered data (entering year in format not yy in the register), mismatches of dates between the banks records and mine, transaction which should have had a split to the account being assigned to another account (sometimes happens with transfers between asset accounts which can be assigned to an expense account by the matching procedures on import - I check them but occasionally miss one) instead of the asset account it is going to). I don't use checks/cheques now but when I did the problems Michael Novack mentioned were on the list. Good luck and good hunting. David Cousens On Wed, 2023-09-27 at 11:47 -0400, Mark Truelove wrote: > Hi again. Besides my tendency to be details-specific (given my professional > background), I also had some college level accounting and understand > double-entry, reconciliation, and the basics. No, I am not an accountant, > but I have been using GnuCash mostly successfully for more than twelve > years now. I am new to this list, but not to the topics we're discussing. > > Regarding using the wrong year for the reconciliation date, the program > suggests an approximate date based on the last, and at the moment that > recommendation is 9/24/22. This is not in a vacuum, however, because all > of the unreconciled transactions between August '22 and present are still > in the ledger awaiting reconciliation against these 12 or so monthly > statements that I just re-downloaded. If I'd simply entered the wrong > year, this would not be the case. > > I'd hoped this would have been something familiar to someone, only that I > didn't know about because I hadn't been on the list previously. Based on > the responses, it's beginning to look a little obscure now. > > On Wed, Sep 27, 2023 at 10:52 AM Michael or Penny Novack < > stepbystepf...@comcast.net> wrote: > > > > > > > > The purpose of reconciliation is to verify that from the last closing > > > date to the new closing date, the listed transactions cleared the > > > account and thus explain the change from the opening balance (last > > > closing balance) to the new closing balance listed on the statement. > > > > > > The actual balance, in your books, on a given day, or as of a given > > > day, is irrelevant to that reconciliation. > > > > > > Precisely. You EXPECT there to be a difference based on checks written > > (appear in the gnucash account) that have not yet cleared. In other > > words, the main part of the job (if no errors) is to verify that the > > total of checks written but uncleared matches the difference between the > > bank statement of the account and the gnucash account as of the date of > > the statement. > > > > When it still doesn't match you then need to find the error, a check not > > entered for the correct amount. Usually at your end but once I had one > > of these at a bank end. > > > > Michael D Novack > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > 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 > - > 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 - 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 of accounts is not permanent
Mark, From this side of the Internet it almost appears that you are forgetting to save the data file after reconciling, but always remembering to save other times, which is not very likely. Have you tried breaking down your procedure and inserting cross-checks? ie, just before starting a reconciliation, save the file, then reconcile one month, save the file, review the reconcile box of the freshly reconciled transactions to verify that they are still reconciled on the correct reconcile date, save again, rinse and repeat as needed? I just tried the reconciliation report for the first time and found that it shows mountains of information about reconciliation status down to split details when they exist, so that may help you too. If, as I suspect, you do indeed discover that some reconciliations are not being properly recorded in your file, please both let us know here and also file a bug report. On Wed, Sep 27, 2023, 10:49 AM Mark Truelove wrote: > Hi again. Besides my tendency to be details-specific (given my professional > background), I also had some college level accounting and understand > double-entry, reconciliation, and the basics. No, I am not an accountant, > but I have been using GnuCash mostly successfully for more than twelve > years now. I am new to this list, but not to the topics we're discussing. > > Regarding using the wrong year for the reconciliation date, the program > suggests an approximate date based on the last, and at the moment that > recommendation is 9/24/22. This is not in a vacuum, however, because all > of the unreconciled transactions between August '22 and present are still > in the ledger awaiting reconciliation against these 12 or so monthly > statements that I just re-downloaded. If I'd simply entered the wrong > year, this would not be the case. > > I'd hoped this would have been something familiar to someone, only that I > didn't know about because I hadn't been on the list previously. Based on > the responses, it's beginning to look a little obscure now. > > On Wed, Sep 27, 2023 at 10:52 AM Michael or Penny Novack < > stepbystepf...@comcast.net> wrote: > > > > > > > > The purpose of reconciliation is to verify that from the last closing > > > date to the new closing date, the listed transactions cleared the > > > account and thus explain the change from the opening balance (last > > > closing balance) to the new closing balance listed on the statement. > > > > > > The actual balance, in your books, on a given day, or as of a given > > > day, is irrelevant to that reconciliation. > > > > > > Precisely. You EXPECT there to be a difference based on checks written > > (appear in the gnucash account) that have not yet cleared. In other > > words, the main part of the job (if no errors) is to verify that the > > total of checks written but uncleared matches the difference between the > > bank statement of the account and the gnucash account as of the date of > > the statement. > > > > When it still doesn't match you then need to find the error, a check not > > entered for the correct amount. Usually at your end but once I had one > > of these at a bank end. > > > > Michael D Novack > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > 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 > - > 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 - 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 of accounts is not permanent
Hi again. Besides my tendency to be details-specific (given my professional background), I also had some college level accounting and understand double-entry, reconciliation, and the basics. No, I am not an accountant, but I have been using GnuCash mostly successfully for more than twelve years now. I am new to this list, but not to the topics we're discussing. Regarding using the wrong year for the reconciliation date, the program suggests an approximate date based on the last, and at the moment that recommendation is 9/24/22. This is not in a vacuum, however, because all of the unreconciled transactions between August '22 and present are still in the ledger awaiting reconciliation against these 12 or so monthly statements that I just re-downloaded. If I'd simply entered the wrong year, this would not be the case. I'd hoped this would have been something familiar to someone, only that I didn't know about because I hadn't been on the list previously. Based on the responses, it's beginning to look a little obscure now. On Wed, Sep 27, 2023 at 10:52 AM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > > > > The purpose of reconciliation is to verify that from the last closing > > date to the new closing date, the listed transactions cleared the > > account and thus explain the change from the opening balance (last > > closing balance) to the new closing balance listed on the statement. > > > > The actual balance, in your books, on a given day, or as of a given > > day, is irrelevant to that reconciliation. > > > Precisely. You EXPECT there to be a difference based on checks written > (appear in the gnucash account) that have not yet cleared. In other > words, the main part of the job (if no errors) is to verify that the > total of checks written but uncleared matches the difference between the > bank statement of the account and the gnucash account as of the date of > the statement. > > When it still doesn't match you then need to find the error, a check not > entered for the correct amount. Usually at your end but once I had one > of these at a bank end. > > Michael D Novack > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - 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 of accounts is not permanent
The purpose of reconciliation is to verify that from the last closing date to the new closing date, the listed transactions cleared the account and thus explain the change from the opening balance (last closing balance) to the new closing balance listed on the statement. The actual balance, in your books, on a given day, or as of a given day, is irrelevant to that reconciliation. Precisely. You EXPECT there to be a difference based on checks written (appear in the gnucash account) that have not yet cleared. In other words, the main part of the job (if no errors) is to verify that the total of checks written but uncleared matches the difference between the bank statement of the account and the gnucash account as of the date of the statement. When it still doesn't match you then need to find the error, a check not entered for the correct amount. Usually at your end but once I had one of these at a bank end. Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 of accounts is not permanent
Unless you never enter a transaction after a reconciliation that is dated before that last closing date, *and* you never have any transactions that aren't reconciled at each and every reconciliation (that is, some that haven't cleared the institution yet, but are in your books) then you will likely never see the suggested Opening Balance match the presumed 'opening date' on the day you attempt reconciliation. (the 'opening date' is not shown or listed, as it isn't relevant, only the closing date is.) For that matter, the account balance as of a closing date isn't likely to match the statement closing balance for reconciliation if any transactions haven't cleared yet. The purpose of reconciliation is to verify that from the last closing date to the new closing date, the listed transactions cleared the account and thus explain the change from the opening balance (last closing balance) to the new closing balance listed on the statement. The actual balance, in your books, on a given day, or as of a given day, is irrelevant to that reconciliation. - Now, how are you *certain* that those reconciliations didn't happen and that there is no record of them? Run a Reconciliation Report and select a desired account. Set the date to say, 1/1/22 and the end date to 'today'. Leave all other defaults. You'll get a report showing transactions and their dates, sorted by Reconciled status with Reconciled first. (followed by Cleared and then Unreconciled) Look that over carefully. If you have blocks of transactions with a reconciled date before they allegedly occurred in real life (the transaction date)—e.g, you had transactions from May '23, reconciled to perhaps May '22, then it is quite possible you had the wrong year on your closing date dialog when you thought you were performing the May '23 reconciliation. If you know for a fact you did, say a May '23 reconciliation, and those transactions all show in either the Cleared or Unreconciled section of the report, then yeah, you have a problem. But the fact that you have backup files also with no evidence of these reconciliations is extremely odd. (it isn't like GnuCash is going to edit or trash data in multiple files at one time) Regards, Adrien On 9/26/23 11:05 AM, Mark Truelove wrote: Hi all, I just joined the list. I thought I'd give this a try before moving to a bug report, because I can't believe this happens to me and no one else has experienced it. I did try searching list history as suggested with google, but didn't find anything referring to this specifically. Also, this is not the first time experiencing this phenomenon, probably the third. I use gnucash for personal finances, so I have a checking or cash account and a number of credit card accounts. All of these are reconciled several times a year as I receive statements, although not always on time every month. However I don't go three months without catching up on all my accounts in any case. Today (and on previous occasions), I started my periodic reconciliations because I had statement notifications in email. I opened my credit card to reconcile and had the month's statement in a browser window. At first I was unable to match the "beginning of month" figures to fill out the small prompt window when reconciling. After a few glances I realized that it was trying to match the beginning balance to September of LAST YEAR instead of last month. I have reconciled this account to its statements 9 or10 times in the last year, including last month. In previous months, I reconciled this account and saved it normally, and that information was retained for the following months' reconciliations. Now when it forgets, it is losing/ignoring several months of previous reconciliations, but not all of them (since this account is at least 20 years old). When I checked them all, it has forgotten reconciliation data for three other accounts as well (while another six accounts in the same file are fully up-to date). I have backups of my files, both through GC's own backup system and my own rotating backups. Loss of data files is not an issue here. This got me thinking, and I went back and reloaded some of these backup files directly. When loaded, they are all missing the same information as my current file. So, one could say, user error - he actually didn't reconcile for months, and the files show that. Unfortunately, I DID reconcile all of these accounts, and the program is treating some aspect of the data as if it doesn't exist beyond that point, regardless of the source file. I'm a retired IT pro, an IT Manager and other roles over 40 years. I know how this looks at first glance. If this hadn't happened to me twice previously I wouldn't be taking the time to report this in detail today. I'm currently running v5.3. I downloaded 5.4 but haven't upgraded yet bc I didn't want to compound the problem. If this is a known issue and 5.4 fixes it, then great, I'l
Re: [GNC] Reconciliation of accounts is not permanent
On Tue, Sep 26, 2023 at 11:06 AM Mark Truelove wrote: > Hi all, I just joined the list. I thought I'd give this a try before moving > to a bug report, because I can't believe this happens to me and no one else > has experienced it. > > Today (and on previous occasions), I started my periodic reconciliations > because I had statement notifications in email. I opened my credit card to > reconcile and had the month's statement in a browser window. At first I > was unable to match the "beginning of month" figures to fill out the small > prompt window when reconciling. After a few glances I realized that it was > trying to match the beginning balance to September of LAST YEAR instead of > last month. I have reconciled this account to its statements 9 or10 times > in the last year, including last month. > First of all, welcome. Just for a data point, I've been using GnuCash 5.3 and have had no such issues with reconciliation. I always open GnuCash by clicking on the GnuCash application, never on a data file. I actually run GC on both an iMac and on Windows (the data file is on a shared network device). I have a Linux box (Ubuntu 22) with an older version of GC, but I don't run it there very often. I thought I saw something like this happen when I was getting online stock quotes... it **COULD** be that the stock quotes programs doesn't look for the LCK file and over-wrote my data entries, but I didn't think I did this. It's the closest I can come to your situation. _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 of accounts is not permanent
Hi, thanks, I'm certain I didn't add anything after the fact. On Tue, Sep 26, 2023 at 12:40 PM Jediator wrote: > Did you perhaps modified/added/deleted transactions after > reconciliation? Any changes could easily break your reconciled > balance. This is typical in a double-entry system: you changed one > account and didn't realized it affected the balance of another. I guess > the only way to make the reconciliation permanent in GC would be to > reset your accounting period in settings after recon, so to prevent any > changes to transactions before your the end date.. Hope this helps. > Cheers! -- JC > > On 9/26/23 12:05 PM, Mark Truelove wrote: > > Hi all, I just joined the list. I thought I'd give this a try before > moving > > to a bug report, because I can't believe this happens to me and no one > else > > has experienced it. I did try searching list history as suggested with > > google, but didn't find anything referring to this specifically. > > > > Also, this is not the first time experiencing this phenomenon, probably > the > > third. > > > > I use gnucash for personal finances, so I have a checking or cash account > > and a number of credit card accounts. All of these are reconciled > several > > times a year as I receive statements, although not always on time every > > month. However I don't go three months without catching up on all my > > accounts in any case. > > > > Today (and on previous occasions), I started my periodic reconciliations > > because I had statement notifications in email. I opened my credit card > to > > reconcile and had the month's statement in a browser window. At first I > > was unable to match the "beginning of month" figures to fill out the > small > > prompt window when reconciling. After a few glances I realized that it > was > > trying to match the beginning balance to September of LAST YEAR instead > of > > last month. I have reconciled this account to its statements 9 or10 > times > > in the last year, including last month. > > > > In previous months, I reconciled this account and saved it normally, and > > that information was retained for the following months' reconciliations. > > Now when it forgets, it is losing/ignoring several months of previous > > reconciliations, but not all of them (since this account is at least 20 > > years old). When I checked them all, it has forgotten reconciliation > data > > for three other accounts as well (while another six accounts in the same > > file are fully up-to date). > > > > I have backups of my files, both through GC's own backup system and my > own > > rotating backups. Loss of data files is not an issue here. This got me > > thinking, and I went back and reloaded some of these backup files > > directly. When loaded, they are all missing the same information as my > > current file. > > > > So, one could say, user error - he actually didn't reconcile for months, > > and the files show that. Unfortunately, I DID reconcile all of these > > accounts, and the program is treating some aspect of the data as if it > > doesn't exist beyond that point, regardless of the source file. > > > > I'm a retired IT pro, an IT Manager and other roles over 40 years. I > know > > how this looks at first glance. If this hadn't happened to me twice > > previously I wouldn't be taking the time to report this in detail today. > > > > I'm currently running v5.3. I downloaded 5.4 but haven't upgraded yet > bc I > > didn't want to compound the problem. If this is a known issue and 5.4 > > fixes it, then great, I'll just upgrade. > > > > I hope this scenario seems familiar to one of the users out there. > > > > __ > > > > *Mark Truelove*true9...@gmail.com > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > 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 > - > 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 - 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 of accounts is not permanent
Hi, sorry, this is running on Windows 10 22H2. On Tue, Sep 26, 2023 at 12:16 PM Derek Atkins wrote: > HI, > > One piece of data you don't provide: what OS/Distro are you using? > > For example, if you are on a Mac, there is a known behavior that GnuCash > on Mac ALWAYS opens the last-used gnucash file, regardless of how you open > it. Even if you double-click on a GnuCash data file, GnuCash on Mac will > still open the LAST USED file, not the one you clicked on. > > This behavior has caused many people to think there's a data issue. > > -derek > > On Tue, September 26, 2023 12:05 pm, Mark Truelove wrote: > > Hi all, I just joined the list. I thought I'd give this a try before > > moving > > to a bug report, because I can't believe this happens to me and no one > > else > > has experienced it. I did try searching list history as suggested with > > google, but didn't find anything referring to this specifically. > > > > Also, this is not the first time experiencing this phenomenon, probably > > the > > third. > > > > I use gnucash for personal finances, so I have a checking or cash account > > and a number of credit card accounts. All of these are reconciled > several > > times a year as I receive statements, although not always on time every > > month. However I don't go three months without catching up on all my > > accounts in any case. > > > > Today (and on previous occasions), I started my periodic reconciliations > > because I had statement notifications in email. I opened my credit card > > to > > reconcile and had the month's statement in a browser window. At first I > > was unable to match the "beginning of month" figures to fill out the > small > > prompt window when reconciling. After a few glances I realized that it > > was > > trying to match the beginning balance to September of LAST YEAR instead > of > > last month. I have reconciled this account to its statements 9 or10 > times > > in the last year, including last month. > > > > In previous months, I reconciled this account and saved it normally, and > > that information was retained for the following months' reconciliations. > > Now when it forgets, it is losing/ignoring several months of previous > > reconciliations, but not all of them (since this account is at least 20 > > years old). When I checked them all, it has forgotten reconciliation > data > > for three other accounts as well (while another six accounts in the same > > file are fully up-to date). > > > > I have backups of my files, both through GC's own backup system and my > own > > rotating backups. Loss of data files is not an issue here. This got me > > thinking, and I went back and reloaded some of these backup files > > directly. When loaded, they are all missing the same information as my > > current file. > > > > So, one could say, user error - he actually didn't reconcile for months, > > and the files show that. Unfortunately, I DID reconcile all of these > > accounts, and the program is treating some aspect of the data as if it > > doesn't exist beyond that point, regardless of the source file. > > > > I'm a retired IT pro, an IT Manager and other roles over 40 years. I > know > > how this looks at first glance. If this hadn't happened to me twice > > previously I wouldn't be taking the time to report this in detail today. > > > > I'm currently running v5.3. I downloaded 5.4 but haven't upgraded yet bc > > I > > didn't want to compound the problem. If this is a known issue and 5.4 > > fixes it, then great, I'll just upgrade. > > > > I hope this scenario seems familiar to one of the users out there. > > > > __ > > > > *Mark Truelove*true9...@gmail.com > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > > > -- >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 - 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 of accounts is not permanent
Did you perhaps modified/added/deleted transactions after reconciliation? Any changes could easily break your reconciled balance. This is typical in a double-entry system: you changed one account and didn't realized it affected the balance of another. I guess the only way to make the reconciliation permanent in GC would be to reset your accounting period in settings after recon, so to prevent any changes to transactions before your the end date.. Hope this helps. Cheers! -- JC On 9/26/23 12:05 PM, Mark Truelove wrote: Hi all, I just joined the list. I thought I'd give this a try before moving to a bug report, because I can't believe this happens to me and no one else has experienced it. I did try searching list history as suggested with google, but didn't find anything referring to this specifically. Also, this is not the first time experiencing this phenomenon, probably the third. I use gnucash for personal finances, so I have a checking or cash account and a number of credit card accounts. All of these are reconciled several times a year as I receive statements, although not always on time every month. However I don't go three months without catching up on all my accounts in any case. Today (and on previous occasions), I started my periodic reconciliations because I had statement notifications in email. I opened my credit card to reconcile and had the month's statement in a browser window. At first I was unable to match the "beginning of month" figures to fill out the small prompt window when reconciling. After a few glances I realized that it was trying to match the beginning balance to September of LAST YEAR instead of last month. I have reconciled this account to its statements 9 or10 times in the last year, including last month. In previous months, I reconciled this account and saved it normally, and that information was retained for the following months' reconciliations. Now when it forgets, it is losing/ignoring several months of previous reconciliations, but not all of them (since this account is at least 20 years old). When I checked them all, it has forgotten reconciliation data for three other accounts as well (while another six accounts in the same file are fully up-to date). I have backups of my files, both through GC's own backup system and my own rotating backups. Loss of data files is not an issue here. This got me thinking, and I went back and reloaded some of these backup files directly. When loaded, they are all missing the same information as my current file. So, one could say, user error - he actually didn't reconcile for months, and the files show that. Unfortunately, I DID reconcile all of these accounts, and the program is treating some aspect of the data as if it doesn't exist beyond that point, regardless of the source file. I'm a retired IT pro, an IT Manager and other roles over 40 years. I know how this looks at first glance. If this hadn't happened to me twice previously I wouldn't be taking the time to report this in detail today. I'm currently running v5.3. I downloaded 5.4 but haven't upgraded yet bc I didn't want to compound the problem. If this is a known issue and 5.4 fixes it, then great, I'll just upgrade. I hope this scenario seems familiar to one of the users out there. __ *Mark Truelove*true9...@gmail.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - 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 of accounts is not permanent
HI, One piece of data you don't provide: what OS/Distro are you using? For example, if you are on a Mac, there is a known behavior that GnuCash on Mac ALWAYS opens the last-used gnucash file, regardless of how you open it. Even if you double-click on a GnuCash data file, GnuCash on Mac will still open the LAST USED file, not the one you clicked on. This behavior has caused many people to think there's a data issue. -derek On Tue, September 26, 2023 12:05 pm, Mark Truelove wrote: > Hi all, I just joined the list. I thought I'd give this a try before > moving > to a bug report, because I can't believe this happens to me and no one > else > has experienced it. I did try searching list history as suggested with > google, but didn't find anything referring to this specifically. > > Also, this is not the first time experiencing this phenomenon, probably > the > third. > > I use gnucash for personal finances, so I have a checking or cash account > and a number of credit card accounts. All of these are reconciled several > times a year as I receive statements, although not always on time every > month. However I don't go three months without catching up on all my > accounts in any case. > > Today (and on previous occasions), I started my periodic reconciliations > because I had statement notifications in email. I opened my credit card > to > reconcile and had the month's statement in a browser window. At first I > was unable to match the "beginning of month" figures to fill out the small > prompt window when reconciling. After a few glances I realized that it > was > trying to match the beginning balance to September of LAST YEAR instead of > last month. I have reconciled this account to its statements 9 or10 times > in the last year, including last month. > > In previous months, I reconciled this account and saved it normally, and > that information was retained for the following months' reconciliations. > Now when it forgets, it is losing/ignoring several months of previous > reconciliations, but not all of them (since this account is at least 20 > years old). When I checked them all, it has forgotten reconciliation data > for three other accounts as well (while another six accounts in the same > file are fully up-to date). > > I have backups of my files, both through GC's own backup system and my own > rotating backups. Loss of data files is not an issue here. This got me > thinking, and I went back and reloaded some of these backup files > directly. When loaded, they are all missing the same information as my > current file. > > So, one could say, user error - he actually didn't reconcile for months, > and the files show that. Unfortunately, I DID reconcile all of these > accounts, and the program is treating some aspect of the data as if it > doesn't exist beyond that point, regardless of the source file. > > I'm a retired IT pro, an IT Manager and other roles over 40 years. I know > how this looks at first glance. If this hadn't happened to me twice > previously I wouldn't be taking the time to report this in detail today. > > I'm currently running v5.3. I downloaded 5.4 but haven't upgraded yet bc > I > didn't want to compound the problem. If this is a known issue and 5.4 > fixes it, then great, I'll just upgrade. > > I hope this scenario seems familiar to one of the users out there. > > __ > > *Mark Truelove*true9...@gmail.com > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Reconciliation of accounts is not permanent
Hi all, I just joined the list. I thought I'd give this a try before moving to a bug report, because I can't believe this happens to me and no one else has experienced it. I did try searching list history as suggested with google, but didn't find anything referring to this specifically. Also, this is not the first time experiencing this phenomenon, probably the third. I use gnucash for personal finances, so I have a checking or cash account and a number of credit card accounts. All of these are reconciled several times a year as I receive statements, although not always on time every month. However I don't go three months without catching up on all my accounts in any case. Today (and on previous occasions), I started my periodic reconciliations because I had statement notifications in email. I opened my credit card to reconcile and had the month's statement in a browser window. At first I was unable to match the "beginning of month" figures to fill out the small prompt window when reconciling. After a few glances I realized that it was trying to match the beginning balance to September of LAST YEAR instead of last month. I have reconciled this account to its statements 9 or10 times in the last year, including last month. In previous months, I reconciled this account and saved it normally, and that information was retained for the following months' reconciliations. Now when it forgets, it is losing/ignoring several months of previous reconciliations, but not all of them (since this account is at least 20 years old). When I checked them all, it has forgotten reconciliation data for three other accounts as well (while another six accounts in the same file are fully up-to date). I have backups of my files, both through GC's own backup system and my own rotating backups. Loss of data files is not an issue here. This got me thinking, and I went back and reloaded some of these backup files directly. When loaded, they are all missing the same information as my current file. So, one could say, user error - he actually didn't reconcile for months, and the files show that. Unfortunately, I DID reconcile all of these accounts, and the program is treating some aspect of the data as if it doesn't exist beyond that point, regardless of the source file. I'm a retired IT pro, an IT Manager and other roles over 40 years. I know how this looks at first glance. If this hadn't happened to me twice previously I wouldn't be taking the time to report this in detail today. I'm currently running v5.3. I downloaded 5.4 but haven't upgraded yet bc I didn't want to compound the problem. If this is a known issue and 5.4 fixes it, then great, I'll just upgrade. I hope this scenario seems familiar to one of the users out there. __ *Mark Truelove*true9...@gmail.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.