Sheet 1 — Transaction Log (Navy tab) 15 sample transactions with 18 columns: Txn ID, Date, Time, Type, Mode, Party Name, PAN/ID, KYC Status, Account No., Debit/Credit amounts, auto-chaining Running Balance, Reference No., Purpose, Branch/Channel, Risk Flag, Alert Level, and Remarks. KYC, Risk, and Alert cells are colour-coded automatically.
Sheet 2 — Alert Dashboard (Red tab) Live KPI boxes showing Total Transactions, Total Debits/Credits, and Red/Amber alert counts — all formula-driven from the Transaction Log. Includes an alert breakdown table and a filtered High-Risk Transactions list.
Sheet 3 — CTR / STR Tracker (Red tab) Tracks every Cash Transaction Report and Suspicious Transaction Report with linked Txn ID, reason/basis, reporting authority (FIU-IND), filing date, status (Filed/Pending), and officer sign-off. Includes a regulatory note per PMLA 2002 & RBI Guidelines.
Sheet 4 — Daily Cash Position (Green tab) Auto-summarised daily opening balance, receipts, payments, net cash flow, closing balance, and alert count — with colour-coded net flow (green = positive, red = negative).
Sheet 5 — Instructions (Purple tab) Regulatory threshold guide (CTR ≥ ₹10L, STR criteria, structuring alerts) and usage tips.
All 39 formulas verified with zero errors. Alert thresholds and colour coding are compliant with standard AML/KYC monitoring practices.
