startAppendix 3 - Data Templates
How To

Appendix 3 - Data Templates

CCH Audit Automation
Last update: Reading time 3 minutes
User Guide

    For Microsoft Word

    System data

       [#Date#]                             Today's date

                  [#Firm#]                             Your firm's name

                  [#Firm Add 1#]                   Your firm's address line 1

                  [#Firm Add 2#]                   Your firm's address line 2

                  [#Firm Add 3#]                   Your firm's address line 3

                  [#Firm Add 4#]                   Your firm's address line 4

                  [#Firm Add 5#]                   Your firm's address line 5

                  [#Reference#]                    Document file name (prefix only)

                  [#Title#]                             Document title

                  [#Author#]                         Document author

    Client data

                  [#Code#]                            Client's audit pack code

                  [#Name#]                           Client's name

                  [#Add 1#]                           Address line 1

                  [#Add 2#]                           Address line 2

                  [#Add 3#]                           Address line 3

                  [#Add 4#]                           Address line 4

                  [#Add 5#]                           Address line 5

                  [#Address#]                       Client's address

                  [#Name/Add#]                   Client's name and address

                  [#Incorp#]                          Date of incorporation

                  [#Day#]                               Day of accounting reference date

                  [#Month#]                         Month of accounting reference date

                  [#Trading#]                        Trading as

                  [#Secretary#]                     Company secretary

                  [#Activity#]                        Principal activity

                  [#Period end#]                   Current period end date

                  [#Period start#]                 Current period start date

                  [#Part init#]                        Partner's initials

                  [#Part name#]                    Partner's name

                  [#Man init#]                       Manager's initials

                  [#Man name#]                   Manager's name

                  [#Sen init#]                        Senior's initials

                  [#Sen name#]                     Senior's name

    Reference data

                  [#RO*#]                              Registered office

                  [#AR*#]                              Accounting records location

                  [#SB*#]                               Statutory books location

                  [#L1*#]                               Client location 1

                  [#L2*#]                               Client location 2

                  [#L3*#]                               Client location 3

                  [#BP*#]                               Bankers - primary

                  [#B1*#]                               Bankers - secondary 1

                  [#B2*#]                               Bankers - secondary 2

                  [#SO*#]                              Solicitors

                  [#IB*#]                                Insurance brokers

                  [#SS*#]                               Software suppliers

                  [#TO*#]                              Main tax office

                  [#PY*#]                               PAYE office

                  [#VO*#]                              VAT office

    Where * may be

                  NAM                                   Name

                  AD1 to AD4                        Address lines

                  CON                                    Contact

                  REF                                     Reference

                  PHN                                    Phone number

                  FAX                                     Fax number

    For Microsoft Excel

    System data

    [#Date#]                                Today's date

    [#Firm#]                                Your firm's name

     [#Reference#]                      Document file name (prefix only)

    [#Title#]                                Document title

    [#Author#]                            Document author

    Client data

    [#Code#]                                    Client audit pack code

    [#Name#]                                   Client name

    [#Period end#]                           Current period end date

    [#Part init#]                                Partner's initials

    [#Part name#]                            Partner's name

    [#Man init#]                                Manager's initials

    [#Man name#]                           Manager's name

    [#Sen init#]                                Senior's initials

    [#Sen name#]                            Senior's name

    Extended codes

    Four extended codes are included to allow you to embed planning information in working papers. These are different from previous codes in that they embed more than just one figure or date. The codes, which must be entered in column 1 of the spreadsheet, are as follows:

    [#Equ_AAAA#]

    Where AAAA is the code of an equation in the equation editor.

    This will cause the system to insert the results of the specified equation. The name of the equation will appear in the cell where the code was entered and the results will be inserted in columns 2 to 11. Column 2 holding the latest year, 3 the previous year, etc.

    [#Budget#]

    This code will cause the summary information, shown on the first page of the budget report from the planning section, to be inserted. The row on which the code appeared will be replaced by headings and this will be followed with the totals for each staff member, totals and the calculation of the projected surplus or deficit.

    [#Materiality#]

    This coded will be replaced by the contents of the materiality calculation. The system inserts the same information as included on the printed report.

    [#Risk#]

    This code results in the risk table being inserted together with any comments that have been made on the audit approach for each area.

    As the information is inserted, you do not have to leave space for each section, the system will expand the spreadsheet as required.

    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.