Http awards mtmrecognition com estes

Case Analysis

Analytics mindset

P-card

Part VI:

Task 6

OSU’s internal controls prohibit transactions to purchase any of the following things:

· Alcohol

· Cash, cash advances, automated teller machine transactions

· Donations and sponsorships

· Gifts, gift cards, gift certificates

· Late fees

· Personal purchases of any type

Required

Using the same file from Week 3 Analytics mindset case studies PCard FY2014 that you already have loaded into IDEA you will perform the following:

Part 1

· Create reports in IDEA that will search for prohibited transactions from the list above.

· Perform two different types of searches (you can use Direct extract of Criteria) listed below for each of the 6 categories listed above for a total of 12 items.

· Search descriptions for possible key words that indicate internal control deviations (e.g., search descriptions for purchases of alcohol). The query should return the relevant information about the transaction for follow up investigation if needed.

· Search vendor names for possible key words that indicate internal control deviations (e.g., search vendor names for purchases from the ATM). The query should return the relevant information about the transaction for follow up investigation if needed.

· Based on these searches identify possible transactions, individuals or vendors that should be investigated further for violation of these internal control policies. Document your results in the attached worksheet (add additional rows if needed), by specifying the transaction date, the search criteria you used and the output you discovered (be sure to provide screen captures of the results). Write a brief statement about what additional tests you recommend performing on these transactions. An example is provided in the worksheet.

· Make sure you use professional judgment to eliminate false-positives. For example, purchasing rubbing alcohol for a laboratory would not be an example of a potential internal control violation even though alcohol was purchased.

Part 2

· Create reports in IDEA using the join feature, that will identify unauthorized cardholders making purchases and unauthorized agencies being used in the transactions.

· A)

· Perform two different types of queries listed below.

· Identify cardholders for possible indication of internal control violations where unauthorized cardholders are using the purchase cards. Join the cardholders list and compare it to the transaction list to see if any transactions need follow up investigation.

· B)

· Identify agency names or numbers for possible indication of internal control violations where unauthorized agencies are indicated on purchase card transactions. Join the agency name or number list and compare it to the transaction list to see if any transactions need follow up investigation.

· Based on these searches identify possible transactions that should be investigated further for violation of these internal control policies. Document your results in the attached worksheet (add additional rows if needed), by specifying the transaction date, the search criteria you used and the output you discovered (be sure to provide screen captures of the results). Write a brief statement about what additional tests you recommend performing on these transactions.

Part 3

· Create reports in IDEA using the gap and duplicate detection features, that will identify any gaps and/or duplicate transaction numbers.

· Perform the detection features listed below.

· Identify trans no that may be missing for possible indication of internal control violations since all transaction numbers are automatically generated. Use gap detection on the trans no field to see if any transactions need follow up investigation.

· Identify trans no that may be duplicates for possible indication of internal control violations since all transaction numbers are automatically generated. Use duplicate detection on the trans no field to see if any transactions need follow up investigation.

· .

Based on these features identify possible transactions that should be investigated further for violation of these internal control policies. Document your results in the attached worksheet (add additional rows if needed), by specifying the transaction date, the search criteria you used and the output you discovered (be sure to provide screen captures of the results). Write a brief statement about what additional tests you recommend performing on these transactions.

Part 1

Category and test

Transaction Date

Description of search criteria

Output Summary (print screen your output to insert into your paper)

Next steps

Alcohol

· Searched description field for Beer

· Searched description field for Wine

· No results were obtained

· No results were obtained

· No further work is needed for this query because this does not violate policy.

· No further work is needed for this query because this does not violate policy.

Cash

· Searched vendor field for ATM

· Searched vendor field for Cash

· No results were obtained

· No results were obtained

· No further work is needed for this query because this does not violate policy.

· No further work is needed for this query because this does not violate policy.

Donations

· Searched description field for Donation

· Searched vendor field for Sponsor

· No results were obtained

· No results were obtained

· No further work is needed for this query because this does not violate policy.

· No further work is needed for this query because this does not violate policy.

Gifts

· Searched description field for Gift

· Searched description field for Vendedor

· No results were obtained

· No results were obtained

· No further work is needed for this query because this does not violate policy.

· No further work is needed for this query because this does not violate policy.

Late Fees

· Searched description field for Late Fee

· Searched description field for Fee

· No results were obtained

· No results were obtained

· No further work is needed for this query because this does not violate policy.

· No further work is needed for this query because this does not violate policy.

Personal

See Print Screen# 12 for transactions date details

· Searched Merchant Category Code (MCC) field for Personal

· Searched Merchant Category Code (MCC) field for: MISCELLANEOUS PERSONAL SERVICES—NOT ELSEWHERE CLASSIFIED

· No results were obtained

· 25 results were returned that was described as a Miscellaneaus Personal Services not elsewhere classified

· No further work is needed for this query because this does not violate policy.

Contact the Oklahome State University Suppervisors and/or Cardholders to ask about this purchase.

Part 2

Category and test

Transaction Date

Description of search criteria

Output Summary (print screen your output to insert into your paper)

Next steps

·

· Print Screen #13

·

Print Screen #14

Oklahoma State University – South with Agency Number 1200 must be investigated (Add other steps here)

Part 3

Category and test

Transaction Date

Description of search criteria

Output Summary (print screen your output to insert into your paper)

Next steps

·

·

·

Analytics mindset case studies – P-card 1

© 2016 Ernst & Young Foundation (US). All Rights Reserved.

SCORE No. 04134-161US

Analytics mindset case studies – P-card 2

© 2016 Ernst & Young Foundation (US). All Rights Reserved.

SCORE No. 04134-161US