Practical point of view of reconciliation example cCITI

Reconciliation in Financial Institutions like Citi – With Examples

1. What is Reconciliation?

Reconciliation is the process of comparing internal financial records with external sources to identify and resolve discrepancies. It ensures data integrity, regulatory compliance, and accurate reporting.

2. Types of Reconciliation at Citi – With Real Examples

a. Cash Reconciliation

Matches Citi's internal ledger entries with external bank balances.

Example: Citi ledger shows $1.5M; JPMorgan shows $1.49M. A $10K FX delay is corrected.

b. Securities/Position Reconciliation

Checks holdings vs. custodians.

Example: Citi reports 10,000 Reliance shares; NSDL shows 9,800. A corporate action wasn’t processed.

c. Trade Reconciliation

Validates trade flow across systems.

Example: Front office shows $1M trade; middle office shows $1.2M. FX rate mismatch fixed.

d. TLC Reconciliation

Monitors the full trade lifecycle.

Example: Trade captured but not accounted—entry added manually.

e. Nostro Account Reconciliation

Compares SWIFT messages with bank statements.

Example: MT103 of $200K sent, but only $180K received. FX fee adjustment required.

f. Broker Reconciliation

Ensures broker records match Citi’s books.

Example: Morgan Stanley logs 50 Apple trades; Citi has 49. One incorrectly canceled.

g. Internal/Intercompany Reconciliation

Aligns entries between global Citi branches.

Example: INR 10 Cr transfer from Citi Singapore missing in Citi India’s ledger—resolved.

h. Cash-in-Hand & Petty Cash

Validates branch cash.

Example: INR 1.5 lakh booked, only 1.48 lakh found. Shortfall flagged.

i. Position Reconciliation

Validates securities lending transactions.

Example: 1000 shares lent; only 990 returned. 10 missing due to dividend stripping.

j. Depository Reconciliation

Matches NSDL/CDSL data with internal systems.

Example: 200 TCS shares in PMS; NSDL shows 150. Failed transfer identified.

3. Reconciliation Process Flow

• Data Load: SWIFT, brokers, DPs feed in.
• Matching Engine: SmartStream, IntelliMatch used.
• Exception Reports: Flag mismatches.
• Investigation: Assigned by break type or region.
• Resolution: Adjustments, confirmations, entries.
• Sign-off: Manager reviews and signs reconciliation status.

4. Key Controls & Manager Role

• Daily T+0/T+1 completion tracking
• Escalation of aged/unresolved breaks
• Audit logs and commentary reviews
• Stakeholder reporting and governance calls
• Dashboards for real-time exception monitoring

5. Handling Breaks – Real-world Example

• 30 total breaks: 20 resolved internally
• 5 pending broker responses
• 3 aged > 5 days – escalated
• 2 client-impacting – top priority

6. Tools Used at Citi

• TLM SmartStream
• IntelliMatch
• SWIFT for MT103/MT202
• Internal Citi platforms
• Excel VBA / SQL for reporting

7. Why Reconciliation is Critical

• Reduces settlement risk
• Ensures regulatory compliance
• Protects Citi’s financial integrity
• Builds client trust
• Prevents fraud and misreporting