Re: [GNC] Reconciliation Roll Back
I'll add a "me, too" - I had no idea that this was available until I saw it here. Very nice! On Wed, May 29, 2024 at 8:15 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > And I learn something new everyday. Thanks David! > > Regards, > Adrien > > On 5/28/24 9:17 AM, David Carlson wrote: > > A tidbit of information that you may find helpful: If you hover the > mouse > > over the "y" character in the reconcile box in an account split line, the > > date of the reconciliation for that account split in that transaction > > appears in a flyover. It may take a couple of seconds to appear. > > ___ > 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. > -- _ 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 Roll Back (Peter Cuthbert)
On Thu, 30 May 2024 12:14:08 +0300 sunfish62--- via gnucash-user wrote: > With all due respect, most of the issues raised by Peter are covered > in some way in section 2.9.4 of the Guide, especially in the notes > and warnings embedded there. > > A deeper exploration of the different methods a user can implement to > recover from some of these more challenging situations might > appropriately fit on the wiki. > > David T. I was thinking about recovery from the challenging situations, which might start with a quote from Douglas Adams "Don't Panic" 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 - 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 Roll Back (Peter Cuthbert)
With all due respect, most of the issues raised by Peter are covered in some way in section 2.9.4 of the Guide, especially in the notes and warnings embedded there. A deeper exploration of the different methods a user can implement to recover from some of these more challenging situations might appropriately fit on the wiki. David T. On May 30, 2024, 8:00 AM, at 8:00 AM, Liz wrote: >On Wed, 29 May 2024 22:54:26 -0400 >NoobAlice wrote: > >> On 2024-05-29 04:39 PM, Peter Cuthbert via gnucash-user wrote: >> >> > The dates associated with the reconciled/not reconciled flag struck >> > me as an easy way to do a roll back without using the backups. >> > Something along the lines of if date = [specified >> > reconciliation date] then flag = n (I have no idea what >> > language is used by the developers. ... >> > So where am I with my data? I have corrected the £10k which was >> > 'swopped' and then gone after the error schrapnel. Some of that I >> > have found and corrected but eventually I had to succumb to a >> > balancing 'fudge it' figure. With that in place the rest of the >> > reconciliation was correct to the penny. >> >> To you and anyone else facing this issue, you can run a transaction >> report that shows you a history of of the account with reconciled >> dates for every transaction. >> > >Thanks NoobAlice >that is a really useful tip > >Thanks to Peter Cuthbert we've got together some really good tips on >what happens when a reconciliation goes awry, and I hope that someone >puts a summary on the wiki. > >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 >- >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 Roll Back (Peter Cuthbert)
There is nothing worse than facing a pile of paperwork to input, at the end of the month - or whatever period of time chosen. As a sufferer of such I resolved to spend a few minutes entering whatever had accrued during the day at the end of it - or first thing the next. The good thing about this is that you can pick up any errors made whilst they are still fresh in your mind, and it is surprising how quickly this becomes part of your daily routine. I heartily recommend it. On Wed, 29 May 2024 at 21:40, Peter Cuthbert via gnucash-user < gnucash-user@gnucash.org> wrote: > > Hi David, Adam, Derek and everybody who has contributed. > > David, your solution is excellent and I suppose it never crossed my mind > as I had not wholly worked out what all the files GNUCash spews out > actually do. I am afraid that using the accounting software is a twice > monthly chore in which I log all the transaction slip and credit card > statement and then reconcile against the bank account. It is almost > always late in the evening after the day's chores are cleared up and I > am not really at my brightest. So I have not been a keen student and > learned how to make the software fly. > > The dates associated with the reconciled/not reconciled flag struck me > as an easy way to do a roll back without using the backups. Something > along the lines of if date = [specified reconciliation date] then > flag = n (I have no idea what language is used by the developers. > I suppose my gripe about the 'Opening Balance' auto figure is probably > based on many years of using Quicken. According to my memory one could > enter both an opening and closing balance, but more recent users can > tell me if that memoryis incorrect, Perhaps, for those of us who are > more in the 'dozy user'category the term Opening balance could perhaps > have Closing balance at last reconciliation added to it. > Have suffered all this messing about to find errors I will probably > remember that but it might help folk loke me who have yet to fall into > the trap of not checking that the opening balance was the last > reconciliation closing balance. After all, if the program will not let > you change it why worry about the figure? However it is really the key > figure on which the reconciliation is built so ought to be checked at > the start. > > So where am I with my data? I have corrected the £10k which was > 'swopped' and then gone after the error schrapnel. Some of that I have > found and corrected but eventually I had to succumb to a balancing > 'fudge it' figure. With that in place the rest of the reconciliation > was correct to the penny. > > Thanks for all the help. > > Best wishes > > Pete > > -- Original Message -- > From: hell...@gmail.com > To: p.f.cuthb...@btinternet.com Cc: gnucash-user@gnucash.org; > blake.hannaf...@gmail.com > Sent: Wednesday, May 29th 2024, 21:01 > Subject: Re: [GNC] Reconciliation Roll Back (Peter Cuthbert) > Peter, The roll back facility is already there and has been for years - > it's called going back to a backup of your accounts file :-) I'm > assuming you're just using the bog standard xml data file here and are > running on Windows. There is a preference under Preferences >> General > that allows you to specify how many days to retain log/backup files > which is defaulted to 30 days from memory, but you can set it to retain > backups permanently and delete on an adhoc basis if you wish. So if you > are using the xml backend Gnucash does this for you and on Windows at > least keeps them in the same folder as your actual data file. Gnucash > names them the same as your actual data file but includes a date and > timestamp embedded in the name and they also have the usual .gnucash > file suffix - e.g. if the actual data file was named > Gnucash_Data_From_2011_01_01.gnucash the backups are named > Gnucash_Data_From_2011_01_01.gnucash.20240429182558.gnucash. > You can open any of these backup files as a Gnucash data file. My > suggestion would be to take a copy of your actual data file and put it > somewhere safe before you do anything further and make a note of the > date and time you did the reconciliation that you think was bad. Then > open the backup file just prior to this date and time - hopefully > whatever happened, occurred within your backup files window if you do > have GnuCash setup to retain backups. If this backup file looks good to > you, you can then choose to save this backup file as your actual data > file name and start over - you need to do this last step of saving the > backup file without the date and timestamp in the name, otherwise going > forward you'll end up with some horrendous backup/log file names e.g. > Gnucash_Data_From_2011_01_01.gnucash.
Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)
On Wed, 29 May 2024 22:54:26 -0400 NoobAlice wrote: > On 2024-05-29 04:39 PM, Peter Cuthbert via gnucash-user wrote: > > > The dates associated with the reconciled/not reconciled flag struck > > me as an easy way to do a roll back without using the backups. > > Something along the lines of if date = [specified > > reconciliation date] then flag = n (I have no idea what > > language is used by the developers. ... > > So where am I with my data? I have corrected the £10k which was > > 'swopped' and then gone after the error schrapnel. Some of that I > > have found and corrected but eventually I had to succumb to a > > balancing 'fudge it' figure. With that in place the rest of the > > reconciliation was correct to the penny. > > To you and anyone else facing this issue, you can run a transaction > report that shows you a history of of the account with reconciled > dates for every transaction. > Thanks NoobAlice that is a really useful tip Thanks to Peter Cuthbert we've got together some really good tips on what happens when a reconciliation goes awry, and I hope that someone puts a summary on the wiki. 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 - 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 Roll Back (Peter Cuthbert)
On 2024-05-29 04:39 PM, Peter Cuthbert via gnucash-user wrote: The dates associated with the reconciled/not reconciled flag struck me as an easy way to do a roll back without using the backups. Something along the lines of if date = [specified reconciliation date] then flag = n (I have no idea what language is used by the developers. ... So where am I with my data? I have corrected the £10k which was 'swopped' and then gone after the error schrapnel. Some of that I have found and corrected but eventually I had to succumb to a balancing 'fudge it' figure. With that in place the rest of the reconciliation was correct to the penny. To you and anyone else facing this issue, you can run a transaction report that shows you a history of of the account with reconciled dates for every transaction. Reports > Transaction Report Options Accounts: Choose your checking account Display: Check Reconciled Date Check Date Entered (may be useful, so why not) Amount: Single column General: Start: BEFORE YOUR FIRST TRANSACTION EVER - I pick Jan 1 2000 End: Today Sorting: Primary key: Reconciled Status, Ascending Uncheck Primary subtotal Secondary key: Reconciled Date, Ascending (sort doesn't work) Secondary subtotal for date: NONE Now run the report. It doesn't get the sort by reconciled date quite right, but it might be close. At this point you need to put the report in a spreadsheet program. I copy and paste, but there are many methods people have shared on the list. See attached for an example of what I describe below. It is very important that the start date of your report is before the first transaction you have in the account. In the spreadsheet program, paste and unmerge cells, then: 1) Freeze panes so the column labels at the top don't move 2) Set up a filter across all columns. 3) Use the filter dropdowns to sort by reconciled date. Make sure the transactions with no date are at the bottom and that the reconciled transactions are with reconciled dates oldest to newest. 4) Make a formula in a column to the right of your data to make your spreadsheet program recognize the numbers. 5) Make a formula in a column to the right of your data to do a running subtotal. (Something like =SUM(I$1:I2) and drag it down, with "$" making a part of the formula sticky.) Now you can quickly look at the reconciled balance as of the end of each reconciliation and see if it matches your bank statement. Once you find the first one that doesn't work (or the last one that works), you can look at your bank statements and see what transactions are missing from the reconciled list in GnuCash. Look for those missing transactions in the unreconciled ones at the end of the list. I would suggest fixing transactions on the spreadsheet report to get things working and highlight all my changes in bright yellow. Once everything is making sense in the spreadsheet, you can make the changes in GnuCash. I have this report saved as Transaction Report -> Rec Report Details GnuCash Sample Reconciliation.xlsx Description: MS-Excel 2007 spreadsheet ___ 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 Roll Back (Peter Cuthbert)
You don't need to roll back a reconciliation that is now out of whack. If need be, un-reconcile that transaction split, then re-reconcile. Regards, Adrien On 5/29/24 8:33 AM, Peter Cuthbert via gnucash-user wrote: So final thought for the GNUCash programmers. Please consider a 'roll back' facility so that one can correct mistakes. Indeed an 'opening balance' entry request for Reconciliations would be useful with a warning message that the value one has entered is not what the system holds. If that happened one would not go ahead with the reconciliation, but go back and look for obvious mistakes. ___ 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 Roll Back (Peter Cuthbert)
GnuCash is supposed to warn you when editing a reconciled transaction that would change the flag. If not, perhaps you turned that message off. Check Actions > Reset Warnings and look for something like "change contents of reconciled split". If it is there, select it and Apply to reset the warning to show up next time. (and next time, don't click the box to never warn you again) If it is not there, and you can intentionally repeat an edit without getting the warning and see the transaction un-reconcile, then you found a bug. Please report it. Regards, Adrien On 5/28/24 12:49 PM, Blake Hannaford wrote: I find this has been a longstanding problem. Every once in a while, old transactions get unreconciled. I always open GC the same way so I'm sure I'm not opening backups. ___ 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 Roll Back
And I learn something new everyday. Thanks David! Regards, Adrien On 5/28/24 9:17 AM, David Carlson wrote: A tidbit of information that you may find helpful: If you hover the mouse over the "y" character in the reconcile box in an account split line, the date of the reconciliation for that account split in that transaction appears in a flyover. It may take a couple of seconds to appear. ___ 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 Roll Back (Peter Cuthbert)
Hi David, Adam, Derek and everybody who has contributed. David, your solution is excellent and I suppose it never crossed my mind as I had not wholly worked out what all the files GNUCash spews out actually do. I am afraid that using the accounting software is a twice monthly chore in which I log all the transaction slip and credit card statement and then reconcile against the bank account. It is almost always late in the evening after the day's chores are cleared up and I am not really at my brightest. So I have not been a keen student and learned how to make the software fly. The dates associated with the reconciled/not reconciled flag struck me as an easy way to do a roll back without using the backups. Something along the lines of if date = [specified reconciliation date] then flag = n (I have no idea what language is used by the developers. I suppose my gripe about the 'Opening Balance' auto figure is probably based on many years of using Quicken. According to my memory one could enter both an opening and closing balance, but more recent users can tell me if that memoryis incorrect, Perhaps, for those of us who are more in the 'dozy user'category the term Opening balance could perhaps have Closing balance at last reconciliation added to it. Have suffered all this messing about to find errors I will probably remember that but it might help folk loke me who have yet to fall into the trap of not checking that the opening balance was the last reconciliation closing balance. After all, if the program will not let you change it why worry about the figure? However it is really the key figure on which the reconciliation is built so ought to be checked at the start. So where am I with my data? I have corrected the £10k which was 'swopped' and then gone after the error schrapnel. Some of that I have found and corrected but eventually I had to succumb to a balancing 'fudge it' figure. With that in place the rest of the reconciliation was correct to the penny. Thanks for all the help. Best wishes Pete -- Original Message -- From: hell...@gmail.com To: p.f.cuthb...@btinternet.com Cc: gnucash-user@gnucash.org; blake.hannaf...@gmail.com Sent: Wednesday, May 29th 2024, 21:01 Subject: Re: [GNC] Reconciliation Roll Back (Peter Cuthbert) Peter, The roll back facility is already there and has been for years - it's called going back to a backup of your accounts file :-) I'm assuming you're just using the bog standard xml data file here and are running on Windows. There is a preference under Preferences >> General that allows you to specify how many days to retain log/backup files which is defaulted to 30 days from memory, but you can set it to retain backups permanently and delete on an adhoc basis if you wish. So if you are using the xml backend Gnucash does this for you and on Windows at least keeps them in the same folder as your actual data file. Gnucash names them the same as your actual data file but includes a date and timestamp embedded in the name and they also have the usual .gnucash file suffix - e.g. if the actual data file was named Gnucash_Data_From_2011_01_01.gnucash the backups are named Gnucash_Data_From_2011_01_01.gnucash.20240429182558.gnucash. You can open any of these backup files as a Gnucash data file. My suggestion would be to take a copy of your actual data file and put it somewhere safe before you do anything further and make a note of the date and time you did the reconciliation that you think was bad. Then open the backup file just prior to this date and time - hopefully whatever happened, occurred within your backup files window if you do have GnuCash setup to retain backups. If this backup file looks good to you, you can then choose to save this backup file as your actual data file name and start over - you need to do this last step of saving the backup file without the date and timestamp in the name, otherwise going forward you'll end up with some horrendous backup/log file names e.g. Gnucash_Data_From_2011_01_01.gnucash.20240429182558.20240430054858.gnucash. This may mean re-entering/importing transactions from the date and time of the backup file - you could always export transactions from your actual data file to cover this period if that's an issue for you ? Hope this helps and you have a suitable backup file to go back to. Cheers David H. On Wed, 29 May 2024 at 23:34, Peter Cuthbert via gnucash-user wrote: > > > Dear Everybody > > Many thanks for your responses to my Reconciliation problem. > > I have been examining my accounts and have managed to find part of the > problem. A £10K transfer out of the bank account to a new saving > account became 'flipped' from a payment to a receipt. Looking at the > details I set up for the savings a/c I made the wrong choices so that it > was shown as an outgoing not an incoming. That clearly accounts
Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)
Useful hint (when making backups, any, not just gnucash) My suggestion would be to take a copy of your actual data file and put it somewhere safe before you do anything further Remove any uncertainty about what back-up is which. Include the Julian date in the name of the file. Thus if I were making a back-up of my personal books today, I might name that file ..backup20240529.personalbooks.gnucash <> 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 Roll Back (Peter Cuthbert)
Peter, The roll back facility is already there and has been for years - it's called going back to a backup of your accounts file :-) I'm assuming you're just using the bog standard xml data file here and are running on Windows. There is a preference under Preferences >> General that allows you to specify how many days to retain log/backup files which is defaulted to 30 days from memory, but you can set it to retain backups permanently and delete on an adhoc basis if you wish. So if you are using the xml backend Gnucash does this for you and on Windows at least keeps them in the same folder as your actual data file. Gnucash names them the same as your actual data file but includes a date and timestamp embedded in the name and they also have the usual .gnucash file suffix - e.g. if the actual data file was named "Gnucash_Data_From_2011_01_01.gnucash" the backups are named "Gnucash_Data_From_2011_01_01.gnucash.20240429182558.gnucash". You can open any of these backup files as a Gnucash data file. My suggestion would be to take a copy of your actual data file and put it somewhere safe before you do anything further and make a note of the date and time you did the reconciliation that you think was bad. Then open the backup file just prior to this date and time - hopefully whatever happened, occurred within your backup files window if you do have GnuCash setup to retain backups. If this backup file looks good to you, you can then choose to save this backup file as your actual data file name and start over - you need to do this last step of saving the backup file without the date and timestamp in the name, otherwise going forward you'll end up with some horrendous backup/log file names e.g. "Gnucash_Data_From_2011_01_01.gnucash.20240429182558.20240430054858.gnucash". This may mean re-entering/importing transactions from the date and time of the backup file - you could always export transactions from your actual data file to cover this period if that's an issue for you ? Hope this helps and you have a suitable backup file to go back to. Cheers David H. On Wed, 29 May 2024 at 23:34, Peter Cuthbert via gnucash-user wrote: > > > Dear Everybody > > Many thanks for your responses to my Reconciliation problem. > > I have been examining my accounts and have managed to find part of the > problem. A £10K transfer out of the bank account to a new saving > account became 'flipped' from a payment to a receipt. Looking at the > details I set up for the savings a/c I made the wrong choices so that it > was shown as an outgoing not an incoming. That clearly accounts for the > £20k of difference but where the other odds and ends that dribbled it > down to 19K came from I have no idea. > > In exasperation I have looked at some of the other account programs that > are out there on the Internet but it looks as if they are keen to simply > import one's bank statement. I cannot see how they would cope with > credit card payements other than as a single lump DD. That is no use to > me as I use the credit card as a payments card and need to analyse the > statements. Thus it looks as if I will have to wind the reconciliation > back transaction by transaction and get GNUCash corrected. > > So final thought for the GNUCash programmers. Please consider a 'roll > back' facility so that one can correct mistakes. Indeed an 'opening > balance' entry request for Reconciliations would be useful with a > warning message that the value one has entered is not what the system > holds. If that happened one would not go ahead with the reconciliation, > but go back and look for obvious mistakes. > > Best wishes > > Pete > > -- Original Message -- > From: gnucash-user@gnucash.org > To: blake.hannaf...@gmail.com Cc: gnucash-user@gnucash.org > Sent: Tuesday, May 28th 2024, 21:40 > Subject: Re: [GNC] Reconciliation Roll Back (Peter Cuthbert) > Generally, I find that transactions ONLY get dereconciled due to an > action I have taken-- like changing some element of said transaction. > They don't just get unreconciled-- at least, not for me. > There was a short period of time where the app was very strict about > when a transaction was dereconciled, but that change was modified after > user feedback. I believe that recent versions only dereconcile a > transaction when you modify a material detail, like the amount or the > date. If you are having this as a longstanding problem, it would be > useful to everyone to figure out what is going on, so that the problem > can be addressed-- regardless of where the problem lies. Dereconciling > transactions is not a minor matter when it comes to accounting software. > David T. On May 28, 2024, 8:51 PM, at 8:51 PM, Blake Hannaford wrote: > >I fi
Re: [GNC] Reconciliation Roll Back
On 2024-05-28, David Carlson wrote: > A tidbit of information that you may find helpful: If you hover the mouse > over the "y" character in the reconcile box in an account split line, the > date of the reconciliation for that account split in that transaction > appears in a flyover. It may take a couple of seconds to appear. Interesting, thanks! I did not know that. ___ 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 Roll Back (Peter Cuthbert)
Pete, I don't understand your request. During reconciliation, you need to enter the ending balance from your statement. If, at the end of the process of checking your transaction the computed balance does not match the entered balance, then the reconciliation will not complete. Now, Gnucash gives you a /guess/ of what that balance is and automatically fills in that field. If you just use that directly then yes, reversed transactions can catch you off guard. So really the only suggestion I can see here is to empty out that text field so gnucash won't suggest an ending balance. But in reality, you just need to manually enter the correct ending balance from your statement and then you wont be able to reconcile if transactions are entered incorrectly. -derek On Wed, May 29, 2024 9:33 am, Peter Cuthbert via gnucash-user wrote: > > Dear Everybody > > Many thanks for your responses to my Reconciliation problem. > > I have been examining my accounts and have managed to find part of the > problem. A £10K transfer out of the bank account to a new saving > account became 'flipped' from a payment to a receipt. Looking at the > details I set up for the savings a/c I made the wrong choices so that it > was shown as an outgoing not an incoming. That clearly accounts for the > £20k of difference but where the other odds and ends that dribbled it > down to 19K came from I have no idea. > > In exasperation I have looked at some of the other account programs that > are out there on the Internet but it looks as if they are keen to simply > import one's bank statement. I cannot see how they would cope with > credit card payements other than as a single lump DD. That is no use to > me as I use the credit card as a payments card and need to analyse the > statements. Thus it looks as if I will have to wind the reconciliation > back transaction by transaction and get GNUCash corrected. > > So final thought for the GNUCash programmers. Please consider a 'roll > back' facility so that one can correct mistakes. Indeed an 'opening > balance' entry request for Reconciliations would be useful with a > warning message that the value one has entered is not what the system > holds. If that happened one would not go ahead with the reconciliation, > but go back and look for obvious mistakes. > > Best wishes > > Pete > > -- Original Message -- > From: gnucash-user@gnucash.org > To: blake.hannaf...@gmail.com Cc: gnucash-user@gnucash.org > Sent: Tuesday, May 28th 2024, 21:40 > Subject: Re: [GNC] Reconciliation Roll Back (Peter Cuthbert) > Generally, I find that transactions ONLY get dereconciled due to an > action I have taken-- like changing some element of said transaction. > They don't just get unreconciled-- at least, not for me. > There was a short period of time where the app was very strict about > when a transaction was dereconciled, but that change was modified after > user feedback. I believe that recent versions only dereconcile a > transaction when you modify a material detail, like the amount or the > date. If you are having this as a longstanding problem, it would be > useful to everyone to figure out what is going on, so that the problem > can be addressed-- regardless of where the problem lies. Dereconciling > transactions is not a minor matter when it comes to accounting software. > David T. On May 28, 2024, 8:51 PM, at 8:51 PM, Blake Hannaford wrote: >>I find this has been a longstanding problem. Every once in a while, >>old >transactions get unreconciled. I always open GC the same way so > I'm >sure >I'm not opening backups. > >Blake Hannaford > >-- >>___ >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. > > > > Dr Peter Cuthbert > Creuddyn > Coedlan Y Plas > Llangawsai > Aberystwyth > Sir Ceredigion > SY23 1HJ > 01970 623 447 > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/lis
Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)
Dear Everybody Many thanks for your responses to my Reconciliation problem. I have been examining my accounts and have managed to find part of the problem. A £10K transfer out of the bank account to a new saving account became 'flipped' from a payment to a receipt. Looking at the details I set up for the savings a/c I made the wrong choices so that it was shown as an outgoing not an incoming. That clearly accounts for the £20k of difference but where the other odds and ends that dribbled it down to 19K came from I have no idea. In exasperation I have looked at some of the other account programs that are out there on the Internet but it looks as if they are keen to simply import one's bank statement. I cannot see how they would cope with credit card payements other than as a single lump DD. That is no use to me as I use the credit card as a payments card and need to analyse the statements. Thus it looks as if I will have to wind the reconciliation back transaction by transaction and get GNUCash corrected. So final thought for the GNUCash programmers. Please consider a 'roll back' facility so that one can correct mistakes. Indeed an 'opening balance' entry request for Reconciliations would be useful with a warning message that the value one has entered is not what the system holds. If that happened one would not go ahead with the reconciliation, but go back and look for obvious mistakes. Best wishes Pete -- Original Message -- From: gnucash-user@gnucash.org To: blake.hannaf...@gmail.com Cc: gnucash-user@gnucash.org Sent: Tuesday, May 28th 2024, 21:40 Subject: Re: [GNC] Reconciliation Roll Back (Peter Cuthbert) Generally, I find that transactions ONLY get dereconciled due to an action I have taken-- like changing some element of said transaction. They don't just get unreconciled-- at least, not for me. There was a short period of time where the app was very strict about when a transaction was dereconciled, but that change was modified after user feedback. I believe that recent versions only dereconcile a transaction when you modify a material detail, like the amount or the date. If you are having this as a longstanding problem, it would be useful to everyone to figure out what is going on, so that the problem can be addressed-- regardless of where the problem lies. Dereconciling transactions is not a minor matter when it comes to accounting software. David T. On May 28, 2024, 8:51 PM, at 8:51 PM, Blake Hannaford wrote: I find this has been a longstanding problem. Every once in a while, old >transactions get unreconciled. I always open GC the same way so I'm >sure >I'm not opening backups. > >Blake Hannaford > >-- ___ >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. Dr Peter Cuthbert Creuddyn Coedlan Y Plas Llangawsai Aberystwyth Sir Ceredigion SY23 1HJ 01970 623 447 ___ 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 Roll Back (Peter Cuthbert)
Generally, I find that transactions ONLY get dereconciled due to an action I have taken-- like changing some element of said transaction. They don't just "get unreconciled"-- at least, not for me. There was a short period of time where the app was very strict about when a transaction was dereconciled, but that change was modified after user feedback. I believe that recent versions only dereconcile a transaction when you modify a material detail, like the amount or the date. If you are having this as a longstanding problem, it would be useful to everyone to figure out what is going on, so that the problem can be addressed-- regardless of where the problem lies. Dereconciling transactions is not a minor matter when it comes to accounting software. David T. On May 28, 2024, 8:51 PM, at 8:51 PM, Blake Hannaford wrote: >I find this has been a longstanding problem. Every once in a while, >old >transactions get unreconciled. I always open GC the same way so I'm >sure >I'm not opening backups. > >Blake Hannaford > >-- >___ >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 Roll Back (Peter Cuthbert)
I find this has been a longstanding problem. Every once in a while, old transactions get unreconciled. I always open GC the same way so I'm sure I'm not opening backups. Blake Hannaford -- ___ 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 Roll Back
A tidbit of information that you may find helpful: If you hover the mouse over the "y" character in the reconcile box in an account split line, the date of the reconciliation for that account split in that transaction appears in a flyover. It may take a couple of seconds to appear. Another tidbit: Transactions with multiple accounts or splits reconcile separately for each account, but sometimes editing, unreconciling or deleting in one account can change a reconciliation for another account in that transaction. That isn't supposed to happen but sometimes it does with unusual editing methods, especially if the account name is changed for a reconciled account line. On Tue, May 28, 2024 at 5:21 AM Maf. King wrote: > On Tuesday, 28 May 2024 09:49:05 BST Peter Cuthbert via gnucash-user wrote: > > > The reason I suspect > > is that the opening balance that it picked up seemed way too high but I > > know of no way to make sure that the opening balance is the correct one. > > Only by visual inspection - if you completed the reconcile of last month's > statement, then the reconciled balance in GC should match the end balance > of > that statement which should match the opening balance of the current > statement which should match what GC suggests as the starting balance. > > If the opening balances don't match but the previous reconciled balances > did > then something slightly odd has happened. Maybe you inadvertently > modified > some reconciled txns and they lost their "reconcied" status. maybe you > accidently started using a backup file at some point (look for lots of > numbers > in the filename) > > > > Additionally I noticed that a good handful of transactions that were > > reconciled in last months task now showed up as unreconciled. > > That would certainly throw off the starting balance. > > > > > I am at a loss as to how to rescure this problem. What would be nice > > would be to be able to 'roll back' the erroneous reconciliation and > > probably the previous one and then begin again. Unless, of course you > > > know a better way to get out of this hole. > > Try a reconcile to the new statement ending balance - ignore the "start". > Also look at the unreconciled transactions from previous months - if they > all > check off OK and you hit the new statement end balance then you are good > to > go. > > If you really want to roll back the previous reconciles, then you can only > do > that manually by clicking on each of the "Y" in the reconciled > transactions > status. > > As always, take a back-up copey of the file before you start digging and > maybe > get in a worse mess! > > HTH, > Maf. > > > > > > > ___ > 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. > -- 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 - 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 Roll Back
On Tuesday, 28 May 2024 09:49:05 BST Peter Cuthbert via gnucash-user wrote: > The reason I suspect > is that the opening balance that it picked up seemed way too high but I > know of no way to make sure that the opening balance is the correct one. Only by visual inspection - if you completed the reconcile of last month's statement, then the reconciled balance in GC should match the end balance of that statement which should match the opening balance of the current statement which should match what GC suggests as the starting balance. If the opening balances don't match but the previous reconciled balances did then something slightly odd has happened. Maybe you inadvertently modified some reconciled txns and they lost their "reconcied" status. maybe you accidently started using a backup file at some point (look for lots of numbers in the filename) > Additionally I noticed that a good handful of transactions that were > reconciled in last months task now showed up as unreconciled. That would certainly throw off the starting balance. > > I am at a loss as to how to rescure this problem. What would be nice > would be to be able to 'roll back' the erroneous reconciliation and > probably the previous one and then begin again. Unless, of course you > > know a better way to get out of this hole. Try a reconcile to the new statement ending balance - ignore the "start". Also look at the unreconciled transactions from previous months - if they all check off OK and you hit the new statement end balance then you are good to go. If you really want to roll back the previous reconciles, then you can only do that manually by clicking on each of the "Y" in the reconciled transactions status. As always, take a back-up copey of the file before you start digging and maybe get in a worse mess! HTH, Maf. > ___ 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 Roll Back
On Tue, 28 May 2024 09:49:05 +0100 (BST) Peter Cuthbert via gnucash-user wrote: > Dear GNU Cash Users > > A year ago I re-started an account from 6th April in GNU Cash as my > previous imports from Quicken were not working as I would have > wished. It was a lot of work to re enter 3 months of transactions but > the clean start has been excellent and every month the bank > reconciiation has been perfect. This month it is out by more than > £20K. The reason I suspect is that the opening balance that it > picked up seemed way too high but I know of no way to make sure that > the opening balance is the correct one. Additionally I noticed that a > good handful of transactions that were reconciled in last months task > now showed up as unreconciled. > I am at a loss as to how to rescure this problem. What would be nice > would be to be able to 'roll back' the erroneous reconciliation and > probably the previous one and then begin again. Unless, of course > you know a better way to get out of this hole. > > Regards > > Pete C 1. make a copy of your data file. 2. Play with the copy. 3. Ensure you are not working with a backup file. 4. Try reconciling the account as it is. Mark as reconciled all the things you know were reconciled in the past and see if that improves the situation. 5. Wait for more advice 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 - 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 with a strange opening balance
Another good idea. I went back to the start and sorted by Description, but nothing out of the ordinary. As we might expect the majority of entries are withdrawals, so the deposits are easier to see. Also, sorted by description sorts out if you put down the credit card payments or the pub expenditures in the wrong place!! Ho hum. Thanks for the suggestion. Barry On 15/11/2023 23:37, Liz wrote: On Wed, 15 Nov 2023 15:39:19 +0100 Mahon Finbar via gnucash-user wrote: Aha, as usual you are correct Maff. I'll just have to soldier on. I already found two deposits entered as withdrawals. Barry At this stage, consider how you could use the search feature to find these sort of errors. If the deposits have a unique description, search for that description in the account and then check that all the entries are in the appropriate column. Sadly the autocomplete features autocomplete errors equally as well as good work, so think about how you can get the accounts sorted out other than through the reconcile feature. 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 - 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 with a strange opening balance
On Wed, 15 Nov 2023 15:39:19 +0100 Mahon Finbar via gnucash-user wrote: > Aha, as usual you are correct Maff. I'll just have to soldier on. I > already found two deposits entered as withdrawals. > > Barry At this stage, consider how you could use the search feature to find these sort of errors. If the deposits have a unique description, search for that description in the account and then check that all the entries are in the appropriate column. Sadly the autocomplete features autocomplete errors equally as well as good work, so think about how you can get the accounts sorted out other than through the reconcile feature. 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 - 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 with a strange opening balance
On Wed, Nov 15, 2023, 3:55 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Sorry David, I messed up the quotation when trimming. That was Chris' > explanation of how GnuCash stores reconciliation info. > > Regards, > Adrien > > On 11/15/23 3:50 PM, David Carlson wrote: > > I agree that the reconciliation date is assigned to each transaction > split > > as it is reconciled. > > > > In Gmail I am unable to see where you found that conflicting information > in > > this thread, as I am sure that I made no suggestion otherwise. > > ___ > 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 with a strange opening balance
Sorry David, I messed up the quotation when trimming. That was Chris' explanation of how GnuCash stores reconciliation info. Regards, Adrien On 11/15/23 3:50 PM, David Carlson wrote: I agree that the reconciliation date is assigned to each transaction split as it is reconciled. In Gmail I am unable to see where you found that conflicting information in this thread, as I am sure that I made no suggestion otherwise. ___ 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 with a strange opening balance
Adrien, I agree that the reconciliation date is assigned to each transaction split as it is reconciled. In Gmail I am unable to see where you found that conflicting information in this thread, as I am sure that I made no suggestion otherwise. On Wed, Nov 15, 2023, 2:55 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > On 11/15/23 10:07 AM, David Carlson wrote: > >>> - each split's reconciliation date (which is the same as the last > >>> Reconciliation date). > > I could be reading your comment oddly, but I'm pretty sure that this > date sticks. That is, it doesn't change for *every* already reconciled > split in the account each reconciliation. Otherwise the Reconciliation > Report would show all the same date, (making that column useless) and it > does not. > > But if you re-reconcile a split, then that date will change to whatever > new date you reconciled to, but just for those re-reconciled splits. > > 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. > ___ 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 with a strange opening balance
On 11/15/23 10:07 AM, David Carlson wrote: - each split's reconciliation date (which is the same as the last Reconciliation date). I could be reading your comment oddly, but I'm pretty sure that this date sticks. That is, it doesn't change for *every* already reconciled split in the account each reconciliation. Otherwise the Reconciliation Report would show all the same date, (making that column useless) and it does not. But if you re-reconcile a split, then that date will change to whatever new date you reconciled to, but just for those re-reconciled splits. 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 with a strange opening balance
My bank just this morning went through another iteration of fine tuning their procedures, which I have yet to process. However, I hope they still have monthly statements, whether mailed or only online to reconcile against. They may be identified only by account number and month, but so far they have been sufficiently immutable to be positively identified years later with an identifiable date interval for reconciliation .. On Wed, Nov 15, 2023 at 9:41 AM R Losey wrote: > I don't get statements with numbers to use - my checkbooks are reconciled > monthly to whatever the current online balance is, so what GnuCash does now > is just what I need. > > On Wed, Nov 15, 2023 at 8:27 AM Christopher Lam > > wrote: > > > A bit tangential to the issue of reconciliation is that fundamentally IMV > > reconciliation means to marry up (aka reconcile) the physical periodic > > (monthly/quarterly/annually) bank statements *against* your own books > which > > carry the canonical data which hopefully supports your financial > activity. > > > > Gnucash reconciliation only stores, for each reconciliation: > > > >- an account's last Reconciliation date > >- each split's reconciliation status n/c/y, > >- each split's reconciliation date (which is the same as the last > >Reconciliation date). > > > > It doesn't store other info such as: starting balance, statement number; > > and doesn't store the reconciled starting and ending balances. > > > > It *could* be transformed to store all these additional data: > > > >- statement ID number > >- statement's start and ending date > >- statement's start and ending balance > >- list of splits identified within the statement > > > > And would be somewhat more robust (ie you could ask gnucash to display > the > > contents of the feb2014 statement), and we would potentially be able to > > re-reconcile a previous statement (e.g. I deleted an old reconciled split > > in error and wish to re-reconcile its statement) but this would require a > > complete backward-incompatible upgrade in the internal data schema, there > > doesn't seem to be a demand of it, nor manpower to implement it, and I > > think it's simply overkill. > > > > Thus the reconciliation is currently limited to the state that exists > > currently. > > > > E > > > > On Mon, 13 Nov 2023, 11:21 pm Mahon Finbar via gnucash-user, < > > gnucash-user@gnucash.org> wrote: > > > > > Hello, > > > > > > The recent discussion on reconciliation was helpful in trying to sort > > > out some anomalies I have. > > > > > > When I do the latest reconciliation of one of my accounts the opening > > > balance is 10,448.43 and gives me an amount of inbalance which is way > > off. > > > > > > Following the advice in the recent posts I tried working backwards to > > > see if I could find any errors. > > > > > > I got close to 0.00 from time to time and was satisfied enough to > > > consider a balancing entry, but was intrigued on where the 'error' > might > > > have been. > > > > > > I set off to see where, but, in the course of my search, I tried to > find > > > the number 10,443.43 in the account, as a baseline, but didn't find > one. > > > > > > If I understand the process of reconciliation the number should be > > > somewhere in the account, should it not?? > > > > > > Just tell me I am barking up the wrong tree, if I am making an error. > > > > > > Finbar > > > > > > ___ > > > 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. > > > > > -- > _ > 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. > -- 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 - 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 with a strange opening balance
I don't get statements with numbers to use - my checkbooks are reconciled monthly to whatever the current online balance is, so what GnuCash does now is just what I need. On Wed, Nov 15, 2023 at 8:27 AM Christopher Lam wrote: > A bit tangential to the issue of reconciliation is that fundamentally IMV > reconciliation means to marry up (aka reconcile) the physical periodic > (monthly/quarterly/annually) bank statements *against* your own books which > carry the canonical data which hopefully supports your financial activity. > > Gnucash reconciliation only stores, for each reconciliation: > >- an account's last Reconciliation date >- each split's reconciliation status n/c/y, >- each split's reconciliation date (which is the same as the last >Reconciliation date). > > It doesn't store other info such as: starting balance, statement number; > and doesn't store the reconciled starting and ending balances. > > It *could* be transformed to store all these additional data: > >- statement ID number >- statement's start and ending date >- statement's start and ending balance >- list of splits identified within the statement > > And would be somewhat more robust (ie you could ask gnucash to display the > contents of the feb2014 statement), and we would potentially be able to > re-reconcile a previous statement (e.g. I deleted an old reconciled split > in error and wish to re-reconcile its statement) but this would require a > complete backward-incompatible upgrade in the internal data schema, there > doesn't seem to be a demand of it, nor manpower to implement it, and I > think it's simply overkill. > > Thus the reconciliation is currently limited to the state that exists > currently. > > E > > On Mon, 13 Nov 2023, 11:21 pm Mahon Finbar via gnucash-user, < > gnucash-user@gnucash.org> wrote: > > > Hello, > > > > The recent discussion on reconciliation was helpful in trying to sort > > out some anomalies I have. > > > > When I do the latest reconciliation of one of my accounts the opening > > balance is 10,448.43 and gives me an amount of inbalance which is way > off. > > > > Following the advice in the recent posts I tried working backwards to > > see if I could find any errors. > > > > I got close to 0.00 from time to time and was satisfied enough to > > consider a balancing entry, but was intrigued on where the 'error' might > > have been. > > > > I set off to see where, but, in the course of my search, I tried to find > > the number 10,443.43 in the account, as a baseline, but didn't find one. > > > > If I understand the process of reconciliation the number should be > > somewhere in the account, should it not?? > > > > Just tell me I am barking up the wrong tree, if I am making an error. > > > > Finbar > > > > ___ > > 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. > -- _ 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 with a strange opening balance
Aha, as usual you are correct Maff. I'll just have to soldier on. I already found two deposits entered as withdrawals. Barry On 13/11/2023 16:40, Maf. King wrote: On Monday, 13 November 2023 15:20:28 GMT Mahon Finbar via gnucash-user wrote: I set off to see where, but, in the course of my search, I tried to find the number 10,443.43 in the account, as a baseline, but didn't find one. If I understand the process of reconciliation the number should be somewhere in the account, should it not?? or possibly ~5221.70 as a CR when it should be a DR (etc). or several smaller errors which total the ~10k discrepancy you are seeing Maf. ___ 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 with a strange opening balance
A bit tangential to the issue of reconciliation is that fundamentally IMV reconciliation means to marry up (aka reconcile) the physical periodic (monthly/quarterly/annually) bank statements *against* your own books which carry the canonical data which hopefully supports your financial activity. Gnucash reconciliation only stores, for each reconciliation: - an account's last Reconciliation date - each split's reconciliation status n/c/y, - each split's reconciliation date (which is the same as the last Reconciliation date). It doesn't store other info such as: starting balance, statement number; and doesn't store the reconciled starting and ending balances. It *could* be transformed to store all these additional data: - statement ID number - statement's start and ending date - statement's start and ending balance - list of splits identified within the statement And would be somewhat more robust (ie you could ask gnucash to display the contents of the feb2014 statement), and we would potentially be able to re-reconcile a previous statement (e.g. I deleted an old reconciled split in error and wish to re-reconcile its statement) but this would require a complete backward-incompatible upgrade in the internal data schema, there doesn't seem to be a demand of it, nor manpower to implement it, and I think it's simply overkill. Thus the reconciliation is currently limited to the state that exists currently. E On Mon, 13 Nov 2023, 11:21 pm Mahon Finbar via gnucash-user, < gnucash-user@gnucash.org> wrote: > Hello, > > The recent discussion on reconciliation was helpful in trying to sort > out some anomalies I have. > > When I do the latest reconciliation of one of my accounts the opening > balance is 10,448.43 and gives me an amount of inbalance which is way off. > > Following the advice in the recent posts I tried working backwards to > see if I could find any errors. > > I got close to 0.00 from time to time and was satisfied enough to > consider a balancing entry, but was intrigued on where the 'error' might > have been. > > I set off to see where, but, in the course of my search, I tried to find > the number 10,443.43 in the account, as a baseline, but didn't find one. > > If I understand the process of reconciliation the number should be > somewhere in the account, should it not?? > > Just tell me I am barking up the wrong tree, if I am making an error. > > Finbar > > ___ > 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 with a strange opening balance
While "Finding reconciliation discrepancies from previous statements can be extremely tedious and GnuCash doesn't have any tools to help. There's not even a way to display historical reconciled balances." is correct, the Banks (and by their proxy their Information Systems) have stepped up and have gotten to the point where their online portals (that is if you have signed up for it) have very good filtering capabilities when it comes to displaying transactions by date range. In the US the Banks are required to keep 7 years of statement available, and most banks now do very good job to getting them to you at a moment's notice. Here is what I do that has worked well for me: If there were any unintended entries gotten added after reconcile ('y' or 'c') then they normally appear as unreconciled ('n') which you can filter by that status in the register (assuming that you normally reconcile accounts like Bank, Credit Card and/or Investment accounts). This is likely to be able to flag it down very quickly. If your last reconciled register suddenly appears out-of-sync with respect to bank statement then review previous statement(s). Check the beginning and ending balance of previous statements and if they do not match then go back one more statement and compare. Rinse and repeat until you get to the statement that actually matches. Your culprit is likely to be somewhere in the statement following the one that matches. Use the previous step of transaction status to locate the errant entry and then correct as necessary. -Original Message- From: john Sent: Monday, November 13, 2023 3:55 PM To: Mahon Finbar Cc: Gnucash Users Subject: Re: [GNC] Reconciliation with a strange opening balance > On Nov 13, 2023, at 07:20, Mahon Finbar via gnucash-user wrote: > > Hello, > > The recent discussion on reconciliation was helpful in trying to sort out some anomalies I have. > > When I do the latest reconciliation of one of my accounts the opening balance is 10,448.43 and gives me an amount of inbalance which is way off. > > Following the advice in the recent posts I tried working backwards to see if I could find any errors. > > I got close to 0.00 from time to time and was satisfied enough to consider a balancing entry, but was intrigued on where the 'error' might have been. > > I set off to see where, but, in the course of my search, I tried to find the number 10,443.43 in the account, as a baseline, but didn't find one. > > If I understand the process of reconciliation the number should be somewhere in the account, should it not?? > > Just tell me I am barking up the wrong tree, if I am making an error. The reconcile info dialog that comes up when you click the reconcile button has two balances: Starting balance and Ending balance. The first is the reconciled balance for the account, that is the sum of all of the splits in the account marked as reconciled. That's different from the opening balance, which is the amount in the account when you created it in GnuCash. The starting balance should match the starting balance on your statement. If it doesn't then there's a mistake in reconciling a previous statement and you need to either make a correcting entry in your account to get it to match or dig through previous statements to try to find the discrepancy. The Ending balance is what you should enter from your account statement or your bank's website. It defaults to the balance of the last transaction on the date you entered in the Reconciliation date entry. When you finish that dialog the reconcile window opens and in the lower left it shows the balances from the info window followed by Reconciled balance and Difference, which update as you tick off transactions in the two panes of the window; you should tick off the transactions that match your statement, paying close attention to the amounts: Reconciliation is all about making sure that there aren't any differences. Fix any differences in the register and press enter to commit the change and it will be immediately reflected in the reconcile window. Once you have marked all of the transactions the Ending and Reconciled balances should match, Difference should be 0, and the Finish button in the toolbar should be enabled. You might not have a transaction balance matching the reconciled balance if you have unbalanced transactions previous to the last reconciled one. The "R" column between Transfer Account and Debit/Deposit shows each transaction's reconciled status: y for reconciled, n for unreconciled, c for cleared, and v for voided. You can use the the Status page of View>Filter By... to hide transactions by status. Finding reconciliation discrepancies from previous statements can be extremely tedious and GnuCash doesn't have any tools to help. There's not even a way to display historical reconciled balances. When it comes to fixing discrepancies remember that bank
Re: [GNC] Reconciliation with a strange opening balance
If you remember that the reconciliation endting balance was correct in GnuCash fairly recently a process that will actually work would be to unreconcile all transaction splits after a given date, then re-reconciling each month after that date with your bank statements handy. To go back more than a few months would be incredibly tedious. If you try this it would be wise to make a working copy of your data file rather than use your real data file. Remember that it is possible that one or more transaction splits having any date may have been deleted, changed or re-assigned to a different account, and those may be rather hard to find. Another possibility would be if there are months when the running balance matches the bank statement exactly... On Mon, Nov 13, 2023 at 2:56 PM john wrote: > > > > On Nov 13, 2023, at 07:20, Mahon Finbar via gnucash-user < > gnucash-user@gnucash.org> wrote: > > > > Hello, > > > > The recent discussion on reconciliation was helpful in trying to sort > out some anomalies I have. > > > > When I do the latest reconciliation of one of my accounts the opening > balance is 10,448.43 and gives me an amount of inbalance which is way off. > > > > Following the advice in the recent posts I tried working backwards to > see if I could find any errors. > > > > I got close to 0.00 from time to time and was satisfied enough to > consider a balancing entry, but was intrigued on where the 'error' might > have been. > > > > I set off to see where, but, in the course of my search, I tried to find > the number 10,443.43 in the account, as a baseline, but didn't find one. > > > > If I understand the process of reconciliation the number should be > somewhere in the account, should it not?? > > > > Just tell me I am barking up the wrong tree, if I am making an error. > > The reconcile info dialog that comes up when you click the reconcile > button has two balances: Starting balance and Ending balance. The first is > the reconciled balance for the account, that is the sum of all of the > splits in the account marked as reconciled. That's different from the > opening balance, which is the amount in the account when you created it in > GnuCash. The starting balance should match the starting balance on your > statement. If it doesn't then there's a mistake in reconciling a previous > statement and you need to either make a correcting entry in your account to > get it to match or dig through previous statements to try to find the > discrepancy. The Ending balance is what you should enter from your account > statement or your bank's website. It defaults to the balance of the last > transaction on the date you entered in the Reconciliation date entry. > > When you finish that dialog the reconcile window opens and in the lower > left it shows the balances from the info window followed by Reconciled > balance and Difference, which update as you tick off transactions in the > two panes of the window; you should tick off the transactions that match > your statement, paying close attention to the amounts: Reconciliation is > all about making sure that there aren't any differences. Fix any > differences in the register and press enter to commit the change and it > will be immediately reflected in the reconcile window. Once you have > marked all of the transactions the Ending and Reconciled balances should > match, Difference should be 0, and the Finish button in the toolbar should > be enabled. > > You might not have a transaction balance matching the reconciled balance > if you have unbalanced transactions previous to the last reconciled one. > The "R" column between Transfer Account and Debit/Deposit shows each > transaction's reconciled status: y for reconciled, n for unreconciled, c > for cleared, and v for voided. You can use the the Status page of > View>Filter By... to hide transactions by status. > > Finding reconciliation discrepancies from previous statements can be > extremely tedious and GnuCash doesn't have any tools to help. There's not > even a way to display historical reconciled balances. > > When it comes to fixing discrepancies remember that banks can make errors > too, but you need documentation and time to get the bank to make > corrections. It's up to you to decide whether to pursue getting the bank to > fix their mistake or to take the hit and adjust your accounts to match the > bank's. > > Regards, > John Ralls > > > > > ___ > 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. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:
Re: [GNC] Reconciliation with a strange opening balance
> On Nov 13, 2023, at 07:20, Mahon Finbar via gnucash-user > wrote: > > Hello, > > The recent discussion on reconciliation was helpful in trying to sort out > some anomalies I have. > > When I do the latest reconciliation of one of my accounts the opening balance > is 10,448.43 and gives me an amount of inbalance which is way off. > > Following the advice in the recent posts I tried working backwards to see if > I could find any errors. > > I got close to 0.00 from time to time and was satisfied enough to consider a > balancing entry, but was intrigued on where the 'error' might have been. > > I set off to see where, but, in the course of my search, I tried to find the > number 10,443.43 in the account, as a baseline, but didn't find one. > > If I understand the process of reconciliation the number should be somewhere > in the account, should it not?? > > Just tell me I am barking up the wrong tree, if I am making an error. The reconcile info dialog that comes up when you click the reconcile button has two balances: Starting balance and Ending balance. The first is the reconciled balance for the account, that is the sum of all of the splits in the account marked as reconciled. That's different from the opening balance, which is the amount in the account when you created it in GnuCash. The starting balance should match the starting balance on your statement. If it doesn't then there's a mistake in reconciling a previous statement and you need to either make a correcting entry in your account to get it to match or dig through previous statements to try to find the discrepancy. The Ending balance is what you should enter from your account statement or your bank's website. It defaults to the balance of the last transaction on the date you entered in the Reconciliation date entry. When you finish that dialog the reconcile window opens and in the lower left it shows the balances from the info window followed by Reconciled balance and Difference, which update as you tick off transactions in the two panes of the window; you should tick off the transactions that match your statement, paying close attention to the amounts: Reconciliation is all about making sure that there aren't any differences. Fix any differences in the register and press enter to commit the change and it will be immediately reflected in the reconcile window. Once you have marked all of the transactions the Ending and Reconciled balances should match, Difference should be 0, and the Finish button in the toolbar should be enabled. You might not have a transaction balance matching the reconciled balance if you have unbalanced transactions previous to the last reconciled one. The "R" column between Transfer Account and Debit/Deposit shows each transaction's reconciled status: y for reconciled, n for unreconciled, c for cleared, and v for voided. You can use the the Status page of View>Filter By... to hide transactions by status. Finding reconciliation discrepancies from previous statements can be extremely tedious and GnuCash doesn't have any tools to help. There's not even a way to display historical reconciled balances. When it comes to fixing discrepancies remember that banks can make errors too, but you need documentation and time to get the bank to make corrections. It's up to you to decide whether to pursue getting the bank to fix their mistake or to take the hit and adjust your accounts to match the bank's. Regards, John Ralls ___ 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 with a strange opening balance
One of several complications that you can run into when searching for a reconciliation error by using the reconciliation tool is that GnuCash leaves all previously reconciled split lines assigned to the target account reconciled. Thus if there are reconciled split lines dated after the reconciliation date, they remain reconciled during your search and will be included in the beginning balance calculation. Recent releases of GnuCash do include a reconciliation report, but I have never used it, so I cannot say how useful it might be in a search for errors. On Mon, Nov 13, 2023 at 9:41 AM Maf. King wrote: > On Monday, 13 November 2023 15:20:28 GMT Mahon Finbar via gnucash-user > wrote: > > > > > I set off to see where, but, in the course of my search, I tried to find > > the number 10,443.43 in the account, as a baseline, but didn't find one. > > > > If I understand the process of reconciliation the number should be > > somewhere in the account, should it not?? > > > > or possibly ~5221.70 as a CR when it should be a DR (etc). or several > smaller > errors which total the ~10k discrepancy you are seeing > > Maf. > > > ___ > 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. > -- 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 - 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 with a strange opening balance
On Monday, 13 November 2023 15:20:28 GMT Mahon Finbar via gnucash-user wrote: > > I set off to see where, but, in the course of my search, I tried to find > the number 10,443.43 in the account, as a baseline, but didn't find one. > > If I understand the process of reconciliation the number should be > somewhere in the account, should it not?? > or possibly ~5221.70 as a CR when it should be a DR (etc). or several smaller errors which total the ~10k discrepancy you are seeing Maf. ___ 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, 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
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,
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.
Re: [GNC] Reconciliation Dates
John, Only because when I see an old date, I think I missed reconciling the account and I'm OCD enough that I want the date to be current. Just to show how OCD I am, I created a new parent placeholder account and moved the subaccounts, then I deleted the original parent placeholder account. Now it doesn't have a reconciliation date to bother me. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: john Sent: Thursday, July 20, 2023 1:00 PM To: Gyle McCollam Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Reconciliation Dates > On Jul 20, 2023, at 08:03, Gyle McCollam wrote: > > Is there a way to delete the reconciliation date from accounts you no longer > wish to reconcile? > Not in the UI or even the API. Why would you care that there's a reconciliation date on the account? Regards, John Ralls ___ 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 Dates
> On Jul 20, 2023, at 08:03, Gyle McCollam wrote: > > Is there a way to delete the reconciliation date from accounts you no longer > wish to reconcile? > Not in the UI or even the API. Why would you care that there's a reconciliation date on the account? Regards, John Ralls ___ 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 error - how should I correct?
Yep; when I worked in a bank, we were always having to call people around the beginning of the year to check with them. I remember that we once did find a very old check; if memory serves (it was a LONG time ago), they were on checks in the 1300s, and the old check was from the 100s... and it was years out of date. I think we called the customer to check before we processed it. On Wed, Feb 1, 2023 at 12:39 AM wrote: > On Tue, 31 Jan 2023 12:13:52 -0600 > R Losey wrote: > > > Thanks; I used to work in a bank, and I thought there was a policy > > such as you described... however, I did check with the bank, and they > > indicated that they would honor the check regardless of how old it > > was. They seem to be angling for me to pay them $$$ to stop payment > > on the check, which I'm refusing to do. > > Different jurisdictions, different rules > In AU, there is a time of 15 months and after that the cheque is stale. > It used to be 12, but back in the olden days when people used cheques, > there would always be havoc at the beginning of new year when people > wrote the old year instead. > > Cheque usage in AU, 2019 > https://www.rba.gov.au/speeches/2019/images/sp-gov-2019-12-10-graph07.gif > > For the bored, the legislation is the Cheques Act, 1986 > https://www.legislation.gov.au/Details/C2017C00074 > > > 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 > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- _ 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 error - how should I correct?
Yes; she doesn't want to bother to look; she's not sure if she destroyed it or not. If she would just say one way or the other, it would help. On Tue, Jan 31, 2023 at 12:29 PM Phyllis Bruce wrote: > Wouldn't it just be simpler to ask your sister in law to destroy the check > if she finds it? Then write it off/delete it. > > On Tue, Jan 31, 2023 at 12:14 PM R Losey wrote: > >> Thanks; I used to work in a bank, and I thought there was a policy such as >> you described... however, I did check with the bank, and they indicated >> that they would honor the check regardless of how old it was. They seem >> to >> be angling for me to pay them $$$ to stop payment on the check, which I'm >> refusing to do. >> >> Given their attitude, I'm considering closing the checking account, and >> then opening a new one, so that the check would bounce if ever presented. >> >> >> On Mon, Jan 30, 2023 at 2:50 PM Michael or Penny Novack < >> stepbystepf...@comcast.net> wrote: >> >> > >> > ... regardless of date. >> > >> > > I sent a check to a sister-in-law that she probably won't cash, but >> she >> > > cannot remember what she did with it... so, years later, it is still >> an >> > >> > Uh no, not outstanding indefinitely. >> > >> > This of course is not really a gnucash question but since this question >> > affects reconciliation... >> > >> > By the UCC rules, after six months a bank does not have to accept a >> > check and as a result checks that have not been =returned to your >> > account by that time might be voided in your books. You might want to >> > allow a bit more time than that just to be on the safe side and you >> > should keep in mind that banks are allowed to process checks older than >> > that so CHECK THE POLICY OF YOUR BANK. >> > >> > If I had the problem of a long outstanding check, I'd enter a >> > transaction to void it once it was more than six months old. >> > >> > Michael D Novack >> > >> > >> > PS -- You might sometimes see on a check you receive, "void after 90 >> > days". AFAIK that has no legal standing and the UCC rule of 180 days >> > would apply. >> > >> > >> > ___ >> > 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. >> > >> >> >> -- >> _ >> 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. >> > -- _ 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 - Again
Phyllis, Simon Thanks, that's as I hoped. The heads up on the (potential) problem if the account on the other side of the transaction has also been reconciled has been noted. Thanks again Eric ___ 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 error - how should I correct?
On Tue, 31 Jan 2023 12:13:52 -0600 R Losey wrote: > Thanks; I used to work in a bank, and I thought there was a policy > such as you described... however, I did check with the bank, and they > indicated that they would honor the check regardless of how old it > was. They seem to be angling for me to pay them $$$ to stop payment > on the check, which I'm refusing to do. Different jurisdictions, different rules In AU, there is a time of 15 months and after that the cheque is stale. It used to be 12, but back in the olden days when people used cheques, there would always be havoc at the beginning of new year when people wrote the old year instead. Cheque usage in AU, 2019 https://www.rba.gov.au/speeches/2019/images/sp-gov-2019-12-10-graph07.gif For the bored, the legislation is the Cheques Act, 1986 https://www.legislation.gov.au/Details/C2017C00074 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 - 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 error - how should I correct?
Welcome to the world of tracking your dollars! On Tue, Jan 31, 2023 at 1:50 PM Dr. David Kirkby < drkir...@kirkbymicrowave.co.uk> wrote: > On Mon, 30 Jan 2023 at 16:41, Phyllis Bruce wrote: > >> Dr. Kirby, >> >> I'm praying your problem is getting away from paper reconciliation. >> Remember how we used to turn the page over and list the items NOT on the >> bank statements? > > > No, because I have never before attempted reconciling a bank account. My > process in the past has always been one of scanning the bank statement to > see if anything looked suspicious, rather than actually checking if it was > right. > > I spotted when a company set up a scam direct debit for £4, but to be > honest if a transaction to a regular supplier like RS Components was £100 > too high, I would most likely not noticed. > > Dave > -- > Dr. David Kirkby, > Kirkby Microwave Ltd, > drkir...@kirkbymicrowave.co.uk > https://www.kirkbymicrowave.co.uk/ > Telephone 01621-680100./ +44 1621 680100 > > Registered in England & Wales, company number 08914892. > Registered office: > Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, > United Kingdom > ___ 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 error - how should I correct?
Wouldn't it just be simpler to ask your sister in law to destroy the check if she finds it? Then write it off/delete it. On Tue, Jan 31, 2023 at 12:14 PM R Losey wrote: > Thanks; I used to work in a bank, and I thought there was a policy such as > you described... however, I did check with the bank, and they indicated > that they would honor the check regardless of how old it was. They seem to > be angling for me to pay them $$$ to stop payment on the check, which I'm > refusing to do. > > Given their attitude, I'm considering closing the checking account, and > then opening a new one, so that the check would bounce if ever presented. > > > On Mon, Jan 30, 2023 at 2:50 PM Michael or Penny Novack < > stepbystepf...@comcast.net> wrote: > > > > > ... regardless of date. > > > > > I sent a check to a sister-in-law that she probably won't cash, but she > > > cannot remember what she did with it... so, years later, it is still an > > > > Uh no, not outstanding indefinitely. > > > > This of course is not really a gnucash question but since this question > > affects reconciliation... > > > > By the UCC rules, after six months a bank does not have to accept a > > check and as a result checks that have not been =returned to your > > account by that time might be voided in your books. You might want to > > allow a bit more time than that just to be on the safe side and you > > should keep in mind that banks are allowed to process checks older than > > that so CHECK THE POLICY OF YOUR BANK. > > > > If I had the problem of a long outstanding check, I'd enter a > > transaction to void it once it was more than six months old. > > > > Michael D Novack > > > > > > PS -- You might sometimes see on a check you receive, "void after 90 > > days". AFAIK that has no legal standing and the UCC rule of 180 days > > would apply. > > > > > > ___ > > 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. > > > > > -- > _ > 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. > ___ 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 error - how should I correct?
I agree that the statement is misleading... all it is trying to say is that if you reconcile a balance to $1000 and then add a transaction before the reconciliation date, the balance will change... (that is, if you add a $50 check, the balance will be $950 now instead of the $1000 you used. For me, this is useless, as I do not reconcile my GnuCash account balance to the bank account balance; for years (longer than I have used GnuCash), I have reconciled the bank balance to my GnuCash balance. I have found it a much easier way. There is no problem with adding transactions prior to the reconciliation date, as long as they are un-reconciled transactions (and that is the default). There are potential problems when altering a reconciled transaction... I had horrible problems with this is Quicken, but GnuCash seems to deal with such cases better. On Tue, Jan 31, 2023 at 3:34 AM Dr. David Kirkby < drkir...@kirkbymicrowave.co.uk> wrote: > On Mon, 30 Jan 2023 at 19:46, R Losey wrote: > >> Normally, people 'reconcile' their records to the financial institution, >> marking the ones on which they agree as 'reconciled'. >> >> If everything went right, the accounts should balance, leaving the >> transactions that the bank doesn't know about... regardless of date. >> > > I was probably interpreting this > > https://cvs.gnucash.org/docs/C/gnucash-guide/txns-reconcile1.html > > incorrectly, where it says > > “ > Warning > > It is important to understand that reconciliation is done for a given > date, and when you reconcile an account based on a statement from a given > date, you are reconciling *all transactions prior to that date*. > Therefore, if you add or modify transactions that predate your last > reconciliation, your *reconciled* balances will be thrown off.” > > As far as I am aware, the transaction took place in June. So to add the > entry to GnuCash I needed to add a transaction that occurred prior to the > last reconciliation. > > I note that bit of the documentation starts cvs. Google found me that, but > I think the latest documentation doesn’t say quite the same thing. > > Dave > -- > Dr. David Kirkby, > Kirkby Microwave Ltd, > drkir...@kirkbymicrowave.co.uk > https://www.kirkbymicrowave.co.uk/ > Telephone 01621-680100./ +44 1621 680100 > > Registered in England & Wales, company number 08914892. > Registered office: > Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, > United Kingdom > -- _ 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 error - how should I correct?
On Mon, 30 Jan 2023 at 16:41, Phyllis Bruce wrote: > Dr. Kirby, > > I'm praying your problem is getting away from paper reconciliation. > Remember how we used to turn the page over and list the items NOT on the > bank statements? No, because I have never before attempted reconciling a bank account. My process in the past has always been one of scanning the bank statement to see if anything looked suspicious, rather than actually checking if it was right. I spotted when a company set up a scam direct debit for £4, but to be honest if a transaction to a regular supplier like RS Components was £100 too high, I would most likely not noticed. Dave -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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 error - how should I correct?
Thanks; I used to work in a bank, and I thought there was a policy such as you described... however, I did check with the bank, and they indicated that they would honor the check regardless of how old it was. They seem to be angling for me to pay them $$$ to stop payment on the check, which I'm refusing to do. Given their attitude, I'm considering closing the checking account, and then opening a new one, so that the check would bounce if ever presented. On Mon, Jan 30, 2023 at 2:50 PM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > > ... regardless of date. > > > I sent a check to a sister-in-law that she probably won't cash, but she > > cannot remember what she did with it... so, years later, it is still an > > Uh no, not outstanding indefinitely. > > This of course is not really a gnucash question but since this question > affects reconciliation... > > By the UCC rules, after six months a bank does not have to accept a > check and as a result checks that have not been =returned to your > account by that time might be voided in your books. You might want to > allow a bit more time than that just to be on the safe side and you > should keep in mind that banks are allowed to process checks older than > that so CHECK THE POLICY OF YOUR BANK. > > If I had the problem of a long outstanding check, I'd enter a > transaction to void it once it was more than six months old. > > Michael D Novack > > > PS -- You might sometimes see on a check you receive, "void after 90 > days". AFAIK that has no legal standing and the UCC rule of 180 days > would apply. > > > ___ > 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. > -- _ 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 - Again
I'm confident that informational stuff, and the date, are irrelevant to reconciliation. And many times, the transfer field won't matter. BUT, if the transfer field is another account subject to reconciliation, and that transaction has been reconciled in the other account (e.g. you made a literal transfer from one account to another and it's all "gone through") then you'll likely have some issues. But, if you successfully reconciled that transaction on both sides... it can't possibly need you to change the transfer account, so if what you're proposing is logically correct, then I think it should be safe too. Reconciliation, to my perspective, is simply the process of ensuring that you and the bank agree on the transactions, and their amounts, that you both think have happened. It doesn't matter if you have different descriptions, or even dates so long as you correctly identify the two records (yours and theirs) that represent the same actual transaction. Open to being corrected, of course :) On Tue, Jan 31, 2023 at 9:20 AM Eric Coates via gnucash-user < gnucash-user@gnucash.org> wrote: > Good Afternoon > > I fully understand that changing the Payment/Charge (on a credit card > account) or the Increase/Decrease (on a bank account) will create > difficulties with future reconciliations. > > However, is it possible to change the contents of other fields (Date, > Description and, particularly, Transfer) without causing problems? > > Thanks > > Eric > > > ___ > 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. > -- Simon Roberts (303) 249 3613 ___ 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 - Again
I've not had a problem when changing any of those fields. You are really only reconciling the one account. On Tue, Jan 31, 2023 at 10:21 AM Eric Coates via gnucash-user < gnucash-user@gnucash.org> wrote: > Good Afternoon > > I fully understand that changing the Payment/Charge (on a credit card > account) or the Increase/Decrease (on a bank account) will create > difficulties with future reconciliations. > > However, is it possible to change the contents of other fields (Date, > Description and, particularly, Transfer) without causing problems? > > Thanks > > Eric > > > ___ > 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 error - how should I correct?
On Mon, 30 Jan 2023 at 19:46, R Losey wrote: > Normally, people 'reconcile' their records to the financial institution, > marking the ones on which they agree as 'reconciled'. > > If everything went right, the accounts should balance, leaving the > transactions that the bank doesn't know about... regardless of date. > I was probably interpreting this https://cvs.gnucash.org/docs/C/gnucash-guide/txns-reconcile1.html incorrectly, where it says “ Warning It is important to understand that reconciliation is done for a given date, and when you reconcile an account based on a statement from a given date, you are reconciling *all transactions prior to that date*. Therefore, if you add or modify transactions that predate your last reconciliation, your *reconciled* balances will be thrown off.” As far as I am aware, the transaction took place in June. So to add the entry to GnuCash I needed to add a transaction that occurred prior to the last reconciliation. I note that bit of the documentation starts cvs. Google found me that, but I think the latest documentation doesn’t say quite the same thing. Dave -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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 error - how should I correct?
Reconciliation verifies that: Opening Balance + *listed* transactions = Ending Balance That is all. Sometimes, banks don't clear transactions in the same period they were submitted. It appears in this case, it cleared an entire period late. You were able to reconcile June & July because the bank didn't think it existed yet either, till August. If you or they *did* have the transaction in your respective books, then you either could not have reconciled without an adjustement, or you'd still have that transaction as pending and not yet cleared. In this case, you just need to add it and it will reconcile in August, because that is when it cleared the bank. (you can still enter it as the original effective date if that is what you want) Regards, Adrien On 1/30/23 5:28 AM, Dr. David Kirkby wrote: I was under the impression that the reconciliation should record all transactions up to the date one reconciles. Clearly one had been missed, so I thought that was an error. But from what you say it is not. ___ 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 error - how should I correct?
... regardless of date. I sent a check to a sister-in-law that she probably won't cash, but she cannot remember what she did with it... so, years later, it is still an Uh no, not outstanding indefinitely. This of course is not really a gnucash question but since this question affects reconciliation... By the UCC rules, after six months a bank does not have to accept a check and as a result checks that have not been =returned to your account by that time might be voided in your books. You might want to allow a bit more time than that just to be on the safe side and you should keep in mind that banks are allowed to process checks older than that so CHECK THE POLICY OF YOUR BANK. If I had the problem of a long outstanding check, I'd enter a transaction to void it once it was more than six months old. Michael D Novack PS -- You might sometimes see on a check you receive, "void after 90 days". AFAIK that has no legal standing and the UCC rule of 180 days would apply. ___ 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 error - how should I correct?
Normally, people 'reconcile' their records to the financial institution, marking the ones on which they agree as 'reconciled'. If everything went right, the accounts should balance, leaving the transactions that the bank doesn't know about... regardless of date. I sent a check to a sister-in-law that she probably won't cash, but she cannot remember what she did with it... so, years later, it is still an unreconciled item every time I balance the account. On Mon, Jan 30, 2023 at 5:29 AM Dr. David Kirkby < drkir...@kirkbymicrowave.co.uk> wrote: > On Mon, 30 Jan 2023 at 03:49, Jim DeLaHunt wrote: > > > On 2023-01-29 17:34, Dr. David Kirkby wrote: > > > > > I've reconciled my bank account until the end of July 2022, but then > > found > > > a bill from a vendor which was paid from the bank account in August, > but > > > the transaction occurred in June. So really I want to create a bill in > > > June. > > > > In what sense is this a "reconciliation error"? > > > I was under the impression that the reconciliation should record all > transactions up to the date one reconciles. Clearly one had been missed, > so I thought that was an error. But from what you say it is not. > > The amount is correct, so I'll just add the transaction in. That's a bit of > a relief. > > I must say, I am impressed with the software and the support. I have found > a few bugs, but once reported they get fixed. > ___ > 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. > -- _ 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 error - how should I correct?
Dr. Kirby, I'm praying your problem is getting away from paper reconciliation. Remember how we used to turn the page over and list the items NOT on the bank statements? Gnu does that automatically. You reconcile to your bank statement so that the difference on your reconciliation screen shows a $0 difference. It is VERY common to have outstanding checks. HTH further, Po On Mon, Jan 30, 2023 at 9:31 AM Stephen wrote: > Presumably you are on a cash basis. If not then stop reading here. If on > a cash basis then you (your bank) paid the bill in August, regardless of > when you received the bill. Why do you say the transaction occurred in > June? Maybe the work was done/goods were delivered, etc. but the bill > was paid in August. Enter the bill payment on the date it was paid and > reconcile your account with your August bank statement per usual > procedures. If you want to you can memo the payment with a note about > when the work was done (June). You can include invoice # etc etc. Not a > reconciliation error. Am I missing something? > > On 1/30/2023 5:28 AM, Dr. David Kirkby wrote: > > On Mon, 30 Jan 2023 at 03:49, Jim DeLaHunt > wrote: > > > >> On 2023-01-29 17:34, Dr. David Kirkby wrote: > >> > >>> I've reconciled my bank account until the end of July 2022, but then > >> found > >>> a bill from a vendor which was paid from the bank account in August, > but > >>> the transaction occurred in June. So really I want to create a bill in > >>> June. > >> In what sense is this a "reconciliation error"? > > > > I was under the impression that the reconciliation should record all > > transactions up to the date one reconciles. Clearly one had been missed, > > so I thought that was an error. But from what you say it is not. > > > > The amount is correct, so I'll just add the transaction in. That's a bit > of > > a relief. > > > > I must say, I am impressed with the software and the support. I have > found > > a few bugs, but once reported they get fixed. > > ___ > > 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 error - how should I correct?
Presumably you are on a cash basis. If not then stop reading here. If on a cash basis then you (your bank) paid the bill in August, regardless of when you received the bill. Why do you say the transaction occurred in June? Maybe the work was done/goods were delivered, etc. but the bill was paid in August. Enter the bill payment on the date it was paid and reconcile your account with your August bank statement per usual procedures. If you want to you can memo the payment with a note about when the work was done (June). You can include invoice # etc etc. Not a reconciliation error. Am I missing something? On 1/30/2023 5:28 AM, Dr. David Kirkby wrote: On Mon, 30 Jan 2023 at 03:49, Jim DeLaHunt wrote: On 2023-01-29 17:34, Dr. David Kirkby wrote: I've reconciled my bank account until the end of July 2022, but then found a bill from a vendor which was paid from the bank account in August, but the transaction occurred in June. So really I want to create a bill in June. In what sense is this a "reconciliation error"? I was under the impression that the reconciliation should record all transactions up to the date one reconciles. Clearly one had been missed, so I thought that was an error. But from what you say it is not. The amount is correct, so I'll just add the transaction in. That's a bit of a relief. I must say, I am impressed with the software and the support. I have found a few bugs, but once reported they get fixed. ___ 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 error - how should I correct?
On Mon, 30 Jan 2023 at 03:49, Jim DeLaHunt wrote: > On 2023-01-29 17:34, Dr. David Kirkby wrote: > > > I've reconciled my bank account until the end of July 2022, but then > found > > a bill from a vendor which was paid from the bank account in August, but > > the transaction occurred in June. So really I want to create a bill in > > June. > > In what sense is this a "reconciliation error"? I was under the impression that the reconciliation should record all transactions up to the date one reconciles. Clearly one had been missed, so I thought that was an error. But from what you say it is not. The amount is correct, so I'll just add the transaction in. That's a bit of a relief. I must say, I am impressed with the software and the support. I have found a few bugs, but once reported they get fixed. ___ 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 error - how should I correct?
On 2023-01-29 17:34, Dr. David Kirkby wrote: I've reconciled my bank account until the end of July 2022, but then found a bill from a vendor which was paid from the bank account in August, but the transaction occurred in June. So really I want to create a bill in June. In what sense is this a "reconciliation error"? Reconciliation is the process of comparing your records with the bank's records, and dealing with any differences. One class of difference is when your records show a transaction, but the bank's records do not show that transaction. That transaction is left unreconciled. Another class of difference is when both your records and the bank's records show a transaction, but the details (e.g. the amount) differ. That transaction gets corrected in your records, or flagged as a bank error, or something. In this case it looks like your records omitted a transaction from June, and you just now see it in the bank's records from August. Have you reconciled your records with the bank's records from August yet? If so, you should have noticed the transaction in the bank's records. If you have not yet reconciled with the bank's records from August, then now is the time to correct the discrepancy. …What's the best way out of this? First, validate that the bill is valid, that the vendor did issue it, and that it was correct to pay it. If any of those are not true, start a dispute about the error. If they are true, then create a bill in your records dated in June, and record that it was paid from your bank account in August. You got two month's worth of float. Congratulations. Dr David Kirkby Ph.D Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100) Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT. ___ 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 Report
Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. On Wed, Oct 5, 2022, 9:53 AM Nathan Rosenthal wrote: > The first sentence in your reply explains why going back further than the > previous month did not produce any results. > > I will wait until the end of the month when there will be new unreconciled > transactions in the account. > > Nathan > > On 10/4/2022 7:45 PM, David Carlson wrote: > > Once a transaction is reconciled it never appears in a subsequent > reconciliation unless it has been unreconciled. > > Apparently I have never tried running a Reconciliation on an account where > there were no unreconciled transactions at all, which must be what you are > seeing, Try creating a test transaction in that account to see if it > appears when you run the reconciliation.. The date would not be critical > as long as it is newly entered and not reconciled. > > On Tue, Oct 4, 2022 at 6:25 PM Nathan Rosenthal > wrote: > >> Yes there were transactions during the month. In fact I got the same >> response when I used a longer time frame. There was a deposit on 9/12, a >> withdrawal on 9/15, and an interest payment on 9/30. It is really puzzling >> since the reconciliation process works correctly on two checking accounts. >> >> I can set the opening and closing balances and the start and end dates >> but the program still reports no transactions in this account. It is not a >> serious problem because I can always use a spreadsheet to do the >> reconciliation. It would be nice, though, to figure out why I get this >> result. >> >> Nathan >> >> >> >> On 10/4/2022 7:13 PM, David Carlson wrote: >> >> Nathan, Are there actually no transactions in the share account for that >> period? I am surprised that the reconciliation dialog doesn't pop up >> anyway to set the start and end balances. >> >> On Tue, Oct 4, 2022 at 4:21 PM Nathan Rosenthal >> wrote: >> >>> I maintain 2 accounts for an organization I belong to - a checking >>> account at one bank and a share account at a credit union. Each of them >>> has an account in gnucash. When I reconcile the accounts, the checking >>> account reconciliation works properly but the share account >>> reconciliation fails with a "no transactions in the specified period" >>> error message even though I use the same period (monthly) for both >>> accounts. >>> >>> I believe I have set them up properly. I am using ver 4.12 under Windows >>> 10. All other functions seem to work properly. >>> ___ >>> 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. >>> >> >> >> -- >> David Carlson >> >> >> > > -- > 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 - 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 Report
Nathan, Are there actually no transactions in the share account for that period? I am surprised that the reconciliation dialog doesn't pop up anyway to set the start and end balances. On Tue, Oct 4, 2022 at 4:21 PM Nathan Rosenthal wrote: > I maintain 2 accounts for an organization I belong to - a checking > account at one bank and a share account at a credit union. Each of them > has an account in gnucash. When I reconcile the accounts, the checking > account reconciliation works properly but the share account > reconciliation fails with a "no transactions in the specified period" > error message even though I use the same period (monthly) for both > accounts. > > I believe I have set them up properly. I am using ver 4.12 under Windows > 10. All other functions seem to work properly. > ___ > 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. > -- 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 - 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 Report -> Trade Debtors -> pairing transactions
If you are looking for 'aging', that is, how much of an amount owed is say 30days, 60days, or 90+days due, then that is at the bottom each Customer or Vendor report. (and also shows any unused pre-payments/deposits in the case you use that feature) It doesn't show any sort of average, but it does give you the exact amounts and how aged they are. If you want to know the 'average' age of your AR/AP, then most likely you'd have to export those individual reports to a spreadsheet and do some math there. (there might be a way to extract this info via gnucash-cli or piecash and automate this process.) If indeed you're looking for an overall average, that might be a good Request For Enhancement (also to be filed on bugs.gnucash.org) maybe to be added to the Summary Bar for each of the AR/AP accounts, and/or the experimental 'Dashboard' report. Regards, Adrien On 10/3/22 8:50 AM, Uttam Chakravorty wrote: If there is a way to get the average debtor/creditor days this would be the icing on the cake. ___ 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 Report -> Trade Debtors -> pairing transactions
Dear Michael, Many thanks to both you and Adrien. Both the answers are far more considered than my initial comment had intended to provoke, thank you. I had made my original comment by way of explaining how I was approaching the puzzle i.e. in the early eighties I would parse the software through a hexadecimal editor such as Norton and then check the search results in plain English by interrogating the Audit Trail. It seems so primitive compared to what I have just learned. In general today I'm very happy to use the TB as my critical check at the risk of missing out on any reciprocating errors. I find they either prove de minimis or so big that they don't stay hidden. The first part part of what I was seeking has been addressed by Adrien. If there is a way to get the average debtor/creditor days this would be the icing on the cake. Returning to Gnucash I find it the best piece of software I have used in 40yrs and it handles our needs brilliantly. I love the way it sticks to the T-bar principles, I'm sure the Medici would have loved it and could have avoided so much bloodshed. I appreciate it is far more capable than simple bookkeeping, the limitation is that is all I know. I was put out to grass nearly a decade ago and I only get to do this as it is a small business (just my wife and son evangelising Linux - fun but not particularly business-like). The multi-user issues that you recall bring a smile to my face as they can no longer strike terror into my soul. With many thanks and best wishes, Uttam (and a beer or three (who's counting) if you are ever in my neighbourhood) From: Michael or Penny Novack To: Sent: 02/10/2022 3:46 PM Subject: Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions > > And in that case of 'breadcrumbs' the entirety of GnuCash is an audit > trail, as that is how double-entry accounting works. > > If you are looking for some record of exactly who entered which > transactions and the date/time stamps, no, that is not available. > Technically I think the posting date/time does get recorded, but it is > not readily available to users. If you really need it, perhaps start a > thread just on that question. > > Certainly the 'who' will be impossible, because GnuCash is not a > multi-user application. Whomever has access to run the app, and access > to the file, can post or edit transactions. As somebody who used to do this (for one of the world's largest "financials") my comment might (or might not) be useful. a) The accounting system itself (its own reporting functions) would not provide a way of reporting when/who by. It is important to understand that this information is NOT part of the accounting system. Accounting is not a "real time" process nor would who by (what worker bee) be relevant to the question of correctness in an accounting sense. b) But there are OTHER ways in which general ledger might be audited. Internally correct is one matter, but externally correct is another. For example,here we have an invoice marked paid by check. But WAS there actually such a check, and if not, who (falsely) entered that invoice as paid and when. How many of you when first learning to use gnucash created a set of "test books" and into these entered a number of "test transactions"? Understand? There was nothing wrong internally with this set of test books you were using to learn gnucash but they matched nothing in the real world. c) Like I said, there would be no functions PART of the accounting system to be used for this sort of purpose. But when the auditors (checking against the real world) found something suspicious, this sort of problem would come t my desk. "Mike, figure out who entered THIS transaction and when". So I would figure out what feed to the system would have fed that transaction to general ledger, get the right backup tape recovered from the vaults, and with a little "ad hoc" program I'd write for the purpose, get that information. It's not as if I'd be writing a lot of these ad hoc programs from scratch, just take to one I used last time and change a line or two of code. THIS sort of "check against the real world" was rare. I [probably did only a few times a year. More often it was personal and quickly enough after that fact I didn't have to have backups recovered from the vault. Thus suppose I was handed a problem from a client area "here's what one of our worker bees entered but it didn't "take", figure out the bug". Well actually MOST of the time no bug. Just a typo, what was on the piece of paper (as what was entered) didn't match what the worker bee actually entered at the terminal. We all do typos, and that's how I would report the problem as s
Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions
And in that case of 'breadcrumbs' the entirety of GnuCash is an audit trail, as that is how double-entry accounting works. If you are looking for some record of exactly who entered which transactions and the date/time stamps, no, that is not available. Technically I think the posting date/time does get recorded, but it is not readily available to users. If you really need it, perhaps start a thread just on that question. Certainly the 'who' will be impossible, because GnuCash is not a multi-user application. Whomever has access to run the app, and access to the file, can post or edit transactions. As somebody who used to do this (for one of the world's largest "financials") my comment might (or might not) be useful. a) The accounting system itself (its own reporting functions) would not provide a way of reporting when/who by. It is important to understand that this information is NOT part of the accounting system. Accounting is not a "real time" process nor would who by (what worker bee) be relevant to the question of correctness in an accounting sense. b) But there are OTHER ways in which general ledger might be audited. Internally correct is one matter, but externally correct is another. For example,here we have an invoice marked paid by check. But WAS there actually such a check, and if not, who (falsely) entered that invoice as paid and when. How many of you when first learning to use gnucash created a set of "test books" and into these entered a number of "test transactions"? Understand? There was nothing wrong internally with this set of test books you were using to learn gnucash but they matched nothing in the real world. c) Like I said, there would be no functions PART of the accounting system to be used for this sort of purpose. But when the auditors (checking against the real world) found something suspicious, this sort of problem would come t my desk. "Mike, figure out who entered THIS transaction and when". So I would figure out what feed to the system would have fed that transaction to general ledger, get the right backup tape recovered from the vaults, and with a little "ad hoc" program I'd write for the purpose, get that information. It's not as if I'd be writing a lot of these ad hoc programs from scratch, just take to one I used last time and change a line or two of code. THIS sort of "check against the real world" was rare. I [probably did only a few times a year. More often it was personal and quickly enough after that fact I didn't have to have backups recovered from the vault. Thus suppose I was handed a problem from a client area "here's what one of our worker bees entered but it didn't "take", figure out the bug". Well actually MOST of the time no bug. Just a typo, what was on the piece of paper (as what was entered) didn't match what the worker bee actually entered at the terminal. We all do typos, and that's how I would report the problem as solved. No harm done. I probably did a few of THESE per week. It'd have been a waste of programmer time my handing off to one of our programmers to try to find a bug that didn't exist. 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 Report -> Trade Debtors -> pairing transactions
Glad to have pointed you in the right direction. And in that case of 'breadcrumbs' the entirety of GnuCash is an audit trail, as that is how double-entry accounting works. If you are looking for some record of exactly who entered which transactions and the date/time stamps, no, that is not available. Technically I think the posting date/time does get recorded, but it is not readily available to users. If you really need it, perhaps start a thread just on that question. Certainly the 'who' will be impossible, because GnuCash is not a multi-user application. Whomever has access to run the app, and access to the file, can post or edit transactions. *note, on the point of timestamps, I don't think *edits* get a stamp, so only the original entry is dated, which is likely of little 'audit' utility. Perhaps, if you save all log files, you might be able to reconstruct timings of when edits were made, but of course, those logs themselves are editable, so certainly not useful in a real audit. Regards, Adrien On 10/1/22 7:52 PM, Uttam Chakravorty wrote: I used 'breadcrumb' as an alternative to 'audit trail'. ___ 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 Report -> Trade Debtors -> pairing transactions
Dear Adrien Your advice meets all my needs. Many thanks to all the others who offered advice, they add to my knowledge. Its good to know I was peering through the wrong end of the telescope. I used 'breadcrumb' as an alternative to 'audit trail'. Buoyed by the wonderful support I have received I would like to ask the community another question. I will raise it as a separate topic = 'Reconciling subaccounts'. Many thanks again, Uttam From: Adrien Monteleone To: Sent: 30/09/2022 7:23 PM Subject: Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions On 9/30/22 12:48 PM, Uttam Chakravorty wrote: > Dear All, > > I am using the Reconciliation Report configured as: > > > > Accounts = Trade Debtors ->Currency / Display / Filter = defaults -> > General - current period selected -> > > Sorting by Description then Date. > > > Is there a way to use this pool of information and pair a receipt with an > Invoice as per the case when the transaction was entered? If you mean to match up payments with Invoices, yes, but not with that report. What you are looking for is the Customer Report. (Reports > Business > Customer Report — or from an Accounts Payable Report, click an *amount* for a customer.) You'll want to set Options > Display Columns > Transaction Links to either 'simple' or 'detailed' per your preference for the level of information. (I personally like detailed best) Note, this requires using the Business Features to enter invoices & payments. (using the Process Payment feature to link payments to invoices) The result is a Statement of Account type report showing which payments were applied to which invoices & vice versa. > Is there a breadcrumb trail? Not sure what you mean by this. 'Breadcrumbs' leading you from where to where? Regards, Adrien If this email has been sent to you in error please delete it and accept my apologies Company number: 4324700 ___ 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 Report -> Trade Debtors -> pairing transactions
The Business Features handle all of that with ease. There is no need for myriad accounts or convoluted account structure. "invoices as sub-categories for each business"? What is that about? The official process is fairly simple and straightforward. Set up Customers. Post Invoices linked to those Customers for services rendered/goods sold. Process Payments on those invoices. Run a Customer Report to see their balance and activity. (and aging too!) No need for separate accounts under A/R, just create Customers and GnuCash will handle it. Regards, Adrien On 9/30/22 1:35 PM, R Losey wrote: Would it help to have each client as an account? (to easily see the balances) Alternatively, I assume you already ask them to put the invoice number of the receipts, but some do not do so... perhaps when you issue bills, it can have a matching part that they return... this would help you pair invoices with receipts. It would be a lot of accounts, but you could set up invoices as sub-categories for each business. ___ 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 Report -> Trade Debtors -> pairing transactions
Would it help to have each client as an account? (to easily see the balances) Alternatively, I assume you already ask them to put the invoice number of the receipts, but some do not do so... perhaps when you issue bills, it can have a matching part that they return... this would help you pair invoices with receipts. It would be a lot of accounts, but you could set up invoices as sub-categories for each business. On Fri, Sep 30, 2022 at 12:50 PM Uttam Chakravorty wrote: > Dear All, > > I am using the Reconciliation Report configured as: > > > > Accounts = Trade Debtors ->Currency / Display / Filter = defaults -> > General - current period selected -> > > Sorting by Description then Date. > > > Is there a way to use this pool of information and pair a receipt with an > Invoice as per the case when the transaction was entered? > Is there a breadcrumb trail? > Am I going about this the wrong way? > > > Background: we are a small business supporting small businesses. We are > sympathetic to some clients needing to pay us monthly. However simple we > try to be a few still manage to lose their way and then we have to go back > and match receipts to invoices made difficult by the fact that the monthly > sums are the same. The good thing is if we hold their hand eventually they > get organised and the problem goes away. Sadly we have only managed to use > this as an opportunity to move them to Gnucash on only one occasion so > far. We live in hope. > > > -- _ 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 Report -> Trade Debtors -> pairing transactions
On 9/30/22 12:48 PM, Uttam Chakravorty wrote: Dear All, I am using the Reconciliation Report configured as: Accounts = Trade Debtors ->Currency / Display / Filter = defaults -> General - current period selected -> Sorting by Description then Date. Is there a way to use this pool of information and pair a receipt with an Invoice as per the case when the transaction was entered? If you mean to match up payments with Invoices, yes, but not with that report. What you are looking for is the Customer Report. (Reports > Business > Customer Report — or from an Accounts Payable Report, click an *amount* for a customer.) You'll want to set Options > Display Columns > Transaction Links to either 'simple' or 'detailed' per your preference for the level of information. (I personally like detailed best) Note, this requires using the Business Features to enter invoices & payments. (using the Process Payment feature to link payments to invoices) The result is a Statement of Account type report showing which payments were applied to which invoices & vice versa. Is there a breadcrumb trail? Not sure what you mean by this. 'Breadcrumbs' leading you from where to where? 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 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.