Subtotal excluding tax not rounded correctly with more then 1 product

  • Resolved SLV

    (@dwnl)


    4 years, 9 months ago

    I have a shop with prices set as:
    Tax options: Prices entered with taxes: Yes, I want to enter prices including tax
    Show prices in the store: Including taxes
    Show prices during ordering and checkout: Including taxes
    Number of decimal places: 2
    Tax: 6.000%

    I have a plugin: Booster.io and set:
    I activated the Tax Display Module Options
    In the section: TAX Display by User Role, I selected a User role and:
    Role: wholesale_customer – shop: Excluding tax
    Role: wholesale_customer – cart: Excluding tax

    So normal customers see price incl. tax and wholesalers see prices excl. tax.

    But the subtotal on the cart page (for the wholesaler) is not correctly rounded.
    The product is set up as:
    €20,75 incl. 6% tax, this is:
    €19,58 excl. 6% tax
    When I add 2 of these products to the cart it says:
    Subtotal: €39,15, this is wrong, this must be €39,16 (19,58 x 2 = 39,16)
    When I add 10 to the cart it says: €195,75, this is wrong, this must be: €195,80 (19,58 x 10 = 195,80)

    The 2 and 10 quantities on the cart page for normal customers is correct.

    Can someone please help me correct this?

    Greetings Ilona

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Damianne P (a11n)

    (@drwpcom)

    Hi @dwnl. The math would be done on the price that you entered, which includes tax.

    For one item:
    Price without tax is 20,75/1.06 = 19,58

    For 2 items:
    Price without tax is (20,75*6)/1.06 = 39,15

    For 10 items:
    Price without tax is (20,75*10)/1.06 = 195,75

    Due to rounding, it matters how the calculation is done. In WooCommerce.com, the calculation is done to calculate the tax from the total, not from each individual to avoid carrying rounding approximations.

    I hope that clarifies things!

    Thread Starter SLV

    (@dwnl)

    Yes this clarifies things!
    I’m so bad at math.
    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Subtotal excluding tax not rounded correctly with more then 1 product’ is closed to new replies.