1.Financial Reconciliation and Outlier Detection
banking audit team · 2026
A banking audit team utilized a financial reconciliation dashboard to track $15.28B in total deposits across 100 institutions against $19.64B in total assets. The dashboard features KPI cards highlighting an 80.7% median deposit-to-asset ratio and a 7.77x leverage reference, alongside a scatter plot that isolates two anomalous institutions representing $119.6M in deposits. By automatically surfacing these red-diamond anomalies, the user successfully replaced a manual velocity banking spreadsheet and visual scanning with a streamlined, automated review process.
What it shows:
Automated scatter plots and KPI tracking eliminate the need for manual spreadsheet calculations when monitoring portfolio leverage.




