Account Register and Reconciliation Issue

I'm working on catching up and cleaning up books for my employer. They have never reconciled their assets and liability accounts despite using them as a holding place for all their policy sales and claim payouts. I have started to clean this up and I'm running into an issue I've never seen before in QBO.

The balance on the balance sheet from 2020-2022 doesn't match the all the transactions that are present in the reconciliation queue for that account. There is over an $8000 difference (a lot of transactions) Everything is checked off "C" on both the debits and credits sides.

Next, I went into the account register and placed the transactions in order by reconciliation status. The transactions fall in order by reconciliation status and then by date so it is very easy to look at the time period in question and see every transaction that is missing the "C" from the reconciliation status column. Obviously, they are the ones missing from the reconciliation queue. I have never seen this glitch.

The only way I have been able to make the missing transaction pop back into the reconciliation queue is to change the vendor account to someone else and save it and then go back into the same transaction and change it back to the correct vendor. This is too inefficient of a processes for this many transactions. Has this happened to anyone before? Is there a faster way for me to get this done?