Concept: Expense Credit Card Transaction Data Mapping
You can use
Dynamic Map Integration Services
in the credit card integration template to create integrations that load expense credit card transaction files from corporate credit card companies. The integrations enable you to use credit card transaction data to populate expense report transaction details and attributes. You can:
- Populate expense item details for airlines, hotels, car rental agencies, and travel cities.
- Create enhanced reporting on total spend by merchant for more visibility.
- Regulate the maximum amounts workers can spend by individual travel city such as maximum hotel rates and meals.
Load Credit Card Transaction Data
When you load credit card transaction files, the Workday integration matches:
- Names or alternate names from transaction files to merchant and travel city names in Workday.
- Airport codes from trip leg data to airport codes in Workday.
- Merchant category codes (MCCs) from transaction files to MCCs in Workday.Not all credit card companies download MCCs with the level of detail needed for matching merchants and cities in Workday.
When Workday matches data from downloaded transactions, we populate expense item attributes on expense reports with data from imported transactions.
Map Merchant Codes and Cities to Expense Item Attributes
Mapping Type | Description |
|---|---|
Integration: Exact Match | The integration maps exact matches between:
|
Integration: Name Match Based on Intelligence Instance Lookup | If the integration identifies a name in the transaction file that closely matches a name or alternate name, Workday populates the corresponding expense item attribute on expense reports. This action applies to:
|
Manual: Mapping | If the integration doesn't identify a match, you can manually map the values on the Find Credit Card Transaction Files report:
When you manually map values, the integration matches them to transactions on future credit card transaction files. |