I have two taxable States (U.S.) and three shipping methods. The taxes are not calculating correctly (MI 6%, OH 5.5%), & shipping methods not available for all tax locations.
[ATTACH]1435[/ATTACH]
tax should be OH-Tax (5.5%) 39.95 x 0.055 = $2.20
[ATTACH]1436[/ATTACH]
tax should be MI-Tax (6%) 39.95 x 0.06 = $2.40
In addition I do not see all the shipping methods for all the tax locations?
[ATTACH]1437[/ATTACH]
[COLOR=“Red”]I have the EXACT same problem, and it’s REALLY pissing the sh!t out of me. WOW THIS IS LAME.[/COLOR]
MO and TN with Flat Rate $9 shipping. Couldn’t be much simpler, yet CS-Cart is kind of a sh!t to work in when it comes to tax and shipping I have noticed. Major con.
I can’t read the tax is for your MI example but for your OH example it appears you have ‘Price includes tax’ checked in the tax setup:
39.95-(39.95/1.055)=2.08
We need more information regarding your shipping problem. Do the missing shipping methods use manual or realtime calculations? Some common problems to check:
- Locations must not overlap - make sure your destinations appear in only one location;
- there is no weight assigned to products;
- if you are using the Supplier addon, you must set the supplier(s) which use the shipping method (in shipping methods).
Bob
I can’t speak for the OP, but the one thing I do not understand is this “locations must not overlap” thing. The reason this doesn’t make since to me is because I have two taxes (MO and TN) in the USA. I have to set MO and TN as locations to apply that tax, right? So when I do that, I have all these problems, like $36 shipping instead of $9 and “no shipping method for your area”, etc.
What is the proper way to set up a tax for two states in the US, and charge manual shipping?
You need to create three location: MO, TN and USA except MO and TN. The locations will be configured as follows:
MO - includes only the state of Missouri
TN - includes only the state of Tennessee
USA except MO and TN - includes all states except MO and TN.
If you include a state in two locations, you may get the no available shipping message.
You then need to create taxes for each taxing authority (e.g., Mo State Sales Tax and TN State Sales Tax). For each of your taxing authorities, go to the “Tax rates’ tab and set the applicable tax rate for the location (e.g., the MO tax will have a rate specified only for the MO location).
Finally, create a 'Flat Rate” shipping method set up as manual and click the “Create” button. Then select the “Shipping charges” tab. Select your MO destination link where it says “Show rates for location:”. Under Cost dependencies, set up as follows:
More than $0 $9 Absolute
Make sure no other costs are set and click the Save button. Repeat this for the TN link.
Everything should be working - if not let us know what problems you encounter in calm, rational language. I almost did not post based on the shrillness of your initial post.
Bob
Perfect – that worked. I’m glad you know your stuff. Thank you.
OK, I have figured out the shipping problem, but am just using the default location with the only county as USA and all the states except OH & MI.
I still do not understand the tax calculation which appears to be wrong when compared with all other POS calculation used:
$39.95 product at 5.5% sales tax would be
$39.95 x 1.055 = $42.14725
$42.14725 - 39.95 = $2.19725 rounded to $2.20 TAX not $2.08
Am I missing something here?
[quote name=‘jobosales’]You need to create three location: MO, TN and USA except MO and TN. The locations will be configured as follows:
MO - includes only the state of Missouri
TN - includes only the state of Tennessee
USA except MO and TN - includes all states except MO and TN.
If you include a state in two locations, you may get the no available shipping message.
You then need to create taxes for each taxing authority (e.g., Mo State Sales Tax and TN State Sales Tax). For each of your taxing authorities, go to the “Tax rates’ tab and set the applicable tax rate for the location (e.g., the MO tax will have a rate specified only for the MO location).
Finally, create a 'Flat Rate” shipping method set up as manual and click the “Create” button. Then select the “Shipping charges” tab. Select your MO destination link where it says “Show rates for location:”. Under Cost dependencies, set up as follows:
More than $0 $9 Absolute
Make sure no other costs are set and click the Save button. Repeat this for the TN link.
Everything should be working - if not let us know what problems you encounter in calm, rational language. I almost did not post based on the shrillness of your initial post.
Bob[/quote]
[quote name=‘TKolman@WearDistrict.com’]I still do not understand the tax calculation which appears to be wrong when compared with all other POS calculation used:
$39.95 product at 5.5% sales tax would be
$39.95 x 1.055 = $42.14725
$42.14725 - 39.95 = $2.19725 rounded to $2.20 TAX not $2.08
Am I missing something here?[/QUOTE]
For the location MI, you have 0.055 as a percentage, correct? (If not, change it; else, read below.)
Go to your Shipping/taxes > Taxes and + Add tax. Call this “Sales Tax” and be sure it’s marked Active. Now go to your rates and enter your rates for MI and OH. So MI will be 0.055 Percent (%) not an Absolute ($).
Disable your other tax methods and test this.
If the problem persists, it must be related to your shipping fees. In that case, I’d delete locations, taxes, and shipping… then restart.
[quote name=‘TKolman@WearDistrict.com’]
I still do not understand the tax calculation which appears to be wrong when compared with all other POS calculation used:
$39.95 product at 5.5% sales tax would be
$39.95 x 1.055 = $42.14725
$42.14725 - 39.95 = $2.19725 rounded to $2.20 TAX not $2.08
Am I missing something here?[/QUOTE]
Do you have ‘Price includes tax’ checked on the tax setup? If so, uncheck it and the calculation should be $2.20.
Bob
Hi,
I found one problem with my Tax count.
For example there is 21% TAX rate, in Lithuania, If I’m selling 10 products for 3.13 each totlat sum will be 31.30 and the TAX should be 5.43, but CSCART counts 5.40!!!
This is incorect. How to fix this???
Guys really need your help!!! Thank You
[quote name=‘arunas@simonaitis.lt’]Hi,
I found one problem with my Tax count.
For example there is 21% TAX rate, in Lithuania, If I’m selling 10 products for 3.13 each totlat sum will be 31.30 and the TAX should be 5.43, but CSCART counts 5.40!!!
This is incorect. How to fix this???
Guys really need your help!!! Thank You[/QUOTE]
Shouldn’t your tax be 6.57? 10 x 3.13 = 31.30 x .21 = 6.573 (6.57 rounded)
Is your tax rate set at 0.210 as a percentage?
[quote name=‘Sleven’]Shouldn’t your tax be 6.57? 10 x 3.13 = 31.30 x .21 = 6.573 (6.57 rounded)
Is your tax rate set at 0.210 as a percentage?[/QUOTE]
31.30 is price including VAT, if my VAT 21% that means:
31.30/1,21=25,87 this is price without VAT, that means VAT = 5,43 but CSSART counts for me 5,40. CS rounds value. Somebody knows how to fix this?
My TAX set to 21.000 by %