Clearing Account Manual Reconciliation limitation

Summary:

We have some 100,000 plus transactions between Oct-21  to Mar-23 which are in unreconciled status. 

It does not get picked up by clearing account automatic reconciliation process as reconciliation reference do not match (which is default requirement for automatic reconciliation process) Though the Manage Clearing account rule is defined and set only for company and account.

But still due to default behavior of the automatic reconciliation process these do not get picked up.

 

We cannot do manual reconciliation also as though manual reconciliation does not have any such restriction of reconciliation reference to match but since record count is large we cannot reconcile in spreadsheet as there is a limitation of only 20,000 records.