Policy Compliance: Hotel Caps by City and Class of Travel
This lesson is part of the course
In this lesson
You compute the nightly hotel rate of each trip, look up the city cap with a default for unlisted cities, and flag hotel stays above the cap and business-class flights the policy does not allow.
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