Structuring: Deposits Just Below the Threshold in a Rolling 7-Day Window
This lesson is part of the course
In this lesson
You build a structuring rule: mark deposits just below the reporting threshold, count them per customer in a rolling 7-day window with COUNTIFS on date ranges, total the window's cash with SUMIFS and raise an alert only when both tests are met.
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