Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. excel problem: employees should not approve their

EXCEL PROBLEM: Employees should not approve their own expense reports. Usually their manager is the...

90.2K

Verified Solution

Question

Accounting

EXCEL PROBLEM: Employees should not approve their own expense reports. Usually their manager is the approver; however, someone other than the employee should approve a claim for segregation of duties purposes. Test the data to see which employees approved their own expenses. (Hint: Create a true/false calculation.) What are their names? How much, in total, did the employees from question 4 approve for themselves?

I have a data set with these categories:

Expense Tracking Number

Approver Employee Number

Approver Name

Expense Approved Date

Reimbursement Paid Date

Expense Type

Description

Expense Category

Ticket Number

Ticket Status

Transaction Date

Vendor

Employee Number

Employee Name

Department

Payment Description

Mileage Rate

Miles

Number Guests

Transaction Amt

How do I create this TRUE/FALSE calculation to solve this?

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Biology
1.2K views

describe the process that occures in gyclosis. Be sure to describe all phases and products throughtout.

Physics
1.2K views

A mass m = 1 kg is attached to a spring with constant k =...

Psychology
1.2K views

Assess the strain theories of Cohen (1955) and Cloward and Ohlin (1960) as explanations of gang...

Physics
1.2K views

Two bodies of masses 10 gm and 90 gm are connected by a weightless spring...

Physics
1.2K views

A person slowly pulls a water bucket of mass 2m from a well with a...

Statistics
1.2K views

Horchata 56 Jamaica Carne Al Asada Pastor Totals 0 Tamarindo 7 63 9 6 33...

Accounting
1.2K views

The following data for the current year ended June 30 are from the accounting records...

Accounting
1.2K views

On November 10 in the current year, zzzz Best sold carpet to a customer for...

Accounting
1.2K views

Exercise 9-17 You are called by Tim Duncan of Sandhill Co. on July 16 and...

Accounting
1.2K views

receivable of $95,400 at March 31, 2017. Credit terms are 2/10, n/30. At March 31,...

Accounting
1.2K views

financial reporting of any not-for-profit institution . Accounting for not-for-profit institutions differs greatly from accounting...

Accounting
1.2K views

Checking account balance $939,320; certificate of deposit $1,445,300; cash advance to subsidiary of $982,280; utility...