This is a reference for bulk importing Tax Group Postal Codes into ServiceTrade. Importing Tax Groups can
There are two ways to bulk import tax groups:
Before you get started on completing the Tax Group Postal Codes Import Template, you should:
- Familiarize yourself with the concept of Sales Tax Groups in ServiceTrade.
- Review the general information on bulk importing.
How to Download the Tax Group Postal Codes Import Template
The image below will show you how to download the Tax Group Postal Codes Import Template or the Taxrates.com Import Template.
Sales Tax Group Import Template Field Definitions
Below is a list of the Field Names and Definitions used in the Sales Tax Group Import Template.
|postal_code||the tax group's zip or postal code (US zip code or Canadian postal code.)
|The tax group's state or province.
Format: Must be abbreviated to 2 characters, such as "TX".
The tax group's code.
Note: If a tax group has multiple postal codes, you should create one row on the import file for each postal code to which the tax group belongs.
All columns except the postal code must be the same for all rows that belong to a single tax group.
Format: Maximum of 40 characters.
|name||The full name of the tax group.
Format: Maximum of 100 characters.
|combined_rate||The combined sales tax rate for the tax group.
Format: Must be a decimal number (for instance, 7.25 means a tax rate of 7.25%).
Bulk Importing Sales Tax Group Data from taxrates.com
The following steps will walk you through importing sales tax groups data from taxrates.com into ServiceTrade.
If you are Updating Existing Tax Groups click this link before starting.
Step 1: Get your Tax Rate Table for Free from taxrates.com
- Go to taxrates.com.
- Scroll until you see Sales Tax Rate Tables.
- Click Get rate tables.
- Select by clicking the state or states in which you do business.
- Confirm the selected states, then click Continue >.
- Enter your Name, Company, and Business email.
- Click Download rate tables to get your free sales Tax Rate Table.
Note: You will need to unzip the file to access the CSV Tax Rate Table files.
IMPORTANT: We recommend double-checking the taxrates.com export to ensure that it covers all zip codes for your service area.
Step 2: Destination-based vs Origin-based Sales Tax State
If you are in a destination-based sales tax state, you likely do not need to make any changes to the .csv file you downloaded before importing.
You can skip ahead to the Importing your tax groups section below.
If you are in an origin-based sales tax state and need one tax group with the estimated combined tax rate for your office location, read this article for instructions on editing the .csv file before completing the steps under 'Importing your tax groups' below.
Step 3: Import your taxrates.com Tax Tables into ServiceTrade
- In ServiceTrade, click Customers.
- Then click Bulk Import.
- Click the Tax Group Postal Codes tab.
- Click the Select Sales Tax File Format drop-down.
- Select the Taxrates.com option.
- Click Choose File.
- Select the .csv file you downloaded from taxrates.com, or your edited .csv file.
- Note: There will be one .csv file per state. You can combine multiple states into one file for upload or upload them separately.
- Clicking Open will begin the import.
- Note: Doing so acknowledges that you understand that your upload will completely override any existing sales tax groups included in the import file. This is more important when you are editing sales tax groups that already exist in your account.
- You will receive confirmation that your upload has been successfully imported.
- Repeat Steps 7 and 8 for all of your state Tax Rate Table CSVs.
What if I'm Updating Existing Tax Groups
If you are using the Bulk Import tool to update existing Tax Groups, the following is important information. If you have any questions, please contact Customer Support before importing. It is not possible to delete a tax group import.
The file provided by Taxrates.com contains a column called "TaxRegionName." The "TaxRegionName" column looks to the "Tax Group Code" in ServiceTrade. It sets both the tax group code AND name in ServiceTrade to be the value provided in the "TaxRegionName" column on the import file.
The file from Taxrates.com will match on the "Tax Group Code" in ServiceTrade, and update that Sales Tax group accordingly.
*If there isn't a match, a new Tax Group will be created in ServiceTrade.*
Example: Say you had an existing Tax Group in ServiceTrade with:
- "Tax Group Code" = "KING (1)"
- "Tax Group Name" = "KING"
Then, you import a file from Taxrates.com that has a "TaxRegionName" of "KING"
ServiceTrade will create a new tax group with a "Tax Group Code" AND "Tax Group Name" of "KING" - It will not update the existing "KING (1)" tax group based on its "Tax Group Name" ("KING").
Zip+4 for City and Local Rates
When you Import Tax Groups from Taxrates.com it does not support the zip code level for cities/locals that have different rates at a more granular level. You will need to create those manually.
Note: If you wish to include US ZIP+4 in your groups, you have to list each one separately, and not as a range. For example 27703-1234, 27703-1235, 27703-1236 is correct. 27703-1234-1236 is incorrect.