Turn your data into information with our audit data analysis
Overview
ProSystem fx® ActiveData is a data extraction and audit data analysis tool. It can be used to automate a full complement of audit processes directly within Microsoft ® Excel, including more than 70 time-saving functions that simplify everything, from sampling to sophisticated audit fraud detection.
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 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 audit data analysis.
Key Features
How can you assess the risk of all your clients’ data for better audit fraud detection?
You can manually compare data against a list of common risk symptoms – a process that could take months to complete and is susceptible to errors. Or, with ProSystem fx® ActiveData's powerful audit data analysis features, you can:
- Merge, match and compare sheets.
- Query, tag and select rows.
- Sort, summarise, sub-total, split, sample, and stratify data.
- Analyse duplicates (de-dupe) and detect gaps in sequenced items such as check and invoice numbers.
- Perform top and bottom performance analysis.
Most users can implement ProSystem fx® ActiveData right out of the box. Where other data analysis and audit fraud detection solutions take weeks to learn and master, most ActiveData users are up-and-running on their first day of implementation.
Once installed, ProSystem fx® ActiveData’s functions are available directly in Microsoft® Excel as an additional pull-down menu.
This high speed and high performance audit 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
Integration
ProSystem fx® ActiveData simplifies your data manipulation and audit data analysis by leveraging a tool you already use – Microsoft® Excel. This tight integration presents a substantially lower learning curve than other products on the market. Your staff will be able to:
- Analyse client data within Microsoft® Excel in minutes using easy, automated functions.
- Adopt a consistent audit fraud methodology for identifying high-risk data based on impact and likelihood for failure.
- Understand how to efficiently detect errors within client data and mitigate the risk of errors.
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, to further simplify your paperless audit process.
Make your current Microsoft® Excel processes more effective and bring data analysis to all your auditors’ desktops.