This article is specifically for customers in origin-based sales tax states and will walk you through how to edit the .csv file from taxrates.com to create one single tax group based on where your business is located. The video below demonstrates the following steps, and also below are before editing and after editing screenshots of a sample csv file.
- Open the .csv file downloaded from taxrates.com with your state information.
- Find the zip code for your place of business. (84107 in the video.)
- Copy the estimated combined tax rate for that zip code. (Column E, 0.0745 in the video)
- Paste that rate in Column E for every row in the file.
- Change Column C for all rows to the name you would like to use for your Tax Group Code and Tax Group Name for the sales tax group in ServiceTrade. We recommend your state name in all capital letters. ('UTAH' in the video example.)
Once you have completed these steps, you can save the csv file and import it using the bulk importer in ServiceTrade. For more information, see this section of the bulk importing article for sales tax groups.
CSV File Screenshots
Before Edits
This is an example of the csv file you will download from taxrates.com. Columns C and E will require edits.
After Editing
This shows the csv file after making the necessary edits for a business with its office in the 84107 zip code in Utah, an origin based sales tax state. The estimated combined sales tax of 84107 is 7.45% or .0745.
Video Walkthrough