Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved 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

Identify which transactions numbers each test would identify. 

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

Step by Step Solution

3.43 Rating (150 Votes )

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing An International Approach

Authors: Wally J. Smieliauskas, Kathryn Bewley

7th edition

1259259870, 1259087468, 70968292, 978-1259087462

More Books

Students also viewed these Accounting questions

Question

8.1 Describe how culture can be considered as cognition.

Answered: 1 week ago

Question

3. How do other scholars define culture?

Answered: 1 week ago