Regulatory Report Setup
Phase 4: Configure regulatory and compliance reports — FETERS, LRS, TCS, EDW, and settlement reports — before UAT.
Before entering UAT, all regulatory and compliance reports must be configured and validated. This ensures accurate data submission to regulators from day one of production.
Complete Before UAT
Regulatory report setup must be completed and validated before starting UAT (Phase 5). Reports are verified as part of the end-to-end testing cycle.
Identify Applicable Reports
Based on the bank's geography and regulatory requirements, identify the set of reports to configure.
Configure Report Parameters
For each applicable report, configure the extraction parameters:
| Parameter | Description |
|---|---|
| Report Template | Select the appropriate template (FETERS, LRS, TCS, etc.) |
| Data Filters | Transaction types, channels, date ranges to include |
| Schedule | Generation frequency — daily, weekly, monthly, or on-demand |
| Output Format | CSV, Excel, or regulator-specified format |
| Delivery Method | SFTP upload, email, or download from portal |
| SFTP Configuration | SFTP host, credentials, and destination path for automated delivery |
Settlement & Reconciliation Reports
Configure settlement reports for network-level reconciliation:
| Report | Description | Frequency |
|---|---|---|
| Daily Transaction Summary | Aggregated transaction counts and amounts by channel | Daily |
| Settlement File | Network settlement data matching (Visa/MC/RuPay) | Daily |
| Fee Posting Summary | All fees posted to CBS with GL account mapping | Daily |
| Card Issuance Report | New cards issued — counts by product, branch, channel | Daily |
| Declined Transaction Report | All declined transactions with decline reasons | Daily |
Validate Report Accuracy
Run reports against test data and validate:
| Validation | Description |
|---|---|
| Data Completeness | All transactions in the period are captured |
| Field Accuracy | Amounts, currencies, dates match source records |
| Format Compliance | Output matches regulator-specified format exactly |
| SFTP Delivery | Automated upload succeeds to destination server |
| Reconciliation | Report totals match CBS and network settlement records |
Use UAT test data to generate sample reports and have the bank's compliance team validate them against expected formats before UAT sign-off.