startIntegration with CCH Accounts Production
How To

Integration with CCH Accounts Production

CCH Audit Automation
Last update: Reading time 5 minutes
Trial BalanceJournalsSystem AdministrationProduct Integration

    Data transfer between CCH Accounts Production and CCH Audit Automation where the nominal codes match

    Import TB from CCH Accounts Production into CCH Audit Automation

    If the nominal codes in CCH Accounts Production and CCH Audit Automation match then the Update from CCH Accounts option can be used to update the trial balance in audit.

    AA capture.PNG

    If any nominals codes have been created in accounts prodution the user will be promted to set up the additional codes in audit as part pof the update process.

    Update journals (created in CCH Audit Automation) into CCH Accounts Production

    To transfer journals to CCH Accounts Production that have been posted in CCH Audit Automation the Update Journals to CCH Accounts button on the Utilities menu can be used

    Picture3.png

    The user will be promoted to select if they want to include the journals as journals or audit journals in accounts production.

    Capture21.JPG

    Other case of data integration between CCH Accounts Production and CCH Audit Automation

    When the nominal codes in CCH Accounts Production and CCH Audit Automation do not match, the process is as below:

    Initially both CCH Accounts Production and CCH Audit Automation need to be configured for manual Trial Balance transfer.
    Once this is done, any Trial Balance can be transferred using the route in C below and journals can be posted back from CCH Audit Automation as described in D.

    One off task in Accounts Production - Create structures for the file that needs to be exported and imported

    Export file structure

    1. Run CCH Central with CCH Accounts Production and log in.

    2. Select Maintenance > Accounts > Import/Export definition > File structure

    3. Ensure that the radio button 'Create Mapping Structure' is selected.

    4. Enter a name for the mapping file “Audit Automation Export”.

    5. Make sure Trial Balance is selected in the 'Mapping Structure Type' and the 'Comma Separated' radio button is selected.

    6. Enter 7 in the 'Number of fields' box using the scroll buttons.

    7. Select the Accounts Production Field Names from the drop down for each column so that they match those shown in the following screenshot.

    clipboard_ed2075cc807bdb360301c1f741e006193.png

    8. Once the screen appears with the same information as above, click on 'Save' and then close the screen.

    Import file structure

    1. Enter a name for the mapping file “Audit Automation Import”.

    2. Make sure Transactions is selected in the 'Mapping Structure Type' and the Comma Separated radio button is selected.

    3. Tick the 'Has headers' checkbox and enter 1 in the edit box to the right of this.

    4. Enter 6 in the 'Number of fields' box - using the scroll buttons.

    5. Select the Accounts Production field names from the drop down for each column so that they match those shown in the following screenshot.

    clipboard_e9eaee414e6ea06084f14e6a22d386972.png

    6. Once the screen appears with the same information as above, click on 'Save' and then close the screen.

    One off task in CCH Audit Automation

    1. Load CCH Audit Automation and log in as a system manager.

    2. Select File > System options then the complete the third-party import options as follows:

    clipboard_e0887d1359b761ab879ac337d33571e64.png

    3. The Path is the link path that you will use to store the Trial Balance and journals to be transferred between CCH Accounts Production and CCH Audit Automation and should be a path all users can access.

    4. Click on 'OK'.

    When you wish to export a Trial Balance to CCH Audit Automation in CCH Accounts Production

    1. Open the client to be exported in CCH Accounts Production 2.0. Select the current accounting period.

    2. Click on 'Export' in the functions panel.

    3. Click in File to Export, browse to the path provided for the link “C:\Temp” in the above example. Enter the code of the client in the File name. CCHTUTOR1 in the example below and click 'Save'.

    4. Enter “Audit Automation Export” in Structure name by selecting it from the drop down.

    5. The details of the file that will be created will be displayed. Click on 'Export' and the file will be created. Click on 'Add CCH Audit Lock' in 'Actions' to lock data entry.

    clipboard_e7dcdb814f5ebe7d05648eb912aea36c7.png

    In CCH Audit Automation

    1. Open the client for which the data has been exported and the system will display:

    clipboard_e1af2d6bbe3b37438f84eb78a96964177.png

    2. Click on 'Yes' and the Trial Balance will be imported.

    3. Once the Trial Balance has been imported the Trial Balance transfer file will be renamed so it will not be offered again.

    If there are any errors during the import, you will be advised of these and any difference will be taken to suspense. You may then correct the error and either manually re-allocate suspense, or repeat the export/import process.

    Transferring journals from CCH Audit Automation to CCH Accounts Production

    1. Enter the journals and mark them as agreed with the client.

    2. In the Utilities menu select 3rd option CCH Accounts Production journal posting file… This option is named using the third-party product entered in B so if you entered a different name there this option will be named accordingly.

    3. The system will create the export file and ask you to confirm that you are happy to mark the entries as exported. Provided that you did not receive any errors click on 'Yes'.

    4. This process will create a file in the link folder, C:\TEMP, in our example in B above, named with the code of the client and an extension of “.PRO”.

    In CCH Accounts Production

    1. Load the client and accounting period to which the journals are to be posted.

    2. Click 'Import' in the functions panel.

    3. Select Transactions as the import type.

    Note: This is very important as importing transactions appends the entries to those that currently exist. If you leave this as Trial Balance then running the import would clear the trail balance, deleting all existing transactions, before importing the journals.

    4. Leave the 'Mapping' name as <None>.

    5. By Structure Name select Audit Automation Import from the drop down.

    6. Click on the 'Browse' button to the right of File to Import and select the file that you have exported from CCH Audit Automation. This will be in the link folder and named with the code of the client and a suffix of “.PRO”. The file will be loaded and displayed in the grid.
     

    clipboard_e92b2808b8f2b33062ad288b691dbff5a.png

    7. If any codes using the export file to do match existing codes in Accounts Production, the 'Nominal Credit To' or 'Nominal Debit To' will be blank and you can either enter an existing code that the amount should be posted to, or abort the process, create the missing codes and run the import again.

    8. Finally, click on 'Import' to complete the process.

    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.