Problem

You are given a reconciliation break across multiple accounts and funding sources. Explain how you would use SQL to isolate the mismatch, identify the accounts driving the variance, and separate missing records, duplicate postings, timing differences, and null mapping issues.

Scope

Focus on the SQL investigation pattern you would use in PostgreSQL: how you would align the data grain, compare expected versus posted amounts, and drill from summary variance down to transaction-level exceptions.