Issue relating to when VAT is calculated/applied

  • Posts: 61
  • Thank you received: 1
9 years 4 months ago #207057

-- HikaShop version -- : 2.4.0
-- Joomla version -- : 3.4.1
-- PHP version -- : 5.4

Hi, we have a shop that a variety of stock with a few that have small prices such as 0.09 each and the timing of when VAT is calculated with these is causing an issue.

The site owner prefers that the price of items are displayed on the site without VAT, as for larger priced items the perception is that they are cheaper even though the prices are declared as "excluding VAT".

Using the example above, an item costs 0.09 excluding VAT and is displayed as such on the website.

If you buy one of those items the cost including VAT would be:

0.09 + 20% (0.018) = 0.108 which will be rounded to 0.11

Using this method, if you buy 20 of these items the total including VAT works out to be:

0.11 x 20 = 2.20

However, if you take the price, excluding VAT, to be 0.09 and want to buy 20, the total for that works out to be:

0.09 x 20 = 1.80

If you then add the 20% VAT it would be:

1.80 + 20% (0.36) = 2.16

So, you can see in the above there is a discrepancy of 0.04 on the purchase of the 20 items which is caused by when the VAT is calculated. Hikashop is calculating the VAT on the single items so the total for 20 of them including VAT is 2.20, whereas it Hikashop calculated the VAT on the 20 items as ordered, then the total for them including VAT is 2.16

We recently made a change to the site to turn on the "Round prices during calculations" option in the taxes configuration in order to overcome an occasional rounding problem being caused by the way Paypal calculated VAT. Is this option now having a knock on effect to the timing of when VAT is calculated? I hope not.

I think it is correct that VAT should be calculated and applied to the total of each line item and not on an item by item basis, but Hikashop is doing the calculation item by item.

Please help with this - thank you

Last edit: 9 years 4 months ago by miwhel.

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

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

Hi,

The "round prices during calculations" option will change the way the system calculates the taxes from one mode to the other.
So if you flip it, you'll that you'll either have 2.16 or 2.20 calculated.
So HikaShop can handle both types of calculations in order to accommodate everyone (different countries recommend different ways of calculating that).

In the PayPal plugin, you have the "send order details" option. When turned off, HikaShop only sends the total of the order to PayPal as if it is one big product. That way, you always pay the correct amount, calculated by HikaShop based on the "round prices during calculations" option.
If however you activate that option, the HikaShop sends all the details of the cart. In that mode, PayPal recalculates itself the total but only supports one mode of calculations rounding. So based on how you configure the "round prices during calculations" option, you might indeed get discrepancies between PayPal and HikaShop as HikaShop cannot give to PayPal the correct total to charge when the whole cart details is sent.

So basically, you have three options:
- You don't send the order details to PayPal and you can use the rounding mode you want.
- You send the order details to PayPal but you're forced to use the same rounding mode as PayPal (which is the one you don't want).
- You use another payment gateway which doesn't recalculate itself the total (PayPal is the only one doing that as far as I know) and you'll be able to use the rounding mode you want.

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

Time to create page: 0.045 seconds
Powered by Kunena Forum