Principles Of Auditing & Other Assurance Services
21st Edition
ISBN: 9781259916984
Author: WHITTINGTON, Ray, Pany, Kurt
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Question
Chapter 11, Problem 27QRA
a.
To determine
Describe two data analytic applications that might be used to audit the existence of receivables and the occurrence of sales.
b.
To determine
Describe one data analytic application that might be used to audit the valuation of receivables.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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.
Assume that your audit partner has asked you to design detailed substantive testingprograms for the accounts receivable and sales; inventory; purchases and accountspayable; and payroll systems of Square Pharma. Your partner also asked you toincorporate all or some of the following types of tests: Specific analytical procedures,tests of detail (i.e. direct tests on balances and tests of transactions of a balance).While designing the testing programs, assume that the Tests of Control identifythe weaknesses as described in each of the following situations, but no other. Insummary:(a)Consider the control weaknesses for each subsystem as set out below;
(b)Design and develop a substantive audit tests program using information fromlast three year annual reports and explain and justify your audit program in termsof audit objectives (also called 'audit assertions' )Note: The risk situations below are created for purposes of teaching and bear norelationship to events in Briscoe Group Ltd or any…
Your client has outsourced the majority of the accounting information system to a third-party data center. What impact does that have on your audit of the financial statements?
Chapter 11 Solutions
Principles Of Auditing & Other Assurance Services
Ch. 11 - Explain the difference between a customers order...Ch. 11 - Prob. 2RQCh. 11 - Prob. 3RQCh. 11 - State briefly the objective of the billing...Ch. 11 - Prob. 5RQCh. 11 - Prob. 6RQCh. 11 - Prob. 7RQCh. 11 - Prob. 8RQCh. 11 - Prob. 9RQCh. 11 - Prob. 10RQ
Ch. 11 - Prob. 11RQCh. 11 - Prob. 12RQCh. 11 - Prob. 13RQCh. 11 - Prob. 14RQCh. 11 - Prob. 15RQCh. 11 - Prob. 16RQCh. 11 - Prob. 17RQCh. 11 - Prob. 18RQCh. 11 - Prob. 19RQCh. 11 - Prob. 20RQCh. 11 - Prob. 21RQCh. 11 - Prob. 22RQCh. 11 - Give an example of a type of receivable...Ch. 11 - Prob. 24RQCh. 11 - Prob. 25QRACh. 11 - Prob. 26QRACh. 11 - Prob. 27QRACh. 11 - Prob. 28QRACh. 11 - Prob. 29QRACh. 11 - Prob. 30QRACh. 11 - Prob. 31QRACh. 11 - Prob. 32QRACh. 11 - Prob. 33QRACh. 11 - Prob. 34QRACh. 11 - Prob. 35QRACh. 11 - Prob. 36AOQCh. 11 - Which of the following would provide the most...Ch. 11 - Prob. 36COQCh. 11 - Prob. 36DOQCh. 11 - Prob. 36EOQCh. 11 - Under SEC rules, which of the following is not...Ch. 11 - Prob. 36GOQCh. 11 - Prob. 36HOQCh. 11 - Prob. 36IOQCh. 11 - Prob. 36JOQCh. 11 - Prob. 36KOQCh. 11 - Prob. 36LOQCh. 11 - Prob. 37OQCh. 11 - Prob. 38OQCh. 11 - An auditors working papers include the following...Ch. 11 - Prob. 40OQCh. 11 - Prob. 41OQCh. 11 - Prob. 42OQCh. 11 - Prob. 43OQCh. 11 - Prob. 44PCh. 11 - Prob. 45PCh. 11 - Prob. 46PCh. 11 - Prob. 47PCh. 11 - The July 31, 20X0, general ledger trial balance of...Ch. 11 - Prob. 49ITCCh. 11 - Prob. 50ECCh. 11 - Prob. 51EC
Knowledge Booster
Similar questions
- To gather audit evidence about the proper credit approval of sales (i.e., valuation assertion), the auditor would select a sample of documents from the population represented by the a. Subsidiary customers' accounts ledger. b. Sales invoice file. c. Bill of lading file. d. Customer order file.arrow_forwardSandol 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.arrow_forwardWhich of the following frames would best enable an auditor to test a sales/receivables system to determine that receivables are supported by all required documentation ? (a) Customer list (b) Sales invoice log Sales order log (d) Shipping logarrow_forward
- An example of an analytical procedure is the comparison of Results of a statistical sample with the expected characteristics of the actual population. O Computer generated data with similar data generated by a manual accounting system. Recorded amounts of major disbursements with appropriate invoices. O Financial information with similar information regarding the industry in which the entity operates.arrow_forwardYou are a trainee in audit firm and you have been assigned to verify the follow balances for IJK Limited; Account receivables Sales Inventories Account payables Vehiclesarrow_forwardIn order to determine whether accounts payable are understated, auditors wish to obtain a sample of purchase transactions from suppliers and how they were recorded in the accounting books. � , sampling is the best mechanism to obtain this type of samples. a . discovery b . attributes c . random digits d . variablesarrow_forward
- Which of the following audit procedures is aimed most directly at testing the completeness assertion for accounts payable? Footing the list of accounts payable. Tracing shipping reports after year-end to related customer purchase orders and invoices. Examining underlying documentation for cash disbursements in the period after year-end. Tracing shipping reports issued on or before year-end to related customer purchase orders and invoices.arrow_forwardIndicate whether each of the following audit procedures is a testof controls, a substantive test, or a dual-purpose test. Next, indicate the financial statement assertion most closely related to each audit procedure. Required:a. Vouch recorded sales invoices to supporting shipping documents.b. Inspect recorded sales invoices for credit approval.c. Vouch recorded sales invoices prices to the approved price list.d. Send confirmations to all customers regarding accounts receivable.e. Recalculate the arithmetic accuracy of the recorded sales invoices.f. Compare the shipment date of recorded sales invoices with the invoice record date.g. Trace recorded sales invoices to posting in the general ledger control account and in the correct customer’s account.h. Select a sample of shipping documents from the shipping department file and trace shipments to recorded sales invoices.i. Scan recorded sales invoices and shipping documents for missing numbers in sequence.j. Vouch sales invoices and…arrow_forwardWhich of the following audit procedures represent a substantive test of transaction that would validate managements assertion on occurrence of a purchase transaction a. Comparing the classification of the transaction based on the supplier's invoice with the company’s chart of accounts. b. Recalculation of the supplier's invoice to check its mathematical accuracy. c. Reviewing and scanning of the purchases journal for large or unusual amounts. d. Tracing from the file of receiving reports to the purchases journalarrow_forward
- Which of the following procedures would provide the most reliable audit evidence?a. Inquiries of the client’s internal audit staff.b. Inspection of prenumbered client purchase orders filed in the vouchers payable department.c. Inspection of vendor sales invoices received from client personnel.d. Inspection of bank statements obtained directly from the client’s financial institution.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_forwardThe following are examples of audit procedures: Watch employees count inventory to determine whether company procedures are being followed. Count a sample of inventory items and record the amount in the audit files. Calculate the ratio of sales commission expense to sales as a test of sales commissions. Review the accounts receivable with the credit manager to evaluate their collectability. Compare a duplicate sales invoice with the sales journal for customer name and amount. Obtain a written statement from a bank stating that the client has $15,671 on deposit and liabilities of $500,000 on a demand note. Add the sales journal entries to determine whether they were correctly totaled. Obtain a letter from the client’s attorney addressed to the CPA firm stating that the attorney is not aware of any existing lawsuits. Extend the cost of inventory times the quantity on an inventory listing to test whether it is accurate. Obtain a letter from an…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 LearningAuditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
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