I have a similar situation, and I know what you're trying to do. I want my online banking account balances to be in-sync, all the time.
We have some expenses from similar time periods that appear to be duplicate recording of the expense.
Some, I can't tell because we were using Desktop version during those years.
In an effort to not have to amend our tax returns for those years, I believe the only proper way to handle this is to make an adjusting journal entry to either 2022 or 2023 and re-capture those prior expenses as income.
Your question about a mid-cycle reconciliation is easy to do if it's a credit card, for example. Grab your online balance as of Today's Date, and create a reconciliation for the account with the balance you believe to be current with the date of your reconciliation - which isn't the actual statement.
The AJE you made earlier will allow you to reconcile all of those old transactions with a Net Zero (If you did your math correctly).
