Issues with tax calculations

  • Posts: 153
  • Thank you received: 7
  • Hikashop Business
12 years 1 month ago #66052

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.

Attachments:
Last edit: 12 years 1 month ago by vanboke. Reason: Adding attachments

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
12 years 1 month ago #66220

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).


Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 153
  • Thank you received: 7
  • Hikashop Business
12 years 1 month ago #66233

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?

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
12 years 1 month ago #66235

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 :)

Last edit: 12 years 1 month ago by Eliot.

Please Log in or Create an account to join the conversation.

  • Posts: 153
  • Thank you received: 7
  • Hikashop Business
12 years 1 month ago #66244

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.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
12 years 1 month ago #66248

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

Last edit: 12 years 1 month ago by Eliot.

Please Log in or Create an account to join the conversation.

  • Posts: 153
  • Thank you received: 7
  • Hikashop Business
12 years 1 month ago #66256

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

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
12 years 1 month ago #66270

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 :)


File Attachment:

File Name: currency_2...9-21.zip
File Size:13 KB

Attachments:
Last edit: 12 years 1 month ago by Eliot.

Please Log in or Create an account to join the conversation.

  • Posts: 153
  • Thank you received: 7
  • Hikashop Business
12 years 1 month ago #66275

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

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
12 years 1 month ago #66368

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 :)

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
12 years 1 month ago #66570

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 :)

Please Log in or Create an account to join the conversation.

  • Posts: 153
  • Thank you received: 7
  • Hikashop Business
12 years 1 month ago #66639

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

Please Log in or Create an account to join the conversation.

  • Posts: 153
  • Thank you received: 7
  • Hikashop Business
12 years 3 weeks ago #69233

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.

Please Log in or Create an account to join the conversation.

  • Posts: 153
  • Thank you received: 7
  • Hikashop Business
12 years 2 weeks ago #70352

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

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
12 years 1 week ago #71377

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.

Please Log in or Create an account to join the conversation.

  • Posts: 153
  • Thank you received: 7
  • Hikashop Business
12 years 1 week ago #71458

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.

Please Log in or Create an account to join the conversation.

  • Posts: 82683
  • Thank you received: 13337
  • MODERATOR
12 years 1 week ago #71717

I checked on the website that you gave a back end and FTP access to but didn't find any taxes configured.
Is that a different website ?
Could you provide access to it in that case so that we can look at that ?

Please Log in or Create an account to join the conversation.

  • Posts: 153
  • Thank you received: 7
  • Hikashop Business
12 years 2 days ago #72760

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

Please Log in or Create an account to join the conversation.

  • Posts: 82683
  • Thank you received: 13337
  • MODERATOR
12 years 1 day ago #73116

We never had access to that website as far as I know.
Could you give one so that we can look at the issue?

Also, each time you post an issue, it would be great if you could directly include a link to the website or even better where you have the problem. That way, we can give you a helpful answer faster.

Please Log in or Create an account to join the conversation.

Time to create page: 0.108 seconds
Powered by Kunena Forum