How to create a report that compares data across Match Types?

Summary:

PROBLEM

We occasionally have merchant files that get updated without us knowing, but they don’t cause the DLR to error. So we end up with missing data in ARCS.

In our previous system, we had a check built in that would make sure the total amount of the items from the merchant would ultimately match against the bank deposit for that merchant.

We’re trying to create a similar check in ARCS by comparing the Bank Deposit (e.g. from AMEX) from MATCH TYPE A to the total activity from a given data source (e.g. AMEX) in MATCH TYPE B. Any difference between the two would indicate we have an issue with the data and we can research and address the data gap.