Auditing: A Risk Based-Approach (MindTap Course List)
11th Edition
ISBN: 9781337619455
Author: Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 41RQSC
To determine
Introduction: The use of data analytics has been developing. It is mainly used in external financial statement auditing and in internal auditing. Data analytics has the potential to transform external auditing as it changed internal auditing.
To ascertain: The way of data analytics tools could be used in the audit of automated
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Upon receipt of the documents from accounts payable department, the cash disbursements clerk files the documents until their payment due date. On the due date, the clerk prepares a cheque for the invoiced amount, which is sent to the treasurer who signs it and mails back to the supplier. The cash disbursement clerk then updates the cheque register, accounts payable ledger, and accounts payable control account from the clerk’s terminal. Finally, the clerk files the invoice and copy of purchase order, receiving report, cheque in the department.
Required: Describe the internal control weakness in Two Symbols’ cash disbursements system and discuss the risk associated with the weakness.
Sandol Corporation has numerous customers. A customer file is kept on disk storage.
Each customer file contains name, address, credit limit, and account
balance. The auditor wishes to test this file to determine whether credit limits are being
exceeded. The best procedure for the auditor to follow would be to:
a. Develop test data that would cause some account balances to exceed the credit
limit and determine if the system properly detects such situations.
O b. Request a printout of a sample of account balances so they can be individually
checked against the credit limits.
c. Request a printout of all account balances so they can be manually checked
against the credit limits.
O d. Develop a program to compare credit limits with account balances and print out
the details of any account with a balance exceeding its credit limit.
Janice Dodds opens the mail for the Ajax Plumbing Company. She lists all customer checks on a spreadsheetthat includes the name of the customer and the check amount. The checks, along with the spreadsheet, are thensent to Jim Seymour in the accounting department who records the checks and deposits them daily in the company’s checking account. How could the company improve its internal control procedure for the handling of itscash receipts?
Chapter 9 Solutions
Auditing: A Risk Based-Approach (MindTap Course List)
Ch. 9 - In the revenue cycle, the most significant...Ch. 9 - Which of the following statements is true...Ch. 9 - Prob. 4CYBKCh. 9 - Prob. 7CYBKCh. 9 - Prob. 8CYBKCh. 9 - Prob. 9CYBKCh. 9 - Prob. 10CYBKCh. 9 - Prob. 11CYBKCh. 9 - Prob. 12CYBKCh. 9 - Prob. 13CYBK
Ch. 9 - Prob. 14CYBKCh. 9 - Prob. 15CYBKCh. 9 - Prob. 16CYBKCh. 9 - Prob. 17CYBKCh. 9 - Prob. 18CYBKCh. 9 - Which of the following statements is false...Ch. 9 - Prob. 20CYBKCh. 9 - Prob. 22CYBKCh. 9 - Prob. 23CYBKCh. 9 - Prob. 24CYBKCh. 9 - Prob. 25CYBKCh. 9 - Prob. 26CYBKCh. 9 - Prob. 27CYBKCh. 9 - Prob. 28CYBKCh. 9 - Prob. 29CYBKCh. 9 - Prob. 30CYBKCh. 9 - Prob. 31CYBKCh. 9 - Prob. 32CYBKCh. 9 - Refer to Exhibit 9.1. Which accounts are relevant...Ch. 9 - Prob. 2RQSCCh. 9 - Prob. 3RQSCCh. 9 - An important task ¡n the audit of the revenue...Ch. 9 - Prob. 5RQSCCh. 9 - Prob. 6RQSCCh. 9 - Prob. 7RQSCCh. 9 - Prob. 8RQSCCh. 9 - Prob. 9RQSCCh. 9 - Prob. 10RQSCCh. 9 - Prob. 11RQSCCh. 9 - Prob. 12RQSCCh. 9 - Prob. 13RQSCCh. 9 - Prob. 14RQSCCh. 9 - Prob. 15RQSCCh. 9 - Stainless Steel Specialties (SSS) is a...Ch. 9 - Prob. 17RQSCCh. 9 - Prob. 18RQSCCh. 9 - Prob. 19RQSCCh. 9 - Prob. 20RQSCCh. 9 - Prob. 21RQSCCh. 9 - Prob. 22RQSCCh. 9 - Prob. 23RQSCCh. 9 - Prob. 24RQSCCh. 9 - Prob. 25RQSCCh. 9 - Prob. 26RQSCCh. 9 - Prob. 27RQSCCh. 9 - Prob. 28RQSCCh. 9 - Prob. 29RQSCCh. 9 - Prob. 30RQSCCh. 9 - Prob. 31RQSCCh. 9 - Prob. 32RQSCCh. 9 - Prob. 33RQSCCh. 9 - Prob. 34RQSCCh. 9 - Prob. 35RQSCCh. 9 - Prob. 36RQSCCh. 9 - Prob. 37RQSCCh. 9 - Prob. 38RQSCCh. 9 - Prob. 39RQSCCh. 9 - Read the following scenario about Strang...Ch. 9 - Prob. 41RQSCCh. 9 - Prob. 42RQSCCh. 9 - ZYNGA (LO Z 3, 4, 5, 6, 8) Refer to the Why It...Ch. 9 - UTSTARCOM, INC. (LO 2, 3, 4, 5, 6, 8) UTStarcom is...Ch. 9 - Prob. 47FFCh. 9 - Prob. 48FFCh. 9 - Prob. 55DAUA
Knowledge Booster
Similar questions
- The following procedures were recently installed by Raspberry Creek Company:a. After necessary approvals have been obtained for the payment of a voucher, the treasurer signs and mails the check. The treasurer then stamps the voucher and supporting documentation as paid and returns the voucher and supporting documentation to the accounts payable clerk for filing.b. The accounts payable clerk prepares a voucher for each disbursement. The voucher along with the supporting documentation is forwarded to the treasurer’s office for approval.c. Along with petty cash expense receipts for postage, office supplies, etc., several postdated employee checks are in the petty cash fund.d. At the end of the day, cash register clerks are required to use their own funds to make up any cash shortages in their registers.e. At the end of each day, all cash receipts are placed in the bank’s night depository.f. At the end of each day, an accounting clerk compares the duplicate copy of the daily cash deposit…arrow_forwardThe following are internal controls that theauditor has identified for various cycles.1. Sales invoices are matched with shipping documents and customer orders beforerecording in the sales journal.2. Receiving reports are prenumbered and accounted for on a daily basis.3. Sales invoices are independently verified before being sent to customers.4. Payments by check are received in the mail by the receptionist, who lists the checksand restrictively endorses them.5. Overtime hours for payroll are approved by the employee’s supervisor.6. Checks are signed by the company president, who compares the checks with theunderlying supporting documents.7. Unmatched shipping documents are accounted for on a daily basis.8. All payroll payments must have a valid employee identification number assigned bythe human resources department at the time of hiring.9. The accounts receivable master is reconciled to the general ledger on a monthly basis.a. For each internal control, identify the type(s) of…arrow_forwardConsider the following internal controls associated with an evaluated receipts process. For each control, identify the assertion for which the control is designed to prevent, or detect and correct misstatements. a. b. C. d. e. f. g. h. Software generates a daily report comparing the daily total in the cash disbursements journal with the total of payables submitted to the third-party payment processor for payment, and discrepancies are reported. Software generates a daily report of any discrepancies between the vendor accounting coding and general ledger accounts coding, which is compared with the purchase order and purchase requisition. Software generates a daily report of any discrepancies between the recorded payable and quantities on the receiving report. Once a receiving report is matched with a purchase, it cannot be matched with another purchase. Software generates a daily report of receiving reports that have not been matched one-for-one with the recording of a purchase and a…arrow_forward
- Janice Dodds opens the mail for Ajax Plumbing Company. She lists all customer checks on a spreadsheet that includes the name of the customer and the check amount. The checks, along with the spreadsheet, are then sent to Jim Seymour in the accounting department, who records the checks and deposits them daily in the company’s checking account. Required: Describe how the company could improve its internal control procedure for the handling of its cash receipts.arrow_forwardSharon, an audit manager assigned to the audit of Newsome Corporation is observing the client's revenue-receivables cycle. Sharon observes that the IT system responsible for processing and posting receivable transactions produces a daily exceptions report which is emailed to an accounts receivable clerk responsible for investigating the exceptions. Which of the following most accurately describes the type of control that is responsible for determining possible exceptions and forwarding them on to the accounts receivable clerk? • This type of control is typically referred to as a detective control. These types of controls usually assist the client in detecting items that need further investigation. These controls help to minimize misstatements in the financial statements. • This type of control is typically known as a manual IT control. This name is derived from the fact that although the control allows initial processing by the client's IT system, it is flagged for manual follow up. •…arrow_forwardWhich statement about Revenue Cycle is correct? The customer and accounts payable department gets copies of the invoice.The sales order department prepares the invoice.The billing department uses the sales order and shipping documents to create the invoice.The accounts receivable department uses the sales order to update the accounts receivable subsidiary ledgerarrow_forward
- The auditor of Ferguson’s, Inc., identified two internal controlsin the sales and collection cycle for testing. In the first control, the computer verifiesthat a planned sale on account will not exceed the customer’s credit limit entered inthe accounts receivable master file. In the second control, the accounts receivable clerkmatches bills of lading, sales invoices, and customer orders before recording in thesales journal. Describe how the presence of general controls over software programsand master file changes affects the extent of audit testing of each of these two internalcontrols.arrow_forwardAt Reyes Company, checks are not prenumbered because both the purchasing agent and the treasurer are authorized to issue checks. Each signer has access to unissued checks kept in an unlocked file cabinet. The purchasing agent pays all bills pertaining to goods purchased for resale. Prior to payment, the purchasing agent determines that the goods have been received and verifies the mathematical accuracy of the vendor’s invoice. After payment, the invoice is filed by vendor and the purchasing agent records the payment in the cash disbursements journal. The treasurer pays all other bills following approval by authorized employees. After payment, the treasurer stamps all bills “paid,” files them by payment date, and records the checks in the cash disbursements journal. Reyes Company maintains one checking account that is reconciled by the treasurer. Instructions (a) List the weaknesses in internal control over cash disbursements. (b) Identify improvements for correcting these…arrow_forwardAt Martinez Company, checks are not prenumbered because both the purchasing agent and the treasurer are authorized to issue checks. Each signer has access to unissued checks kept in an unlocked file cabinet. The purchasing agent pays all bills pertaining to goods purchased for resale. Prior to payment, the purchasing agent determines that the goods have been received and verifies the mathematical accuracy of the vendor’s invoice. After payment, the invoice is filed by vendor name and the purchasing agent records the payment in the cash disbursements journal. The treasurer pays all other bills following approval by authorized employees. After payment, the treasurer stamps all bills “paid,” files them by payment date, and records the checks in the cash disbursements journal. Martinez Company maintains one checking account that is reconciled by the treasurer. List the weaknesses in internal control over cash disbursements.arrow_forward
- V4. Hayden Corporation uses an enterprise resource planning (ERP) system. In their audit of receivables and revenues, the auditors have identified the following data elements in the corporation’s database that may be used for data analytics applications: Customer balance Customer credit limit and credit rating Customer total annual sales Customer purchases by date Customer returns by date Customer name Customer shipping address Required: a. Describe two data analytic applications that might be used to audit the existence of receivables and occurrence of sales. b. Describe one data analytic application that might be used to audit the valuation of receivables.arrow_forwardChoose only one answer as well as state their reasons/rationale for the answer chosen. A customer entered the wrong account number on the memo line of the check mailed to the company. Consequently, another customer’s account was credited for that payment. The most effective way to prevent such problems would be to use:a. Turnaround documentsb. A validity check of customer account numbersc. Closed loop verificationd. Check digit verification of customer account numbersarrow_forwardAt Reyes Company, checks are not prenumbered because both the purchasing and the treasurer are authorized to issue checks. Each signer has access to unissued checks kept in a unlocked file cabinet. The purchasing agent pays all bills pertaining to goods purchased for resale. Prior to payment, the purchasing agent determines that the goods hae been received and verifies the mathematical accuracy of the vendor’s invoice. After payment, the invoice is filed by vendor and the purchasing agent records the payment in the cash disbursement journal. The treasurer pays all other bills following approval by authorized employees. After payment, the treasurer stamps all bills “Paid”, files them by paymet date, and records the checks in the cash disbursement journal. Reyes Company maintains one checking account that is reconciled by the Treasurer. Requirements: List the weaknesses in internal conrtrol over cash disbursements. Identity improvements for correcting these weaknesses.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage LearningAccounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Auditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College PubCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengagePkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Auditing: A Risk Based-Approach to Conducting a Q...
Accounting
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:South-Western College Pub
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L