THE CLIENT
About the Organization
The Global Business Services (GBS) Operations team at a global S&P 100 software company.
THE CHALLENGE
The Problem
A transition to a new procurement system broke an existing automated integration that previously allowed seamless upload of a major logistics provider's invoices. This forced the account manager and operations team to manually download, format, and upload CSV files. The resulting bottleneck created significant payment delays of around $2M, accrued late payment fees, and caused vendor frustration.
OUR APPROACH
How We Solved It
Process Mapping
Analyzed the manual intervention required to convert the logistics provider's output file into a format ingestible by the new procurement software.
Logic Definition
Confirmed the specific logic and mapping tables needed to accurately key the 20 distinct fields required from each invoice.
Script Development
Leveraged a Python script to automatically convert the raw output files into the required upload template.
Deployment
Deployed the solution to handle the monthly volume of 200 to 400 invoices, speeding up the overall processing timeline.
Replacing broken legacy integrations with nimble script-based automation can quickly restore straight-through processing and repair vendor relationships.
Results
