startCCH Audit Automation: BDE to SQL - Converter Consultancy (10091828)
How To

CCH Audit Automation: BDE to SQL - Converter Consultancy (10091828)

CCH Audit Automation
Last update: Reading time 3 minutes
SQL ServerData ConversionConsultancyCourse OutlinesBDE
    This online single session covers Master Pack administration functionality plus the setup work and the process of converting client files and where appropriate Master Packs from the BDE version to the SQL version.

    Overview

    This online single session covers Master Pack administration functionality plus the setup work and the process of converting client files and where appropriate Master Packs from the BDE version to the SQL version. 

    Key objectives

    • Masterpack administation
    • Convert client files and where appropriate Master Packs from the BDE version to the SQL version. 

      Course Duration: This session will last up to 3 hours.

    Course Contents

    Master Pack Administration

    • New Hierarchical Structure
    • Creating
    • Editing
    • Installing
    • Merging
    • Master Chart selection

    Client Conversion process

    • Running the converter programme on selected clients 
    • Checking the conversion log
    • Checking integrity of the client data in SQL
    • Balancing forward to new year in SQL
    • Updating to latest Master pack

    Pre-requisites

    Attendees should adhere to the Training session Guidelines.

    All attendees should have a good understanding of the BDE version of CCH Audit Automation and the existing audit procedures and policies of the practice.

    Data is being transferred from one database to another and therefore the following will need to be done in advance of the consultancy:

    • Identify which users on the BDE system have not worked on client files to be converted.  
    • Typically these would be old users who have left the firm a year or more ago but have not been deleted from the BDE system. 
    • The actual deletion of these will be done during the consultancy.
    • Select a few clients that we can use to test the conversion process.  
    • It would be best if these clients are at finalisation status in the BDE version.
    • We will need to use one of your computers to show you how to transfer clients. 
    • The computer we use will need to be running both old and new versions of the CCH Audit software as well as CCH Central and this of course will need to be the computer you use for the consultancy session. 
    • Contact us if you have made extensive changes to any of your Master Packs. 
    • If you have this may mean CCH will have to do some work on them prior to the consultancy so we will need as much notice as possible if this is the case.
    • Please note that in any event we will have a pre-call or email exchange concerning the above points prior to the consultancy session.


    Who is this course designed for?

    Representative(s) with Responsibility for the Running of the system - We will be covering how to convert files from old to new system as well as the administration of the Master Packs.  
    Therefore any user who has System Manager status for the system needs to be involved.
    Representative(s) who will be converting files – Super Users who will be involved in converting client files.

    Although we should not require IT during this session it is essential they can be contacted in case they are needed. 
    We will require access to your live system during the consultancy session and may need to do some setup work in CCH Central as well as the client converter program and will need system admin rights in CCH Central to do.

    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.