Comprehensive Guide to Reconciliation
1. What is Reconciliation and How is it Completed?
Reconciliation is the process of comparing two sets of records to ensure consistency and accuracy. It ensures that financial data in internal systems matches external sources such as bank statements, broker records, or custodian reports.
Completion Steps:
- Data extraction from both sources
- Matching key fields (dates, amounts, trade IDs)
- Identification of mismatches (breaks)
- Investigation and resolution
- Reporting and sign-off
2. Different Types of Reconciliation
- Account Reconciliation: Matching ledger balances with bank or custodian statements
- IB Reconciliation: Inter-branch transaction matching
- TLC Reconciliation: Ensures trade data consistency throughout life cycle
- Transaction Reconciliation: Matching specific transactions across systems
- Position Reconciliation: Matching security holdings
- Internal Reconciliation: Between internal departments or systems
- External Reconciliation: With banks, brokers, custodians, etc.
3. Process of Reconciliation
- Data Collection
- Data Matching
- Break Identification
- Investigation
- Resolution & Adjustments
- Escalation if needed
- Final sign-off
4. Key Controls and Integrity in Reconciliation
- Automation and system validations
- Segregation of duties
- Break aging analysis
- Approval workflow
- Audit trail and documentation
5. Dealing with Breaks or Mismatches
Investigate timing issues, system errors, or manual input mistakes. Communicate, adjust entries, and document resolution thoroughly.
6. TLC, Internal and External Reconciliation
- TLC Reconciliation: Ensures trade is correctly processed across all stages
- Internal: Within departments or internal systems
- External: With brokers, custodians, clearing houses
7. Cash Reconciliation
Matches internal cash ledger with external bank records. Ensures all receipts and payments are accounted for accurately.
8. Nostro Account Reconciliation
Used in foreign currency transactions. Internal vs actual bank balances are reconciled to identify discrepancies in foreign transactions.
9. Position vs Depo Reconciliation
- Position: Compares internal vs custodian-held securities
- Depository: Reconciliation with NSDL/CDSL for Indian securities
10. Broker Reconciliation
Confirms internal trade records with broker trade confirmations. Key in equity, derivatives, and forex operations.
11. Custodian Reconciliation
Custodians maintain financial assets. Reconciliation ensures accuracy of:
- Holdings
- Settlement statuses
- Corporate actions
- Cash balances
12. Examples
- Nostro: Bank expects $100,000 but sees $98,000. Investigates fees or short payment.
- Broker: Bought 500 shares internally, broker confirms 400. Needs reconciliation and update.
- Position: Internal record shows 10,000 units; custodian reports 9,950. Resolve pending trade or error.
Comments
Post a Comment