As a data analyst for an internal fraud advisory team at a regional accounting firm, you...

 

Transcribed Image Text:

As a data analyst for an internal fraud advisory team at a regional accounting firm, you have been asked to perform a review of the fraud risk in the client's expense reimbursement process. You must analyze the following travel expense transactions, submitted by the company's vice president of sales. To assess the transactions for the presence of fraud flags, you will perform the following four data analytics tests. Read about each test and visually review the spreadsheet below. Tests: Transactions where the amounts are the same and the transaction dates are the same, but the types are different (one is credit card and one is cash). Transactions where all fields are the same except for the expense submission date. Transactions with transaction type "Cash" and category that is "out of policy" for cash payment. See "Out of policy cash categories" (below) for a list of categories to analyze. Late expense submissions: Transactions with an expense submission date more than 30 days after the transaction date. Double dipping: Duplicate expenses: Inappropriate cash: Out of policy cash categories: Airline Hotel Rental Car Meals (Over $35) Rideshares (Uber, Lyft, etc.) Transaction Category 1125 1126 1127 1128 1129 1130 1131 1132 Airline Hotel Meal Airline Taxi Meal Meal Rental Car Amount $827.34 Delta $983.09 $33.28 Vendor Ritz Carlton N/A $827.34 Delta $14.05 $19.54 $29.54 Uber Starbucks Chipotle $224.09 Enterprise Transaction Date 1/28/202X 2/4/202X 2/2/202X 1/28/202X 2/4/202X 2/1/202X 2/1/202X 2/4/202X Description Roundtrip flight Three-night stay Dinner Roundtrip flight Ride from airport to home Breakfast Lunch Four-day rental Transaction Type Credit Card Credit Card Cash Credit Card Cash Cash Credit Card Credit Card Expense Submission Date 2/15/202X 3/1/202X 3/1/202X 3/1/202X 3/1/202X 3/1/202X 3/1/202X 3/1/202X 1133 1134 1135 Taxi Meal Taxi Duplicate expenses Save for Later Inappropriate cash $14.56 Lyft Identify which transactions numbers each test would identify. Late expense submissions $85.38 Expense Reimbursement Test Transactions Identified Double dipping Jimmy's Steakhouse $29.54 Uber > > > < < < 2/1/202X 2/3/202X 2/4/202X Ride from home to airport Dinner with client Ride from airport to home Credit Card Credit Card Credit Card 3/1/202X 3/1/202X 3/27/202X Attempts: 0 of 1 used Submit Answer As a data analyst for an internal fraud advisory team at a regional accounting firm, you have been asked to perform a review of the fraud risk in the client's expense reimbursement process. You must analyze the following travel expense transactions, submitted by the company's vice president of sales. To assess the transactions for the presence of fraud flags, you will perform the following four data analytics tests. Read about each test and visually review the spreadsheet below. Tests: Transactions where the amounts are the same and the transaction dates are the same, but the types are different (one is credit card and one is cash). Transactions where all fields are the same except for the expense submission date. Transactions with transaction type "Cash" and category that is "out of policy" for cash payment. See "Out of policy cash categories" (below) for a list of categories to analyze. Late expense submissions: Transactions with an expense submission date more than 30 days after the transaction date. Double dipping: Duplicate expenses: Inappropriate cash: Out of policy cash categories: Airline Hotel Rental Car Meals (Over $35) Rideshares (Uber, Lyft, etc.) Transaction Category 1125 1126 1127 1128 1129 1130 1131 1132 Airline Hotel Meal Airline Taxi Meal Meal Rental Car Amount $827.34 Delta $983.09 $33.28 Vendor Ritz Carlton N/A $827.34 Delta $14.05 $19.54 $29.54 Uber Starbucks Chipotle $224.09 Enterprise Transaction Date 1/28/202X 2/4/202X 2/2/202X 1/28/202X 2/4/202X 2/1/202X 2/1/202X 2/4/202X Description Roundtrip flight Three-night stay Dinner Roundtrip flight Ride from airport to home Breakfast Lunch Four-day rental Transaction Type Credit Card Credit Card Cash Credit Card Cash Cash Credit Card Credit Card Expense Submission Date 2/15/202X 3/1/202X 3/1/202X 3/1/202X 3/1/202X 3/1/202X 3/1/202X 3/1/202X 1133 1134 1135 Taxi Meal Taxi Duplicate expenses Save for Later Inappropriate cash $14.56 Lyft Identify which transactions numbers each test would identify. Late expense submissions $85.38 Expense Reimbursement Test Transactions Identified Double dipping Jimmy's Steakhouse $29.54 Uber > > > < < < 2/1/202X 2/3/202X 2/4/202X Ride from home to airport Dinner with client Ride from airport to home Credit Card Credit Card Credit Card 3/1/202X 3/1/202X 3/27/202X Attempts: 0 of 1 used Submit Answer