Universal Blogs
INPUT by Alteryx Blog

Leveraging Analytics to Optimize Collections, Compliance + Forecasting

Universal Blogs

If you’re like most government leaders responsible for tax and revenue operations, you’re faced with increasing pressure and challenges surrounding the process of optimizing collections, compliance, and the forecasting of tax revenue.

Many revenue managers assume that dealing with manual spreadsheet-based data processes to collect, prep, and blend data is just another cost of doing business. In fact, through our work and research, it’s estimated that many organizations are losing an average of seven hours per week per employee in productivity due to manual, legacy data prep issues.

What if there was a way to regain those lost hours of productivity, reduce complexity, and enhance your ability to fully analyze the generation and collection of tax revenues both within and outside of your jurisdiction?

(Spoiler alert: There is.)

Picture This

Imagine a tax and revenue organization that has two very qualified business analysts who know the operation and how to get things done. The leader of this organization could not fathom being able to function without the contributions of these skilled humans, but the line of business leader knows that at the end of every reporting cycle, they’re drained and dread having to repeat the same process again next month.

In this scenario, the tax organization is losing 56 hours of productivity a month, the analysts are tired and frustrated, and because of this, there’s always risk of them leaving and taking their domain knowledge with them. Not only are they burnt out from the current process, organizations like this are not able to fully analyze the entire spectrum of data to find additional opportunities to improve compliance and collections. As a result, their jurisdictions could be losing out on hundreds of thousands of dollars in additional tax revenues.

Recently, we worked with a tax organization for a city in California that faced a very similar situation. In this case, this office was responsible for monthly reporting and forecasting on the status of city tax revenue. The tedious legacy analytics process they had in place required the download of seven files monthly from the California Department of Tax and Fee Administration (CFDTA) to analyze the city’s portion of state and county taxes collected.

The analysts would manually prep and blend that data, creating another file that was then uploaded to a SQL database using Access. The SQL database was appended monthly with new data. Excel templates were then used to extract and create necessary reports. In many cases, due to time restraints and the complexity of the data, three of the seven files were never analyzed or included in the blended file, leading to an incomplete view of projected revenues. The files that were not analyzed mostly dealt with new sales tax permits for organizations who resided outside city limits. These organizations may have had a tax liability owed to the city, but with no analysis, the amount of taxes owed couldn’t be measured, collected, or forecasted.

On a national scale, “The Wall Street Journal” reports that state and local governments are losing upwards of $33.9 billion annually in uncollected sales taxes. These uncollected taxes are sapping resources for essential public services while distorting the marketplace by benefitting remote sellers over those anchored in the community.

While the U.S. Supreme Court has ruled state and local governments have a right to collect sales tax from online businesses, many government organizations lack the resources, technology, and bandwidth to effectively measure and enforce compliance.

Many government tax and revenue organizations are realizing that in order to maximize collections and ensure their constituent services and programs are funded appropriately, they need to more fully analyze tax records and identify areas to focus compliance and collections. In response, jurisdictions like yours across the county are turning to advanced analytics to improve analytics productivity and enhance revenue compliance and collection operations.

According to Govtech, Big Data and analytics increased tax revenue collection by $1 billion in California, cut tax fraud by $30 million in Georgia, and identified $5 million in unpaid property tax in Miami-Dade County, Florida.

Enable seamless collaboration across your organization with self-service analytics solutions that address the needs of the information worker, analyst, and data scientist. This empowers every data worker to transform data into actionable insights, freeing up time and resources to deliver faster insights.

STAY PUT.

WATCH

Check out these data innovators in finance in this on-demand webinar.

READ

Learn 10 Best Practices for Modern Analytics in Finance.

Written By
Alteryx logo
Alteryx
Leader in Analytic Process Automation (APA)
abstract image
Blog
3 min to read

Top Priorities for Corporate Tax Departments

The success of tax departments depends on the establishment of a balance between the demands of technology and employees’ needs rather than the number of technical solutions it has at its disposal.

Alteryx Platform
Analytics Leader
Business Leader
Read Now
abstract image
Blog
5 min to read

How to Increase ROI Through Data Democratization 

See 4 things you should do to increase ROI through democratization.

Analyst
Analytics Leader
Business Leader
Read Now
abstract image
Blog
5 min to read

Why Alteryx is a Better Choice for Enterprise Analytics

Why Alteryx is a better choice for organizations that want to experience a unified analytics platform that is easy to use and upskills your existing workforce to enable a democratized approach to data.

Business Leader
Analytics Leader
Alteryx Platform
Read Now