Tax amount incorrect

  • Posts: 301
  • Thank you received: 1
13 years 3 months ago #23865

Hi

Even though only small, I notice that the GST (Tax) that appears on the order is always lower than the amount that needs to be charged when multiple items are selected.

For example

Item Cost with 10% tax = $8.95

The tax on this amount is 8.95 / 11 = $0.8136 which is near enough 81c which is fine for 1 product.

But when someone orders bulk of an item - say 15 items then the tax amount showing on the invoice is lower than the tax that actually needs to be charged.

Item Cost with tax = $8.95 x 15 = $134.25

Tax on total item cost = $134.25 / 11 = $12.2045 or $12.20 rounded.

In Hika, the tax amount is showing as $12.15.

It is not much - only 5 cents difference but this adds up if hundreds of products are sold. Small hiccup somewhere in the tax calculation.

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 3 months ago #23866

Hi,

Ecommerce systems display the taxes based on the unit price , and not based on the total quantity price.
If you do : 0.81 * 15, you get 12.15

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

  • Posts: 301
  • Thank you received: 1
13 years 3 months ago #23868

It would be more accurate if it was calculated with 4 decimal places. eg 8.95 / 11 = 0.8136. For 15 items this is 0.8136 x 15 = $12.20 and same as $134.25 / 11 = $12/20.

By not showing the true tax amount, it makes it a lot more work at the end of 3 months when we must pay tax to reconcile all the transactions. The amounts are very small but it makes it easier for accounting software to match figures that are the same instead of having to adjust all transactions. :)

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 3 months ago #23869

If you want, you can build a small product quantity calculation plugin which would calculate the taxes the way you want:
www.hikashop.com/support/documentation/6...tation.html#override

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

  • Posts: 301
  • Thank you received: 1
13 years 3 months ago #23871

Thanks - thats getting a little beyond my technical expertise. Is there a particular View page where the tax is actually calculated? If not, I can look at this after I have the shop live.

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 3 months ago #23872

The taxes are not calculated in views but when the data is loaded in classes which cannot be overridden directly. Which is why we provide such plugins possibilities.

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

Time to create page: 0.064 seconds
Powered by Kunena Forum