at Financial Technnology Year
Please contact them if you have any questions.
Features in Reconciliation Software
for Fund Operations
Tools that automate the comparison and matching of financial data from different sources (e.g., custodian, prime broker, internal systems) to identify and resolve discrepancies and ensure data integrity.
We ask vendors to mark their product against our feature list. It is not available for all products and in some cases we have derived data from publicly available sources. The list of features follows. Vendors can add a further 10 key features of their own.
Audit, Control, & Compliance
Features ensuring regulatory compliance, transparent audit trails, and robust internal controls.
- Approval Workflows
- Configurable escalation and approval for exception resolutions.
- Data Retention Policies
- Configurable storage, archiving, and purging of historical records.
- Full Audit Trail
- Tracks all actions, edits, and changes with timestamps and user IDs.
- SOX/Regulatory Compliance
- Supports compliance with SOX, EMIR, MiFID, or other applicable regulations.
- Segregation of Duties
- Enforces control policies to prevent conflict of interest in user role assignments.
- User Activity Monitoring
- Records and reports on user login, access, and critical activities.
Configurability & Customization
The ability to tailor the software to specific asset classes, workflows, and reporting needs.
- Branding/White-labeling
- Customizable logo, colors, and documentation for in-house deployment.
- Custom Data Fields
- Define new data fields and tracking elements without core code changes.
- Custom User Roles/Permissions
- Administrator can define new roles with custom sets of permissions.
- Dynamic Workflow Builder
- Visual workflow editor for developing and adjusting processes.
- Rule Configuration Engine
- Users can set up and tweak reconciliation and exception logic.
Core Reconciliation Functionality
Fundamental capabilities essential for reconciling financial data efficiently, accurately, and at scale.
- Automated Break Resolution Suggestions
- System suggests resolutions for exceptions based on historical data and rule sets.
- Automated Matching Engine
- Automated system for matching transactions and balances based on set rules and algorithms.
- Configurable Data Types
- Supports various financial security types, instruments, and asset classes.
- Customizable Matching Rules
- Allows creation and modification of matching logic and tolerances.
- Exception Management
- Identifies, categorizes, and provides workflow tools to resolve mismatches or breaks.
- Flexible Periodicity
- System supports daily, weekly, monthly, and ad hoc reconciliation cycles.
- Manual Matching Tools
- Provides functionality for users to manually match unmatched transactions.
- Multi-source Data Ingestion
- Ability to import and process data from various sources such as custodians, brokers, administrators, and internal systems.
- Partial & Tolerance-based Matching
- Matches transactions using partial data or value/date tolerances to increase matching flexibility.
- Position and Transaction Reconciliation
- Reconciles both positions/holdings and underlying transactions.
- Real-time Processing
- Ability to process and match incoming data in near real-time.
- Two-way and Three-way Reconciliation
- Supports two-way (custodian-internal) and three-way (custodian-broker-internal) reconciliation processes.
- Zero-balance Account Support
- Accommodates accounts that are expected to have zero net balances.
Cost & Licensing
Understanding the commercial model and operational costs associated with the product.
- Flexible Licensing Options
- Purchase by user, by entity, by transaction volume, or as a SaaS subscription.
- No Hidden Fees
- All costs are clearly disclosed and predictable.
- Transparent Pricing Structure
- Published, clear pricing tiers, including base and additional features.
- Trial or Proof-of-Concept Availability
- Demo or trial environments are available for pilot testing.
- Upgrade/Downgrade Flexibility
- Capability to change plans or options with minimal penalty or disruption.
Integration & Interoperability
The capacity of the software to integrate seamlessly with other systems and support different data exchange formats.
- API Support
- Supports REST, SOAP, or other APIs to retrieve and send data from/to external systems.
- Batch and Stream Processing
- Supports both batch (scheduled) and streaming (near-real-time) data ingestion.
- Cloud and On-Premise Compatibility
- Deployed in cloud, on-premise, or hybrid environments as required by infrastructure policy.
- Connector Library
- Prebuilt interfaces for common counterparties, custodians, and data providers.
- Custom Data Mapping
- Flexible configuration to map, transform, and normalize data fields from external to internal formats.
- Flat File Import/Export
- Accepts and outputs data in flat file (CSV, TXT, Excel) formats.
- Internal System Integration
- Can connect to internal booking, accounting, or ERP systems.
- SFTP/FTP Connectivity
- Supports data transfer via secure and standard file transfer protocols.
- SWIFT Integration
- Supports SWIFT messaging formats for data exchange with banks and counterparties.
- Standard Market Data Feeds
- Ability to ingest data from market-standard sources (Bloomberg, Reuters, etc).
Reporting & Analytics
Comprehensive tools for generating insights, reports, validations, and exports.
- Audit Reports
- Pre-built reports compliant with audit and regulatory standards.
- Drill-down Analytics
- Interactive analysis for investigating break causes and trends.
- Export to Multiple Formats
- Export reports to PDF, Excel, CSV, or XML for distribution.
- Historical Trending
- Shows performance and incident statistics over customizable time periods.
- Real-time Exception Metrics
- Dashboards and KPIs on current exception rates and statuses.
- Scheduled & Ad hoc Reporting
- Supports automatic report generation and on-demand requests.
- Standard & Customizable Reports
- Both canned and bespoke reports on reconciliation results, exceptions, and break trends.
Scalability & Performance
Measures and characteristics related to the system’s capacity to handle large and complex data in minimal time.
- Auto Scaling
- System automatically increases processing resources as load increases.
- Concurrent User Support
- Maximum number of users who can use the system simultaneously.
- Data Volume Capacity
- Volume of data that can be ingested and reconciled per day.
- Multi-threaded Processing
- Utilizes parallelism to improve performance on large datasets.
- Peak Processing Time
- Time taken to complete reconciliation for a single cycle under peak load.
- Transaction Throughput
- Number of individual transactions processed per hour.
Security & Data Protection
Mechanisms for keeping financial and personally identifiable data safe and secure.
- Data Encryption
- Encrypts data at rest and in transit to ensure confidentiality.
- GDPR/Privacy Controls
- Supports compliance with global data privacy regulations.
- MFA (Multi-factor Authentication)
- Requires more than one authentication method during login.
- Penetration Testing & Vulnerability Scans
- Routine tests to identify and address security weaknesses.
- Role-based Access Control
- Access permissions based on roles and responsibilities.
- Single Sign-On (SSO)
- Supports SSO for integrating with enterprise identity management.
Support, Training & Documentation
Resources and services made available to ensure successful onboarding and ongoing user success.
- 24/7 Technical Support
- Round-the-clock access to product and technical support services.
- Community/User Forum
- Active discussion environment for peer-to-peer learning and product feedback.
- Dedicated Account Manager
- Directly assigned account representative for ongoing relationship management.
- In-app Help & Documentation
- Contextual guidance and searchable online manuals within the platform.
- Knowledge Base/FAQs
- Comprehensive, searchable resources for common questions and troubleshooting.
- Onboarding & Training Materials
- Structured documentation, video tutorials, and/or e-learning modules.
User Experience & Accessibility
Features related to usability, navigation, accessibility, and the user interface.
- Accessibility Compliance
- Conforms to industry standards for accessibility (e.g., WCAG 2.1).
- Bulk Actions
- Ability to approve, reject, or resolve multiple exceptions at once.
- Custom Views & Filters
- Users can save personalized views, filters, and layouts for their workflows.
- Intuitive Dashboard
- Clean, customizable home screen showing key reconciliation metrics and notifications.
- Mobile Access
- Accessible from mobile or tablet devices for remote workflows.
- Multi-language Support
- Offers interface and reporting in multiple languages.
- Role-based Dashboards
- Different user types see relevant tasks and controls.
Workflow Automation & Task Management
Capabilities allowing the automation of routine processes, follow-ups, and exception resolution.
- Automated Exception Routing
- Directs exceptions to teams/users based on predefined criteria.
- Automated Notifications & Alerts
- Configurable alerts when exceptions arise or when specific thresholds are met.
- Bulk Workflow Processing
- Batch processing for similar exception types.
- Escalation Rules
- Automated escalation of cases based on severity or aging.
- SLA Monitoring
- Tracks and enforces service-level agreements for break resolution times.
- Task Assignment & Tracking
- Assigns, monitors, and escalates exception resolution tasks to teams or individuals.