Woocommerce Rounding Issue With Tax

Hi @piskui07,

Thanks for reaching out to us!

The actual tax calculation for WooCommerce does not round each line tax, WooCommerce does instead calculate tax for the invoice line as a whole.

There has been some discussion already about the 0,01 price difference and you can have a look at this Github thread:

https://github.com/woocommerce/woocommerce/issues/14458

If you will increase the number of decimals to 4 you will see that the actual product price is not $9.83 but $9.8333 and the totals are $29.4999. This may work for you if you think that the 0,01 price difference may confuse customers.

Link to image: https://snipboard.io/fCvuJU.jpg

However, as Mike suggested on that thread, to avoid these types of rounding issues you can use tax-exclusive prices. Calculations are more straightforward when prices are exclusive of tax.

Link to image: https://snipboard.io/015KBD.jpg

Hope this all makes sense.

Thank you.

Hi,
thanks for your reply.

I see with 4 decimal numbers all seems good but this is not a solution since for final customer is not good to see 4 digits decimals… let’s say is not “standard” or common way to display numbers. So this is not a solution for my shop (and I think also for other shops).

I see the issue is reported from several ecommerce and also that it seems a “very old question”. Also searching in Google I don’t find any (up to date) applicable solution.
The Git discussion you pointed me is about 2017.
In the meanwhile there is no update in this topic?
No one has found a fix or a workaround to apply?
I tried this workaround https://github.com/woocommerce/woocommerce/pull/14475#issuecomment-306742617 but code seems to be old compared to the newest Woocommerce so I don’t know if it is ok.
By the way, it doesn’t fix my issue, but the base idea under the code I think is good. Basically it force the rounding precision to the same value set in the backoffice settings of WP admin. So if decimal numbers to display to user is 2 also math operation is done with this precision. I udnerstand that this can be a workaround but for some shop can be a good solution and, from my point of view, I’d like to give a try.
So… Is there a way to set newest Woocommerce version to do math operation using only 2 decimal precision number and not 4 decimal as it do now?

I think a simpler method to do this might be to just set the prices to be entered with taxes included, like this:

https://d.pr/i/Oh230A/zjdbq9GzST

Then, if you have a $9.83 product x 3, you get the amount you expect in the cart and checkout:

https://d.pr/i/Y1t0eC/xqAaWgcqkO

Would that work for you?

Hi Adam,
I already tried set all price including tax but this is not a solution.
Yes… maybe it fix this single test case example but the store has several other products with several different prices and the use case is always valid.

With price set with tax included the issue is the same when a user from a country not equal to the one of my store try to buy.
Woocommerce, simplyfing, first remove the VAT in the country of the store and then add the VAT of the country of the user.
So, dipending on the start price, this is resulting again in 1 cent different on some products cart lines.

So, again, my question is: Is there a way to set newest Woocommerce version to do math operation using only 2 decimal precision number and not 4 decimal as it do now?

Hey @piskui07,

So, again, my question is: Is there a way to set newest Woocommerce version to do math operation using only 2 decimal precision number and not 4 decimal as it do now?

There isn’t a solution for this in core WooCommerce at the moment, however, some users have found workarounds for different situations that might be helpful in your case. For example, this open Github issue includes a comment with a code snippet that looks like it limits the number of decimal places used in calculations on the Cart and Checkout pages to “2”, rather than only displaying “2” decimals like WooCommerce does currently:

https://github.com/woocommerce/woocommerce/issues/29908#issuecomment-878651737

Hi @shaunkuschel,
the piece of code you point me change the decimals diplayed to the user, not the decimals used by Woocommerce to do Math operations. So it is not a solution for me.

Any other ideas/suggestion?

Howdy again,

You will need to use custom code to achieve the rounding for orders / checkout as well. Here is 1 suggestions: https://stackoverflow.com/questions/65287180/how-to-round-taxes-per-product-in-woocommerce and a general approach: https://stackoverflow.com/questions/36242467/woocommerce-tax-rounding-issue

Please note that we provide no warranty or support for custom code or 3rd party plugins (meaning we cannot not help you further with this code snippet or www.remarpro.com / GitHub plugins). Use them at your own risk.

**Also: Before you do that, please do make a full backup!**

Kind regards,

Hi @piskui07

We’ve not heard back from you in a while, so I’m marking this thread as resolved. If you have further questions, please feel free to open a new topic.