How Does Elliott Determine Sales Tax Codes?
Release Date: 08/24/2018
Q - I’m noticing that some of the cities in Elliott are not populating the correct tax codes. In the screenshot below, Elliott is prompting me to add tax code WN4- but this city should not have that code. The correct codes for this zip code are WA and WVT. How does Elliott determine the tax codes for each zip code? Is there a place to do that?
A - Generally speaking, we support three types of sales tax code: State (Tax Code 1), County (Tax Code 2) and City (Tax Code 3). A location can have 1 sales tax code, 2 or 3. In this case, we determine the sales tax for this ship-to by first looking at the following:
State WA
Zip Code 98201
Based on the Zip Code table (System Utilities -> Zip Code File), this zip code corresponds to the following City and County:
City: Everett
County: (53061) Snohomish County
See sample screen below:
If you go to A/R -> Maintenance -> State Table File, you will find state WA uses the sales tax code WA.
If you go to A/R -> Maintenance -> County Tax Code File, and bring up county code 53061, you will see that this county corresponds to tax code WN4.
If you go to System Utilities -> System File Setup -> Maintenance -> City File, and bring up the city Everett in WA, you will see the tax code is WVT.
Therefore, the proper sales tax for this ship-to location should be:
Tax Code 1 = WA
Tax Code 2 = WN4
Tax Code 3 = WVT
Your current setup is:
Tax Code 1 = WA
Tax Code 2 = WVT
So the system was trying to warn you that the tax code 2 should be the county tax code WN4. If you answer “Y,” it will also prompt you to change the Tax Code 3 to WVT.
If you go to A/R -> Maintenance -> County Tax Code File, and bring up county code 53061, you will see that this county corresponds to tax code WN4.
If you go to System Utilities -> System File Setup -> Maintenance -> City File, and bring up the city Everett in WA, you will see the tax code is WVT.
Therefore, the proper sales tax for this ship-to location should be:
Tax Code 1 = WA
Tax Code 2 = WN4
Tax Code 3 = WVT
Your current setup is:
Tax Code 1 = WA
Tax Code 2 = WVT
So the system was trying to warn you that the tax code 2 should be the county tax code WN4. If you answer “Y,” it will also prompt you to change the Tax Code 3 to WVT.
You may also want to reference the following KB articles on this subject:
EMK
Related Articles
Avalara - Item Tax Codes
Release Date: 4/28/23 Version: 8.6 and Above Tax codes (_GOODSERVICES attribute) are used to determine what tax category an item belongs to for taxing purposes. Tax codes can be assigned at the product category, user-defined code, and item levels. ...How Do I Start to Collect Sales Tax for Other States?
Release Date: 08/02/2018 Q - I have been asked by other states to collect sales tax on their behalf. How do I do that? A - First, in each customer and ship-to record, there are three sales tax codes that you can enter. We suggest that you use the ...Feature - Avalara Tax Code Support in Sales Order Import
Release Date: 9/6/23 Version: 8.6 and Above Sales Order Import now determines the correct tax codes for an order based on the ship-to state and country for the order. First, the application will determine if the address is a foreign address (non-US ...Auto Assigned Sales Tax Code by State and County
Q: Recently we have set up sales offices in several states, and we'd like to let the system assign sales tax codes by state and county automatically in order to reduce human error. A: Solutions: 1. Global Setup/A/R Global Control: Fields #1, 5 and 13 ...Arizona Cities Not in Elliott for Sales Tax Code Auto Assign
Q - I finished our tax code setup for the state of Arizona. But I am having an issue with a few cities that have a city level sales tax that are not listed as Arizona cities in Elliott. I just synced my city list this week. The cities that have a ...