You are designing a daily reconciliation pipeline for remittance processing in a healthcare finance workflow. The goal is to match incoming 835 files to posted cash entries, identify variances, and surface exceptions for analyst review. The process must preserve audit history, handle duplicate or late files, and produce a clear reconciliation result that finance can trust.
How would you design a process to reconcile incoming 835 files to posted cash on a daily basis?