You are conducting substantive tests on the accounts receivable file to verify its accuracy. The file is large, and you decide to test only a sample of the records. Because of the complexity of the database structure, you cannot access the database directly. The client’s systems programmer uses a utility program to write a query that produces a flat file, which he provides for testing purposes. Required Discuss any concerns you would have as an auditor and any actions you would take.

You are conducting substantive tests on the accounts receivable file to verify its accuracy. The file is large, and you decide to test only a sample of the records. Because of the complexity of the database structure, you cannot access the database directly. The client’s systems programmer uses a utility program to write a query that produces a flat file, which he provides for testing purposes. Required Discuss any concerns you would have as an auditor and any actions you would take.

Auditing: A Risk Based-Approach (MindTap Course List)

11th Edition

ISBN:9781337619455

Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg

Publisher:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg

Chapter5: Professional Auditing Standards And The Audit Opinion Formulation Process

Section: Chapter Questions

Problem 33RQSC

See similar textbooks

Similar questions

Case Study. You are conducting substantive tests on the Accounts Receivable file to verify its accuracy. The file is large, and you decide to test only a sample of records. Because of the complexity of the database structure, you cannot access the database directly. The client’s systems programmer uses a utility program to write a query that produces a flat file, which he provides for testing purposes. Discuss any concerns you would have as an auditor and any actions you would take.
Which of the following is an advantage of computer-assisted audit techniques (CAATs)?a. All the CAATs programs are written in one computer language.b. The software can be used for audits of clients that use differing computer equipment and file formats.c. The use of CAATs has reduced the need for the auditor to study input controls for computer-related procedures.d. The use of CAATs can be substituted for a relatively large part of the required testing.
You are conducting substantive tests on the Accounts Receivable file to verify its accuracy. The file is large, and you decide to test only a sample of records. Because of the complexity of the database structure, you cannot access the database directly. The client's systems programmer uses a utility program to write a query that produces a flat file, which he provides for testing purposes. Discuss any concerns you would have as an auditor and any actions you would take.
When an auditor tests the internal controls of a computerized accounting system, which of the following is true of the test data approach? A. Test data are coded to a dummy subsidiary so they can be extracted from the system under actual operating conditions. B. Test data programs need NOT be tailor-made by the auditor for each client's computer applications. C. Test data programs usually consist of all possible valid and invalid conditions reguarding compliance with internal controls. D. Test data are processed with the client's computer and the results are compared with the auditor's predetermined results.
A primary advantage of using generalized audit software packages to audit the financial statements of a client that uses a computer system is that the auditor may: a.Access information stored on computer files while having a limited understanding of the client’s hardware and software features. b.Consider increasing the use of substantive tests of transactions in place of analytical procedures. c.Substantiate the accuracy of data through selfchecking digits and hash totals. d.Reduce the level of required tests of controls to a relatively small amount.
Suppose your company has built a database application that runs on a centralized database, but even with a high-end computer and appropriate indices created on the data, the system is not able to handle the transaction load, leading to slow processing of queries. What would be some of your options to allow the application to handle the transaction load?
1. Explain how client internal controls can be improved through the proper installation of IT. 2. Distinguish between random error resulting from manual processing and systematic error resulting from IT processing and give an example of each category of error. 3. Explain what is meant by auditing around the computer, and describe what must be present for this approach to be effective in the audit of a client that uses IT to process accounting information. 4. An audit client is in the process of creating an online Web-based sales ordering system for customers to purchase products using personal credit cards for payment. Identify three risks related to an online sales system that management should consider. For each risk, identify an internal control that could be implemented to reduce that risk. 00000000000
The increasing use of sophisticated EDP systems has produced significant changes in the accounting environment. The changes are: Documents that are used to enter information into the computer may exist for only a short time or only in computer-readable form. In some computer systems, input documents may not exist at all, because the information is entered directly into the system. Required: Discuss the impact on the internal control system and the independent audit.
Among the client electronic data processing (EDP) systems listed below, which one can typically undergo an audit without the need for examining or directly testing the EDP computer programs of the system? Select one: a. A system that updates a few essential master files and produces no printed output other than final balances. b. A system that affects a number of essential master files and produces a limited output. c. A system that performs relatively uncomplicated processes and produces detailed output. d. A system that performs relatively complicated processing and produces very little detailed output. Question 8 Not yet answered Marked out of 1 Flag question Question text In the aftermath of the initial stage of examini
Among the client electronic data processing (EDP) systems listed below, which one can typically undergo an audit without the need for examining or directly testing the EDP computer programs of the system?Select one: a. A system that updates a few essential master files and produces no printed output other than final balances. b. A system that affects a number of essential master files and produces a limited output. c. A system that performs relatively uncomplicated processes and produces detailed output. d. A system that performs relatively complicated processing and produces very little detailed output.
Which of the following statements is most accurate? a. ERP systems are commercial software packages that are sometimes called turnkey systems because they can be implemented by the user with little or no modification. b. Substantive tests provide evidence focused on the system controls. c. Public accounting firms that provide attest services are not allowed under SOX to offer IT advisory services. d. Both small and large firms that have standardized information needs are potential customers for commercial software. e. External auditors may rely on the work of internal auditors only if they report to the controller or the CEO of the client company.
Answer the following from Chapter 7 of the textbook (write a one page response for each question): Discussion Question 27: Explain how an audit trail might get “lost” within a computerized system. Discussion Question 37: Explain why Benford's Law is useful to auditors in the detection of fraud. Discussion Question 41: Explain the necessity for performing substantive testing even for audit clients with strong internal controls and sophisticated IT systems.