XLNET Features

XLNET automates inventory, risk assessment, analysis, auditing, and remediation for critical spreadsheets, while streamlining ongoing audit efforts to ensure compliance. With XLNET, you’ll have the ability to minimize the risk of errors in financial reporting processes by auditing, tracking, and managing changes to financial spreadsheets while satisfying SOX 404 and other corporate and regulatory compliance mandates.

Inventory

Through an easy-to-use interface, XLNET speeds the inventory process by leveraging federated search capabilities to help you locate all critical spreadsheets within your network – searching across a variety of disparate content sources. After critical spreadsheets have been identified, XLNET generates a detailed inventory report of the spreadsheet population, including key metrics (file name, path, file size, number of formulas, errors, nested IFs, external links, named ranges, blank cells, invisible cells, hidden rows/columns/sheets, locked cells, warnings and more).

XLNET Search Speeds Inventory

To speed inventory efforts, you can instantly perform enterprise-wide searches across gigabytes of data! Users can search and retrieve spreadsheets and other files on their local PCs, in emails and attachments, on corporate shared drives, peer PCs, internal and external websites, and third party applications (e.g., Microsoft Sharepoint, CRM, ERP, etc.). There is full text, keyword, and value search capability, and support for multiple file formats, including spreadsheets and other Office documents, images, audio and video files, text files, ZIP and PDF files, XML, XSL, email, MIME, and more.

Risk Assessment and Analytics

XLNET delivers in-depth diagnostic reports on all critical spreadsheets to help automate risk assessment. Reports include in-depth formula and cell diagnostics, multi-workbook audit trails, workbook and cell change history, and interactive workbook and cell dependency diagrams. All reports can be printed, exported to Excel and PDF formats, or imported into a secure repository as electronic evidence to support ongoing audits.

Spreadsheet Documentation

Detailed documentation can be created and organized using a built-in Microsoft Word editor. Spreadsheet documentation is organized in a flexible hierarchy along with optional attachments at each level. Documentation can be created at the inventory, spreadsheet, worksheet, and cell levels with attachments at each level. Documentation is stored as a companion file to the original spreadsheet, just like online Help.

Spreadsheet Development Best Practices

XLNET incorporates an easy-to-use cell-painting tool for applying pre-defined color schemes to formulas, errors, input cells, and external links. Color schemes help users to quickly identify missing input data, formula inconsistencies, and errors, and they can be automatically re-applied after spreadsheets are modified.

Remediation and Controls

XLNET provides you with a powerful set of controls that satisfy the latest guidance from leading tax and audit firms, including:

• Comprehensive file, system and cell-by-cell audit trails
• Range auditing, alerts and notifications of changes to key financial metrics and risk indicators
• In-context drill through for reviewing audit trail entries
• Regulatory compliant electronic signatures
• Tracking of links to external databases and other spreadsheets
• Spreadsheet versioning
• Powerful differencing and reporting tools for comparing changes between spreadsheets
• Access control based on users, groups, roles and privileges
• Spreadsheet security and data integrity checking
• "Active" archival and backup for information lifecycle management
• Comprehensive document and records management support
• Enterprise class workflow support for automate change requests, review and approval processes, and other critical close-the-books sub-processes

»  learn more about the XLNET Advantage