Design a Payment Reconciliation System

Design a payment reconciliation system that receives settlement files from multiple banks in varying formats and frequencies, reconciles them against recorded transactions from a payment gateway, and identifies discrepancies such as missing transactions, amount mismatches, duplicates, and potential financial losses.