[GNC] Undo a reconciliation?
Hi all, question from my bookkeeper. She performed a reconciliation, but had not added an interest payment to the account. Because of that the reconciliation was wrong. For reasons that went unnoticed, and likely cannot be reproduced, the process completed, leaving the "y" in the appropriate column. We managed to undo this by clicking on all the "y" entries and reverting them. This was not a big deal since this particular account, this particular time, had only two transactions and the interest payment (well, that's three transactions :) But, if this happened with dozens of transactions, reverting each one by hand would be horrible, and likely error prone too. Is there a proper/better way to do this? TIA, Simon -- 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] Undo a reconciliation?
Yu could just add the interest payment and redo the reconciliation with the same date. The items that were previously reconciled won't show up, but the added interest payment will. Gnucash doesn't care how many times you reconcile to a date. If you/she had noticed this before the reconciliation was completed, you could select postpone and redo it after entering the interest payment. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of Simon Roberts Sent: Monday, January 2, 2023 1:05 PM To: Gnucash Users Subject: [GNC] Undo a reconciliation? Hi all, question from my bookkeeper. She performed a reconciliation, but had not added an interest payment to the account. Because of that the reconciliation was wrong. For reasons that went unnoticed, and likely cannot be reproduced, the process completed, leaving the "y" in the appropriate column. We managed to undo this by clicking on all the "y" entries and reverting them. This was not a big deal since this particular account, this particular time, had only two transactions and the interest payment (well, that's three transactions :) But, if this happened with dozens of transactions, reverting each one by hand would be horrible, and likely error prone too. Is there a proper/better way to do this? TIA, Simon -- 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. ___ 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] Undo a reconciliation?
Oh, thanks Gyle, that seems much simpler. On Mon, Jan 2, 2023 at 11:40 AM Gyle McCollam wrote: > Yu could just add the interest payment and redo the reconciliation with > the same date. The items that were previously reconciled won't show up, > but the added interest payment will. Gnucash doesn't care how many times > you reconcile to a date. If you/she had noticed this before the > reconciliation was completed, you could select postpone and redo it after > entering the interest payment. > > Thank You, > > *Gyle McCollam* > > Gyle McCollam > > gmccol...@live.comemail > -- > *From:* gnucash-user > on behalf of Simon Roberts > *Sent:* Monday, January 2, 2023 1:05 PM > *To:* Gnucash Users > *Subject:* [GNC] Undo a reconciliation? > > Hi all, question from my bookkeeper. > > She performed a reconciliation, but had not added an interest payment to > the account. Because of that the reconciliation was wrong. For reasons that > went unnoticed, and likely cannot be reproduced, the process completed, > leaving the "y" in the appropriate column. > > We managed to undo this by clicking on all the "y" entries and reverting > them. This was not a big deal since this particular account, this > particular time, had only two transactions and the interest payment (well, > that's three transactions :) But, if this happened with dozens of > transactions, reverting each one by hand would be horrible, and likely > error prone too. Is there a proper/better way to do this? > > TIA, > Simon > > > -- > 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. > -- 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] Undo a reconciliation?
Simon I don't think there is any need to undo and redo the complete reconciliation. Just add the correcting transaction and rerun the reconciliation. By default the parameters are set for the next reconciliation, but you can reset the statement date and ending balance to that for the current reconciliation and just check the additional transactions you have added which will now appear unchecked in the reconciliation dialogue and complete the process to reconcile them. I David Cousens On Mon, 2023-01-02 at 11:05 -0700, Simon Roberts wrote: > Hi all, question from my bookkeeper. > > She performed a reconciliation, but had not added an interest payment to > the account. Because of that the reconciliation was wrong. For reasons that > went unnoticed, and likely cannot be reproduced, the process completed, > leaving the "y" in the appropriate column. > > We managed to undo this by clicking on all the "y" entries and reverting > them. This was not a big deal since this particular account, this > particular time, had only two transactions and the interest payment (well, > that's three transactions :) But, if this happened with dozens of > transactions, reverting each one by hand would be horrible, and likely > error prone too. Is there a proper/better way to do this? > > TIA, > Simon > > ___ 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] Undo a reconciliation?
Simon, I should have mentioned that when you select reconciliation on an account the dialogue box has a button you can click on to "Enter Interest Payment...". From there you can enter your interest payment if you have forgotten to previously. Also, if your financial institution allows you to export your transactions, you can import them into Gnucash. You can then show matching transactions that you have entered during the month (checkbox at the bottom) and it will show any transactions that the institution has that you may have forgotten to enter. You will be able to specify the expense/income account it should be posted to as well. There is another checkbox to do the reconciliation once the import is finished if you want to do that or you can let the items be marks as cleared until you are ready to reconcile. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: Simon Roberts Sent: Monday, January 2, 2023 1:53 PM To: Gyle McCollam Cc: Gnucash Users Subject: Re: [GNC] Undo a reconciliation? Oh, thanks Gyle, that seems much simpler. On Mon, Jan 2, 2023 at 11:40 AM Gyle McCollam mailto:gmccol...@live.com>> wrote: Yu could just add the interest payment and redo the reconciliation with the same date. The items that were previously reconciled won't show up, but the added interest payment will. Gnucash doesn't care how many times you reconcile to a date. If you/she had noticed this before the reconciliation was completed, you could select postpone and redo it after entering the interest payment. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user mailto:gmail@gnucash.org>> on behalf of Simon Roberts mailto:si...@dancingcloudservices.com>> Sent: Monday, January 2, 2023 1:05 PM To: Gnucash Users mailto:gnucash-user@gnucash.org>> Subject: [GNC] Undo a reconciliation? Hi all, question from my bookkeeper. She performed a reconciliation, but had not added an interest payment to the account. Because of that the reconciliation was wrong. For reasons that went unnoticed, and likely cannot be reproduced, the process completed, leaving the "y" in the appropriate column. We managed to undo this by clicking on all the "y" entries and reverting them. This was not a big deal since this particular account, this particular time, had only two transactions and the interest payment (well, that's three transactions :) But, if this happened with dozens of transactions, reverting each one by hand would be horrible, and likely error prone too. Is there a proper/better way to do this? TIA, Simon -- Simon Roberts (303) 249 3613 ___ gnucash-user mailing list gnucash-user@gnucash.org<mailto: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] Undo a reconciliation?
Thanks again Gyle and David. This is making good sense now, much appreciated! Cheers, Simon On Mon, Jan 2, 2023 at 1:59 PM Gyle McCollam wrote: > Simon, > I should have mentioned that when you select reconciliation on an account > the dialogue box has a button you can click on to "Enter Interest > Payment...". From there you can enter your interest payment if you have > forgotten to previously. Also, if your financial institution allows you to > export your transactions, you can import them into Gnucash. You can then > show matching transactions that you have entered during the month (checkbox > at the bottom) and it will show any transactions that the institution has > that you may have forgotten to enter. You will be able to specify the > expense/income account it should be posted to as well. There is another > checkbox to do the reconciliation once the import is finished if you want > to do that or you can let the items be marks as cleared until you are ready > to reconcile. > > Thank You, > > *Gyle McCollam* > > Gyle McCollam > > gmccol...@live.comemail > -- > *From:* Simon Roberts > *Sent:* Monday, January 2, 2023 1:53 PM > *To:* Gyle McCollam > *Cc:* Gnucash Users > *Subject:* Re: [GNC] Undo a reconciliation? > > Oh, thanks Gyle, that seems much simpler. > > > On Mon, Jan 2, 2023 at 11:40 AM Gyle McCollam wrote: > > Yu could just add the interest payment and redo the reconciliation with > the same date. The items that were previously reconciled won't show up, > but the added interest payment will. Gnucash doesn't care how many times > you reconcile to a date. If you/she had noticed this before the > reconciliation was completed, you could select postpone and redo it after > entering the interest payment. > > Thank You, > > *Gyle McCollam* > > Gyle McCollam > > gmccol...@live.comemail > ---------- > *From:* gnucash-user > on behalf of Simon Roberts > *Sent:* Monday, January 2, 2023 1:05 PM > *To:* Gnucash Users > *Subject:* [GNC] Undo a reconciliation? > > Hi all, question from my bookkeeper. > > She performed a reconciliation, but had not added an interest payment to > the account. Because of that the reconciliation was wrong. For reasons that > went unnoticed, and likely cannot be reproduced, the process completed, > leaving the "y" in the appropriate column. > > We managed to undo this by clicking on all the "y" entries and reverting > them. This was not a big deal since this particular account, this > particular time, had only two transactions and the interest payment (well, > that's three transactions :) But, if this happened with dozens of > transactions, reverting each one by hand would be horrible, and likely > error prone too. Is there a proper/better way to do this? > > TIA, > Simon > > > -- > 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. > > > > -- > Simon Roberts > (303) 249 3613 > > -- 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.