You have to select “Yes, my prices include VAT” (sorry, translated to englisch from another language).
In your case, Woocommerce calculates the VAT from 80 AED, which is 76,109 AED, equals a VAT of 3,81 AED.
Dear @chris2201 yes my prices are include VAT you are right and 80AED should be RSP+vat but if we calculate 5% of 45 and 35 its still wrong and 3.81 is not the right number.
5% for 45 = 2.25
5% for 35 = 1.75 so total is 4 right?
and 5% for 80 is 4 so WooCommerce should show 4 in the invoice and checkout. correct me please if im wrong.
You’re calculating it wrong. If the INCLUDING TAX price is 45 then it is:
42.86 + 5% (2.14) = 45
The 45 already has the 5% applied to it – so 5% of 45 would give you an additional 5% of the 2.14 that was already added!
agree! my bad, i update it and all good now but problem with decimals on shipping. My shipping rate is 19AED taxable so it should be 18.10+5% VAT but on woocommerce its showing now 19.01 with decimals why?https://prnt.sc/sxtVA3RJAyPU and this is on frontend: https://prnt.sc/6XeYpnR6otzQ
Hi @marchajj – 19.01 is correct if you start with 18.10 and then add 5% to it. If you want 19.00 even, you should use the un-rounded amount, and let WooCommerce do the rounding after adding the tax.
Here’s the calculation for how to work backwards from your final amount, so that we can see the un-rounded amount.
19/1.05 = 18.0952381
In this case, use the number down to 3 decimals: 18.095 – if you enter that as your shipping cost, the total after 5% tax will be 19.00.
I hope that helps! For more context, have a look at the How Taxes Work in WooCommerce documentation.
Thanks a million @eastofwest for the great details and info. much appreciate it!
@eastofwest sorry i had to reopen this thread here because something strange is happening here and please check the below scenario carefully:
This is my TAX RATE for the shipping fees in the backend: https://prnt.sc/npXzig_WItVa the delivery fees here is correct 19AED https://prnt.sc/6wQrHC_b1aLD but i dont know why the currency is Arabic here when the website is english but its not a concern or issue now, and when i place order its wrong: https://prnt.sc/yFpZ7ivhMpPT why its becoming 19.01 https://prnt.sc/5YSXlRBk2DCK this is wrong! can you please advice please about this behavior?
Zee
(@doublezed2)
Hello marchajj,
Thank you for your message here.
This thread was created over a month ago and WooCommerce has released a few updates since.
As per forum guidelines, I suggest you create a new topic and describe your issue there.
Looking forward to your new topic. 🙂
Have a great day!
