KYC Risk Rating & Transaction Monitoring: Customer Scores, Alert Rules & Case Backlogs
Score customers with weighted risk factors, set tiers, due diligence and review dates, run large-cash and structuring rules on transactions, screen names against a fictional watchlist, measure alert outcomes, tune thresholds and staff the case backlog – 8 hands-on labs at one fictional bank, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you build the calculations of a KYC and transaction-monitoring team at one fictional bank. You score customers on weighted risk factors with XLOOKUP and SUMPRODUCT, set risk tiers with a PEP override, assign due diligence and schedule periodic reviews with EDATE. You flag large cash transactions and aggregate cash per customer and day with SUMIFS, then detect structuring with COUNTIFS over a rolling 7-day window. You normalise names and match them against an invented watchlist, measure false-positive, escalation and report-conversion rates, back-test thresholds for precision and coverage, and calculate how many analysts the case backlog needs.
Lessons
- Customer Risk Rating: Weighted Factors with XLOOKUP and SUMPRODUCT Pro
- Risk Tiers, Due-Diligence Levels & Periodic Review Dates Pro
- Large Cash Rule: Single-Transaction Flags and Daily Aggregation per Customer Pro
- Structuring: Deposits Just Below the Threshold in a Rolling 7-Day Window Pro
- Name Screening Basics: Normalising Names, Exact Matches and Partial Hits Pro
- Alert Disposition Metrics: False Positives, Escalations & Report Conversion Pro
- Rule Tuning: Alerts vs True Hits at Different Thresholds Pro
- Case Backlog: Ageing, SLA Breaches and Required Analysts Pro