Integrate Working Papers with Caseware AnalyticsAI

AnalyticsAI is a risk-based transaction analysis tool that auditors can use to scan transaction sets and find exceptions that might warrant further investigation. It reduces the time spent in transaction analysis by automatically performing multiple tests on the entire transaction set. With AnalyticsAI integration, firms can improve their audit process by creating AnalyticsAI engagement files directly from Working Papers, uploading trial balance data, and incorporating reports based on specific tests back into Working Papers.

Prerequisites:

  • Your organization must be using Working Papers 2020 or later.

  • Your organization must have a license for the AnalyticsAI app. If you do not have a license, contact your local distributor for more information.

  • Working Papers must be integrated with a Cloud site.

Recommendations:

  • Store your engagement files on Cloud by publishing them to a Cloud entity. Published files are accessible from any location where you can log in to your Cloud account and can be immediately linked to an AnalyticsAI file.

Integrate an engagement file with a Cloud entity

In Cloud, each client's information — such as engagement properties, address and contact information — is stored in their own entity. When you integrate a Working Papers engagement file with an entity, it will automatically populate the file with the information from Cloud.

To integrate an engagement file with a Cloud entity:

  1. In Working Papers, open the engagement file that you want to integrate with a Cloud entity.

  2. On the ribbon, click Engagement | Engagement Properties.

  3. On the Name/Address tab, click the Cloud Entity field. Enter the name of the entity or click the drop-down menu and select New to create a new entity.

  4. Client information from the Cloud entity populates the engagement's properties automatically. Click OK.

The engagement file is integrated with the Cloud entity. If you need to modify the engagement properties, select Automatically sync engagement properties with the Cloud Entity and make your changes in either the dialog or the Cloud entity.

Link the engagement to an AnalyticsAI file

After integrating your engagement file, you'll need to link it to a new or existing AnalyticsAI file before uploading your trial balance data.

To link to an AnalyticsAI file:

  1. On the ribbon, click Cloud. In the AnalyticsAI group, click Open.

  2. The AnalyticsAI Setup dialog displays. If applicable, select the AnalyticsAI product that you want to use.

  3. Select Create New to create a new AnalyticsAI file, or Select Existing to select an existing AnalyticsAI file from the drop-down menu. Click OK.

The engagement is linked to the AnalyticsAI file and the Cloud pane displays.

Notes:

  • You can unlink an engagement from an AnalyticsAI file by clicking Unlink on the ribbon.

  • If you permanently delete a linked AnalyticsAI file from the Cloud Recycle Bin, attempting to open it in the associated engagement file will result in an "Invalid engagement" error. Unlink the engagement file to clear the error, then create a new AnalyticsAI file.

Upload trial balance data to AnalyticsAI

When you link an engagement to an AnalyticsAI file, you can upload the engagement's trial balance data to begin performing tests. Prior to the upload, ensure that each account in the trial balance is assigned a map or group number. Note that you cannot upload trial balance data from consolidated engagement files.

To upload trial balance data to AnalyticsAI:

  1. On the ribbon, click Cloud | Upload.

  2. In the prompt to upload the trial balance, click Yes.

  3. If the mapping structure between the file and AnalyticsAI doesn't match, a prompt displays to provide an optional mapping file (.ini) to map the accounts. Click Yes to apply a mapping file, No to continue without a mapping file, or Cancel to abort the upload process.

  4. If the upload will produce unassigned accounts, a prompt displays to confirm that you will need to manually map the accounts. Click Yes to continue.

The trial balance data is uploaded to AnalyticsAI. You can view the uploaded data from the Data page of the Cloud pane and map any unmapped accounts by clicking Assign Accounts.

Generate test results in AnalyticsAI

AnalyticsAI automatically generates a default set of test results which you can refine as required using a variety of different tests and configuration settings.

When you've generated the required test results, you can download them as a report to incorporate into your engagement file. The report can be downloaded as a CSV, CSV ASCII or PDF file type.

To download test results as a report:

  1. In the Cloud pane, click Documents | 2-2 Risk Analysis (Transaction Risk).

  2. The test results display. At the top-right corner of the Cloud pane, click the Download icon.

  3. Select a file type for the report (CSV, CSV ASCII, PDF).

  4. In the File Download dialog, click Add to download the report to the Document Manager.

  5. The New Document Link dialog displays. Confirm the report settings and click OK.

The test results are downloaded as a report and added to your engagement file. You can move, modify or delete the report as required.