CS-Cart has created store for us www.shopimation.com based on ver 2.0.3. There are several issues we are observing and would like to have input from other CS-Cart users.
In this post we would like to mention an improper method of Tax calculation done by cart for atleast from US customer base persepective. CS-Cart calculates tax by per line item rather than on the order total which is totally incorrect from US customer perspective.
We would appreciate if similar thoughts and concern can be shared to this post so that CS-Cart realize that how critical is this. As a corporate we cannot charge customers incorrect taxes and then file incorrectly to the governement. Within a month of launch our accounts department is already struggling to reconcile as taxes don’t match between CS-Cart and Oracle.
We have seen that similar discussions on this topic was done but surprising CS-Cart did not take an initiative to fix this?
We have been working very closely with CS-Cart development and am sure that if they get feedback through this topic then we would be able to get this addressed.
This CS-cart tax calculation method is incorrect atleast in USA. All Tax calculations for the purchase in US is made on the order total and not on each individual item and then added.
Appreciate if we can input and feedback on this topic so that we can suggest CS-Cart to fix this on a priority.
As you mention, this issue has been brought up over and over without a proper solution.
I think the proper solution is to specify how taxes are calculated for each tax: by line item, product subtotal, discounted product subtotal or order subtotal (which would include shipping charges). This would provide a way to use different tax base for differing taxes.
[quote name=‘shopimation’]CS-Cart has created store for us www.shopimation.com based on ver 2.0.3. There are several issues we are observing and would like to have input from other CS-Cart users.
In this post we would like to mention an improper method of Tax calculation done by cart for atleast from US customer base persepective. CS-Cart calculates tax by per line item rather than on the order total which is totally incorrect from US customer perspective.
We would appreciate if similar thoughts and concern can be shared to this post so that CS-Cart realize that how critical is this. As a corporate we cannot charge customers incorrect taxes and then file incorrectly to the governement. Within a month of launch our accounts department is already struggling to reconcile as taxes don’t match between CS-Cart and Oracle.
We have seen that similar discussions on this topic was done but surprising CS-Cart did not take an initiative to fix this?
We have been working very closely with CS-Cart development and am sure that if they get feedback through this topic then we would be able to get this addressed.
Example - Customer ordered 2 products
and CS-Cart calculates
This CS-cart tax calculation method is incorrect atleast in USA. All Tax calculations for the purchase in US is made on the order total and not on each individual item and then added.
Appreciate if we can input and feedback on this topic so that we can suggest CS-Cart to fix this on a priority.
whew ok…so it sounds like someone has some recoding of the class tax if you are telling me the tax is applied pre discounts
2)i had a total of 3 active locations
a)usa
b)usa->state->alabama
c)usa->state->alabama->zip(zip code list)
i then applied a tax rate to:
b)state at 4%
c)city at 5%
no matter what i did i was only applied the stat tax rate, and not state and city, even when in the correct zip regardless of the state selection, i tried setting up the location with and without the country and state for the zip code based location, no difference on applying 2 tax rates on same order…
i am less concern on this second issue, as i could just make 1 tax rate to get me by, but it is illegal to collect the taxes as your cart is configured i would be over taxing the buyer as they as not spending the full amount i cannot charge taxes on the full amount!!
I made the changes noted in the KB article below but it doesn’t correct the display of amounts shown for an option on an item. The totals at the bottom of the View Cart screen are correct but the option amounts by item are not shown without the rounding feature. Can someone point me to the files that I should update to make the options amounts use the same rounding logic as the changes made in the KB article?
[quote name=‘grabbags’]Please see the fix for the round up in here
I have a situation where CS-Cart is being used for a ‘Services’ based company.
Besides the ‘State’ tax there is also a ‘Service Fee’ which is calculated on a percent basis. The only way I could figure out to handle this fee is to setup an additional tax called ‘Service Fee’.
The problem that I am having is that the total is taxed, the first tax is added, THEN the second tax is applied to that total - this is not correct.
Purchase = $110.00
Tax1 = 4.712%
Tax2 (Service Fee) = 18%
--------------------------------------
Total should = $134.3892 ($134.39)
However the total actually comes out to $135.2152 ($135.22)
Is there a way to either apply each tax seperately then added together for the total, OR a way to setup the 18% service fee in a differnet manner so that the total comes out correctly?
I didn’t see a reply from shopimation, but the KB article mod corrects the problem he started this thread with. I duplicated his two scenarios and got the correct tax calculated with the modification in the KB article. I am going to leave the mod in for my tax calculations.