Vote up!
Vote down!

How to calculate tax for each individual county within a state?

The store I am building a commerce site for is required to charge tax on all orders that ship to IL. How do I account for all of the different tax rates within IL? I think it varies from county to county, and maybe even town to town. Is there some sort of module that can do this, or do the individual tax percentages need to be entered and updated manually?

Asked by: mjade1138
on August 2, 2012

2 Answers

Vote up!
Vote down!

I am almost positive that the law states you only need to charge the sales tax of the county that the physical location is in. So if the store that is fulfilling orders is in Lake County, ANY order that is shipped to IL will be charged the tax rate of Lake County. If there are multiple store locations in IL, I would just choose the main location or the location that will be processing the online orders.

I know that doesn't answer your question, but perhaps it solves your problem?

Answer by: BD3
Posted: Aug 3, 2012


Thanks so much for your response! That makes sense, and sounds much easier to set up.

- mjade1138 on August 5, 2012

That may work for IL, but not for NC. According to NC DOR, the tax applied is based on the customer's county tax rate, not the seller's. Therefore, the need to apply a sales tax per county rate is still needed. When setting a condition by address, there is a line for Administrative area (State/Province) and a line for Sub-administrative area (District). The sub-administrative area could/would serve as the county or in some states, like CA, a tax district that may follows zip, county or other boundaries. There could also be a need for a sub-sub-admin-area e.g. a city tax within a sub-admin-area.

So the question still remains, how to set up sales tax per county (or other taxing sub-admin area). The billing address is a field that I (with my limited knowledge) have not been able to alter. Is there a way of adding a field to the billing form that would be able to have a rule applied? For my client in NC, the customer would need to be able to choose, or fill in, their county for the applicable rule to apply the tax.

Please advise. I will post this info other places, and if I find out before a response is delivered here, I will post back.

- FrankJC on March 25, 2013

I compiled a module and rules to handle the three tax rates and 100 counties in NC. With about an hour of editing, it could likely be turned into any US state that uses county based sales tax. Being as how this is the closest I have come to actual programing, I can't gurantee it is Drupal code compliant, but the module is based off of the addressfield module's example plugin. http://drupal.org/project/addressfield If anyone wants to test it contact me at [email protected].

- FrankJC on April 22, 2013
Vote up!
Vote down!

I got this working on my site. I did a write up about how I did this at TriDUG

Answer by: FrankJC
Posted: May 27, 2013