Itemize Hotel Expenses
- Create the expense items that you plan to use for your hotel itemization mapping.
- Security:Set Up: Expense Itemdomain in the Expenses functional area.
(For Mastercard and Visa) If you want to use level 3 credit card transaction data:
- Contact your financial institution to request level 3 credit card transaction data for hotel stays.
(Optional but recommended) Set up expense item defaulting. See: Steps: Set Up Recommendations and Defaulting for Expense Items on Credit Card Transactions.
You can make specific configurations on expense items so that Workday automatically itemizes hotel charges on expense report lines. Examples: Internet fees, room rates, and room tax.
- Access theCreate Expense ItemorEdit Expense Itemtask.
- On theExpense Item Attributesgrid, add theArrival DateandDeparture Dateattributes. When level 3 credit card transaction data isn't available, Workday uses these attributes to calculate the number of nights for hotel stays.
- Select these check boxes:
- Expense Report: Display to User
- Expense Report: Required
- Map your expense items using theItemization Mappingtab:
Option Description Hotel ExpenseSelect to designate the expense item as a hotel expense item. Selecting this check box also enables Workday to itemize credit card transaction data automatically on expense report lines.If you don't select this check box, Workday doesn't automatically itemize expense report lines with credit card transaction data for hotel stays. You'll also be unable to select these check boxes:- Automatically Populate Itemization for Level 3 Credit Card Transaction Data
- Is Room Rate
Automatically Populate Itemization for Level 3 Credit Card Transaction DataSelect to populate level 3 credit card transaction data automatically on itemized lines for hotel expenses.If you don't select this check box, you'll be unable to map product codes to your expense items.You must have at least 1 itemization mapping line for automatic itemization to work.Expense ItemSelect the expense items that you want to map for hotel itemization.Itemize Expense byCharge Breakdown: Select to populate the exact charge amount on the itemization line. Example: You want expense payees to provide a charge breakdown for their nonrecurring charges, such as laundry and meals.Recurring Daily Charge: Select to populate the average charge amount on the itemization line. Example: An expense payee stays at a hotel for 2 nights. The charge for the first night is USD 200. The charge for the second night is USD 100. Workday displays a daily average of USD 150 on each of the 2 itemization lines.Is Room RateSelect to enable Workday to generate itemization that includes the daily rate from level 2 credit card transaction data. Workday calculates the room rate amount by multiplying the total number of days, based on theArrival DateandDeparture Date, by theDaily Rate.If you enable the use of enhanced level 3 credit card transaction data, Workday uses this data instead if the data exists. When Workday automatically generates itemization and a user amends theArrival Date,Departure Date, orDaily Ratethen Workday recalculates the room rate.Always Generate Itemization LineWorkday selects this check box automatically if you:- Select theAutomatically Populate Itemization for Level 3 Credit Card Transaction Datacheck box, and
- Set the expense item as required.
When selected, Workday generates an itemization line, regardless of whether there's data coming from a credit card transaction.If you don't select this check box and there's no corresponding level 3 credit card transaction data, Workday doesn't generate an itemization line.Product CodeSelect the product codes that you want to map to the expense item, which enables Workday to populate expense items on itemization lines automatically.If you don't map product codes and credit card transactions exist, Workday generates itemization lines but doesn't automatically populate them with expense items.
If your organization enables the use of level 3 credit card transaction data, Workday displays a green check mark icon on the itemization line and automatically populates itemization lines with data from hotel stays. If you don't enable the use of level 3 credit card transaction data, Workday automatically generates itemization lines but doesn't populate the lines with any 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.
When payees select your hotel expense items on expense reports, Workday displays an
Itemization
section that includes a Daily Expenses
subsection for recurring daily charges. We also display charge breakdowns in a separate subsection beneath the Itemization
section.