I've never tried this before, but I think you should be able to fix this by entering the purged unreconciled items as "Beginning Transactions".

In the Account Reconciliation window there's a Beginning Transactions button in the bottom right corner, just below the unreconciled difference. If you don't see it there, click the double arrow button that is in the bottom left corner to expand that section.

In the Beginning Transactions window you can enter outstanding checks and deposits in transit. These transactions don't affect the general ledger. Normally this screen is only used when you first set up your company in Sage 50 to enter the outstanding items dated prior to your conversion date. But it should work in this situation too.

I've never tried this before, but I think you should be able to fix this by entering the purged unreconciled items as "Beginning Transactions".

In the Account Reconciliation window there's a Beginning Transactions button in the bottom right corner, just below the unreconciled difference. If you don't see it there, click the double arrow button that is in the bottom left corner to expand that section.

In the Beginning Transactions window you can enter outstanding checks and deposits in transit. These transactions don't affect the general ledger. Normally this screen is only used when you first set up your company in Sage 50 to enter the outstanding items dated prior to your conversion date. But it should work in this situation too.

Hey Stephen yes thank you so much that worked perfectly. We also had an issue where all the AP vendors defaulted to the same expense account. I exported from the previous company file and imported to the new company file and seems to have straightened that out. The crew is here is now very weary something else is going to be out of place. =0

Thank you - I appreciate the suggestion.  I will try it when I get back from a couple of days off.  Part of the current problem is an "attack" on transactions from 2018 and I am suspecting 2017.  We are currently in 2020, I can't get back into those periods to fix it.

Do you understand my frustration and simmering anger at this situation?  It is nothing I have done, yet I feel as though it is my fault because as the accountant here these numbers are my responsibility.  I have used the chat line in the past and been "informed" I obviously did something wrong - Really? - or don't know what I am doing.  Both times by someone who literally answered my question by rearranging the words and saying it back to me.  I hung up.

I have had about 4 people on chat line who actually seem to understand my problem and either worked through it with me or passed me on to someone who could help, generally in I.T.  I do not call to ask how to do my job - I call because there is a legitmate mess on the system.