Advanced concepts of reconciliation of financial markets

Advanced Reconciliation Concepts – With Real-Life Examples

1. Break Categorization

Timing Break: Trade booked after cutoff doesn't appear until next day in custodian report.

Valuation Break: Price feed difference between Citi and custodian due to timing lag.

Booking Error: Same trade booked twice by mistake.

Custody Break: Dividend received but not reflected in system.

2. Aging Analysis

Breaks categorized by age for priority resolution. E.g., unresolved ₹5 lakh trade mismatch for 7 days escalates to risk team.

3. Materiality Thresholds

Minor differences like ₹20 due to FX rounding may be logged but not escalated. Large mismatches (₹1.5 Cr) trigger immediate action.

4. Regulatory & Audit Readiness

All breaks must be audit-tracked with comments and timestamps. Non-compliance during inspections leads to penalties.

5. Automation & AI

Tools like SmartStream and AI help identify recurring breaks and auto-match trades, reducing manual effort.

6. Reconciliation KPIs

• 98.5% of T+0 breaks resolved daily
• Only 3% aged over 5 days
• Breaks per 10,000 transactions: 0.6%

7. Reconciliation Calendar

Daily: Cash, trades, Nostro

Monthly: Intercompany balances

Quarterly: Custodian holdings vs. fund NAV

8. End-of-Day and Month-End Close

Reconciliation ensures accurate NAV, P&L, and accounting for investor reports and regulatory filings.

9. Policy & Governance

All high-value breaks must be cleared within specific timelines, else escalated to compliance.

10. Analyst Training & Soft Skills

Analysts are trained to investigate breaks, communicate with stakeholders, and work under pressure efficiently.