Calculation gives 21€ of tax on 90€ but rate = 21%

  • Posts: 52
  • Thank you received: 0
9 years 4 months ago #208955

-- url of the page with the problem -- : www.valkyrie-guitars.com
-- HikaShop version -- : latest
-- Joomla version -- : latest
-- PHP version -- : 5.5.24
-- Browser(s) name and version -- : All browsers
-- Error-message(debug-mod must be tuned on) -- : No error message, just wrong tax calculation

Hi there.

We are very pleased with Hikashop in general, our webshop is looking better and better. The Help through the forum is also always quick and good, which is excellent as that helps us to quickly continue the development.

Right now we have discovered however a problem with the tax calculations. Our is set to 21% for the default. This works well without coupons. When someone uses a coupon, the calculation is strange. It presents as a calculation of 21€ of tax on a base of 90€ where the tax percentage is 21%.
This happens regardless of whether the tax for the coupon is set to "None" or "Default tax category".
See the images attached.

Perhaps somewhere we do not have the right settings, I did see that there had been other questions about this on the forum. And I followed up the advice I found there. It did not resolve the issue.

But whatever the reason, the tax calculation as presented on the front-end to the customers should never be so obviously wrong.

Can you help?

Cheers,
Marjoline

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 4 months ago #208994

Hi,

You want to select the tax category of your coupon, and you also want to change the "apply discount" setting of the HikaShop configuration.

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

  • Posts: 52
  • Thank you received: 0
9 years 4 months ago #209015

Sorry, but this is a response I have seen given before on this forum. I had already checked this out. But as mentioned above, I found that this happens regardless of whether the tax for the coupon is set to "None" or "Default tax category".

And the calculation should still not be wrong on the front end, this is inexplicable to the customer. 21€ tax on 90€ when the tax rate is 21% is silly, any customer can see that.

It is a 10% discount but regardless whether the discount is before tax or after tax, Hikashop always turns it into a 10€ discount. So 10% of 121€ = 10€ and 10% of 100€ = 10€.

So we need more help on this one.
You have access to our backend, should you wish to have a look.

Cheers,
Marjoline

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 4 months ago #209030

Hi,

Well, you didn't mention the "apply discount" option in your first message so it's normal that I gave the same answer than before as that's what usually solves the issue.

For further investigation, I'll have to check your website settings.
We don't keep track of user accesses. Please provide the access again via our contact form along with a link to this thread so that we can do that.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 3 months ago #209709

Hi,

I change the coupon code to use the "default tax category".

And I made a simple test :
pasteboard.co/2gHA9Z6m.png (with default view)
pasteboard.co/2gHMAsNf.png (with your view override)

Prices without tax :
* Product - 100 €
* Coupon (10 %) - 10 €
* Shipping - 7€

Prices with tax :
* Product : 121 €
* Coupon (10 %) - 12.1 €
* Shipping - 8.47 € (7 * 1.21)

Total : 121 - 12.1 + 8.47 = 117.37 €
Taxes : ( 100 - 10 + 7 ) * 21% = 20.37 €

Thus ; about the " over 97 € " which is displayed in your cart. As you probably noticed, that information is not displayed by the original HikaShop view ; it is something that your view override add.
And that information that you display does not include the shipping (97 € = 100 € - 10 €)
Which explained why you think that the VAT is incorrect because you do not include all elements in your processing.

More than that, if your coupon does not have tax ; the taxes will be 21 % of the original price ( 100 € ) because the coupon will remove 10 € but it will not remove taxes.

To conclude, I didn't see any problem with the HikaShop processing but your view override does not display the most appropriate value for the "over ..." because it does not include the shipping and it also include the discount provided by coupon without vat.
So, if you really want to display that information, I suggest you to not look for a value in the HikaShop variables, but to process it or to deduce it from the VAT value.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: Marjoline

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

  • Posts: 52
  • Thank you received: 0
9 years 3 months ago #210507

Hi Jerome,

That is a wonderfully complete answer, thank you so much! My partner was going to look into this, but he has had no time, which is the reason for my delay in answering here. Just now I was looking at it again with my son/webmaster, and everything seems to be working well! I cannot explain it, I previously thought I myself had tried all possible combinations of settings in products and coupons, but obviously not. My apologies.

You have as always been a tremendous help for us.

Kind regards,
Marjoline

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

Time to create page: 0.065 seconds
Powered by Kunena Forum