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