Transaction Matching match among multiple sources
We are in the process of implementing a bank account rec with multiple sources and multiple match processes. So we have 4 sources - Bank, payment gateway, internal staging and GL. To have 4 match processes - Bank vs Payment Gateway, PG vs Staging, Staging vs GL and GL vs Bank, we are planning to create 8 data sources, each one with a source side and a subsys side. As a result we need load each file twice each day via DM. Is our approach correct?
One concern is that in case of mismatches, Matching landing page will club all sources and all subs together and report. Won't it create confusion as the same unmatched record would get counted twice and blow up the number. And since the profile is TM with Balance Comparison, the unmatched amount in either side of source and sub would also not be a correct representation. Am I missing something here?