You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.

Go to chinese website
Logo - Keyrus
Logo - Keyrus
  • Playbook
  • Services
  • Insights
  • Partners
  • Careers
  • About us
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations

Success story

Automating tax processes for an international bank

By Kevin Maroney

A multinational financial services organization turned to Keyrus for assistance in improving their data processes as well as how they present their analysis. 

Prior to this engagement, real-time tax provision forecasting required multiple teams and manual manipulation, which meant there was a high risk for human error and breaks in the audit trail. The different teams were responsible for different data (forecasts from the FP&A, actuals from finance, tax rates and discrete items from tax). No one person understood the full process from source to PowerPoint, so providing data quality assurance was impossible. 

As mentioned, the end user was receiving the final product of the tax forecast outlook in a PowerPoint. The CFO and other senior management wanted to understand how the updated forecasts were deviating from the plan and, more importantly, what was driving that deviation. 

This required significant manual time and effort in creating the visuals in Excel, manually analyzing and checking to see the largest variances, and then highlighting those in an ad-hoc section of the PowerPoint. This was long, tedious, manual, error-prone work, and it was expected to be done monthly.

Solution

Keyrus created an automated, repeatable process using Alteryx to ingest the data from the different teams and create a data source that the new Tableau dashboard would connect to directly. 

Keyrus recommended an incremental approach. The ideal state would be to go directly against the source, but due to security regulations, this was not doable at the given time. The compromise was to create a process that required a user to drop raw extracts into a landing zone and simply run the Alteryx process as is. 

This process did not need to be adjusted each month because it was built in a generic and configurable fashion. The process archived raw files and implemented data validation checks to ensure no data reached the dashboards unless it met all requirements. The process provided the tax team an easy way to adjust tax rates to predict tax amounts with changing rates. This entire data process was built using Alteryx.

The next main initiative was to sunset the historical way that they were providing this report to the CFO. Using Tableau, Keyrus created a dashboard that highlighted tax variances from update to update. Using the tools native drill-down ability, the dashboards allowed users to easily find variances and drill into the detail to understand the drivers of these differences (were these differences tied to NIBT changes or were these due to different discrete tax adjustments?). This removed the need to format and manually build this report each month (and even the existence of the report all together). 

We also revamped what was once an Excel report on the derivative holdings to a Tableau dashboard. Simply being able to roll up, filter, and drill down at different levels of detail (ForEx vs. Interest Rate Swaps, only products with over 100M Notional, products maturing in the next month, etc.) greatly increased efficiency for end users.

Keyrus implemented these tools as well as a full set of documentation and best practices around them. Skilling the internal team and making sure they were able to support the solution was a top priority that was accomplished as part of the engagement. 

Results 

The initial process was highly manual, meaning there were many questions about where metrics came from and how to assess the data quality. We were able to consolidate this tiered process into two simple steps: place files in the landing zone and run the Alteryx workflow. The resulting process is more efficient, scalable, and has a much lower risk for human error. The company saves two weeks per month of manual effort and eliminated the average five monthly mistakes that slowed down reporting. The c-level can also drill into the numbers to better understand forecasting changes without relying on the operations team to take time to explain results. Overall, the organization has significantly more confidence in their data.

whatsapptwitter
linkedinfacebookworkplace
newsletter.svg

Never miss an insight

Stay updated on the latest articles, events, and more

Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.

Continue reading

Press release

Keyrus named amongst Top B2B Companies on Clutch

December 12, 2022

The Keyrus team is excited to announce that we’ve been named one of the top 1000 companies on Clutch’s platform in 2022! This is the second year that Keyrus has been recognized by Clutch as a top company and B2B leader. 

Webinar

PDF Parsing with Alteryx Intelligence Suite

December 1, 2022

In 20 minutes, we’ll teach you how to use Alteryx Intelligence Suite to eliminate common problems and inefficiencies in accessing data from .pdf files. In the past, you’d need to run custom Python and complex parsing logic to get any usable data from a pdf. Now, you can parse PDFs with out-of-the-box features in Alteryx Intelligence Suite.

Webinar

Modern Cloud Analytics in Action: Keyrus and Red Ventures

November 11, 2022

The cloud offers new opportunities to save you time and money, allowing you to shift focus from maintaining growing servers and upgrading infrastructure to making your data work for you and the success of your business. Watch the webinar and Q&A to learn how AWS, Tableau, and Keyrus worked together to help Red Ventures migrate to a powerful cloud BI tool that created new pathways for success and a modern data culture.

Event

Pharma/Biotech GTN Summit 2022

October 27, 2022

Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit

Press release

Keyrus Achieves AWS Data and Analytics Competency Status

October 6, 2022

Keyrus achieved Amazon Web Services (AWS) Data and Analytics Competency. To receive the designation, AWS Partners must possess deep AWS expertise and deliver solutions seamlessly on AWS.

Webinar

Live Webinar: Lessons on workforce capacity planning and optimization from Optum (UnitedHealthcare)

October 19, 2022

Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)

Webinar

Tableau Embedded Analytics: Optimizing insights from Salesforce data

September 20, 2022

Want to optimize your visual analytics in Salesforce? You need the right tools. Tableau Embedded Analytics can be used to help you build and visualize reports in Salesforce.

Success story

How C&S Wholesale Grocers maximized ROI with an analytics center of excellence

September 7, 2022

C&S Wholesale Grocers worked with Keyrus and Alteryx to implement an analytics center of excellence to help them efficiently and effectively achieve business objectives, maximize return on investment (ROI), and standardize best practices.

Success story

Implementing a cloud security automation tool at a global consulting firm

September 2, 2022

Keyrus partnered with a consulting firm to build an in-house cloud security solution that would automate their verification processes and keep their information safe.

Success story

Leveraging Salesforce to improve operations at Pajama Program

July 25, 2022

Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.

Logo - Keyrus
New York City

252 West 37th st., Suite 1400 New York, NY 10018

Phone:+1 646 664 4872

LinkedInInstagram
PlaybookServicesInsightsPartnersCareersAbout us
Company purposeInnovation & TechnologiesCommitted KeyrusRegulatory complianceInvestorsManagement teamBrandsLocations
Legal notice & Terms of use
Privacy policy
Data protection