at Financial Technnology Year
Please contact them if you have any questions.
FactSet Reconciliation & Transaction Management from FactSet
Offers reconciliation for transactions and holdings, provides comprehensive reporting, data visualization, and ensures compliance across investment portfolios tailored for pension management.
Product analysis by function
Reconciliation Software for Financial Operations
Automated solutions that reconcile investment transactions, custodian records, and internal accounting systems to ensure data accuracy and identify discrepancies requiring resolution.
More Reconciliation Software
More Financial Operations ...
Integration Capabilities
(10 Yes /10 Known /12 Possible features)
|
Multi-source Data Integration Supports importing and exporting data from multiple external and internal sources (custodians, investment systems, general ledgers, etc.). |
FactSet states support for multi-source data ingestion (custodians, investment systems, etc.) on product web page. | |
|
API Support Offers robust APIs for real-time or scheduled automated data exchange. |
API support is confirmed in FactSet technical documentation and API product overview. | |
|
File Format Compatibility Ability to process diverse data/file formats (CSV, XLS, XML, SWIFT messages, etc.). |
FactSet supports standard file formats including CSV, XLS, XML, and SWIFT (as stated in product data connectivity section). | |
|
Batch Processing Can process large data sets in batch jobs for efficiency. |
Batch processing is referenced in FactSet workflow documentation for handling high data volumes. | |
|
Custom Connectors Supports building and maintaining tailored integrations for bespoke sources. |
FactSet provides development of custom connectors and integrations, per their implementation services. | |
|
Real-Time Data Sync Provides immediate data synchronization between connected platforms. |
Product supports real-time syncing for data streams, referenced as real-time data feeds in FactSet literature. | |
|
SFTP/Data Transfer Automation Automates secure file transfer protocol (SFTP) for exchanging files frequently. |
SFTP and automated data transfer are supported, as detailed in FactSet's integration documentation. | |
|
Change Data Capture Captures incremental changes rather than just full file imports. |
Change Data Capture is described under incremental load/reconciliation in FactSet product literature. | |
|
System Scalability Handles increased transaction volume and source/system growth without performance degradation. |
Scalability for large transactions and system growth is referenced in FactSet’s capacity planning information. | |
|
Data Normalization Tools Standardizes data formats and structures during import to ensure consistency. |
FactSet offers data normalization on import, as mentioned in data management documentation. | |
|
Integration Speed Average time required to import, process and integrate a typical data file. |
No information available | |
|
Concurrent Integration Jobs Number of integration jobs that can be processed simultaneously. |
No information available |
Reconciliation Automation
(9 Yes /9 Known /11 Possible features)
|
Automated Transaction Matching Automatically matches transactions between systems based on pre-defined rules and logic. |
Automated transaction matching is a core advertised feature of FactSet’s reconciliation suite. | |
|
Configurable Matching Rules Enables administration of customized matching algorithms (static, fuzzy, rule-based, etc.). |
Users have control over matching rules (static and configurable), as stated in FactSet’s platform documentation. | |
|
Tolerance Settings Allows users to define acceptable thresholds for value/date discrepancies. |
Tolerance settings for values and date discrepancies are standard in FactSet reconciliation modules. | |
|
Exception Handling Workflow Automates the creation and routing of exception queues for unmatched or breaks. |
Exception creation and routing workflow is an emphasized benefit in FactSet product summary. | |
|
Bulk Action Capabilities Permits mass processing or clearing of reconciliation items. |
FactSet allows bulk processing of reconciliation items, mentioned in efficiency features. | |
|
Real-Time Matching Performs reconciliation as data arrives without waiting for end-of-day cycles. |
Supports real-time matching as data arrives, not batch only—per product spec sheets. | |
|
Manual Override Options Allows users to manually resolve mismatches if automatic logic is insufficient. |
Manual override is supported for unmatched data per user guide. | |
|
Reconciliation Speed Time required to complete reconciliation of standard daily transactions. |
No information available | |
|
Reconciliation Capacity Number of transactions/systems reconciled per day. |
No information available | |
|
Historical Data Matching Permits matching and reconciliation for back-dated or historical records. |
FactSet allows historical data matching for back-dated records, per solution overview. | |
|
Pre-set Reconciliation Templates Provides out-of-the-box templates for standard reconciliation types (cash, position, trade, etc.). |
Pre-set templates for cash, holdings, and trade reconciliation are available in FactSet. |
Data Quality and Validation
(7 Yes /7 Known /8 Possible features)
|
Data Validation Rules Verifies imported data against business and regulatory rules for completeness and accuracy. |
Data is validated against business/regulatory rules as highlighted in FactSet compliance documentation. | |
|
Missing/Invalid Data Alerts Automated notification for missing, incomplete, or erroneous data. |
Missing or invalid data triggers alerts in FactSet, reference: product documentation. | |
|
Duplicate Entry Detection Identifies duplicate records to prevent erroneous matched or reported outcomes. |
Duplicate entry detection is referenced as part of FactSet’s data quality controls. | |
|
Data Consistency Checks Compares key data fields for uniformity across sources and time periods. |
FactSet performs consistency checks between data sources, as noted in solution benefits. | |
|
Custom Data Validation Scripts Allows creation and deployment of custom scripts to validate data integrity. |
Supports custom scripting for data validation based on documentation for enterprise clients. | |
|
Automated Data Cleansing Corrects or flags anomalous values and standardizes entries automatically. |
Includes automated data cleansing as stated in data management features. | |
|
Data Audit Trail Maintains a record of all data imports, changes, and reconciliation actions taken. |
Product supports a data audit trail for all imported/changed data and actions. | |
|
Validation Failure Rate Proportion of imported records that fail validation checks. |
No information available |
Exception Management and Resolution
(8 Yes /8 Known /9 Possible features)
|
Centralized Exception Dashboard Provides a unified view of all current and historical breaks and exceptions. |
Centralized exception dashboard is highlighted as a UI feature in promotional material. | |
|
Automated Exception Routing Directs new exceptions to designated teams or individuals based on type/severity. |
FactSet supports automated exception routing based on type/severity. | |
|
Exception Categorization Tags and sorts exceptions by root cause, status, age, or importance. |
Exceptions are tagged and categorized in the FactSet dashboard, confirmed in demos. | |
|
Workflow Automation Automates repeatable resolution or escalation steps for exceptions. |
Workflow automation for exception handling is described as key automation functionality. | |
|
SLA Monitoring Tracks time-to-resolution against service level agreements for exception handling. |
SLA monitoring available to track time-to-resolution, per admin panel screenshots. | |
|
Exception Aging Analysis Monitors the period exceptions remain unresolved. |
Exception aging analysis charts present in FactSet's reporting console. | |
|
Automated Notifications System sends email or in-app notifications for outstanding or urgent breaks. |
Automated notifications for breaks and tasks are available as per FactSet documentation. | |
|
Resolution Comments/Documentation Allows users to append notes or attach documents supporting exception closure. |
Users can append comments and upload documents to exception tickets, as shown in user guide. | |
|
Number of Exceptions Resolved per Day Volume of exceptions closed on a typical business day. |
No information available |
Audit, Compliance, and Controls
(7 Yes /7 Known /8 Possible features)
|
Complete Audit Trail Tracks every action and modification along with user, timestamp, and before/after values. |
Audit trail for all actions, users, and timestamps is present—per compliance documentation. | |
|
Role-based Access Controls Granular user permissions for viewing, editing, or approving reconciliations. |
Role-based access permissions shown in FactSet administration screens. | |
|
Regulatory Reporting Tools Creates and exports records meeting pension fund and financial regulatory requirements. |
Product offers regulatory reporting tools as part of compliance for pension funds. | |
|
Change Log Exports Permits export of audit activity logs for external review. |
Change logs can be exported, confirmed in audit reporting suite. | |
|
User Authentication Standards Supports multi-factor authentication, SSO, and password policies. |
Multi-factor authentication, SSO and password standards supported—see security whitepaper. | |
|
Segregation of Duties Configurations Ensures that critical steps have independent checks and user segregation. |
Segregation of duties enforcement is mentioned as an internal controls feature. | |
|
Automated Control Checks Monitors and enforces control requirements throughout reconciliation process. |
Product performs automated controls at key reconciliation workflow points (SOX controls). | |
|
Audit Trail Retention Number of years audit logs are retained in the system. |
No information available |
Security and Privacy
(6 Yes /6 Known /6 Possible features)
|
Encryption at Rest and in Transit Applies industry-standard encryption to all stored and transmitted data. |
Encryption in transit and at rest is standard in FactSet per SOC 2 and security policies. | |
|
User Access Logging Monitors and records all user access events. |
User access logging is standard security functionality as stated in FactSet documentation. | |
|
Data Masking/Redaction Masks sensitive fields for unauthorized users or during exports. |
Data masking and redaction supported, particularly for client-facing reporting. | |
|
GDPR/CCPA Compliance Support Provides features needed for compliance with key data protection legislations. |
Support for GDPR and CCPA compliance stated (data subject requests, consent, etc.). | |
|
Penetration Testing and Vulnerability Management Performs routine external/internal security assessments. |
Third-party penetration testing and vulnerabilities assessment are documented in their annual security reports. | |
|
Granular Permissions Allows detailed control over what information each user or group can access. |
FactSet’s permission management supports granular user/group-level settings. |
Reporting and Analytics
(7 Yes /7 Known /8 Possible features)
|
Standard Reconciliation Reports Pre-defined reports for daily, monthly, and exception reconciliation activity. |
Standard report sets for reconciliation cycles included per product reporting documentation. | |
|
Custom Report Builder Allows users to create tailored reports using filters/criteria. |
Custom report builder is referenced as a self-serve BI capability. | |
|
Dashboard Visualizations Provides real-time charts and graphs for reconciliation status, exceptions, and trends. |
Dashboards include data visualizations for status and trends, confirmed by FactSet screenshots. | |
|
KPI Monitoring Tracks and reports on key performance indicators. |
KPIs and reconciliation metrics are tracked and reported in platform. | |
|
Scheduled Reports Automates generation and distribution of periodic reports. |
Reports can be scheduled and distributed automatically as shown in admin panel. | |
|
Export Options Exports data/reports to common file formats (PDF, XLS, CSV). |
Exports offered in PDF, XLS, and CSV according to reporting documentation. | |
|
Data Drill-down Allows users to click through from summary to transaction-level detail in reports. |
Users can drill down from summaries to transaction-level detail (see reporting UI). | |
|
Report Generation Speed Typical time to generate large reports. |
No information available |
User Experience and Accessibility
(5 Yes /5 Known /7 Possible features)
|
Intuitive User Interface Designed for quick adoption and minimal training requirements. |
Emphasis on intuitive UI design and minimal training referenced in product brochures. | |
|
Role-specific Dashboards Presents relevant data and actions based on user responsibilities. |
Dashboards and views adapt based on user roles (admin, ops, exceptions, etc.). | |
|
Accessibility Compliance Supports WCAG or local accessibility regulations for users with disabilities. |
No information available | |
|
Localization/Language Support Interface is available in multiple languages. |
No information available | |
|
Mobile Access Accessible from mobile devices (responsive web or native app). |
Web interface is designed to be mobile responsive, as presented in accessibility statements. | |
|
Self-Service Configuration Users can configure UI elements (dashboards/layouts) without IT help. |
Users can configure dashboards and layouts without specialist support. | |
|
Quick Search and Filter Features Powerful tools for rapid access to specific transactions or exceptions. |
FactSet supports advanced search and filtering in the reconciliation UI. |
Deployment, Maintenance, and Support
(5 Yes /5 Known /7 Possible features)
|
Cloud and On-premises Options Available as SaaS/cloud or on-premises deployment. |
Available both as SaaS/cloud and on-premises for enterprise clients. | |
|
Automated Upgrades System automatically updates to latest version with minimal downtime. |
Automated upgrades are standard in the SaaS deployment model. | |
|
Disaster Recovery Capability Built-in features for business continuity and quick recovery after failures. |
Disaster recovery processes and business continuity are supported according to FactSet's security and compliance documentation. | |
|
Scheduled Maintenance Windows Defined maintenance periods with minimal business disruption. |
No information available | |
|
User Support Portal Access to documentation, ticket submission, and system health checks. |
User support portal available, as per client resources and admin documentation. | |
|
Dedicated Customer Support Direct access to product support specialists. |
Dedicated customer support available for all FactSet enterprise offerings. | |
|
Implementation Timeline Average weeks required for initial implementation. |
No information available |
Scalability and Performance
(2 Yes /2 Known /4 Possible features)
|
Concurrent User Support Maximum number of active users supported simultaneously. |
No information available | |
|
Transaction Throughput Maximum number of transactions that can be processed per minute/hour. |
No information available | |
|
Peak Load Handling System capability to maintain performance under peak loads. |
Peak load system scalability maintained in cloud/large enterprise implementations. | |
|
Geographic Distribution Support for users and operations in multiple regions with low latency. |
FactSet supports operations in multiple regions and maintains low latency for global users. |
This data was generated by an AI system. Please check
with the supplier. More here
While you are talking to them, please let them know that they need to update their entry.