How do you guys deal with this?
Technically, the sales tax varies from city to city. It's not practical to create conditional rules for each CA city isn't it?
Tue, 01/13/2009 - 16:40
Tax
See if any of these will be of assistance.
Re: CA Sales Tax
This was a huge nightmare for me, i don't wish California State sales tax on anyone. I ended up getting a spreadsheet and using zip codes to determine the tax rate. I cam up with clusters like if 961XX apply the 7.5% rate. It took me the better part of two days going through the data and setting up the rules. I am thinking there is an API to do the figuring for you. I think there are a few zip codes in my setup that might be off but I got as close as possible given the circumstances. I ended up with 5 tax rules and like 12 tax conditions.
thill:
Would you mind
thill:
Would you mind sharing your nightmare with me?
Re: thill:
Would you mind
Ok, here is the rows you need for my setup in ca_predicates and in the uc_taxes,
Like I said these are not 100% perfect, you don't know me if the tax man come to visit.
| Attachment | Size |
|---|---|
| ca_predicates.sql_.zip | 1.68 KB |
| uc_taxes.sql_.zip | 1.18 KB |
Re: CA Sales Tax
Thanks thill. I'll blame it on ryan when the taxman comes since his picture is plastered all over this forum.
I'm assuming that these rates are the ones effective 01/01/2009.
Re: Re: CA Sales Tax
hmmm no i did this in November, the client hasn't mentioned them changing, sorry about that.
California Local Tax Rates: Related Thread
The issue of localizing the tax rates for California is also discussed in an issue thread here:
http://www.ubercart.org/issue/7644/conditional_actions_tax_miscalculation.
I had originally posted to that thread as 'copperIT' (a former work account that may be used by my former employer), but I am now posting as 'daveX99' (my personal account).
I hadn't seen this thread, so forgive the double-posting, but this seems a better place (the other is in the category for Conditional Actions Issues)... I'm not a frequent poster to these forums, so if I've made a faux pas, please feel free to let me know.
Anyway, the reply I posted to the above thread is still pending moderation (or lost in the ether somewhere), but I will post here as well.
The method I use to deal with this is to download a file from the CA Board of Equalization with the current Sales Tax and Use Tax Rates from this page:
http://www.boe.ca.gov/sutax/pam71.htm
(see the .csv or .xls files at the bottom of the page)
Essentially, I take the list of cities in the csv file and sort by tax rate, then break all the cities out into separate lists by each rate. This makes 14 lists. I then set up corresponding tax rates in Ubercart with following conditions in their Conditional Actions:
- Check if the Shipping Zone is California
- Execute PHP code that uses the lists set up above to checkthe Shipping City and apply the appropriate rate.
I'm attaching a txt file that has the current lists (as of 10.1.2010) set up, as well as more details on how to set it up. It's tedious, and this all would be better if it could somehow be set up as a module (which is beyond my capabilities just now, both skill- and time-wise),
-dave.
| Attachment | Size |
|---|---|
| uc_CA_salestax-2010-10-01.txt | 43.53 KB |
Regex
This thread is a bit old, but it took me quite a while to come up with a working solution. We only needed to worry about Los Angeles County, but a similar method should work for any other limited scenario. I created two tax rules: one for the state, and the other for the LA District add-on (an extra 1.5%). The state rule is a simple data comparison. The district rule needed a text comparison set up as a regular expression. I published the regex for LA County at http://regexlib.com/REDetails.aspx?regexp_id=3498. An admin might want to look at some of the attachments in this thread. I've been getting a lot of file not found errors when trying to access them.