Shipping rounding VAT exclusive prices

  • Resolved Leachimster

    (@leachimster)


    5 years, 7 months ago

    Hello, I have set VAT exclusive prices.

    VAT – 20%
    Decimals set to 2
    Flat shipping rate – 3.325 € (Without VAT)
    Displayed shipping rate: 4.00€

    3.325 * 1.2 = 3.99 €
    3.325 + (3.325 * 20/100) = 3.99 €

    When I set 3.324x, I get 3.98€. I just cant get 3.99€ with VAT.

    When I set vat inclusive prices, I have problem in rounding with low cost products.

    Woocommerce v3.4.5

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support John Coy a11n

    (@johndcoy)

    Automattic Happiness Engineer

    5 years, 7 months ago

    Hi @leachimster

    Can you tell me if you are rounding tax at subtotal level, instead of rounding per line:

    https://docs.woocommerce.com/document/setting-up-taxes-in-woocommerce/#section-2

    Thread Starter Leachimster

    (@leachimster)

    5 years, 7 months ago

    Hi,

    I have tried both options, same result, shipping is always rounded to 4.00€ instead of 3.99€

    Maybe the problem is with decimals setting? I did not check the code, but 3.325 * 20/100 is 0.665. If this number is rounded to 2 decimal points, it is 0.67 which is than 3.995 in total, rounded to 4.00.

    But I do not want to display more than 2 decimals on front end.

    Plugin Support John Coy a11n

    (@johndcoy)

    Automattic Happiness Engineer

    5 years, 6 months ago

    Hi @leachimster

    Do you get the same result if you activate the Twenty Seventeen theme and disable all plugins except for WooCommerce?

    Thread Starter Leachimster

    (@leachimster)

    5 years, 6 months ago

    Yes, I have tried that. Still getting 4.00€, even in original storefront or twenty seventeen theme with all other plugins disabled.

    I see 1×10.00€ in cart + 4.00€ shipping, in total I see 13.99€ (which is correct)

    • This reply was modified 5 years, 6 months ago by Leachimster.
    Plugin Support John Coy a11n

    (@johndcoy)

    Automattic Happiness Engineer

    5 years, 6 months ago

    Hi @leachimster

    Taking a closer look at the math and rounding, it’ll be best for you to change the shipping to 3.99€ and set the tax rate to 19.95%. This should take care of the rounding of the second digit for you. Let us know if this helps.

    Thread Starter Leachimster

    (@leachimster)

    5 years, 6 months ago

    Cant’t do, because tax percentage is displayed on the invocie and it has to be exactly 20%.

    Thread Starter Leachimster

    (@leachimster)

    5 years, 5 months ago

    @johndcoy why is this marked as resolved? I still have this problem, it not have been solved.

    Setting a different tax to make it work like it should is not what I call “solving”.

    I need working solution with 20% tax.

    Jesse Pearson (a11n)

    (@jessepearson)

    Automattic Happiness Engineer

    5 years, 4 months ago

    @leachimster The issue is the rounding, and it’s rounding the tax amount. I set the shipping to have it’s own tax class and set the taxes to be shown as itemized and this is what I see:


    Link to image: http://cld.wthms.co/HOBZ9G

    The .665 is being rounded to .67. This is a battle that has been going on for years because everyone wants taxes and rounding to function as they need it, which isn’t possible because any change made will affect thousands of other stores.

    Kenin

    (@kbassart)

    Automattic Happiness Engineer

    5 years, 4 months ago

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Shipping rounding VAT exclusive prices’ is closed to new replies.