Executive Overdrive LLC
  • Home
  • Services
  • Experience
  • Testimonials
  • Blog
  • Contact

CASE STUDY: Automating Concur Expenses Charged to Projects

3/1/2019

0 Comments

 
Travel Project Costs
​The Problem: Concur allows users to charge transactions to projects. The field used to enter projects is free form text. The entity required project entries to follow a specific nomenclature for automated loading into the Oracle Projects module. The free form text format presented a challenge. Without correct input, the project field would fail validation resulting in costly rework and/or manual intervention.    
 
​The Approach: The free form text field was the main item to address. Since the field was going to be loaded directly into Oracle, we needed to create a standard entry format to pass validation. Working with key users and the local accounting team, we identified a nomenclature that would split projects off from tasks. Using unique identifiers throughout the string, the process that extracted information from Concur correctly populated the Project and Task fields in Oracle Projects. We conducted training classes and provided print screen work instructions.
 
The Result: Most users adapted quickly to the new format. Accounting Review identified any reports with incorrect Project-Task strings. Accounting review returned incorrect reports. Rework and payment delays were the impetus to users embracing the new format. Soon after go live we achieved virtually 100% first time, zero defect compliance. Covering three years and hundreds of expense reports the process is an unqualified success.

0 Comments



Leave a Reply.

    Authors

    Jack DiMatteo is a licensed CPA in the state of Ohio with 25+ years of diversified finance, operations and technology experience.

    What business topics would you like to see in this blog? Drop Jack a line:   

    Contact Jack

    Archives

    February 2025
    January 2022
    November 2021
    September 2020
    June 2020
    January 2020
    October 2019
    September 2019
    August 2019
    July 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019

    RSS Feed

Web Hosting by FatCow
Photos from ePublicist, wuestenigel, barockschloss, Tim Reckmann | a59.de, GCampbellHall, wuestenigel, driver Photographer, verchmarco, Sustainable Economies Law Center, Got Credit, wuestenigel, Virginia Sea Grant