You have been asked to assist in the planning and development of audit data analytics as a
Question:
You have been asked to assist in the planning and development of audit data analytics as a substantive test for Cloud 9. Cloud 9 uses an evaluated receipt settlement system (see Chapter 12) that involves electronic invoice presentment and payment (EIPP) for 90% of its purchase transactions. The following information is captured electronically within this system.
Required
Plan a substantive test of purchase transactions using ADA as a substantive test. When planning the substantive test, identify the following:
a. What is (are) the assertion(s) being tested?
b. What information are you comparing electronically for each assertion?
c. What electronic evidence would represent a misstatement for each assertion?
Field Description A unique identification number for each vendor Vendor's mailing address excluding city, state, post (zip) code Database Vendor Master File Field Code Data Type 6-digit number Data Input By Cloud 9 Vendor_ID Cloud 9 Text Vendor_ADD Vendor_CITY City associated with Vendor_ADD Text Cloud 9 Vendor_STATE State associated with Vendor_ADD Text Cloud 9 Vendor_PC Vendor post (zip) code Text Cloud 9 Vendor COUN Country associated with Vendor_ADD Text Cloud 9 Vendor Bank Routing number and account number for vendor Numeric data Cloud 9 Account Number Vendor Credit Limit Amount of credit extended by the vendor 9-digit number Cloud 9 EIPP Databasec Vendor_ID A unique identification number for each vendor 6-digit number Cloud 9 A unique transaction number that follows each transaction from order (serves as purchase order number), through shipment (serves a shipment number), receiving (serves as receiving number), invoicing (serves an ASN number), recording of the liability (serves as voucher number) and Cloud 9 and Vendor EIPP_NO 14-digit number payment (number identified on payment). PO DATE Order date MM/DD/YYҮY Cloud 9 PO SHIP_ADD Shipping address for PO excluding city, state, post (zip) code Text Cloud 9 PO_CS PO_SHIP_ADD Text Cloud 9 PO_PC Post (zip) code for PO_SHIP_ADD Text or number Cloud 9 PO_COUNTRY Country associated with PO_SHIP_ADD Text Cloud 9 14-digit number 7-digit number PO_PROD_CODE Product number Cloud 9 PO_PROD_QUANT Inventory quantity ordered by Cloud 9 Cloud 9 PO PROD PRICE Price per unit for each item ordered by Cloud 9 $X.XXX.XX Cloud 9 PO_ACCT Account charged based on ordering department 5-digit number Cloud 9 TOTAL ORD_PRICE Total price for the individual purchase order $XXX,XXX.XX Cloud 9 ASN DATE ASN date MM/DD/YYҮҮ Vendor PROD_NO Unique inventory number 14-digit number Vendor PROD_QUANT Inventory quantity ordered by Cloud 9 7-digit number Vendor PROD_PRICE Price for each item ordered by Cloud 9 $X,XXX.XX Vendor ASN_TOTAL Sum total of the vendor's advance shipping notice $XXX,XXX.XX Vendor ASN TERMS % discount allowed if paid within XX days from receiving date PP.P%/XX Vendor BILL_ADD Billing address excluding city, state, post (zip) code Text Vendor City and state (separated by a comma) associated with BILL_ADD BILL CS Text Vendor BILL_PC Post (zip) code associated with BILL_ADD Text Vendor BILL_COUNTRY Country associated with BILL_ADD Text Vendor BL DATE Bill of lading date MM/DD/YYҮY Vendor SHIP_ADD Shipping address excluding city, state, post (zip) code Text Vendor SHIP_CS City and state (separated by a comma) associated with SHIP_ADD Text Vendor SHIP_PC Post (zip) code associated with SHIP_ADD 5-digit number Vendor SHIP_COUNTRY Country associated with SHIP_ADD Text Vendor 14-digit number 7-digit number SHIP_PROD_NO Unique inventory number Vendor SHIP_QUANT Inventory quantity shipped by vendor Vendor REC DATE Date of receipt of goods MM/DD/YYYY Cloud 9 REC_ADD Shipping address excluding city, state, post (zip) code Text Cloud 9
Step by Step Answer:
a The following assertions should be tested with respect to purchase transactions a Completeness b O...View the full answer
Auditing A Practical Approach with Data Analytics
ISBN: 978-1119401742
1st edition
Authors: Raymond N. Johnson, Laura Davis Wiley, Robyn Moroney, Fiona Campbell, Jane Hamilton
Students also viewed these Business questions
-
(a) Your firm has been hired to build a large government facility near a residential neighbor-hood. A committee of residents has been formed to oppose the building. You have been asked to assist in...
-
The Thompson Corporation, a manufacturer of steel products, began operations on October 1, 2016. The accounting department of Thompson has started the fixed-asset and depreciation schedule presented...
-
This case study on project evaluation is applicable for beginning courses in corporate finance or finance strategy. Two alternative investment options are available to evaluate. Challenges are...
-
Given the following network, with the indicated flow capacities along each branch, determine the maximum flow from source node 1 to destination node 10 and the flow along eachpath: 15 5 10 7 16 12 0...
-
A compact-valued correspondence
-
According to general trends in the periodic table, predict which element in each of the following pairs has the larger atomic radius. (a) Li or Na (b) N or P (c) Mg or Ca (d) Ar or Kr. Periodic...
-
Apply the marketing-myopia concept to print media, magazines, and newspapers. What is the implication?
-
(Comprehensive 2-Year Worksheet) Lemke Company sponsors a defined-benefit pension plan for its employees. The following data relate to the operation of the plan for the years 2010 and 2011. (a)...
-
An owner arrives to collect her dog's prescription for ampicillin tablets. The dog weighs 23 kg and the dose of ampicillin suggested by the vet is 15 mg/kg/t.i.d. You have the tablets available in...
-
As an experienced networking professional, you are asked to conduct a posture assessment on a local credit union's network. The credit union currently has two locations, a headquarters downtown...
-
Perform the following as part of the 2022 audit of G&J Airlines. The dependent variable is revenue. The independent variable is passenger miles. a. Plan an ADA as a risk assessment procedure that...
-
What step follows planning the ADA? a. Evaluating results and concluding whether the purpose of the ADA has been achieved. b. Considering the relevance and reliability of data used. c. Accessing and...
-
Specify the following queries on the COMPANY relational database schema shown in Figure 3.5, using the relational operators discussed in this chapter. Also show the result of each query as it would...
-
Jennifer Davis wants to invest in four-year bonds that are currently priced at $853.73. These bonds have a coupon rate of 5.7 percent and make semiannual coupon payments. What is the current market...
-
Cheryl Thompson is a manager for Health Care Inc.Her weekly earningsare subject to deductions for Social Security, Medicare, FIT, and State Income tax.Assume a FICA rate of6.2%on$128,400for social...
-
what are the main issues with population growth contributing to climate chnage? How does population growth contribute to climate change? what issues does it cause?
-
You are borrowing $30,000 to buy a car. The terms of the loan call for monthly payments for 5 years at 7 percent interest (annual). What is the amount of each payment?
-
In the next three years, there will be three cash flows: $168, $148, $153 at the end of each year. The discount rate is 3.8%. Find the present value of the cash flows.
-
On January 1, 2017, Bretz, Inc., acquired 60 percent of the outstanding shares of Keane Company for $573,000 in cash. The price paid was proportionate to Keane's total fair value although at the date...
-
Flicker, Inc., a closely held corporation, acquired a passive activity this year. Gross income from operations of the activity was $160,000. Operating expenses, not including depreciation, were...
-
"So, any good news on the staffing front, Till?" Sophie White Eagle asked in between bites of a Christmas cookie. "Nope. Still short at least one staff accountant," Tillman Rollins replied glumly...
-
The busy season that was winding down had been notable for Madison because it was her first as an audit manager for her employer, a large practice office of a Big Four accounting firm. Her promotion...
-
Leigh Ann Walker graduated from a major state university with a bachelor's degree in accounting.1 During her college career, Walker earned a 3.9 grade point average and participated in several...
-
find the balance on the credit card after 3 months with the following information: apr = 15.99% carryover balance for month 1 = $793.16 minimum payment is $50 or 8%, whichever is greater
-
Discuss the following questions: Should we pay federal employees or contractors a percentage of any amounts they help recover to better incentivize them to fight fraud? Which enforcement functions...
-
A loan is negotiated with the lender agreeing to accept $8, 000 after 1 year, $9, 000 after 2 years, and $20, 000 after four years in full repayment of the loan. The loan is renegotiated so that the...
Study smarter with the SolutionInn App