CUSTOMER STORY

Apter Streamlines Customer Tax Projects with Alteryx + UiPath

1 day

2-3 weeks to build one database reduced to 1 day

5000

manual hours spent on tax data file processing -> now 2500 hours

3 wks

to build a fully automated process

Using data and analytics to replace traditional processes

No one likes tax time, especially when you’re the one trying to process a year’s worth of data on Google Drive—without making a single mistake. That’s what Gustavo Zagato, director of technology and innovation at Apter and his team of tax specialists were tasked with doing.

“When I first started with the company, Apter was using very traditional and labor-intensive processes to gather and analyze data from the Brazilian bookkeeping system, and it seemed that they were slow to adapt to changing technologies. We needed to be able to analyze a year’s worth of customer tax data to send back to local authorities, and this process proved to be challenging, as five to six analysts would spend one to two weeks downloading data files and putting them on Google Drive. They’re also human, so we knew they would be prone to human error such as making typing or grammatical errors on the data files. My job is to use technology to help us find innovative solutions, and I knew there had to be a better way to approach this process.”

Using automation to streamline efficiency

“We started with the implementation of UiPath and their RPA (robotic process automation) solution to reduce human errors like bookkeeping, typing, service tickets and more transactional tasks,” says Zagato. “This helped us avoid the need to hire more specialists to learn and operate our systems, and the robots help us accomplish these tasks without needing to think about them much.”

“We found that the robots were very good at going into our internal portal and grabbing information needed, but we needed a way to process and parse the data files that were in complex SPED (required tax format by Brazilian government) formats more efficiently. A consultant had mentioned Alteryx to us as a possible solution, and within a few weeks we were building out a use case on processing complex files with greater speed, helping us streamline the process.”

BENEFITS OF USING ALTERYX
Automation of data files

Process complex files quickly and reduced hours spent parsing and analyzing data manually

Risk reduction

Allowing robots to handle transactional tasks with less errors

Speed

Increased speed in operational efficiencies to ensure client projects are delivered on time

Gaining substantial value in speed through analytics

Alteryx + UiPath: Automating End-To-End Processes To Drive Better Business Outcomes

Assigning boring, high-volume, repeatable tasks to a team can introduce errors and other risks. UiPath assigns those tasks to bots instead, allowing analysts to spend time truly analyzing data and creating repeatable, automated workflows that deliver insights into operational systems.

Continuing to focus on customer needs using data

Zagato says that the organization’s focus going forward will be to provide proactive analyses on the ever-increasing complexity of customers’ tax obligations. “We want to present a full picture of the customer’s organization from a tax perspective,” Zagato says. “We want to be more predictive in our approach so that we can help companies avoid strained tax positions with the government. We’ll continue to use RPA combined with Alteryx to help solve problems and gain digital knowledge to avoid complex tax situations.”

 

Recommended Resources

 
Customer Video
All in with RSM US
RSM US is on the cutting edge of finance analytics, learn how Alula and Zach leverage Alteryx to analyze and transform data from over 40 blockchain data sources
  • Analytics Leader
  • Finance Leader
  • BI/Analytics/Data Science
Watch Now
 
Customer Story
How RSM Uses Alteryx to Decode Crypto and Blockchain Transactions
Global tax and audit firm uses Alteryx to reduce the time it takes to decode crypto and blockchain transactions from weeks to hours.
  • Analytics Automation
  • Process Automation
  • Analytics Leader
Learn More
 
Customer Video
All In with Bank Of America
Enabling thousands of your peers with Alteryx analytics takes a community. When David Hardister, winner of 2023’s Maveryx excellence award for community enablement realized there was an internal Alteryx community at Bank of America, he rolled up his sleeves and electrified it.
  • Data Prep and Analytics
  • Finance Leader
  • Finance
Watch Now