Duplicate & Suspicious Claims: COUNTIFS Keys and Weekend Flags
This lesson is part of the course
In this lesson
You find claims submitted twice (same employee, date and amount), flag them for review, mark weekend claims and total the value that needs checking before payment.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Expense Report Totals by Category & Employee Locked
- Policy Compliance: Hotel Caps by City and Class of Travel Locked
- Per Diems: Travel Days, City Rates and 75 % Partial Days Locked
- Booking Lead Time vs Airfare: Buckets, CORREL and a Scatter Locked
- Duplicate & Suspicious Claims: COUNTIFS Keys and Weekend Flags Locked
- Mileage Reimbursement: Round Trips, Commute Deduction and a Rental Break-Even Locked
- Savings Opportunities: Advance Booking and Preferred Hotels Locked
- T&E Dashboard: Monthly Totals, Budget Variance, a Stacked Chart and Red Flags Locked