Release history - Caseware AnalyticsAI

The following highlights the features and enhancements in previous releases of the generic version of AnalyticsAI.

What's new - Data Analytics DA-10

AnalyticsAI

Envision

Envision provides a quick visualization of the transaction data that's been imported into an AnalyticsAI engagement.

Envision is divided into several widgets:

  • Overview
  • Summary
  • Distribution
  • Posted Date Distribution

AnalyticsAI Envision

Refer to Envision for more information.

Notebooks

Notebooks are interactive documents that contain live code together with markdown text. Using Notebooks, you can build and explore custom analysis, and display the results. Each notebook consists of a series of cells. Run each cell individually in sequence to view its output or run the entire notebook.

Notebook files have the .ipynb file name extension and can be explored, modified and run in JupyterLab, an open-source notebook editor. The Data Analytics team has re-engineered out-of-the box Analytics AI tests to work with a new Notebooks engine. You can access these from the AnalyticsAI platform.

Notebooks are interactive documents that contain live code together with markdown text. Using Notebooks, you can build and explore custom analysis, and display the results. Each notebook consists of a series of cells. Run each cell individually in sequence to view its output or run the entire notebook.

Notebook files have the .ipynb file name extension and can be explored, modified and run in JupyterLab, an open-source notebook editor. You can access these from the AnalyticsAI platform.

To launch a notebook:

  1. Select a test in the Configuration page.
    Launching a Notebook
  2. Select Explore test. The notebook for the selected test displays.
    Cluster-based Outlier Factor notebook

Note: The initial launch of a CWI Notebook in an engagement by each user may take several minutes. Changes made in notebooks, including those in the code cells as well as the markdown cells, are not saved.

Note: The initial launch of a CWI Notebook in an engagement by each user may take several minutes. The Data Analytics team is working on reducing the initial load times. Changes made in notebooks, including those in the code cells as well as the markdown cells, are not saved.

Refer to Get started with AnalyticsAI Notebooks SDK for more information .

Data import

Import from online accounting software

Some minor UX improvements have been made in this release.

  • The Next button now appears in the same place on each page of the wizard.
  • The message on the final page of the wizard has been improved.

What's new - Data Analytics DA-9

AnalyticsAI

There are no updates to AnalyticsAI in this release.

Data import

Transaction file import

This release has added a new processing step to enable file validation during tagging.

Transaction import processing progress

Entry number error message

Now, when mapping a column in a transactions file to ENTRY NUMBER, LINE NUMBER or ENTRY ID, an error displays if any blank cells are detected.

Entry number error

Click on the warning to show the blank cells and their line numbers. With this information, you can correct the file using a tool of your choice, or contact your client with this information and ask for a corrected transactions file.

An error also displays if there are blank rows.

Blank cells error

You will not be able to import files with errors -- the Import button on the Import Transactions page will be inactive.

Amount error message

When mapping a column in a transactions file to AMOUNT, an error displays if any non-numeric properties are present.

Invalid data type

Click on the warning to view the affected data.

Invalid data rows

You will not be able to import files with errors -- the Import button on the Import Transactions page will be inactive.

Unassigned value warnings

When mapping a column in a transactions file to DOCUMENT TYPE, POSTING STATUS, IDENTIFIER TYPE or ORIGINATING DOCUMENT TYPE, a warning displays if there are any unassigned values. For example,

Unassigned document type

Duplicate entries

If duplicate transactions are detected in CSV files, either in the same file, or a subsequent file in an engagement, the duplicate transactions will be ignored on import.

Attempting to import duplicate transactions will no longer corrupt the transactions database. Additionally, if an import fails, users will be able to upload and import another file. Prior to this release this action would also result in a corrupted datbase.

Note: Transaction duplicates are based on the entry number property, not the entire transaction.

What's new - Data Analytics DA-8

AnalyticsAI

This release includes the following bug fix:

  • There was an inconsistency in the High Amounts test default percentile. The default percentile is now set to 99.1%.

Data import

Transaction import

SIZE and STATUS columns have been added to the Import Transactions page.

Import transactions

Import from online accounting software

With this release, the Transactions checkbox on the Configure Data page do not appear in products that don't support transaction imports.

More detailed error messages have been added to the STATUS column in the Summary: Import Status page. For example, when you import data with dates that are outside of the date set for the engagement, the message in the example below displays.

Import complete with data error

What's new - Data Analytics DA-7

AnalyticsAI

The graphical widget user interface for High Risk Exceptions was updated. High Risk Exceptions displays all tests with the pagination feature.

Users are now able to add tickmarks and annotations to a transaction.

Data import

There are no updates to Data Import for this release.

What's new - Data Analytics DA-6

AnalyticsAI

This release includes the following bug fixes:

  • Redirects for AAI and CSV import links for AAI engagements created from subfolders on Collaborate.
  • Failure to export files due to tagged and blank posting date.
  • Configuration page does not work well with narrow viewports.
  • Configuration page risk score should have an input limit.
  • Not showing spinners on AnalyticsAI test LOADING status.
  • MS service (AAI, CSV Import) link goes through constant loop when engagement is created from folder.
  • Issues with AAI for tagged but blank posting date.

Data import

Major improvements have been made to how you import data into an engagement from online accounting platforms.

With this new functionality enabled, the Data page has been simplified to include a single button to access online accounting software.

Import from online accounting software

When you select Online Accounting Software, the Import Transactions wizard displays:

Choose data source

These platforms will continue to be supported:

  • Exact (NL and BE)
  • SnelStart
  • Visma - eAccounting
  • Octopus (NL and BE)
  • Yuki (NL and BE)
  • Twinfield
  • Quickbooks Online
  • Xero

Additionally, we have added support for:

  • Freshbooks
  • Microsoft Dynamics 365: Business Central

Limitations for the initial release:

  • Transactions import is limited to all transactions within the last five years to the import date.
  • You will not be able to filter import providers by product.

What's new - Data Analytics AnalyticsAI 2020.4

AnalyticsAI

There are several changes to AnalyticsAI for this release.

Displayed currency

Currency symbols now show where currency amounts display in AnalyticsAI. For example:

Currency units in AnalyticsAI

Tip: You can change the currency symbol for your product from the Cloud menu () under Customization | Regional Settings.

Version visible in footer

The version of AnalyticsAI now shows in the footer of the RESULTS and CONFIGURATION pages.

Faster data analysis

Improvements have been made to analysis time and performance for large transaction sets.

Direct export to engagement file

A Save to Engagement function has been added to the Export option in the RESULTS tab.

Save analytics results to engagement

This dialog gives you the same files options as Download, with the added ability to save them to a specific folder in the engagement.

Save to engagement in AnalyticsAI

Data import changes

The ability to delete a saved data layout has been added to the SELECT DATA LAYOUT drop-down. A layout can only be deleted by the person who created it.

What's new - AnalyticsAI 2020.1

This highlights the major changes since the last release of this product.

AnalyticsAI changes

A number of improvements have been made in AnalyticsAI for this release.

Translations are now supported and implemented

You can now select AnalyticsAI's language from the Language drop-down in the top-right of the Caseware Cloud login screen. You must be logged out to do this.

When you log back in, you will see the following AnalyticsAI elements in the selected language:

  • The login screen
  • All elements on the Results page
  • All elements on the Configuration page
  • The Export Data Locally dialog
  • The contents of the Analysis Summary PDF when exported

Improved export file name defaults

The default file name formats for exported data files have been improved.

Exported file type

File name format

Analysis Summary PDF

<year>_<month>_<day>_<entity>_AAi Summary.pdf

Results (CSV)

<year>_<month>_<day>_<entity>_AAi Audit Evidence.csv

All Data (CSV)

<year>_<month>_<day>_<entity>_AAi All Data.csv

For more information on exporting results, see Export AnalyticsAI results.

CSV export headers consistent

Header information for exported Results and All Data CSV files is now consistent.

Added approved_by property to Results CSV export

The CSV file that is created by a Results export from the Export Data Locally dialog now includes an approved_by column.

Data import changes

Improvements have been made to the process for importing trial balance CSV files.

Data layouts

This new functionality lets you save data layouts for transactions properties. This saves time by avoiding the need to map similar transactions files for multiple imports.

Now, you can map an imported transactions file in the usual manner, and then save the layout for future use.

See Import the client's transactions for more information.

What's new - AnalyticsAI 2019.8

This highlights the major changes since the last release of this product.

Configuration page improvements

When the dates in a data file don't match the engagement's dates, the Run tests on drop-down now appears on the Configuration page. You can run tests on:

  • All data
  • Current year

Additionally, the Save & Run Tests button is now called Run Tests.

Running tests on all data in AnalyticsAI

Style Improvements to Tagging Dropdown

These improvements have been made to the Import as dialog that appears when you are mapping an imported .csv transactions file:

  • The Select button has been removed. Now, simply click an available item in the list to select it.
  • The arrows that appeared beside each potential selection have been removed.
  • Unused properties that were visible during the transactions file mapping process have been hidden in this release.

What's new - AnalyticsAI 2019.7

This highlights the major changes since the last release of this product.

Updates to transactions import

The process for importing and mapping .csv transaction files has been improved for this release.

You can now import multiple transaction files. When you do this, the files are processed into a single data file for analysis.

The process for mapping imported transaction files has also been improved, including better descriptions for each data type.

See Import clients transactions for more information.

Improvements to data export

The data in the Analysis Summary PDF now includes:

  • Time Series Graph – Risk-to-Value of Transactions
  • List of Tests Performed
  • List of Accounts Influenced
  • Appendix A: Descriptions of Tests Performed

Status of tests

The Configuration page now shows test statuses as follows:

  • An In progress indicator shows for any test that is running.
  • Not run – grey status icon.
  • Precondition failed – yellow status icon.
  • Pending run – grey status icon.
  • Failed run – red status icon.
  • Successful run – green status icon.

What's new - AnalyticsAI 2019.6

This highlights the major changes since the last release of this product.

Outlier detection

These outlier detection tests have been added for this release:

  • Angle-based Outlier Detection
  • Cluster-based Local Outlier Factor
  • Histogram-based Outlier Detection
  • Isolation Forest Outliers
  • K-Nearest Neighbours
  • Local Outlier Factor
  • Minimum Covariance Determinant
  • Principal Component Analysis

See Outlier detection for more information.

Fiscal year filter

If you have data outside of the fiscal year of the audit, you now have the option to only test the transactions within the fiscal year.

In the following example, the engagement properties show a fiscal period of January 1, 2017 to December 31, 2017.

Engagement properties

Because this engagement has data from more than just 2017, the following option appears on the Configuration page. Select the checkbox if you wish to run analyses on data solely from the period of the engagement.

Fiscal year filter

Currency symbols removed

For easier Internationalisation, currency symbols have been removed from the Results page.

What's new - AnalyticsAI 2019.5

This article is intended to highlight the major changes since the beta release of this product. It is not a listing of all changes.

Improved workflow

When you open a new engagement in AnalyticsAI, the following workflow now appears on the Documents page:

AnalyticsAI workflow

See Data analytics workflow for more information.

Improvements to trial balance and online transactions import

The following options are now available for importing data into AnalyticsAI:

Import trial balance and online transactions

See Import trial balance in Caseware AnalyticsAI for more information.

Risk analysis configuration page

Tests on the Configuration page now include a pie chart that shows the percentage and quantity of the flagged transactions for that test. Pie charts appear when a test has flagged transactions. The pie chart shows the percentage of transactions flagged by that test.

Some tests, such as High Amounts include a pie chart and an additional graph that helps you configure parameters.

See Test configuration for more information.

Time series chart

A new widget has been added to the Results page.

Use the Time Series chart to observe the risk score and dollar value of evaluated transactions over time. Hover over a bar or line to further investigate by summing the value of transactions over a given risk threshold for a given month.

AnalyticsAI time series chart