Verifying sales tax information using GIS

Blog_Verifyingsalestax.png

Every year, The Village of Wheeling finance department receives tax
information from the State. This information includes the amount of
money the village received from sales tax and which companies provided
it. In previous years, the finance department would look over the data
and try to find any discrepancies in the data and see if they were
missing sales tax from companies in the Village. They would typically do
this by comparing the sales tax information with the business license
data by hand. This year, the Village wanted to do a more thorough check
and one that wasn’t as time consuming, so they decided to compare the
two tables by using GIS.

Because both the sales tax information and the business license
tables contained address information, the data was easily mapped using
the Village’s address database. With both tables mapped, checks were run
to determine which business license records did not have a sales tax
record, and which sales tax records did not match any existing business
license. This process would help find any businesses that Wheeling did
not receive sales tax from and additionally businesses that did not have
an existing business license.

The finance department received full lists of businesses within the
Village that they did not receive sales tax from and businesses that
were listed in the sales tax table that did not have a business license.
There are many possible reasons why both situations exist, but by
having a list the finance department was able to go to the state and
figure out each record discrepancy. By using GIS, the finance department
was able to expand on an already existing project and save some time in
the process.

Verifying sales tax information using GIS

Blog_Verifyingsalestax.png

Every year, The Village of Wheeling finance department receives tax
information from the State. This information includes the amount of
money the village received from sales tax and which companies provided
it. In previous years, the finance department would look over the data
and try to find any discrepancies in the data and see if they were
missing sales tax from companies in the Village. They would typically do
this by comparing the sales tax information with the business license
data by hand. This year, the Village wanted to do a more thorough check
and one that wasn’t as time consuming, so they decided to compare the
two tables by using GIS.

Because both the sales tax information and the business license
tables contained address information, the data was easily mapped using
the Village’s address database. With both tables mapped, checks were run
to determine which business license records did not have a sales tax
record, and which sales tax records did not match any existing business
license. This process would help find any businesses that Wheeling did
not receive sales tax from and additionally businesses that did not have
an existing business license.

The finance department received full lists of businesses within the
Village that they did not receive sales tax from and businesses that
were listed in the sales tax table that did not have a business license.
There are many possible reasons why both situations exist, but by
having a list the finance department was able to go to the state and
figure out each record discrepancy. By using GIS, the finance department
was able to expand on an already existing project and save some time in
the process.