98.5%
Accuracy in data extraction and mapping
500+
Expense Report files processed
1200+
Employees gets streamlined financial processes
About
Client
Business
Global Leader
Ponbike is a leading global company with over 20 renowned bicycle brands, including Cervelo, Cannondale, and Caloi, catering to both recreational cyclists and professional athletes.
Wide Market Presence
The company operates in key markets across Europe, North America, South America, and Asia, promoting green transportation solutions.
Operational Challenges
Ponbike needed to integrate large volumes of employee expense reports from Concur’s SFTP server into NetSuite, ensuring data consistency across accounts, departments, and locations to improve operational efficiency.
Our Solutions
We worked closely with Ponbike to build a tailored integration solution that enhanced their financial processes by integrating Concur’s SFTP with NetSuite.
SFTP Connector SuiteApp Integration
We used the “SFTP Connector SuiteApp” to securely connect to Concur’s SFTP server and retrieve files efficiently.
Structured Folder Management
A structured folder hierarchy was implemented in NetSuite’s File Cabinet for better file organization and ease of access.
MapReduce Script for Data Mappin
A custom MapReduce script was developed to extract information and map it to the appropriate NetSuite expense records.
Custom Record Mapping
We created custom records to map NetSuite locations, accounts, and departments to Concur’s data, ensuring accurate and seamless integration.
Challenges
The integration presented several challenges that required innovative solutions:
Handling Large Volumes of Data
Processing the large volume of data without affecting system performance required optimization of data processing methods and storage solutions.
Data Mapping Consistency
Ensuring accurate and consistent data mapping between Concur and NetSuite was critical, requiring detailed mapping strategies and frequent data verification.
Error Detection & File Organization
Organizing files in NetSuite’s folder system for seamless processing and implementing robust error detection methods were essential to maintaining operational integrity.
Results
The successful integration significantly enhanced Ponbike’s financial processes:
High Accuracy in Data Mapping
We achieved 98.5% accuracy in data extraction and mapping, improving data reliability for Ponbike’s financial operations.
Efficient Processing
Over 500 text files containing expense reports from 1,200 employees were processed, streamlining the company’s expense management process.
Reduced Manual Effort
The automation of the process reduced manual intervention, allowing Ponbike to focus on core business activities.
Improved Financial Operations
The integration allowed Ponbike to manage expense reports more efficiently, supporting their mission to promote clean mobility.