Large Cash Rule: Single-Transaction Flags and Daily Aggregation per Customer
This lesson is part of the course
In this lesson
You run a simple threshold rule on a week of transactions: flag single cash transactions at or above the limit, add up each customer's cash per day with SUMIFS, flag the customer-days that reach the limit and count what the daily view adds.
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