SE
SmartEngagement
Working Papers
CaseWare Working Papers
Analytics
CaseWare Cloud Analytics
AnalyticsAI
CaseWare AnalyticsAI
Time
CaseWare Cloud Time
PCR
OnPoint PCR (Preparation Compilation Review)
RCT
CaseWare  ReviewCompTax
PBC
CaseWare  Cloud Provided by Client Requests
SE
SmartEngagement
Working Papers
CaseWare Working Papers
Analytics
CaseWare Cloud Analytics
AnalyticsAI
CaseWare AnalyticsAI
Time
CaseWare Cloud Time
PCR
OnPoint PCR (Preparation Compilation Review)
RCT
CaseWare  ReviewCompTax
PBC
CaseWare  Cloud Provided by Client Requests

Testing client data

This feature is only available with CaseWareCloud Analytics, part of the CaseWare Cloud suite.

Learn more about Cloud.

The Analytics app enables you to test data submitted by clients. Find errors and irregularities, locate duplication, and create data visualizations directly within the app. The diagram below describes a typical Analytics engagement, and the steps pictured are outlined in detail in this topic.

The audit process using CaseWare Cloud.

Start an Analytics engagement

Begin by creating your Analytics engagement in the Files page

To create an Analytics engagement:

  1. Ensure that you have the Editor role or equivalent privileges.

  2. From the Cloud menu, select Analytics.

  3. Select New.


  4. Specify an Entity, then complete the remaining fields.

  5. Select Save.

Once you’ve created an Analytics engagement, you can begin to import your client data.

Import client data for analysis

The way you import this data depends on what accounting software the data was created in. If the data was created in one of the following software packages, you can use the CaseWare Transformer Tool to convert your client files to a formatted .zip package, then import the .zip file into Analytics:

  • AuditXML 3.x
  • MyOB AccountRight Live 2013 - 2016
  • Pastel Partner 12.1-14.0
  • QuickBooks CA 2012 - 2017
  • QuickBooks US 2012 - 2017
  • Sage 50 Accounting (Peachtree - WIN) 2012 - 2017

Download the CaseWare Transformer install package below:

CaseWare_Transformer_setup.exe

Otherwise, you will need to import your client data in .csv file format. The .csv files should follow specific formatting guidelines to ensure successful import and testing.

After uploading client files, you can generate an overview of your data.

Your mapped file will appear on the Profile page. Its position is determined by the Type you selected.

View an overview of your client data

If you would like to see an overview of your Analytics engagement before conducting specific tests, Cloud offers several methods to visualize the client data you have received. These visualizations can make it easier to see broad trends in client data.

Generating Analytics reports

In addition to providing an overview of your client data, Analytics can conduct specific tests. For example, you can test for duplicate entries, entries with amounts ending in 999 or out of balance entries.

To run an Analytics test:

  1. Ensure that you have the Editor role on the file or equivalent privileges.

  2. From the Cloud menu, select Analytics.

  3. Select your Analytics engagement, then select the appropriate data file from the Data Files pane on the left.

  4. Select the Tests tab to show a set of test categories.
    Select Tests to show a set of test categories.

  5. Select the arrow next to a test to run it. A green arrow () indicates that you can run the test without providing any parameters or additional mapping. If a test displays a yellow () or dark gray () arrow, you will be asked to provide test parameters or map additional columns before you can run the test.

  6. On the test results page, select Save to keep a copy of the report to your engagement. The report appears as a child of the original data file.
    The Compare user is a child of ABC Inc. General Ledger.

Downloading your Analytics report

Once you have run a test and saved a report, you can download it for later use.

Download a report to your computer

You can download any report your have saved directly to your computer.

To download an Analytics report to your computer:

  1. Ensure that you have the Editor role on the file or equivalent privileges.

  2. From the Cloud menu, select Analytics and then select the appropriate Analytics engagement.

  3. Next to your saved report, select More Actions () | Download and select the appropriate download option. When a graph is available, you can download it in .png format.

    Download your Analytics report to your computer

Attach a report to a Working Papers engagement

You can also download an Analytics report directly to a Working Papers engagement.

To download an Analytics report to a Working Papers engagement:

  1. Ensure you have the Editor role on the file or equivalent privileges.

  2. In Working Papers, click File | Options | CaseWare Cloud. Sign in with your Cloud credentials.

  3. Select Cloud | Engagement, Entity, or Files to open Cloud in your Working Papers browser window.

  4. In the browser window, select Analytics from the Cloud menu.

  5. Next to your saved report, select More Actions() | Download and select the appropriate download option. When a graph is available, you can download it in .png format.

    Download your Analytics report to your computer

  6. In the File Download dialog, click Add.

  7. In the New Document Link dialog, specify the appropriate settings for the document and click OK.

Was this helpful?

Yes
No
This content is exclusively related to Analytics and has been filtered out. Select the PRODUCTS dropdown in the top navigation to modify your filter settings.

Stay Connected

Subscribe to receive updates on the latest articles and news for CaseWare products.

Your download will start immediately after you subscribe.

Please enter a valid email.
No thanks, I just want the file.