[GNC] Fwd: Reconciliation mystery - unreconciled transactions in a period that was reconciled.

[David H]

Rogier,

Was there a pic ? The mailing list doesn't allow embedded pics - you need
to attach them as a file or I find that sometimes pasting them into the
email as the very last thing also works.

You could just try re-doing the Dec 2020 reconcile - they should show up
there allowing you to check them off and include them in the Dec 2020
reconcile. What version of GnuCash / what OS are you on - there were issues
ages ago with amending reconciled txns causing the flag to be reset to "u"
?   It seems if your opening balance is correct for Jan (does this come
from a last reconciled record in GnuCash?) you are correct in that they
would have been reconciled previously based on your figures, so must have
been unset by some action - did you update any details on these two txns
after reconciling for December ?

Cheers David H.


On Tue, 21 Dec 2021 at 07:03, Rogier F. van Vlissingen <vliscony at gmail.com>
wrote:

> To: <davidcousens49 at gmail.com>
>
>
> Thanks, I am not totally clear as to what you are saying...
>
> It seems clear that the problem is in December only, and I remember racing
> for the tax deadline ;-) so I may have done something wrong in that last
> reconciliation of the year. But, yes, it is two months ago, and I do not
> have a memory of making the mistake, I am now setting up my 2021 and that's
> when I realized the discrepancy. there was no error with the dates, and the
> two transactions do show up as unreconciled in Jan 31 2021 reconcile.
>
> Here is the pic in Dec 2020 - the two "n" transactions are the 2nd and 3rd
> last, so there was only one final one on 12/31.2020 (not shown in table).
>
> "n" 12/30/2020 $35.88
> "n" 12/31/2020 $99.46
> ending balance $52.03 but statement says $187.37 - difference $135.34,
> which is the total of the two "n" transactions.
>
> mysteriously, the reconcile process thinks the Jan 21 opening balance is
> (correctly) $187.37, so that, if I accept the two "n" transactions, I come
> out wrong, for that opening balance assumes they were already reconciled in
> december, but the register and the trial balance do not reflect it.
>
> In short, if I reconcile them in January, I am perpetuating the mistake.
> So it seems that ideally, I should undo the December reconcile and do it
> again, at which point in time I may have to correct my 2020 filing.
>
> I am not sure if or how I can undo the reconcile for December.
>
> Is it possible that I did the reconciliation, but forgot to save the data
> or some such thing?
>
>
> <
> http://rogierfentenervanvlissingen.me?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=gmail_api&utm_content=thumb
> >
> Rogier Fentener van Vlissingen <http://rogierfentenervanvlissingen.me>
>
> <
> http://rogierfentenervanvlissingen.me?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=gmail_api&utm_content=thumb
> >
>
>
> On Sun, Dec 19, 2021 at 5:29 PM <davidcousens49 at gmail.com> wrote:
>
> > Rogier,
> >
> > It would appear on the surface that somehow you did not reconcile the two
> > transactions which remained marked as "n" which means not cleared("c) or
> > not
> > reconciled("y").  How ? Unfortunately without knowing exactly what you
> did
> > during the reconciliation process it will be hard for anyone to tell.
> > Obvious
> > things are to check the dates on the two transactions to make sure they
> > are in
> > the reconciliation period and check that any transactions after the end
> of
> > the
> > reconciliation date are not marked with "y". A common error is entering
> the
> > wrong year when entering the transaction.  Any unreconciled transactions
> > from
> > earlier periods should show up in the reconcilation window panes.
> >
> > That the balances add up with the two un reconciled transactions suggest
> > opening
> > the reconciliation process again and seeing if the two unmarked
> > transactions
> > appear in it.
> >
> > David Cousens
> >
> > On Sun, 2021-12-19 at 16:42 -0500, Rogier F. van Vlissingen wrote:
> > > A while ago, I set up a business in Gnucash after having some
> outrageous
> > > problems with QBO.
> > >
> > > Once I got going it all worked out OK, but it appears I may have made
> > some
> > > mistakes in the end and I cannot comprehend how I might have done it or
> > how
> > > to fix them.
> > >
> > > The primary tipoff was that I did all my reconciliations of three
> > accounts
> > > and as it was, the bank account ended up with a $187.37 balance on
> > > 12/31/20, however the account register shows to transactions that are
> > still
> > > showing "n" for unreconciled, and the balance at 12/31/20 shows $52.03
> > and
> > > the two "n" transactions account for the difference, $135.34. But why
> do
> > > they show "n" and is the ending balance $52.03???
> > >
> > > I have not been able to figure out a way to fix this.
> > >
> > > Evidently, the result is a minor error in my final reports of 2020, and
> > > hence in my tax filing.
> > >
> > >
> > > <
> > >
> >
> http://rogierfentenervanvlissingen.me?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=gmail_api&utm_content=thumb
> > > >
> > > Rogier Fentener van Vlissingen <http://rogierfentenervanvlissingen.me>
> > >
> > > <
> > >
> >
> http://rogierfentenervanvlissingen.me?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=gmail_api&utm_content=thumb
> > > >
> > > _______________________________________________
> > > gnucash-user mailing list
> > > gnucash-user at 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 at 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 at 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.
>