Automating Trade Reconciliation for a Global Asset Servicer - CACEIS
The Challenge
A financial institution used a highly customized Excel-based system to manage trade reconciliation across middle- and back-office operations. While powerful, the system had critical limitations:
Key pain points included:
- Maintenance depended on a single resource with deep VBA knowledge
- Trade data came from multiple sources with inconsistent formats
- Errors in reconciliation created compliance risks and manual rework
- Lack of audit trails and scalability hindered operational transparency
Fragmented Input Formats
Manual Processes & Errors
Lack of Auditability
The Solution
Konverge developed a web-based platform to replace the legacy Excel “wizard,” mirroring core workflows while adding robust data management and automation features:
- Modular trade processing: Designed separate interfaces for derivatives activity, trade matching, and settlement monitoring
- Automated imports: Integrated with LISA, TMC, Globe, and Ullink systems to auto-import trade files
- Smart reconciliation: Enabled sorting, filtering, and status tracking across different trade stages
- Auditability: Included user role management, audit logs, and report generation tools
Key Features:
- Import/export trade files via CSV and integrate with external trade systems
- Track trades through custom Wizard interfaces (DL, MO, SE, UL)
- User role-based access and administrative controls
- Audit trails and history logs for compliance reviews
- Custom report generation and scheduled exports
Import/Export CSV Files
Role-Based Access
Custom Report Generation
Business Outcomes
- Significantly reduced reconciliation time and manual interventions
- Eliminated reliance on fragile VBA macros and hardcoded spreadsheets
- Improved transparency and audit readiness
- Enhanced scalability and maintainability for internal IT teams
Why It Matters
This project illustrates how a custom solution can reduce risk, improve data governance, and support operational growth, especially for institutions managing complex financial workflows.
Konverge’s financial domain expertise and agile development practices enabled a seamless transition from legacy spreadsheets to a secure, high-performance platform.
“We understood that the real value was in making trade data trustworthy and processes dependable, no more hidden formulas or manual workarounds. That’s what we delivered.”
— Sonia Couto, Managing Director, Konverge Digital Solutions
Let’s Set your Direction
Start Your Growth
Let’s Set your Direction
Start Your Growth