ProSystem fx ActiveData

ProSystem fx® ActiveData™
Turn your data into information

ProSystem fx ActiveData is a data extraction and analysis tool that manipulates and analyzes client and financial data within Microsoft^® Excel to simplify everything from sampling to sophisticated fraud detection.

When your staff audits client data, they are looking for a pattern within the transactions that will help determine whether a deviation is indicative of fraud or an anomaly. This includes:

Simplifying queries in Microsoft^® Excel.
Highlighting rows with certain criteria and extracting those values, helping you look for values that seem improper.
Finding gaps in outstanding checks, effortlessly.
Is easy to learn and cost-effective.
Supports greater accuracy and efficiency.
Saves time by relieving you of manual calculations.

As an auditing professional, you need tools that work the way you do. Simplify your account and financial data analysis with more than 70 ProSystem fx ActiveData functions that let your staff effortlessly manipulate data, perform complex calculations, and manage Microsoft^® Excel workbooks and files. The result is a better understanding of client data and increased opportunity for analysis.

Powerful data analysis features let you:

Merge, match and compare sheets.
Query, tag and select rows.
Sort, summarize, sub-total, split, sample, and stratify data.
Analyze duplicates (de-dupe) and detect gaps in sequenced items such as check and invoice numbers.
Perform top and bottom performance analysis.

This high speed and high performance data analysis and manipulation tool can support up to a million rows of data,* and your reports are published right into Microsoft^® Excel.

*Limited to users of Microsoft® Excel v.2007.

ProSystem fx ActiveData simplifies your data manipulation and analysis by leveraging a tool you already use. Make your current Microsoft^® Excel processes more effective and bring data analysis to all your auditors’ desktops.

Tight integration with Microsoft^® Excel presents a substantially lower learning curve than other products on the market. In addition to its integration with Microsoft^® Office, ProSystem fx ActiveData is highly leveraged by ProSystem fx^® Engagement, CCH’s paperless trial balance and workflow solution.