As a data analyst for an internal fraud advisory team at a regional accounting firm, you...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Related Book For
Auditing An International Approach
ISBN: 978-1259087462
7th edition
Authors: Wally J. Smieliauskas, Kathryn Bewley
Posted Date:
Students also viewed these accounting questions
-
You have been asked to perform a feasibility study on the design of a blood warmer to be used during the transfusion of blood to a patient. This exchanger is to heat blood taken from the bank at 10C...
-
You have been asked to perform a stock valuation prior to the annual shareholders meeting next week. The two models youve selected to value the firm are 1) the dividend discount model and 2) the...
-
Topic: Google Analytics Submit your answers to each of the 10 questions and the accompanying screenshots. Question 1 Company One wants an overview of the website activity of its users. Provide...
-
As Amazon.com grew rapidly after it first went online with Internet sales in 1995, it experienced several supply chain problems that other retail companies like L.L. Bean, Sears, and J.C. Penney were...
-
Refer to the Real Estate DataSaskatoon online, which reports information on home listings. a. Compute the mean and standard deviation of the distribution of the list prices for the homes. Assume this...
-
The following MINITAB output presents a 95% confidence interval for the mean ozone level on days when the relative humidity is 60%, and a 95% prediction interval for the ozone level on a particular...
-
Does Monsanto maintain an ethical culture that can effectively respond to various stakeholders ? The original Monsanto was very different from the current company. It was started by John F. Queeny in...
-
develop a plan outlining five occupational health services recommended by the ILO that Fakude Manufacturing Ltd . can implement to improve the health and well - being of its employees. Consider the...
-
San Francisco led the movement to ban plastic shopping bags and is now proposing to ensure people have access to safe high-quality tap water and ban bottled water. A supporter of the ban says The...
-
Elder Oasis outsources its app development to a foreign country where bribery is a way of life. Obtaining airline tickets, a taxi cab, and even medicine for a sick child necessitates some type of...
-
Consider and discuss how Lewins general theory of change underpins the complacency and leading change models (Exhibits 18.6 and 18.7). Exhibit 18.6 Exhibit 18.7 1. Establishing a sense of urgency 2....
-
What are the implications of behavioral finance?
-
You are asked to design a packed column to recover acetone from air continuously by absorption with pure water at \(289 \mathrm{~K}\). The air contains \(3.0 \mathrm{~mol} \%\) acetone, and a \(97...
-
Perhaps you have watched the game show known as Jeopardy. Contestants must prepare a question that is answered by a given prompt. It is your turn to play Jeopardy and your category is tools of...
-
Fill in the blanks to make the following statements correct. a. If the exchange rate is determined by the equality of supply and demand for foreign exchange and the central bank makes no...
-
IE Exercise 23-12 (Algo): Pricing using variable costs LO P6 Rios Company makes drones and uses the variable cost method in setting product price. Its costs for producing 31,000 units follow. The...
-
(a) Explain why the concentration of dissolved oxygen in freshwater is an important indicator of the quality of the water. (b) How is the solubility of oxygen in water affected by increasing...
-
Why is critical thinking becoming more important in the CAS and IFRS audit environment?
-
Define and explain privity, primary beneficiary, and foreseeable beneficiary in terms of the degree of negligence on the part of a PA that would trigger the PAs liability.
-
Major Manufacturing Company is a large diversified international corporation whose shares trade on the New York Stock Exchange. The U.S. Department of Justice and the SEC have investigated the Global...
-
Define accompanying information in an auditing context and give an example. What is a CPA's responsibility for this information?
-
When an auditor reports on financial statements prepared on an entity's income tax basis, the auditor's report should a. Disclaim an opinion on whether the statements were examined in accordance with...
-
An auditor's report on financial statements prepared on the cash receipts and disbursements basis of accounting should include all of the following except a. A reference to the note to the financial...
Study smarter with the SolutionInn App