Example: Itemize Hotel Expenses Automatically
This example illustrates 1 way to configure an expense item so that Workday automatically itemizes hotel charges on expense report lines.
Your expense payees regularly use expense credit cards to pay for hotel charges. During a 2-night hotel stay, your employee uses their credit card for:
- These nonrecurring charges:
- Parking for 1 night.
- 3 meals.
- These recurring daily charges:
- Room rate.
- Room tax.
You want to configure a Hotel expense item that payees can use to itemize the payments on expense report lines.
- Contact your financial institution to request level 3 credit card transaction data for hotel stays.
- Create these expense items so you can map them to the Hotel expense item that you'll create: Meals, Parking, and Room Rate and Tax. See: Create Expense Items.
- Security:Set Up: Expense Itemdomain in the Expenses functional area.
- Access theCreate Expense Itemtask.
- In theSummarysection, specify these values:OptionDescriptionItem NameHotelSpend CategorySelect.
- In theProcessingsection, select these options:Actual Amountfrom theExpense Item Amount Typesubsection.None of the abovefrom theExpense Item Calculationsubsection.
- In theExpense Item Attributesgrid, add these values:AttributesExpense Report: Display to UserExpense Report: RequiredArrival DateSelect.Select.Departure DateSelect.Select.
- On theItemization Mappingtab:
- Select these check boxes:
- Hotel Expense
- Automatically Populate Itemization for Level 3 Credit Card Transaction Data
- Specify these values on the itemization grid:Expense ItemItemize Expense byRequiredIs Room RateAlways Generate Itemization LineProduct CodeMealsCharge BreakdownLeave blank.Leave blank.Leave blank.MasterCard - Restaurant Charges (L-1101)ParkingCharge BreakdownLeave blank.Leave blank.Leave blank.MasterCard - Valet Charges (L-1110)Room Rate and TaxRecurring Daily ChargeSelect.Select.We automatically select this check box when you select theRequiredcheck box.MasterCard - Room Rate (L-1000)MasterCard - Room Tax (L-1020)
- ClickOK.
- Configure security for your expense item.
Workday automatically itemizes hotel charges when expense payees:
- Create an expense report.
- Have credit card transactions that include level 3 data that you've mapped to the Hotel expense item.
On the expense report, we display an
Itemization
section that includes a Daily Expenses
subsection that details recurring daily charges. We also display charge breakdowns in a separate subsection beneath the Itemization
section.To review data for automatically itemized hotel expense items, create custom reports and include these report fields from the Expense Report Lines and Itemizations business object:
- Itemization Includes Lines Created Automatically from Level 3 Transaction Data
- Itemization Line Created Automatically from Level 3 Transaction Data
Workday doesn't automatically re-itemize a hotel transaction when a user manually modifies the expense item details of an automatically itemized hotel expense. To re-initiate automatic hotel itemization, delete the existing expense report line and re-add the credit card transaction to the expense report.
Workday doesn't automatically itemize hotel expenses when you add an expense item manually. We recommend that you set up expense item defaulting or merchant category codes mapping.