How do you configure taxes for U.S. states where taxes are defined by zip codes

Started by bobmeetin, November 26, 2012, 17:39:45 PM

Previous topic - Next topic

bobmeetin

In the United States, perhaps Canada, sales tax is collected on the basis of a combination of a state sales tax rate and special regional rates commonly defined by zip code.  In many states including Colorado and California  there are hundreds of zip codes with specific rates which must be collected in addition to the base tax rate.

For example, in Colorado there is a base state tax of 2.9%.  If you live in any of the special tax rate regions (zip codes) and the business is located in Colorado the business owner must also collect (and pay) those supplemental taxes.

zip code 80000 - 3% --> 2.9% + 3% = 5.9%
zip code 80501 - 5.8% --> 2.9% + 5.8% = 8.7%
zip code 80026 - 7.3% --> 2.9% + 7.3% = 10.2%
...

It only needs to be shown on one line, does not need to be itemized, but you need to collect the total tax per order. Colorado has over 500 of these special rate zones, California perhaps several thousand.  There does not appear to be any way in VM2.x to handle this need. In VM 1.x there was an after-market hack to accomplish this need, but with the code having changed not even this works now.

Does anyone have a solution for this need?