Client Success Story: Data Analytics + RPA

AAFCPAs develops a bot to automate manual HR processes and boost accuracy.

Global Nonprofit Saves 800+ Hours of Manual Data Input Annually with Automation

AAFCPAs developed a custom bot that ran daily, saving the organization more than 800 hours, or approximately 100 workdays, annually of manual data entry into ADP while reducing the risk of errors and improving accuracy.

Obstacles & Opportunities

One branch of a global nonprofit organization focused on youth development and social responsibility required that managers within their organization complete an online form when an employee under their supervision had a change in status, such as a promotion, raise, manager change, or termination. This form then triggered a series of actions/processes. 

The online form recorded changes in a Microsoft SharePoint list as part of its daily payroll maintenance process. Once changes were approved by corresponding managers, another employee would manually enter necessary data for each affected employee into the online ADP system. There were anywhere from a few to more than 100 changes depending on the time of year and other factors, with each status change requiring 5 to 10 minutes or more of manual data entry in ADP. For example, if there were 10 ADP updates that required on an average seven minutes per change, this absorbed 70 minutes to complete. Obviously, this was a time-consuming and error-prone process. 

The organization needed to find an automated solution that could cut personnel time, boost efficiency, and mitigate human error. Staff also needed to free their time to focus on more strategic and meaningful activities, thus enhancing job satisfaction, morale, motivation, and productivity. 


Once AAFCPAs’ Business Process & IT Consulting Practice had an understanding of the current process and end goals, the team used Robotic Process Automation software to build a customized bot. The bot then logs into ADP and cycles through the data changes record by record to update the corresponding employee record within ADP. 

For each row, the bot searches for the employee using their employee ID and navigates through various ADP menus to make changes as appropriate according to the type and reason along with associated specific rule-based instructions. Once the bot completes a row, it then updates an automatically generated log file with a record of actions taken in ADP. If a change is not processed for any reason, the bot makes a note of this in a log file for manual review post-processing. As soon as all changes are successfully processed, the bot then sends an email that includes a brief overview of the actions taken with the logfile attached. 

Robotic Process Automation helping streamline tasks

The Payoff

AAFCPAs developed a custom bot that ran daily, saving the organization more than 800 hours, or approximately 100 workdays, annually of manual data entry into ADP while reducing the risk of errors and improving accuracy. This process also provided the organization with a reliable record of all changes made in the system. 

Thanks to automation, the organization was able to realign resources, free staff to focus on more human-centered activities, enhance job satisfaction, and empower staff to accomplish more in less time and with less effort, such as electronic payment reconciliation. The success of this automation provided the organization an opportunity to look at other areas of the business where they can benefit by automating a process. 

AAFCPAs works with clients across all industries to design custom automation processes that eliminate repetitive tasks and help organizations shift focus onto more strategic, analytic, and human-centered activities. Automation notably shrinks the time involved in repetitive, rules-based tasks that require no human judgement, such as data entry, paper forms processing or digital transfer, invoice verification and processing, inventory management, and claims administration. So teams can get back to higher valued tasks while reducing the risk of errors.   

How One Nonprofit Distributed ~$700 million to 15,000+ Small Businesses in ~4 Months

Client Success Story: Massachusetts Growth Capital Corporation (MGCC) was charged with standing up a new program to quickly deliver an unprecedented amount of relief to small businesses across Massachusetts impacted by the pandemic. Learn how AAFCPAs helped them accomplish this.

Learn More

Integrating the transformative power of Robotic Process Automation (RPA) and Data Analytics, AAFCPAs provides a unique competitive advantage to our clients by embedding the strategic insights and financial acumen of experienced consulting CFOs directly into our practice. This approach ensures that our solutions not only leverage the latest in technology but are also finely tuned to the nuanced needs of finance functions and strategic financial leadership.

Vassilis Kontoglis
Vassilis Kontoglis

Vassilis Kontoglis

Partner, Analytics, Automation & IT Security

Partner with AAFCPAs today and let our proven expertise drive your company’s growth and efficiency. Contact us now to get started!