Perform data analysis

This topic applies to CaseWare ReviewCompTax.

Learn more about CaseWare ReviewCompTax

Your next step after responding to the Fieldwork Optimiser inquires is to proceed to 3-01 Analytical overview document to perform data analysis. This is where you look for trends, compare and calculate ratios, investigate discrepancies and confirm expectations.

In the 3-01 Analytical overview document:

  • you can hide or display specific charts by selecting the toggles () at the top of the page.

  • you can use the drop-downs at the top to switch the display between Preliminary balances and Final balances.

  • each chart has a section where you can enter comments or notes.

  • you can hover the graphs to view a tooltip that shows the data a specific bar or line represents. Note that the corresponding data in the table is highlighted as well.

3-01 Analytical overview

If you hover the data labels in the table, a tooltip displays showing the definition of each label and the formula used to calculate it.

3-01 Analytical reivew: Data presentation in table

In the overall bar chart, you can select a specific financial statement area to open the corresponding bar chart as an alternative to enabling it using the toggles at the top of the page. In the following figure, we selected Total expense to display a separate bar chart for it below.

3-01 Analytical review: Overall chart.

In a financial area bar chart, you can remove one or more data set from the chart and compare results. Select Edit (), then select Delete () to remove one or more data set. You can revert to the original chart by selecting the Edit () then Revert ().

Edit mode in charts.

Analysis sheets for the relevant financial areas in your engagement are also available for review.

Based on your responses in the Fieldwork Optimiser, these analysis sheets can be found in the Analysis section in the Documents page or grouped by the corresponding financial area. For example, you can find the 3-03 Liabilities and Equity analysis sheet in the Analysis section or in the Liabilities and equity section in the Documents page.

The default view in analysis sheets is to show data for accounts and groups. You can modify the setting to show groups only or accounts only.

Table settings in analysis.