EXCEL PROBLEM: Employees should not approve their own expense reports. Usually their manager is the...
90.2K
Verified Solution
Link Copied!
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!
