Data Overview

You can access journal entry tests by clicking on Data Analytics on the Hamburger Menu. You will land on the Data tab.

Data Analytics option in the Hamburger Menu is displayed only for engagements that have Analytics license enabled.

To perform journal entry testing, Trial Balance, Chart of Accounts and General Ledger are required.

Sync Data

A banner will be displayed in the Data tab to Sync the data before proceeding with journal entry testing if your engagement meets any of the following criteria:

  • Trial balance imported before engagement was upgraded with Analytics license.

  • Trial balance imported through older import wizard of CCH ProSystem fx Trial Balance.

  • Manually added Trial balance without any import.

This is a one-time activity per engagement and will take a few minutes to complete.

After successful completion of sync, you can proceed with General Ledger import using the Import button.

Note: If your engagement meets the above criteria and you try to import General Ledger, you may face an error. If faced, ensure to Sync Data from data tab before importing general ledger if you have not imported Trial Balance through new import wizard.

The Data tab in the Data Analytics section allows you to view imported General Ledger (GL) data.

Note: You must import a General Ledger before you can proceed with Transaction Testing.

Data Table Overview

The data table displays imported GL files and their metadata. The columns include:

  • Name. The name of the imported GL file

  • Start Date. Start date of the engagement

  • End Date. End date of the engagement

  • Updated. Timestamp of last import/re-import of general ledger data

    Tip: If no data appears, ensure that a valid GL file has been imported.

Export Data

You can export the financial data used for analytics - Trial Balance, General Ledger, and Chart of Accounts - in the Common Data Model (CDM) format for external use by clicking Generate Export.

Select the data sets you want to include in the export and start the generation process.

Export generation may take a few minutes. Once the export is ready, you'll receive a notification, and a Download link will become available. The generated file will remain available for download for 24 hours.

The exported data will be downloaded as a compressed ZIP file.