Re: [GNC] Getting previous reconciliation closing balances?
On 2019-07-10, Maf. King wrote: ... > If it is proving too hard to find the missing £10 payment, I'd just put one > in > today with notes about "missing transaction. don't know where or when" and > reconcile it in due course - either a special 1-off reconcile or as part of > the next regular cycle. > > usual disclaimer about not an accountant and check local laws, but really, > it's ten quid. It pained me greatly, but that's what I ended up doing! ___ 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] Getting previous reconciliation closing balances?
On 7/10/19 4:33 AM, Adam Funk wrote: > I've tried all the following: > >> or start the reconciliation and see what appears, >> >> or search for a transaction equal to GBP10 >> >> or sort the register by amount and look at transactions equal to GBP10 > ... >>> Try doing a search using the Reconcile field for "Not cleared" or >>> "Cleared" . That should locate any old transactions that were not marked >>> "y". With luck you will find the missed transaction. > > Two errors on my part appear to have coincided: > > 1. I failed to enter a -GBP10.00 transaction; > > 2. I entered a closing balance GBP10.00 too high when reconciling one > of the previous statements. Yea! You found it! (er, them). -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Getting previous reconciliation closing balances?
Sorry about the confusion! What I meant was that it is a British "current account" in GBP, and I was trying to explain that that is the British equivalent of a "checking account". On 2019-07-10, David Carlson wrote: > I believe you mentioned in your original note that it was an American > checking account. If it is denominated in dollars you may have an > additional variable in how you handle exchange rate. > > Also, I sometimes mistakenly assign a purchase to the wrong account, so > there might be a similar error in another account > > David Carlson > > On Wed, Jul 10, 2019, 6:59 AM Maf. King wrote: > >> On Wednesday, 10 July 2019 12:33:48 BST Adam Funk wrote: >> > I've tried all the following: >> > > or start the reconciliation and see what appears, >> > > >> > > or search for a transaction equal to GBP10 >> > > >> > > or sort the register by amount and look at transactions equal to GBP10 >> > >> > ... >> > >> > >> Try doing a search using the Reconcile field for "Not cleared" or >> > >> "Cleared" . That should locate any old transactions that were not >> marked >> > >> "y". With luck you will find the missed transaction. >> > >> > Two errors on my part appear to have coincided: >> > >> > 1. I failed to enter a -GBP10.00 transaction; >> > >> > 2. I entered a closing balance GBP10.00 too high when reconciling one >> > of the previous statements. >> > >> >> If it is proving too hard to find the missing £10 payment, I'd just put >> one in >> today with notes about "missing transaction. don't know where or when" >> and >> reconcile it in due course - either a special 1-off reconcile or as part >> of >> the next regular cycle. >> >> usual disclaimer about not an accountant and check local laws, but really, >> it's ten quid. >> >> 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 >> 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] Getting previous reconciliation closing balances?
On 7/9/19 8:41 AM, Adam Funk wrote: Hi, The problem is that I can't figure out what the missing transaction is! I was hoping to be able to pin it down to one previous statement. What I do when old reconciles get affected by new entries/deletions is look for a previous balance that aligns with an ending balance, then look after that for a change. Usually that gets me to the mystery entry so it can be fixed. If I had deleted an entry that was reconciled in the past, it can no be reconciled up to that month it is in, and then following months are then OK again. ___ 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] Getting previous reconciliation closing balances?
I believe you mentioned in your original note that it was an American checking account. If it is denominated in dollars you may have an additional variable in how you handle exchange rate. Also, I sometimes mistakenly assign a purchase to the wrong account, so there might be a similar error in another account David Carlson On Wed, Jul 10, 2019, 6:59 AM Maf. King wrote: > On Wednesday, 10 July 2019 12:33:48 BST Adam Funk wrote: > > I've tried all the following: > > > or start the reconciliation and see what appears, > > > > > > or search for a transaction equal to GBP10 > > > > > > or sort the register by amount and look at transactions equal to GBP10 > > > > ... > > > > >> Try doing a search using the Reconcile field for "Not cleared" or > > >> "Cleared" . That should locate any old transactions that were not > marked > > >> "y". With luck you will find the missed transaction. > > > > Two errors on my part appear to have coincided: > > > > 1. I failed to enter a -GBP10.00 transaction; > > > > 2. I entered a closing balance GBP10.00 too high when reconciling one > > of the previous statements. > > > > If it is proving too hard to find the missing £10 payment, I'd just put > one in > today with notes about "missing transaction. don't know where or when" > and > reconcile it in due course - either a special 1-off reconcile or as part > of > the next regular cycle. > > usual disclaimer about not an accountant and check local laws, but really, > it's ten quid. > > 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 > 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] Getting previous reconciliation closing balances?
On Wednesday, 10 July 2019 12:33:48 BST Adam Funk wrote: > I've tried all the following: > > or start the reconciliation and see what appears, > > > > or search for a transaction equal to GBP10 > > > > or sort the register by amount and look at transactions equal to GBP10 > > ... > > >> Try doing a search using the Reconcile field for "Not cleared" or > >> "Cleared" . That should locate any old transactions that were not marked > >> "y". With luck you will find the missed transaction. > > Two errors on my part appear to have coincided: > > 1. I failed to enter a -GBP10.00 transaction; > > 2. I entered a closing balance GBP10.00 too high when reconciling one > of the previous statements. > If it is proving too hard to find the missing £10 payment, I'd just put one in today with notes about "missing transaction. don't know where or when" and reconcile it in due course - either a special 1-off reconcile or as part of the next regular cycle. usual disclaimer about not an accountant and check local laws, but really, it's ten quid. 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 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] Getting previous reconciliation closing balances?
I've tried all the following: > or start the reconciliation and see what appears, > > or search for a transaction equal to GBP10 > > or sort the register by amount and look at transactions equal to GBP10 ... >> Try doing a search using the Reconcile field for "Not cleared" or >> "Cleared" . That should locate any old transactions that were not marked >> "y". With luck you will find the missed transaction. Two errors on my part appear to have coincided: 1. I failed to enter a -GBP10.00 transaction; 2. I entered a closing balance GBP10.00 too high when reconciling one of the previous statements. ___ 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] Getting previous reconciliation closing balances?
On 7/9/19 6:41 AM, Adam Funk wrote: > Hi, > > The problem is that I can't figure out what the missing transaction > is! I was hoping to be able to pin it down to one previous > statement. > > Thanks, > Adam > When this happens to me, I print out the entire annual checking account (I presume this is checking, works for Credit card accounts, savings, etc also) from GC and from the bank and compare them line by line. I usually fine one of the following: A. A transaction I had previously entered was removed by me by mistake. B. I updated an already reconciled entry and failed to notice it on the reconciliation window. [Usually I see it and then figure out my beginning balance was off.] C. A new transaction was entered with a really old date. Sometimes I don't realize this and enter the same transaction again with the proper date and then have to hunt down the "old" one. D. My dyslexia messed with either the current or prior reconciliation and I read the numbers wrong or entered them wrong and that's why things are off. It is usually easier to let me wife do the detail work since I'm in the habit of making the same mistake multiple times in a row before spotting it. She takes great pleasure in pointing that out! --Steve PS. If both printouts have the running balance then I've been known to cut the list in half and see if the running balance matches at the half-way point. That usually indicates which half has the problem. Do the same with the remaining half. Iterate until you find the problem transaction (or lack of one). > > On 2019-07-09, David Carlson wrote: > >> Since there is no way to view the reconciliation dates of transactions and >> it rarely matters later, if at all, the easiest thing to do is to ignore >> the error in the starting balance as long as you have entered the missing >> transaction(s) and reconcile them in the current reconciliation to get to >> the correct reconciled balance. >> >> The much more difficult solution would be to try to mark all of last >> month's transactions as unreconciled and repeat last month's reconciliation >> before doing this month's reconciliation. >> >> I think the choice is easy for most users unless they have severe OCD. >> >> David Carlson >> >> On Tue, Jul 9, 2019, 7:48 AM Maf. King wrote: >> >>> On Tuesday, 9 July 2019 13:10:56 BST Adam Funk wrote: Hi, I have somehow managed to miss a GBP10 subtraction from my current account (= American checking account), so I can't reconcile my latest statement. To make matters worse, the opening balance in the reconciliation tool is GBP10 higher than the closing balance of last month's statement. I can't find a discrepancy between my GC account and that statement, so I don't know how far back I made the mistake. Is there any way to get GnuCash to show me previous the opening or closing balances of older reconciliations, so I can pin down the monthly statement where I made the mistake? >>> Hi Adam, >>> >>> there's no way that I can think of to see previous reconcile start/end >>> balances. If you have sufficient backup files, you could look at those >>> and see >>> if they are back in time. >>> >>> do you know the rough date of the payment you missed recording? >>> >>> I can think of a couple of ways through this, of varying degrees of >>> fudge... >>> >>> Maf. >>> >>> >>> >>> -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Getting previous reconciliation closing balances?
Even easier than that is to temporarily change the register view to not show transactions that have a Y in the reconcile field, or start the reconciliation and see what appears, or search for a transaction equal to GBP10 or sort the register by amount and look at transactions equal to GBP10 or think creatively... or let GnuCash automatically enter a correcting transaction to complete the reconciliation On Tue, Jul 9, 2019 at 9:03 AM Dale Alspach wrote: > Try doing a search using the Reconcile field for "Not cleared" or > "Cleared" . That should locate any old transactions that were not marked > "y". With luck you will find the missed transaction. > > Dale > ___ > 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] Getting previous reconciliation closing balances?
Try doing a search using the Reconcile field for "Not cleared" or "Cleared" . That should locate any old transactions that were not marked "y". With luck you will find the missed transaction. Dale ___ 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] Getting previous reconciliation closing balances?
Hi, The problem is that I can't figure out what the missing transaction is! I was hoping to be able to pin it down to one previous statement. Thanks, Adam On 2019-07-09, David Carlson wrote: > Since there is no way to view the reconciliation dates of transactions and > it rarely matters later, if at all, the easiest thing to do is to ignore > the error in the starting balance as long as you have entered the missing > transaction(s) and reconcile them in the current reconciliation to get to > the correct reconciled balance. > > The much more difficult solution would be to try to mark all of last > month's transactions as unreconciled and repeat last month's reconciliation > before doing this month's reconciliation. > > I think the choice is easy for most users unless they have severe OCD. > > David Carlson > > On Tue, Jul 9, 2019, 7:48 AM Maf. King wrote: > >> On Tuesday, 9 July 2019 13:10:56 BST Adam Funk wrote: >> > Hi, >> > >> > I have somehow managed to miss a GBP10 subtraction from my current >> > account (= American checking account), so I can't reconcile my latest >> > statement. To make matters worse, the opening balance in the >> > reconciliation tool is GBP10 higher than the closing balance of last >> > month's statement. I can't find a discrepancy between my GC account >> > and that statement, so I don't know how far back I made the mistake. >> > >> > Is there any way to get GnuCash to show me previous the opening or >> > closing balances of older reconciliations, so I can pin down the >> > monthly statement where I made the mistake? >> > >> Hi Adam, >> >> there's no way that I can think of to see previous reconcile start/end >> balances. If you have sufficient backup files, you could look at those >> and see >> if they are back in time. >> >> do you know the rough date of the payment you missed recording? >> >> I can think of a couple of ways through this, of varying degrees of >> fudge... >> >> 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 >> 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] Getting previous reconciliation closing balances?
Since there is no way to view the reconciliation dates of transactions and it rarely matters later, if at all, the easiest thing to do is to ignore the error in the starting balance as long as you have entered the missing transaction(s) and reconcile them in the current reconciliation to get to the correct reconciled balance. The much more difficult solution would be to try to mark all of last month's transactions as unreconciled and repeat last month's reconciliation before doing this month's reconciliation. I think the choice is easy for most users unless they have severe OCD. David Carlson On Tue, Jul 9, 2019, 7:48 AM Maf. King wrote: > On Tuesday, 9 July 2019 13:10:56 BST Adam Funk wrote: > > Hi, > > > > I have somehow managed to miss a GBP10 subtraction from my current > > account (= American checking account), so I can't reconcile my latest > > statement. To make matters worse, the opening balance in the > > reconciliation tool is GBP10 higher than the closing balance of last > > month's statement. I can't find a discrepancy between my GC account > > and that statement, so I don't know how far back I made the mistake. > > > > Is there any way to get GnuCash to show me previous the opening or > > closing balances of older reconciliations, so I can pin down the > > monthly statement where I made the mistake? > > > Hi Adam, > > there's no way that I can think of to see previous reconcile start/end > balances. If you have sufficient backup files, you could look at those > and see > if they are back in time. > > do you know the rough date of the payment you missed recording? > > I can think of a couple of ways through this, of varying degrees of > fudge... > > 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 > 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.