tax professionals

5 Use Cases to Help Tax Professionals Take Back Their Time

According to IDC, six billion hours per year are spent working in spreadsheets

How many hours does your team spend in spreadsheets?

What if you could lower that number while also increasing efficiency and accuracy and minimizing efforts, errors, duplicate work, and penalties?

Discover five common tax processes that can be streamlined to create faster reports and clearer audit trails.


Use Case #1: Tax Apportionment

100+ hour process reduced to 7 minutes

Tax apportionment is no longer as simple as property, payroll, and receipts. It can be a time-consuming, complex process to determine how each sale or transaction should be taxed and how to divide income among different states. There’s also a higher risk of errors and inconsistencies when the process is done manually.

Common Issues

  • Spending too much time considering apportionment issues
  • Determining what’s included in states’ apportionment formulas
  • Not having the correct data for apportionment calculations
  • Overpaying or underpaying taxes based on current apportionment issues

Alteryx Solution

Quickly and easily bring together multiple data sources, save on internal labor costs, and increase accuracy so you can reduce penalties. Analyze entire datasets, not just samples, minus the headache.

Customer Success

A large global REIT reduced its 100+ hour state apportionment process to seven minutes while eliminating approximately 90% of quarterly tax underpayments.

Use Case #2: Accrual Automation

80-hour accrual process reduced to 2.5 seconds

Accrual accounting can be more accurate than cash basis accounting, but also more complex, especially with the increase in information on accounting statements. If companies aren’t looking at the right data, they’ll run into forecasting issues.

Common Issues

  • Creating consistent reconciliation processes
  • Finding and analyzing the right data from different sources
  • Ensuring data quality, especially around revenue and expense data
  • Producing a clear audit trail with an increased amount of information

Alteryx Solution

Reduce redundancy in managing accruals and compliance and create a complete audit trail.

Customer Success

A global transportation and logistics company reduced its accrual process from 80 hours to 2.5 seconds to save $32K annually.

Automate Accruals

Use Case #3: Sales and Use Tax Reporting

50% reduction in manual processes

State tax rules constantly change as states try to capture sales and use tax from e-commerce sales and online transactions. This makes it both difficult and time-consuming for companies to understand their tax obligations on out-of-state activities and transactions.

Common Issues

  • Incorrectly invoicing customers as nontaxable, tax-exempt, or with the wrong tax rate
  • Staying up to date on exemption certifications and states’ sales and use tax laws
  • Misunderstanding nexus obligations
  • Audits that result in penalties, interest, fees paid to tax pros, and worker hours lost to collecting proper documentation

Alteryx Solution

Quickly assess at the transactional level and reconcile the taxes applied to what should’ve been applied based on the rates. Alert tax groups to any transaction instance in which inappropriate taxes are applied the moment it hits the general ledger.

Customer Success

A corporate tax services firm reduced manual processes by 50% and is saving time on sales and use tax reporting.

Read The Full Story

Use Case #4: Fixed Asset Depreciation

5-month fixed asset processing time reduced to 5 minutes

Fixed asset depreciation can help companies reduce their tax bill, but companies need to make sure their depreciation reporting is both accurate and timely and that they’re using the right calculations since they impact bottom-line tax amounts.

Common Issues

  • Using manual and outdated processes that lead to mistakes and inefficiencies
  • Staying aware of tax law updates and making sure calculations reflect them
  • Reconciling data from disparate sources to calculate metrics, such as cost of goods sold, operating expenses, earnings before interest/ tax, etc.
  • Finding the best method of calculations that consider both flexibility and accuracy
  • Tracking and reviewing calculations to ensure proper management

Alteryx Solution

Read, analyze, and wrangle data from multiple sources, such as ERP systems. Test multiple complex calculations before final outputs are produced.

Customer Success

An industrial corporation that manages hundreds of thousands of rail cars reduced its fixed asset processing time from five months to five minutes.

Read Their Story

Use Case #5: Transfer Pricing

Approximately 2,000 hours saved on transfer pricing processes

While transfer pricing can lead to tax savings for companies that have divisions, subsidiaries, or affiliates under the same enterprise, it’s also one of the riskiest areas from a compliance standpoint. Since transfer pricing involves interpretation of facts and assumptions when choosing an economic model, there’s always a possibility of penalties, double taxation, and adjustments to taxable income.

Common Issues

  • Scenario testing across multiple business units and data sources (tangible goods, services, intangibles, loans, etc.) that involve complex logic
  • Needing to adhere to specific models, such as Arm’s Length and other standards
  • Lacking an audit trail for TP processes
  • Having complicated intercompany and legal entity structures

Alteryx Solution

Determine optimal prices with automated transfer pricing calculations and scenario testing.

Customer Success

A multinational accounting firm saved about 2,000 hours on transfer pricing processes, transfer pricing studies, scenario planning, and forecasting.

Want to execute tax processes faster than ever?

Get Your Free Finance Starter Kit

Get Started With Alteryx

Alteryx powers analytics for all by providing our leading Analytics Automation Platform. Alteryx delivers easy end-to-end automation of data engineering, analytics, reporting, machine learning, and data science processes, enabling enterprises everywhere to democratize data analytics across their organizations for a broad range of use cases.

See how your tax department can use Analytics Automation to take back their time and maximize efficiency and performance.

Try Alteryx free for 30 days or schedule a free consultation.

Alteryx is a registered trademark of Alteryx, Inc. All other product and brand names may be trademarks or registered trademarks of their respective owners.

Download PDF


Recommended Resources

Cost Transformation, Driving Sustainable Change with Alteryx and Accenture
  • Analytics Automation
  • Alteryx Designer
  • Manufacturing
Read Now
Building Data Talent for the Decade Ahead
This paper lays out several approaches that educational institutions can take to embed data analytics into legacy academic programs or the DIY path individuals can follow.
  • BI/Analytics/Data Science
  • Global
Read Now
Understand Risks and Mitigate Supply Chain Disruption With Advanced Analytics
Learn how the Alteryx Analytics Cloud Platform and PwC's expertise in digital transformation can help you reduce risk throughout your supply chain.
  • Supply Chain
  • Supply Chain
  • Alteryx Designer
Read Now