How do we filter out some matched transactions from balance explanations in custom solution

Summary:

How do we fix this issue?

We are using a custom solution so that we can match on transactions using functional currency. So, we are using a query and report of unmatched transactions and using it to automatically load balance explanations to the Account Analysis Reconciliations with Transaction Matching.

In accordance with Golden Balancing Rule #5, we need some matched transactions:

A. Filter in transactions with accounting dates up to the period end date that are matched with transactions with accounting dates after the period end date (we get all 50K of these)

B. Filter out transactions with accounting dates up to the period end date that are only matched with other transactions with accounting dates up to the period end date (this is where we filtered out 345K of 350K transactions).