Use Case

R&D Calculations


Transactions related to research and development are eligible for tax credits. However, the process of collecting and reviewing every transaction and applying manual adjustments is difficult and time-consuming.

Efficiency Gains

Analyze, organize and manipulate large amounts of data from multiple sources

Top-Line Growth

Get insight into the application of tax codes to R&D costs

Bottom-Line Returns

Replace spreadsheets with dedicated analytics, spend less time collecting transactions and devote more time to analyzing data


Business Problem

To accurately calculate the credit, tax accountants need to collect data on all R&D activities including staff hierarchies, wages, tax rates and time and materials allocated to R&D. Specifying and collecting the data manually from internal systems is time-consuming, especially when it comes to handling sensitive data from each group. Some tax professionals resort to their own end-user-developed applications (EUDAs) to perform calculations and allow for manual adjustments and allocations.

Alteryx Solution

Automating R&D calculations with analytics allows companies to review every transaction and maximize the tax credit. Operating on sources as diverse as HR data, expenses, tax rates and country data, analytics can follow staff/departmental hierarchies, allow for adjustments and perform complex calculations.

By automating R&D tax calculations, you can:

  • Increase efficiency, save time, and improve ROI
  • Increase consistency with how your company defines and captures Qualified Research Expenses (QREs)
  • Reinvest money saved into higher value projects
  • Increase visibility and accuracy in the R&D tax calculation process


Recommended Resources

Nucleus Research – Alteryx Highlights AI and ROI at Inspire 2023
At Alteryx Inspire 2023, Alteryx announced various new and extended capabilities to improve its value proposition for certain users or use-cases. This includes expanded cloud platform experiences, cloud-based Location Intelligence for spatial analytics, integrated generative AI capabilities with Alteryx AiDIN, and the Alteryx Maveryx user community.
  • Analytics Maturity
  • Company
  • Analyst
Read Now
Customer Story
Health Care Program Advisors Builds Actionable Models with Snowflake, Alteryx, and Tableau
A boutique healthcare consulting firm uses modern analytics tools to provide advisory services to its clients.
  • Alteryx Designer
  • Alteryx Server
  • Healthcare & Insurance
Read Now
Enable Data and Analytics Innovation for an Era of Perpetual Uncertainty
Fueled by intense and rapid political, environmental, social, and technological change: organizations face a new era of perpetual uncertainty.
  • Analytics Leader
  • Risk Reduction
  • Workforce Upskilling
Read Now