Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Map Data from Expense Integration Files

Map Data from Expense Integration Files

  • Create an integration for each corporate credit card to download credit card transaction files.
  • Create a travel booking inbound connector integration to download travel booking data from a corporate travel provider.
  • Workday recommends you set up merchant codes, names, and alternate names on these tasks to ensure accurate matches from integration files:
    • Maintain Airlines
    • Maintain Hotels
    • Maintain Car Rental Agencies
    • Maintain Travel City
  • Security:
    • Process: Credit Card
       domain in the Common Financial Management functional area.
    • Process: Travel Booking
       domain in the Expenses functional area.
Contact Workday Professional Services or your consultant to implement expense integrations. To integrate travel booking data, you must also coordinate with your travel provider.
You can map travel cities, airports, and merchants from integration files to Workday, and then update transactions and records as needed. Workday populates expense item attributes with the cities, airports, and merchants you map when workers import these files into expense reports:
  • Credit card transactions.
  • Travel booking records.
  1. Access 1 of these reports:
    Option Description
    Find Credit Card Transaction Files
    To map:
    • Airports
    • Cities
    • Merchants
    Find Travel Booking Record Files
    To map:
    • Cities
    • Merchants
  2. As you complete the report, consider:
    Option Description
    Merchants
    Map
    Merchant Name in File
     to
    Merchant in Workday
     for the transaction level or trip leg level of the integration file.
    Airports
    Map:
    • Origination Airport Name on Leg
       to
      Origination Airport Name in Workday
      .
    • Destination Airport Name on Leg
       to
      Destination Airport Name in Workday
      .
    Cities
    Map:
    • Origination City Name In File
       to
      Origination City Name In Workday
      .
    • Destination City Name In File
       to
      Destination City Name In Workday
      .
  3. (Optional) Select
    Save Alternate Name
     to map the merchant or city and store a permanent name for matching merchants and cities in future integrations.
  4. Apply mapping.