5 replies to this topic

[glenn1723]

I am shipping from a location within Los Angeles County, within California

California has a sales tax and so does Los Angeles County.

I need a way to charge sales tax based on whether the customer is within California and another sales tax needs to be added if they are within LA county.

I'm sure this has been set up by someone before me...

I have a list of all zipcodes that are entirely within Los Angeles County, and another list of zip codes that are partly within LA county.

So I can use these zip codes to determine that someone is definitely outside the county
and
can also determine SOME customers are within LA county
but
I can't use zip code to determine if someone IS within LA county, if they are in one of the zip codes that are PARTLY in the county

so...

I need a way to charge income tax based on "IS the customer in California" AND an additional tax "if someone is within Los Angeles County" (and I need a way to determine if they are, like a question "Is this being shipped to LA County?"

any suggestions how to best set this up?

[enigma1]

have a look here:
http://www.oscommerce.com/community/contributions,5171

there are tax related contributions for various states including cali.

[glenn1723]

enigma1, on Jun 3 2007, 09:36 PM, said:

have a look here:
http://www.oscommerce.com/community/contributions,5171

there are tax related contributions for various states including cali.

I don't see anything on California.

I cannot use zip code to determine if someone is charged county tax, some of the zip codes contain addresses within and not within the County.

[enigma1]

glenn1723, on Jun 4 2007, 01:54 AM, said:

I don't see anything on California.

then what's the ca_country_tax_sql-4-1-2007.txt file in the contribution? Have you read the documentation? Because I see

Quote

I've also included a sql file for the subzone tax rates for Georgia and California current as of 4-1-2007.

[MrPhil]

A related question: are there any modules/add-ons to handle New York State tax collection? Sales taxes here in NY are a nightmare for non-brick-and-mortar stores, because the tax rate is supposed to be collected for the shipping address (customer destination), not the seller's store/HQ/warehouse location. So, I need to take the full shipping address and figure out which town it is (e.g., there are at least 5 Mount Pleasants!), in which county, and in some cases which street number to get the right tax rate. Then there are reduced taxes on some clothing items as well as sales tax holidays! The state discourages tax-rate-by-ZIP-code, as ZIP boundaries don't always coincide with tax jurisdiction boundaries. We won't even talk about all the variations in spelling and various tricks people might use to try to fool the system. Oh yeah, some Post Offices in NY serve neighboring states and vice-versa (or serve multiple counties, each with their own tax rate). Beyond asking the customer to give me the correct tax rate for a category, is there any kind of automated system? The state has a Web page where you can enter the address and it will spit back the rate, but no API for it, so evidently it can be done.

[kembree]

Have you seen this?

New York State Tax By Zip Code
http://addons.oscommerce.com/info/2792