1. No Common ID Available which is generally lookup to reconcile
2. Amount Difference from one report to another. In my case it PKR 5-10 Rs but could be more and vary scenario to scenario.
1. Amount has to be matched without repeatation and in contrast to its count coming in report.
I have made a model which overcomes all limitations and addressed the challenges mentioned above and allows you to reconcile data with 100% accuracy.