An intuitive, flexible and generic tool providing complete control over the reading and forwarding of data les from prime brokers, custodians and administrators, and the preparation of outbound data for transmission to clients, to management or uploading to other systems.
Importer allows the creation of a file definition containing the layout and content of source or destination data, whether in a database, a text file or Excel files. Any ODBC database can be read from or written to. Any style of text file can be defined, including delimited and fixed format. Complex layouts of source files can be read including header and footer blocks.
Importer maps contain the logic required to translate between a source and a destination definition. Maps contain sequential programming steps including mathematical, string, logical and data reference and lookup functions. At run time data is read from the source using the inbound destination, map steps are sequentially interpreted, and translated data is posted to the destination using the outbound definition.
Maps can be designed and fully tested prior to publishing. Revisions can be applied to published maps, and tested before republishing. All versions are retained by the system providing a complete audit trail.
Maps can be executed using Importer, from within iRecs by reconciliation staff, or automatically based on the receipt of a data file in a specified location or scheduled to run as required. All execution steps are written to a comprehensive audit trail, including skipped rows or user defined warning and error messages.
I was impressed with the capacity of Importer – we deal with many custodians and various file formats, and Importer now allows each to be presented in a standard format – this is a very powerful attribute.
Genesis Investment Management
Having evaluated several reconciliation tools we were impressed by the close fit between iRecs’ functionality and our very specific reconciliation needs and were convinced this was the scalable and flexible reconciliation platform we needed to support a large and diverse business.
iRecs gives us a valuable add on to our existing systems, providing a very flexible reconciliation tool which we anticipate will allow us a high level of automation, and replace existing manual processes. The quality of the management reporting suite is also very impressive.
Genesis Investment Management
The implementation of iRecs has made a meaningful contribution to our control environment, improving the productivity of reconciliations between internal systems, administrator and counterparties in a cost effective manner. The WWFS team were both pragmatic and helpful throughout the process.
London Hedge Fund
iRecs is an automated reconciliation system designed to meet the needs of the asset management
industry. iRecs matches positions, balances, trades, cash flows and uniquely, P&L between internal
systems and external service providers and across all instrument classes.
iRecs is the only system available that completely solves margin accounts reconciliation for listed and OTC derivatives. iRecs also handles full NAV reconciliation accounting for all differences in positions, balances, prices and exchange rates between the internal accounting system and records provided by the custodian or administrator.