- Posts: 301
- Thank you received: 1
Tax amount incorrect
15 years 1 month ago #23865
by Huski
Tax amount incorrect was created by Huski
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.
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.
15 years 1 month ago #23866
by nicolas
Replied by nicolas on topic Re: Tax amount incorrect
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
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.
15 years 1 month ago #23868
by Huski
Replied by Huski on topic Re: Tax amount incorrect
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.
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.
15 years 1 month ago #23869
by nicolas
Replied by nicolas on topic Re: Tax amount incorrect
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
www.hikashop.com/support/documentation/6...tation.html#override
Please Log in or Create an account to join the conversation.
15 years 1 month ago #23871
by Huski
Replied by Huski on topic Re: Tax amount incorrect
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.
15 years 1 month ago #23872
by nicolas
Replied by nicolas on topic Re: Tax amount incorrect
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.211 seconds