Zip Code Based Tax Rates
This page allows you to upload a CSV file containing ZIP codes and tax rates.
The uploaded CSV file may have the following formats.
The ZipCode and SalesTaxRatePercent columns.
ZIP code intervals matching a mask have a lower priority than explicitly defined ZIP codes. This means that if a customer enters the ZIP code 43003 at checkout, the tax rate will be 6.75%. Even though the entered ZIP code falls in the 4300* interval, this exact ZIP code is also defined in Row #2 and has precedence. In case of identical ZIP codes, the higher tax rate will be used. For example, if a customer enters the ZIP code 43005 at checkout, then the tax rate will be 7.00% (according to the screenshot shown).
Defining ZIP code intervals
You cannot use masks in the Zip5Low and Zip5High fields. For the above example, if a customer enters the ZIP code 43005 at checkout, then the tax rate will be 7.00%, because this ZIP code falls under the interval defined in Row #2.
Using expanded Zip codes (Zip5+4).
Here, the ZipCode field defines the 5-digit part of the ZIP code. The Zip4Low and Zip4High fields define the Zip4 interval. You cannot use masks in the Zip4Low and Zip4High fields. For the above example, if a customer enters the ZIP code 43011-0155 at checkout, then the tax rate will be 6.50%, because this Zip5+4 code falls in the interval defined in Row #4.
You can look up the sales tax rates from the websites of your state’s revenue agency.
Paid tax databases are available from http://www.taxdatasystems.com
After you download a CSV file from one of these websites, open it in a spreadsheet processing program (for example, Microsoft Excel) and set up the appropriate column headers as described above.
© 2004-2011 Pentasoft Corp. Corp. All Rights Reserved.