If you live in a state that requires separate tax rates for each city (Washington state, for example), you can import a spreadsheet file (CSV) containing all of the pertinent information rather than having to create a new tax option for each city by hand on our Sales Tax page. You can import the sales tax spreadsheet by doing the following:
- From the main menu, click Selling » Prices, Shipping, Tax » Sales Tax.
- Click the Import from CSV button.
- Click the Browse button to locate the CSV file on your computer.
- Click Import The File.
Spreadsheet Details
Your CSV spreadsheet file must contain the following columns: Type, Country, State, Custom, Tax, TaxShipping.
- The Type column should contain one of the following values: "City", "PostalCode", "County", or "All."
- The Country column should contain the name of the country. Such as "United States" or "Canada." Note: If you have a question about what the country name should be listed as, please check the droplist from the Create New form within the Sales Tax page.
- The State column should contain either the name of the state/province or, if the Type column is set to "All" and you are setting a rate for an entire country, it should be blank.
- The Custom column should contain the name of the city, the postal code, the county name, or, if the Type column is set to "All" and you are setting a rate for an entire state/province, it should be blank.
- The Tax column should contain the tax rate for the area you are setting up. This should be a decimal number with the value provided being less than 1. For example, a tax rate of 6.9% should be provided as .069.
- The TaxShipping column should be either "Yes" or "No", depending on whether or not you are required to collect sales tax on your shipping prices.
