4 ms·
State sales tax is a pain in the ass. I do some work for a place that only has a physical presence in the state of Washington, so collects sales tax for online
by tzs 10y ago
State sales tax is a pain in the ass. I do some work for a place that only has a physical presence in the state of Washington, so collects sales tax for online sales to Washington residents.
Online sales tax in Washington is based on the buyer's location, not the seller's location. There are currently 25 different sales tax rates in effect here. So for each sale to a Washington resident we have to determine which of those 25 rates applies.
5 digit zip code is not sufficient to determine the tax rate for a location. A given zip code region can overlap different tax regions that have different rates. There is one zip code that includes 5 different sales tax rates, and several that include 4. A zip+4 code is sufficient, but (1) many people do not know their zip+4, and (2) I don't think there is any guarantee that a zip+4 won't cross a tax region boundary.
The way you are supposed to handle this is to determine the rate based on the street address. You can download from a Washington state government website[1] 39 files (one per county) that contain lists of streets and address ranges and tell which tax location each falls under. A typical record from one of these files looks like this:
100,198,E,CASECO LN,WA,98366,4700,Q22017,1802,N,Kitsap PTBA,
That particular record says that it covers addresses in the range [100, 198], on the even address side of the street named "Caseco LN", in the state of WA, and those addresses have zip code 98366-4700, the record is valid for quarter 2 of 2017, the location code is 1802, those addresses have Regional Sound Transit indicator N, and in the Kitsap PTBA (Public Transit Benefit Area). The empty field on the end is the name of the Community Empowerment Zone. The important part for tax purposes is the location code (1802), for those are the codes that identify tax regions.
If you use that you've got to deal with all the different ways people might write their street address. For instance, if there is a "Martin Luther King Blvd", you will find people who write it as "MLK Blvd", and probably some who write it as "MLKing Blvd", and some who will suffix it with "St" or "Ave" instead of "Blvd".
What we do is simplify this a bit, and just go by 5 digit zip code. The rate we collect is the rate of the highest rate location that overlaps that zip code. That way we are sure to never under collect (and more importantly, never under pay to the state).
Our only physical presence is in Washington, so we only have to do this for Washington. I cannot imagine how painful it would be if we had to do this for several states, let alone if we had to do it for 50 states.
[1] http://dor.wa.gov/content/FindTaxesAndRates/SalesAndUseTaxRates/stdownloads.aspx http://dor.wa.gov/content/FindTaxesAndRates/SalesAndUseTaxRa...
- syshum 10y agoThis exactly is why I am glad the US Constitution forbids states from charging interstate taxes, and why I oppose all of the efforts by congress to allow states to collect interstate sales taxes. My State 1 tax, for the entire state, and outside an few industry specific taxes (hotels, rental cars ) there is only 1 sales tax to collect. We do not have sales taxes at the city or county level those are forbidden at the state level. makes it so much simpler
- rblatz 10y agoThe address stuff gets a lot easier if you use smarty streets.