Reference no: EM133123854

Question - As part of the engagement team for the audit of JA Tire Manufacturing for the year ended December 31, 2019, you are responsible for auditing the sales and collection cycle. The data file "JATireSales.xls" contains sales transaction information for the year ended December 31, 2019. You will use this data file to perform the following substantive tests of transactions for sales and cash receipts. Use IDEA to perform the testing.

1. The company issues sales invoices in sequential order. Use the Invoice file to determine whether there are any gaps or duplicates in the sales invoice sequence.

2. Company policy is that invoices are prepared after the invoicing function receives notification of shipment to the customer. Verify that each shipment in the Bill of Lading file is associated with an invoice in the Invoice file.

3. Company policy is that invoices should be prepared within five days of shipment. Identify any sales included in the Invoice file that were not invoiced within five days of shipment.

4. Verify that all sales included in the Invoice file are to authorized customers included in the Customer Master file.

5. Verify that the quantity and product number billed on the sales invoice matches the same information on the bill of lading and sales order (three-way match using the Invoice, Bill of Lading, and Sales Order files).

6. Determine that the total amount of the invoices included in the Invoice file (in the Amount column) is properly computed based on the quantities shipped and invoice prices.

Required -

a. Indicate the audit assertion being tested by each of the six audit procedures listed above.

b. Document any exceptions identified in your testing, including associated document numbers.

c. Assume your initial assessment of control risk was low for each of the revenue transactions assertions. Based on the exceptions found, indicate which audit assertion should have an increase in control risk and what you should do next as an auditor.