Risk Tiers, Due-Diligence Levels & Periodic Review Dates
This lesson is part of the course
In this lesson
You turn risk scores into Low / Medium / High tiers with IFS and a PEP override, assign simplified, standard or enhanced due diligence, schedule the next periodic review with EDATE and count the overdue reviews.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Customer Risk Rating: Weighted Factors with XLOOKUP and SUMPRODUCT Locked
- Risk Tiers, Due-Diligence Levels & Periodic Review Dates Locked
- Large Cash Rule: Single-Transaction Flags and Daily Aggregation per Customer Locked
- Structuring: Deposits Just Below the Threshold in a Rolling 7-Day Window Locked
- Name Screening Basics: Normalising Names, Exact Matches and Partial Hits Locked
- Alert Disposition Metrics: False Positives, Escalations & Report Conversion Locked
- Rule Tuning: Alerts vs True Hits at Different Thresholds Locked
- Case Backlog: Ageing, SLA Breaches and Required Analysts Locked