startGraph of Trends
How To

Graph of Trends

CCH Audit Automation
Last update: Reading time 3 minutes
GraphsAnalytical Review

    Audit Automation can be requested, at any time, to display or print a graph showing the historical data and the trend line for any account within the trial balance. When graphs are produced, the system recalculates the trends for each account in case any changes have been made to the historical data since the last calculations. As indicated in the last section, Audit Automation will display a list of account exceptions when you run trend analysis and you may also view and print graphs from this list.

    To produce a graph

    Select option View/print trend graphs from [Analytical tools] on the Planning menu.

    The system will calculate the trend lines and present the Graphs of actual results and trend lines dialog, listing the nominal accounts for you to select the account to be graphed.

    clipboard_e14daa81c4625f01e3d6ce6b923fd2609.png

    Graph of actual results dialog

    You may scroll the list to the right to see the actual figures stored for each year, and scroll through the list of codes using the scroll bar or the navigation buttons. To view an account, either double click on the account in the list, or highlight it and click on the graph button at the bottom corner of the dialog box. Using either method will cause the system to display the graph.

    clipboard_e9c6caa8d7b3886c4ae17fd5075313976.png

    Display of actual results and the trend line

    The trend line shown will be that which most closely fits the historical data. The type of line selected from the 5 equations is displayed at the foot of the graph, together with the correlation - shown as R on the screen - and details of the number of years used for the calculation, the projected and the actual figures. However, you may wish to see, in graphical form, the other 4 lines which were calculated, and you can do this by clicking on the radio button by the name of the line to be viewed.

    The [Restrict] button at the foot of the dialog, allows you to restrict the number of years used for trend analysis for a particular account. This allows you to exclude older year’s data where they are out of line and are distorting the current projections.

    To use this feature, decide on the number of years that you wish to use and click on the [Restrict] button. The system will display a dialog inviting you to change the number of years used for the calculation, either enter the number to use, or use the scroll buttons to change the number and click on [OK]. The system will recalculate the trends for the account and redisplay the graph using the revised trend.

    For the options available when viewing graphs on the screen, please refer to the next section.

    Related documents

    Inherent Risk Questions
    This document outlines the process for assessing inherent risk in clients through a systematic approach of questions. The system can store up to 99 risk areas, each containing 99 questions, which are assigned point scores for "Yes" and "No" answers. It details steps for editing, adding, and deleting risk areas and questions, including interface navigation and confirmation prompts. Additionally, it emphasizes that once numbers are assigned to risk areas or questions, they cannot be changed. The document serves as a guide for managing inherent risk assessments effectively.
    Audit Risks
    This document details the functionality of CCH Audit Automation for recording Identified Audit Risks, also referred to as Significant Business Risks. It provides instructions for users to add, edit, and manage risks, including features for maintaining risks for future audits, assessing their significance, and linking them to assertions. The system includes tools for risk assessment, audit response, and documenting conclusions. Other functionalities encompass risk summarization, printing options, and risk linkage across multiple sources, enhancing the audit process's efficiency and accountability.
    Default Specific Risk Questions
    CCH Audit Automation allows users to define specific risk questions for audit areas, although it's not mandatory. If no specific questions are set, default questions will be used. Users can edit the default questions through the "Specific risk questions" option in the Risk Model section. Up to 99 default questions can be defined, similar to inherent risk questions. The system utilizes a lookup table that combines specific and inherent risks for audits, with editing instructions provided in the manual.
    Risk/Sample Selection
    This document outlines the concept of audit risk, defined as the likelihood of undetected material errors during an audit. It introduces a risk model used in Audit Automation that requires total audit risk to remain below acceptable levels across various audit areas. The risks are broken down into inherent risk, control risk, and detection risk, with further subdivisions for detection risk. It emphasizes the importance of understanding these concepts to design effective audit procedures and assess risk at different levels. Additionally, it discusses general and control environments, and the calculation of residual risk, alongside a risk scoring system.
    Inherent Risks
    The document outlines the procedure for addressing inherent risk questions in an audit context. Users can access a dedicated window to view up to 99 risk areas, answer questions, and modify responses as necessary. The system prompts users to validate changes to ensure proper risk assessments. It includes functionalities for viewing prior comments, copying text, and overriding calculated risk levels, emphasizing that auditor judgment is crucial. Comments on overrides must be provided to rationalize any adjustments made. The document serves as a guide for navigating and utilizing the auditing software effectively.