Issues with tax calculations

I am having issues with sales tax calculations. I have an order where I can't get the numbers to add to the total that the customer was charged, and what they were charged was wrong. The included screen shots show the information in the order.

The order is simple. Two items ordered. One item is taxable, and they ordered 3 of them. The other item is not taxable, and they ordered only one of them. The tax rate is 6.875%. Shipping is $12.50, and is not taxable.

From my calculations the tax should have been $4.11, not $5.49, the sub total should have been $76.46, not $77.84, and the order total should have been $88.96, not $90.34. Where is the extra $1.38 in tax coming from?

Anyone have any thoughts? I am stumped.

Hi there,

I tried on my end and it's working here.
Do you have the last version of Hikashop? Also are you sure your product are configured as you said (especially for the non-taxed product and the non-taxed shipping method).

I am running 1.6.0. I upgraded to it shortly after it was released.
Both the shipping method and the product have a tax category of none.

I think I found how the math is working now, but I still don't understand why.

One product, the one selling for $12.50 actually has a discount on it. The regular price is $19.95. If I add $19.95 and the other merchandise before taxes which comes to $59.85, I get $79.80. If I calculate tax from that amount, I get $5.49, which is what the customer was charged.

I feel confident that I have figured out what happened, but I don't understand why, as the discounted item has a tax category of none. It does have three variants as there are three sizes, but variants don't have a tax setting, so it isn't something buried in there.

Any thoughts as to why that one item would be taxed, when it is not set to be taxed?

First of all, try to download the last version an re-install it. We fixed many bugs about tax calculation since the first release and it may solve your problem

I just downloaded 1.6.0 again installed it. I then built up the cart just as that customer had, and proceeded to checkout. The tax amount is still wrong. It is still including the before discount price of that item in the tax calculations.

I have attached a screen shot of the results.

Could you please send me screenshot of your discount?
It seems indeed that we have a bug there, I'll try to fix it

Here is a screen shot of the discount. It is a very simple one applied specifically to that product.

We found the bug. Here is the fixed file, just go in administrator\components\com_hikashop\classes and replace the currency.php with the attached one.
It should solve your problem


EDIT: I did a mistake but the attached file is now the right one

I just downloaded the fix, applied it, and tested again. Unfortunately I am still seeing the issue.

Then I think I'll need a FTP and backend access to found the source of the issue.
If you could PM me these informations

My bad, I gave you the wrong file so the correction wasn't applied.
I just updated with the new file and it's working fine now

I just myself, and it is indeed working right now. Thank you! I really appreciate all the help in getting this resolved.

I appear to be having issues with taxes again.

Running Joomla 2.5.7 and HikaShop 1.6.0

The shopping cart had 4 products, 3 of them were taxable. The tax rate is 6.875%. The user that purchased the products is a member of our organization, and all members get a 10% discount on all items in the online store. All members are assigned to a special members only user group, and that user group is granted access to a 10% discount I created for this purpose. I have the tax setup to be applied after discounts are applied. All shipping is not taxable.

The items were as follows:

Item 1 - $19.95 - $17.95 after discount - showing $1.23 in tax
Item 2 - $14.95 - $13.46 after discount - showing $0.93 in tax
Item 3 - $15.15 - $13.63 after discount - showing $0.94 in tax
Item 4 - $44.95 - $40.45 after discount - not taxable

The tax should have been $3.10, but it came in at $4.14. With shipping at $14.50 the order total came in at $104.14. It should have been $103.10.

I can't figure out where the extra $1.04 came from. Any help at all would be appreciated.

This is still an issue for us. Anyone have any thoughts on this?

Hi,

I'm trying to reproduce your bug but I don't get the same result. Are you sure you're shipping method is not associated to any taxe? That could be the source of the problem.

We are using the manual shipping plugin. I just went in and checked on the tax settings to be sure. We are not taxing any shipping. The tax category for all of them is set to none.

Which website did you check? This issue is occurring on www.bear.org .