Design a transaction reconciliation system

Design a transaction reconciliation system. The system receives files on a regular schedule from two external parties: a bank and a payment processor. Each file contains transaction records that must be compared with the company's own orders and payments. The system must find records that are absent from one side, records that occur more than once, and records whose fields disagree. It should produce outputs for human operators and for downstream services that rely on…