Pipeline ran successfully
Period: Jan 2024 – Dec 2024 · 120 Sellers · 1,440 Records
Overview
Anomaly Register
Monthly Trends
Reconciliation
Commission Audit
Total Records
1,440
120 sellers · 12 months
Anomalies Detected
523
36.3% of records flagged
Critical + High
190
77 Critical · 113 High
Medium Risk
333
Requires weekly review
Financial Exposure
₹2.39Cr
Across all anomaly types
Time Saved / Week
~87%
vs manual reconciliation
// MONTHLY GMV vs NET PAYOUT (₹)
// RISK LEVEL DISTRIBUTION
// DETECTION METHOD BREAKDOWN
ROLLING_BASELINE
151
IQR
123
MISSING_RETURN
121
PLATFORM_RECON
77
COMMISSION_RATE
21
Z-SCORE
17
NEGATIVE_PAYOUT
13
// PAYOUT BY SELLER TIER (Total ₹)
// TOP ANOMALIES BY RISK SCORE 523 records
Seller ID Name Tier Month Net Payout (₹) Detection Method Risk Level Score
Total GMV (2024)
₹6.81Cr
Across 120 sellers
Total Net Payout
₹5.49Cr
After all deductions
Peak Month GMV
Nov
₹77.6L — Festive spike
Peak Anomalies
Aug
11 anomalies detected
// 12-MONTH PAYOUT TREND — GMV vs NET PAYOUT vs ANOMALY COUNT
// CATEGORY RETURN RATES (%)
// MONTHLY DATA TABLE
MonthGMV (₹L)Payout (₹L)Anomalies
Total Pairs Checked
1,440
Internal vs Platform
Platform Discrepancies
77
Above ₹500 threshold
Match Rate
94.7%
1,363 exact matches
Avg Discrepancy
₹8,240
Per flagged record
// RECONCILIATION STATUS
1,363
MATCHED
47
MINOR DIFF
30
MAJOR DIFF
// DISCREPANCY BY DETECTION METHOD

Platform reconciliation compares internal net_payout against platform reference data. A discrepancy above ₹500 triggers a PLATFORM_RECONCILE flag. 77 such cases detected in 2024.

Platinum sellers
32
Gold sellers
22
Silver sellers
13
Bronze sellers
10
ROOT CAUSE ANALYSIS
Platinum discrepancies are highest in absolute value due to larger GMV. Platform sync delays of 24–48 hrs account for ~60% of minor discrepancies. Major discrepancies co-occur with commission rate anomalies.
Rate Violations
21
>10% deviation flagged
Total Overcharge
₹3.1L
Across all violations
Avg Rate Deviation
42%
Above contracted rate
Tiers Affected
3/4
Platinum · Gold · Silver
TOP OVERCHARGE CASES
// CONTRACTED vs APPLIED RATE BY TIER (%)
AUDIT NOTE
All 21 violations show over-application of rates (never under). Suggests systematic billing config issue rather than random error. Recommend immediate review of rate assignment logic for Platinum FBA sellers.