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

Mon Dec 20 22:32:34 EST 2021

To: David H <hellvee at gmail.com>

Oh, the pic was just my sig, irrelevant.

on Gnucash 3.8 Linux Mint 20.2 Cinnamon.

What happened is a mystery to me. I was racing for the tax deadline, and
all I did was enter a whole year pretty quickly and reconcile the accounts
every month, When Dec was reconciled I shipped it off to the accountant,
and never noticed the problem, so it existed right then, for in the reports
the closing balance of that account was 52.03 and not 187.37, yet the
reconciliation in January shows an opening balance of 187.37.

I have no idea how I get to re-do the december reconcile?
do I reset the year to 2020 and then simply go back to the reconciliation?
Or do I need to manually reset the transactions somehow?

On Mon, Dec 20, 2021 at 6:37 PM David H <hellvee at gmail.com> wrote:

> 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?
>>
>>
>>
>> Rogier Fentener van Vlissingen <http://rogierfentenervanvlissingen.me>
>>
>>
>>
>> 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.
>> > >
>> > >
>> > > <
>> > >
>>
>> > > >
>> > > Rogier Fentener van Vlissingen <http://rogierfentenervanvlissingen.me
>> >
>> > >
>> > > <
>> > >
>>
>> > > >
>> > > _______________________________________________
>> > > 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.
>>
>