Read and work through IDEA Tutorial pages 48-59 of Section 4. NOTE: Start with “Creating a Pivot Table”

Read and work through IDEA Tutorial pages 48-59 of Section 4. NOTE: Start with “Creating a Pivot Table” on Page 48. Please skip the following sections: “Reviewing the History” on pages 50/51, “Appending a Virtual Field” on page 53/54, and “Performing a Record Extraction” on page 54/55. After reading the assigned tutorial pages, complete the Chapter 5 problems below.

Visit Connect’s additional student resources section to access the IDEA software (which will install the tutorial), the IDEA problems, and the Roger Company files. You can obtain instructions to access Connect from your instructor. Save the Roger Company project inside the “IDEA Projects” folder located in “Documents” >> “My IDEA Documents”. You may need to uncompress or unzip the file.

Roger Company is a mid-size company that handles the distribution of various home and garden products. You are part of the engagement team assigned to audit Roger Company’s financial statements. Roger Company has been an audit client of your firm for many years, and your firm has rarely encountered any problems with management or material misstatements in the past. However, the engagement partner has made it very clear to you that there is no room for mistakes. Your tasks as one of the auditors on the engagement are outlined below and in other problems in the following chapters.

Auditors must gather evidence, and obtain documentation around identified risks. A risk in the purchasing process is that a purchase is made from an unauthorized vendor. To gather evidence around this risk, we first want to open and join the two data sets (Accounts_Payable and Vendors) for Roger Company to begin the process for identifying the unauthorized vendors. Once the file is open, join the databases. With the Accounts_Payable file open, on the Analysis tab, in the Relate group, select Join to open the Join Databases window. Select Vendors as your Secondary database. Join both databases by vendor number in the Match menu (refer to Section 4 of the tutorial for additional help. Hint: AP Vendor Number must both be the same field format, i.e., either both numeric or both character). Choose to retain all records in both files. How many total records are there in the joint database?

Now that both the Accounts_Payable and Vendors data sets for Roger Company are joined together, right click a null cell in the CITY column and select the Display All Records Containing function identify how many transactions were made in the Accounts_Payable database using unauthorized vendors (refer to Section 4 of the tutorial for additional help).

One aspect of gathering evidence is obtaining copies of invoices. As has been demonstrated through the tutorial, IDEA is useful for testing completeness and finding gaps in invoice numbers. With the Shipping table open for Roger Company, on the Analysis tab, in the Explore group, select Gap Detection to open the Gap Detection window. How many gaps are there within the invoice numbers for the Shipping database?

  Do you need high-quality Custom Essay Writing Services?