Bulk Importing Tax Groups

Derek Torres
Derek Torres
  • Updated

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:

 

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.

Tax_Import_Template.gif

 

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.)
*required

state

The tax group's state or province.
Format: Must be abbreviated to 2 characters, such as "TX".
*required
tax_group_code

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.
*required

name The full name of the tax group.
Format: Maximum of 100 characters.
*required
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%).
*required

 

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

  1. Go to taxrates.com.
  2. Scroll until you see Sales Tax Rate Tables.
  3. Click Get rate tables.
  4. Select by clicking the state or states in which you do business. 
  5. Confirm the selected states, then click Continue >.
  6. Enter your Name, Company, and Business email.
  7. 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.

Taxe_Rates_Com.gif

 

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

Import_Tax_Rate_Table.gif

  1. In ServiceTrade, click Customers.
  2. Then click Bulk Import.
  3. Click the Tax Group Postal Codes tab.
  4. Click the Select Sales Tax File Format drop-down.
  5. Select the Taxrates.com option.
  6. Click Choose File.
  7. 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.
  8. 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. 
  9. You will receive confirmation that your upload has been successfully imported.
    mceclip1__1_.png
  10. 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.

Was this article helpful?

/

Comments

0 comments

Please sign in to leave a comment.