Coworx Staffing Uses Astera to Process Customer PDF Files and Reduce Their Payroll Data Consumption Time by 95%.
95% Reduction in Time Spent Processing Customer PDF Files and Consuming Data in Payroll System
Data Integration Processes Brought Down to Just 10 Minutes From 4 Hours
CoWorx Staffing, established in 1974, is a well-known recruitment agency with over 90 locations across the U.S. It connects workers with employers in areas like accounting, customer service, administration, manufacturing, packaging, and warehouse roles.
CoWorx Staffing receives worker timesheets from clients in various formats like PDF, CSV, or Excel, sent via email or FTP. Although the formats vary, the core data remains the same: worker timesheets. This data is extracted, uploaded to a SQL database, and used for payroll processing, calculating wages based on weekly work hours.
CoWorx required clients to format their data a certain way. If clients could not do this, staff had to manually enter timesheet data, a time-consuming process prone to errors. Some files had hundreds of pages, making the task even more challenging, requiring double-checking before final payroll processing.
“Before Astera, we had to ask clients to format their data into a specific format, if they were unable to do this, we would have to hand key the information.”
CoWorx Staffing selected Astera for its ability to seamlessly extract data from PDFs and automate the entire data integration process. Astera workflow automation simplifies the flow, from receiving files to extracting data, populating SQL tables, and generating payroll import files.
The automated PDF data extraction with field auto-mapping was a game-changer, eliminating the need for manual data mapping. Astera now manages the entire process from extraction to SQL integration without user intervention, reducing processing time by 95%. Tasks that once took 4 hours are now completed in just 10 minutes, transforming CoWorx payroll operations.
Astera intelligent algorithms also identified missing details in pre-audit reports, allowing CoWorx to resolve timesheet issues before payroll processing, ensuring accurate payments. Additionally, Astera consolidates data from back-office and payroll systems for efficient in-house reporting.
“Our two most favorite components are the PDF mapping tool, and the array of connectors. This allows us to connect to a multitude of data sources resulting in limitless reporting capabilities. By using Astera, we can map any incoming file to a destination format that our systems will consume in an automated fashion.”
“Astera has impacted our business in a very positive way. We have been using the product for a year, and still have a lot to learn, but we are always thinking of new ways that Astera can help automate processes for us.”