Lyquidity Solutions, unveil ComplyXL Enterprise that incorporates a full range of tools for organizations to track, monitor and analyze their spreadsheets. Now that compliance has become so important, apply version control to the Excel workbooks used in your organisation and make sure you are able to determine whether changes have been made to critical workbooks before you rely upon them. ComplyXL offers a simple to implement option that can scale from a single user to an entire company.
Version 2.3 of ComplyXL Enterprise adds Active Monitoring, Spreadsheet Discovery, drag-and-drop Business Intelligences features for analysis among many other changes to improve users' confidence in their compliance with Sarbanes Oxley and other governance legislation. Active Monitoring of spreadsheets allows users to subscribe to receive automated notifications when a spreadsheet has changed. Notifications can be received by email, IM or SMS.
Change tracking with ComplyXL is automatic. Users can review changes down to individual cells, worksheets or whole workbooks. Comments and user information are recorded with updates so reviewers can see and report the reason for change and the individuals making changes. Faster analysis allows users to review spreadsheets containing thousands of rows and hundreds of columns for changes and exceptions in real-time.
Spreadsheet discovery provides managers with the tool needed to find spreadsheets wherever they are on their systems. ComplyXL automatically builds an inventory of spreadsheets that can be categorized as, for example, high or low risk. Managers can also decide whether future changes to discovered spreadsheets should be monitored. Role based security allows managers to control access and rights to workbooks. This can be used for reporting, with the history of access rights tracked.
"The enhancements in ComplyXL Enterprise are client driven and together allow line and compliance managers to become more aware of the changes happening to key documents that may be used in external reporting and decision making. Users can configure the software to act pro-actively as a safeguard so it doesn't matter if managers are out of the office or in meetings because change notifications can either be sent as an email, IM or even SMS," said Sandy Marshall, Product Manager for ComplyXL at Lyquidity.
Versions can be added manually or can be added automatically by discovery processes. Each version records the changes made, the location and machine used in addition to the user and date. Version control records changes in a central repository built on any of several leading database engines so that the histories of key spreadsheets can be included in a business continuity process.
Focus filtering gives users the ability to filter change reviews to focus on the types of change that are important. Volatile functions are those functions like TODAY() that will be recalculated whenever a spreadsheet is opened and so can obscure material changes. Flexible reporting uses Business Intelligence style analysis for spreadsheet change reviews. Reports are designed on-screen using simple drag-and-drop techniques to select the columns and change details that will be included and to group and sort the information to be printed.
Centralized management is provided by integration with Active Directory on Windows platforms or LDAP on other server systems making it for easier for administrators to manage deployments and updates to large user communities. No new skills have to be taught to users. ComplyXL does not affect the use of Excel in any way so there is no need to re-train users before the benefits of control can be realized. Users can be shown the menu option to add versions manually or versions can be done automatically by a discovery process.