Question: 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

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?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!